OBIA W_AR_XACT_F Is Not Loaded With POSTED Transactions
Last updated on JANUARY 31, 2017
Applies to:Business Intelligence Applications Consumer - Version 18.104.22.168 [AN 1900] and later
Information in this document applies to any platform.
We are using OBIA 22.214.171.124, Informatica OOTB Adaptor is SDE_ORA1213_Adaptor
For populating W_AR_XACT_F table, we have the following list of mappings
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.
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