OBIA W_AR_XACT_F Is Not Loaded With POSTED Transactions (Doc ID 1562639.1)

Last updated on JANUARY 31, 2017

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6.3 [AN 1900] and later
Information in this document applies to any platform.

Symptoms

We are using OBIA 7.9.6.3, Informatica OOTB Adaptor is SDE_ORA1213_Adaptor

For populating W_AR_XACT_F table, we have the following list of mappings
SDE_ORA_ARTransactionFact_Adjustments
SDE_ORA_ARTransactionFact_ARSchedule_Derive
SDE_ORA_ARTransactionFact_CreditMemoApplication
SDE_ORA_ARTransactionFact_ReceivableApplication
SDE_ORA_Stage_ARTransactionFact_DiffManDerive

In all these mappings, SOURCE_OF_DATA column is hard coded as 'PS', 'ADJ', 'RCM', 'CM', etc.
But in the calculation of EXT_DOC_STATUS_ID is given like: 'ACCT_DOC_STATUS'||'~'||IIF(ISNULL(INP_STATUS), 'CLEARED', IIF(INP_STATUS = 'CL', 'CLEARED', 'OPEN'))||'~'||IIF(INP_SOURCE_OF_DATA='DIF' OR INP_SOURCE_OF_DATA='MAN', 'POSTED', 'UNPOSTED')

The above condition will always return UNPOSTED based on the hard coded values.

So we are not getting any POSTED transactions into our W_AR_XACT_F.
All transactions are coming as OPEN-UNPOSTED or CLEARED-UNPOSTED.

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