OBIA 126.96.36.199: How to process Miscellaneous Cash Receipts into Data Warehouse
(Doc ID 2339446.1)
Last updated on FEBRUARY 15, 2019
Applies to:Business Intelligence Applications Consumer - Version 188.8.131.52 to 184.108.40.206 [Release V7]
Information in this document applies to any platform.
EBS R12 Source
Miscellaneous Cash Receipts are not Processed into the Data Warehouse.
The Out of the Box OBIA 220.127.116.11 ETL processes does not process "Accounts Receivable Miscellaneous Receipts" to the data warehouse. The best EP candidate for this appears to be the SDE_ORA_ARTransactionFact_ReceivableApplication/SDE_ORA_ARTransactionFact_ReceivableApplication_Full Informatica mappings available within the SDE_ORAR1213_Adaptor project folder, however, the SQL override provided does not extract this data set from EBS.
Miscellaneous Receipts are identified by a TYPE field value of 'MISC' in the EBS AR_CASH_RECEIPTS_ALL table. Guidance on how to process this dataset to the warehouse given it is excluded by the Receivable Application process would be appreciated.
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