OBIA 11g AP balance amount(s) not calculated correctly (source = W_AP_BALANCE_F) due to incorrect GL_STATUS_ID in SDE_ORA_APTransactionFact_LiabilityDistribution_InitialBalance
Last updated on JANUARY 31, 2017
Applies to:Business Intelligence Applications Consumer - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
In OBIA 22.214.171.124.1, the following issue is encountered:-
Many figures in the Payables dashboard are not correct. There are many negative numbers being shown in orders of magnitude larger or smaller than expected (in some cases millions instead of thousands).
You found that the AP balance amount(s) was not calculated correctly (source = W_AP_BALANCE_F). After investigating, the mapping SDE_ORA_APTransactionFact_LiabilityDistribution_InitialBalance seemed to be the cause. This mapping hard-codes the following GL_STATUS_ID:"GL_STATUS~ACCOUNTED~TRANSFERRED TO GL~POSTED". This ID is not found in W_STATUS_D. Later in the load, when populating W_AP_BALANCE_F_TMP, the task PLP_PLP_APINCREMENTALACTIVITYLOAD will filter on GL_STATUS and not load all the required records:
And (W_STATUS_D.W_SUBSTATUS1_CODE IN ('POSTED','REVERSED'))
You updated the mapping and replaced GL_STATUS~ACCOUNTED~TRANSFERRED TO GL~POSTED with FIN_GL_STATUS~ACCOUNTED~TRANSFERRED TO GL~POSTED.
This brought back the correct data
Can you please confirm that this is indeed a known issue and what correct measures need to be taken.
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