My Oracle Support Banner

OBIA: Following Source EBS upgrade W_GL_BALANCE_F is not populated correctly (Doc ID 2125093.1)

Last updated on AUGUST 15, 2019

Applies to:

Business Intelligence Applications Consumer - Version and later
Information in this document applies to any platform.


Source system -- EBS R12.1.3

W_GL_BALANCE_F  is not getting updated properly.

Ran an INITIAL FULL LOAD ON 11/28/2015, at that time two records were created.
Then ran incremental load on 01/16/2016, at that time again two new records were inserted.

Again ran incremental load on 02/13/2016, then the rows that were inserted 01/16/2016 were updated.
But on 02/13/2016  two new rows were also inserted. 

11/28/2015 12:35:07 PM 11/28/2015 12:35:07 PM GL~1~2592201~NOV-15~DEBIT~A~N~USD~USD~
11/28/2015 12:35:07 PM 11/28/2015 12:35:07 PM GL~1~2592201~NOV-15~CREDIT~A~N~USD~USD~
1/16/2016 8:40:01 AM 2/13/2016 10:56:22 AM GL~1~2592201~NOV-15~DEBIT~A~N~USD~NULL~
1/16/2016 8:40:01 AM 2/13/2016 10:56:22 AM GL~1~2592201~NOV-15~CREDIT~A~N~USD~NULL~







Noticed at the time of INITIAL FULL LOAD, integration id was 'GL~1~2592201~NOV-15~DEBIT~A~N~USD~USD~', so that means BEQ was populated at that time.  Now the BEQ are coming NULL.



 Source system -- Upgraded from EBS 11i to EBS R12.1.3 


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.