R12: How to Troubleshoot ORA-0001 in Create Accounting. (Doc ID 947372.1)

Last updated on AUGUST 05, 2016

Applies to:

Oracle Receivables - Version 12.0.0 to 12.1.1 [Release 12.0 to 12.1]
Information in this document applies to any platform.
ConcurrentProgram:XLAACCUP - Create Accounting Program


Goal

How to troubleshoot ORA-0001: unique constraint  (XLA.XLA_AE_HEADERS_GT_U1) violated in create accounting?

ERROR:
The journal entry cannot be saved.  Please inform your system administrator or support representative that:

The Accounting Program for Oracle Subledger Accounting cannot successfully save the entry for technical reasons. ORA-00001: unique constraint (XLA.XLA_AE_LINES_GT_U1) violated.

or

The Accounting Program for Oracle Subledger Accounting cannot successfully save the entry for technical reasons. ORA-00001: unique constraint (XLA.XLA_AE_HEADERS_GT_U1) violated.

or

An internal error has occurred in the program
XLA_00200_AAD_S_000002_PKG.EventClass_235.  ORA-06503: PL/SQL: Function
returned without value   (real error which got masked is still unique constraint voildated)

Note: SLA Dev will be shortly making code changes to ensure that “function returned without a value” is not printed in such cases (as it can be misleading), so “unique constraint violation” is always printed.

Solution

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