Autoinvoice Import Program Error APP-AR-11526: ORA-06510

(Doc ID 2315179.1)

Last updated on OCTOBER 06, 2017

Applies to:

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

Symptoms

On : 12.2 version, Transactions Related

Autoinvoice Import is failing with error:

ERROR
-----------------------
APP-AR-11526: ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line
begin arp_process_returns . process_application_list ; EXCEPTION WHEN !
APP-AR-11526: 5069629/ar/src/autoinv/raacsa.lpc 101
Error calling raacsa()
Error calling raapic()

FND debug log shows

After raising workflow event : event_name =
oracle.apps.ap.invoice .import event_
sid:51076650: key = 57963
sid:51076650: Returned True
sid:51076650: No invoices created<- Submit_Payment_Request<-
AR_REFUNDS_PVT.crea te_refund
1 Errors found interfacing data to AP ...
INCONSISTENT RATE
Activity_application ()-
ActivityApp:
ActivityApp failed
EXCEPTION : arp_process_returns.process_application_list : User-Defined
Exceptio n
raacsa(): arp_process_returns.process_application_listUser-Defined Exception
Current system time is 21-JUL-2017 09:18:33
APP-AR-11526: ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512:
at line
begin arp_process_returns . process_application_list ; EXCEPTION WHEN !
APP-AR-11526: 5069629/ar/src/autoinv/raacsa.lpc 101
Error calling raacsa()
Error calling raapic()
raarrt2()+

ADDITIONAL SYMPTOMS
-----------------------------
Error happens when they try to import RMA where Refund has to be created and the exchange rate is huge (more than 15 digit precision)
Receipt handling option is set to REFUND in Batch Source

The same problem was reported from Receipts form, for which Patch of Bug 22381132 is fixed.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Receipt handling option is set to REFUND in Transactions Batch Source
2. Try to import a Foreign currency Credit Memo where Exchange rate precision is more than 15 digits
3. The Autoinvoice should initiate Refund on the Receipt applied to the Invoice for which you are creating Refund
4. Run Autoinvoice and see error in the log.


Changes

 

Cause

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