OBIA 11g: Load Plan Not Populating Balance Type In W_GL_OTHER_F Table. It Shows Zeros

(Doc ID 2386094.1)

Last updated on APRIL 24, 2018

Applies to:

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

BI Apps modules: Financial
Source: Fusion Apps (FSCM) 11.12.1.0.0
Target System/Version: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

Symptoms

Running Full Load with Oracle Fusion Cloud as a source and the balance type is not accurately populating for the W_GL_OTHER_F. It only shows zero.

Found via SQL:
select distinct balance_type_wid from w_gl_other_f;

Result table:
Balance_type_wid
-----------------------
0

Changes

 

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