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 JANUARY 31, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

In OBIA 11.1.1.7.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.

Cause

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