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 AUGUST 17, 2023

Applies to:

Oracle Receivables - Version 12 and later
Information in this document applies to any platform.



  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




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
 GDF Script
 ODM Tags

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