OBIA 7964 Incorrect Calculation Of SOURCE_OF_DATA In SDE_ORA_ARTransactionFact_CreditMemoApplication (Doc ID 1962760.1)

Last updated on JANUARY 30, 2017

Applies to:

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

Symptoms

BI Apps 7.9.6.4

Source EBS: R12.2.2

The OOTB mapping SDE_ORA_ARTransactionFact_CreditMemoApplication calculates SOURCE_OF_DATA based on the SIGN of the AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED and AMOUNT_DISTRIBUTED(AR_DISTRIBUTIONS_ALL.AMOUNT_DR - AR_DISTRIBUTIONS_ALL.AMOUNT_CR).


VAR_SOURCE_OF_DATA = IIF(SIGN(VAR_AMOUNT_APPLIED)=SIGN(VAR_AMOUNT_DISTRIBUTED) , 'RCM', 'CM')

However, when Credit Memos, with Distribution amounts having different signs to the Credit Memo amount, are applied to Invoices, the above formula SOURCE_OF_DATA calculation will be incorrect.


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