How do I configure OBIA to process Miscellaneous Cash Receipts into Datawarehouse

(Doc ID 2339446.1)

Last updated on JANUARY 30, 2018

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6.4 and later
Information in this document applies to any platform.

Goal

On : 7.9.6.4 version, BIAPPS Version 7x Transfers Only

Miscellaneous Cash Receipts not Processed to the Data Warehouse

The Out of the Box OBIA 7.9.6.4 ETL processes do not appear to support processing of Accounts Receivable Miscellaneous Receipts to the Data Warehouse. The best candidate to process Accounts Receivable Miscellaneous Receipts to the data warehouse 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 dataset 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.
 

Solution

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