GL中本位币借贷不平的处理方法

仅供引用参考，实际请联系Oracle Support索取Datafix。 

 

--Journal name:GL-SGA 042010-18

select * from gl.gl_je_batches where je_batch_id=571585 

--running_total_accounted_dr=-165850.88,running_total_accounted_dr=-165850.86

select * from gl.gl_je_headers where je_header_id=377429

--running_total_accounted_dr=-165850.88,running_total_accounted_dr=-165850.86

select * from gl.gl_je_lines where je_header_id=377429 and je_line_num=2

--accounted_dr=-34312.79

 

update gl.gl_je_batches

set running_total_accounted_dr=-165850.86

where je_batch_id=571585

 

update gl.gl_je_headers 

set running_total_accounted_dr=-165850.86

where je_header_id=377429

 

update gl.gl_je_lines

set accounted_dr=-34312.77

where je_header_id=377429 and je_line_num=2

 

 

--Journal name:GL-SGA 042010-19

select * from gl.gl_je_batches where je_batch_id=571584 

--running_total_accounted_dr=1790149.05,running_total_accounted_cr=1790149.03

select * from gl.gl_je_headers where je_header_id=377427 

--running_total_accounted_dr=1790149.05,running_total_accounted_cr=1790149.03

select * from gl.gl_je_lines where je_header_id=377427 and je_line_num=3

--accounted_dr=-272693.54

 

update gl.gl_je_batches

set running_total_accounted_dr=1790149.03

where je_batch_id=571584

 

update gl.gl_je_headers 

set running_total_accounted_dr=1790149.03

where je_header_id=377427

 

update gl.gl_je_lines

set accounted_dr=-272693.52

where je_header_id=377427 and je_line_num=3