My Oracle Support Banner

How Are The Records In ARC_AUTOREC_EXCEPTIONS Deleted in R12? (Doc ID 1669853.1)

Last updated on JUNE 25, 2019

Applies to:

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


1. Is there any change with respect to 11i and R12 on the way the data is handled in AR_AUTOREC_EXCEPTIONS table?
2. How and when is the data in the table AR_AUTOREC_EXCEPTIONS going to be deleted.


During the automatic receipt creation process,  there are records not getting through approval because of the following error:


There is a credit memo for $-1,000  and invoice for $500.  Both have credit card information populated on the transactions.  The automatic receipts program picks these transactions and processes them. However, since the over all amount is $-500, the authorization fails and a record is inserted into the errors table AR_AUTOREC_EXCEPTIONS  against the payment_schedule_id.  

Later on a credit memo for  $-1000 is applied to another non autopay invoice and  is closed.  After this when automatic receipts program is ran, it is  expected that the error in ar_autorec_exceptions table against the credit memo will be deleted.  However this is not happening.

In 11i, the records from AR_AUTOREC_EXCEPTIONS does get deleted when the credit memo is corrected and automatic receipts program is ran.



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

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