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
(Doc ID 1597971.1)
Last updated on FEBRUARY 17, 2019
Applies to:Business Intelligence Applications Consumer - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
In OBIA 18.104.22.168.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.
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