R12: How to Troubleshoot ORA-0001 in Create Accounting.
(Doc ID 947372.1)
Last updated on JULY 17, 2019
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document