My Oracle Support Banner

AR GDF: AR_DFS_RCT_RMT_TO_CONF.sql AR_S_00087 Receipt is Remitted in AR But Not Remitted in IBY, When Trying to Reselect, Errors APP-AR-999967187 or ORA-06502 Can Occur (Doc ID 2873187.1)

Last updated on SEPTEMBER 12, 2022

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 fail for various reasons during remittance process, which leaves the receipts as Remitted in AR, but not in IBY.

 

Scenario 1:

When attempting to reverse a receipt the following error occurs.


These symptoms are observed randomly during remittance.


Steps to Reproduce:

Responsibility: Receivables Manager
Navigation: Receipts > Remittance

 

 

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
References

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