My Oracle Support Banner

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.

Symptoms

BEST PRACTICES:

  1. Run the Receivables Period Close Analyzer before closing the period to proactively identify this issue, as well as many other issues that will prevent you from closing the period.

  2. If you post to multiple EBS subledgers, use the EBS Period Close Process Analyzer for a smoother period close.

 

Receipts are not being picked up by Create Accounting.

 

STEPS
-------
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.

 

Cause

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
Symptoms
Cause
Solution
 Script to Identify the Corruption
 GDF Script
 ODM Tags
 Still Have Questions?
References

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