OBIA: Following Source EBS upgrade W_GL_BALANCE_F is not populated correctly
Last updated on JUNE 20, 2017
Applies to:Business Intelligence Applications Consumer - Version 126.96.36.199.1 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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms