OBIA 11g : W_GL_BALANCE_F.GL_SEGMENT3_WID Loaded With All Zero Values
Last updated on MAY 22, 2018
Applies to:Business Intelligence Applications Consumer - Version 188.8.131.52.2 and later
Information in this document applies to any platform.
W_GL_BALANCE_F.GL_SEGMENT3_WID is loaded with all 0.
The ETL task has Below Query:-
Select W_GL_ACCOUNT_D.ACCOUNT_SEG3_INTEGRATION_ID, W_GL_SEGMENT_D.INTEGRATION_ID, SCD1_WID
From W_GL_ACCOUNT_D, W_GL_SEGMENT_D
W_GL_ACCOUNT_D.ACCOUNT_SEG3_INTEGRATION_ID is populated with concatenation of three values where as W_GL_SEGMENT_D.INTEGRATION_ID is a concatenation of two values.
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