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

Last updated on JUNE 20, 2017

Applies to:

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

Symptoms

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. 

W_INSERT_DT W_UPDATE_DT INTEGRATION_ID
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.

 

Changes

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

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms