How do I configure OBIA to process Miscellaneous Cash Receipts into Datawarehouse
Last updated on JANUARY 30, 2018
Applies to:Business Intelligence Applications Consumer - Version 18.104.22.168 and later
Information in this document applies to any platform.
On : 22.214.171.124 version, BIAPPS Version 7x Transfers Only
Miscellaneous Cash Receipts not Processed to the Data Warehouse
The Out of the Box OBIA 126.96.36.199 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.
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