My Oracle Support Banner

OBIA 7.9.6.4: How to process Miscellaneous Cash Receipts into Data Warehouse (Doc ID 2339446.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6.4 to 7.9.6.4 [Release V7]
Information in this document applies to any platform.
EBS R12 Source

Goal

Miscellaneous Cash Receipts are not Processed into the Data Warehouse.

The Out of the Box OBIA 7.9.6.4 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.
 

Solution

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
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.