Localization Issue with Autoinvoice causes error ORA-04092: cannot COMMIT in a trigger (Doc ID 2088193.1)

Last updated on DECEMBER 29, 2015

Applies to:

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

Symptoms

Issue Clarification
---------------------------
When Running autoinvoice for a localized instance, the process ends in error.


ERROR / ISSUE
-----------------------

Keeping TRX_DATE from Interface Table...
End of Fetching details for l_batch_source_id=3724
Exiting JG_ZZ_AR_AUTO_INVOICE.upd_trx_date...
...
customer trx_id 624063063
ORA-04092: cannot COMMIT in a trigger


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