R12: How to Troubleshoot ORA-0001 in Create Accounting.
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
How to troubleshoot ORA-0001: unique constraint (XLA.XLA_AE_HEADERS_GT_U1) violated in create accounting?
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.
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms