Autocreate Requisition To Purchase Order - Error APP-PO-14142: AUTOCREATE_DOCUMENTS-002: ORA-0000: (Doc ID 1400150.1)

Last updated on JANUARY 10, 2017

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

Cause

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