Encumbrance Acctg Failed After Upgrade From 12.1.3 To 12.2.4 and FND Debug Log Shows Errors like ORA-00001 XLA_00200_AAD_S_000006_BC_PKG.EventClass_101 ORA-06503 (Doc ID 1998467.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version 12.0.0 to 12.2.4 [Release 12.0 to 12.2]
Information in this document applies to any platform.

Symptoms

Encumbrance accounting failed holds for all invoices created manually as well as matched with PO ( WHich is already encumbered at PO Level)
Fnd debug log of online validating INVOICE_ID shows errors:

SQL - Insert into xla_ae_lines_gt
ERROR : ORA-00001: UNIQUE CONSTRAINT (.) VIOLATED
XLA-95103: An internal error occurred.  Please inform your system
administrator or support representative that:

An internal error has occurred in the program
XLA_00200_AAD_S_000006_BC_PKG.EventClass_101.  ORA-06503: PL/SQL: Function
returned without value.
ERROR. = ORA-20001: -: XLA-95103: An internal error occurred.  Please inform
your system administrator or support representative that:

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