OBIA W_AR_XACT_F Is Not Loaded With POSTED Transactions
(Doc ID 1562639.1)
Last updated on AUGUST 19, 2019
Applies to:Business Intelligence Applications Consumer - Version 188.8.131.52 [AN 1900] and later
Information in this document applies to any platform.
We are using OBIA 184.108.40.206, 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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document