OBIA 11g : W_GL_BALANCE_F.GL_SEGMENT3_WID Loaded With All Zero Values
(Doc ID 2399147.1)
Last updated on FEBRUARY 05, 2019
Applies to:Business Intelligence Applications Consumer - Version 22.214.171.124.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.
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