Autocreate Requisition To Purchase Order - Error APP-PO-14142: AUTOCREATE_DOCUMENTS-002: ORA-0000:
(Doc ID 1400150.1)
Last updated on JULY 03, 2023
Applies to:
Oracle Purchasing - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]Information in this document applies to any platform.
Symptoms
When attempting to Autocreate an error has occurred.
Error:
APP-PO-14142: AUTOCREATE_DOCUMENTS-002: ORA-0000: normal, successful completion.
Cause: A SQL error has occurred in AUTOCREATE_DOCUMENTS. The SQL error is ORA-0000:
normal successful completion.
Action: take note of both this error number and the actions you were trying to perform.
Contact your system administrator for further assistance.
Replication Steps:
1. Login to the E-Business Suite and choose the Purchasing Module.
2. Attempt to autocreate.
3. Error is encountered.
Other:
All users attempting autocreate experience the error.
Complete purge of the interface tables was not an option as there is a large amount of data.
In the forms trace file the following could be seen for the statement inserting into PO_HEADERS_INTERFACE.
ERROR #28:err=1 tim=6293076037324
STAT #18446744071466643568 id=1 cnt=0 pid=0 pos=1 obj=0 op='LOAD TABLE CONVENTIONAL (cr=0 pr=0 pw=0 time=7 us)'
The err=1 represents a unique constraint - ORA-00001: unique constraint
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |