OBIA 7964 Incorrect Calculation Of SOURCE_OF_DATA In SDE_ORA_ARTransactionFact_CreditMemoApplication
Last updated on JANUARY 30, 2017
Applies to:Business Intelligence Applications Consumer - Version 220.127.116.11 and later
Information in this document applies to any platform.
BI Apps 18.104.22.168
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.
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