How Are The Records In ARC_AUTOREC_EXCEPTIONS Deleted in R12?

(Doc ID 1669853.1)

Last updated on JUNE 07, 2016

Applies to:

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

Goal

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.

Scenario:

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

'ARZCAR_BANK_MIN_AMT'

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.

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms