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 184.108.40.206 and later
Information in this document applies to any platform.
BI Apps 220.127.116.11
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!