AR GDF: AR_DFS_RCT_STAMP_RA_MCD_CRHID.sql AR_00091 AR_RECEIVABLE_APPLICATIONS_ALL.CASH_RECEIPT_HISTORY_ID is Causing Receipts To Not Process by Create Accounting
(Doc ID 1498239.1)
Last updated on JUNE 21, 2023
Applies to:Oracle Receivables - Version 12 and later
Information in this document applies to any platform.
Receipts are not being picked up by Create Accounting.
1. Run Create Accounting, receipts are not picked up
Investigation shows it could be due to following symptoms :
1) AR_RECEIVABLE_APPLICATIONS_ALL.CASH_RECEIPT_HISTORY_ID for some receipts is NULL.
2) AR_RECEIVABLE_APPLICATIONS_ALL.CASH_RECEIPT_HISTORY_ID for some receipts shows cash_receipt_history_id of APPROVED row.
3) AR_MISC_CASH_DISTRIBITIONS_ALL.CASH_RECEIPT_HISTORY_ID for some receipts is NULL.
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
|Script to Identify the Corruption|
|Still Have Questions?|