Create Accounting Failing With Error ORA-06503: PL/SQL: Function returned without value. (Doc ID 1676638.1)

Last updated on APRIL 18, 2022

Applies to:

Symptoms

When running Create Accounting the program is failing with error:

An internal error occurred. Please inform your system administrator or support representative that:
An internal error has occurred in the program XLA_00222_AAD_S_000011_PKG.EventClass_140. ORA-06503: PL/SQL: Function returned without value.

Following error appears in FND debug log:

SQL - Insert into xla_ae_lines_gt
ERROR : ORA-00001: UNIQUE CONSTRAINT (.) VIOLATED
ERROR : ORA-00001: UNIQUE CONSTRAINT (.) VIOLATED
ERROR : ORA-00001: UNIQUE CONSTRAINT (.) VIOLATED
ERROR : ORA-00001: UNIQUE CONSTRAINT (.) VIOLATED
ERROR : ORA-00001: UNIQUE CONSTRAINT (.) VIOLATED
ERROR : ORA-00001: UNIQUE CONSTRAINT (.) VIOLATED
ERROR : ORA-00001: UNIQUE CONSTRAINT (.) VIOLATED
ERROR : ORA-00001: UNIQUE CONSTRAINT (.) VIOLATED
ERROR : ORA-00001: UNIQUE CONSTRAINT (.) VIOLATED
ERROR : ORA-00001: UNIQUE CONSTRAINT (.) VIOLATED
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_00222_AAD_S_000011_PKG.EventClass_141.  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:

An internal error has occurred in the program XLA_00222_AAD_S_000011_PKG.EventClass_141.  ORA-06503: PL/SQL: Function returned without value."
ROLLBACK issued in the procedure UNIT_PROCESSOR_BATCH

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.