Autoinvoice Is Failing To Import Transactions When AX_AR Triggers Are Enabled (Doc ID 2126694.1)

Last updated on JULY 24, 2017

Applies to:

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

Symptoms

Autoinvoice is failing to import transactions when the following AX_AR triggers are enabled

AX_RA_CUSTOMER_TRX_BRI1
AX_RA_CUSTOMER_TRX_ARU1
AX_RA_CUST_TRX_LINE_GL_ARDI1

Power outage occured and after that If the AX triggers are enabled, then autoinvoice fails with the following error in log

ERROR
-----------------------
Current system time is 21-MAR-2016 12:13:15
APP-AR-11526: ORA-20001: -: ORA-01422: exact fetch returns more than requested numbe
insert into ra_customer_trx
(
customer_trx_id,
last_update_date,
last_
APP-AR-11526: 3879222/ar/src/autoinv/raaihd.lpc 888
Current system time is 21-MAR-2016 12:13:15
APP-AR-11526: ORA-20001: -: ORA-01422: exact fetch returns more than requested numbe
insert into ra_customer_trx
(
customer_trx_id,
last_update_date,
last_
APP-AR-11526: 3879222/ar/src/autoinv/raaihd.lpc 888
Error calling raaihd()
Error calling raapic()
Commit after cleanup - Current system time is 21-MAR-2016 12:13:16
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE

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