OBIA 11g:W_GL_SEGMENT_D Missing Record Compare To W_GL_ACCOUNT_D.ACCOUNT_SEG5_INTEGRATION_ID
(Doc ID 2152522.1)
Last updated on JULY 11, 2022
Applies to:Business Intelligence Applications Consumer - Version 184.108.40.206.1 and later
Information in this document applies to any platform.
You have w_acct_budget_f fact stage deriving gl_account_id properly and w_gl_account_d has appropriate account_seg5_integration_id as well. However, w_gl_segment_d do not have respective records with the integration_id referred in the w_gl_account_d populated.
This is causing the gl_segment5_wid to be derived as 0 in the fact W_ACCT_BUDGET_F.
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