Consumption Advice POs Fail Approval With PO_DOCUMENT_ACTION_AUTH.Approve:90:Archive_po Not Successful: ORA-00001: (PO.PO_HEADERS_ARCHIVE_U1) (Doc ID 2229535.1)

Last updated on FEBRUARY 02, 2017

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Consumption Advice POs approval fail leaving them stuck in Pre-Approved Status.

Upon submitting the PO for approval the following error occurs:

The Document Manager failed with error number 3.

Error Number 3 = Unknown Error
Contact your system administrator

Error Messages:
po.plsql.PO_DOCUMENT_ACTION_AUTH.approve:90:archive_po not successful -
po.plsql.PO_DOCUMENT_ACTION_PVT.do_action:110:unexpected error in action call

The document being processed is Standard Purchase Order 54321

FND Log shows:

Entering PO_DOCUMENT_ARCHIVE_PVT.ARCHIVE_PO
Set SavePoint
check_po_archive(PO) p_document_id: 1234567
Entering PO_DOCUMENT_ARCHIVE_PVT.CHECK_PO_ARCHIVE
archive_header() p_document_id: 1234567
Entering PO_DOCUMENT_ARCHIVE_PVT.ARCHIVE_HEADER
Update PO_HEADERS_ARCHIVE to reset latest_external_flag
Insert PO_HEADERS_ARCHIVE
;SQLERRM = ORA-00001: unique constraint (PO.PO_HEADERS_ARCHIVE_U1) violated
EXCEPTION: ORA-00001: unique constraint (PO.PO_HEADERS_ARCHIVE_U1) violated
EXCEPTION: ORA-00001: unique constraint (PO.PO_HEADERS_ARCHIVE_U1) violated
archive_po not successful;SQLERRM = User-Defined Exception
p_action_ctl_rec.return_status = U
End of subprogram.
unexpected error in action call;SQLERRM = User-Defined Exception
p_action_ctl_rec.return_status = U
p_action_ctl_rec.return_code is null
p_action_ctl_rec.functional_error is null
p_action_ctl_rec.error_msg =
po.plsql.PO_DOCUMENT_ACTION_AUTH.approve:90:archive_po not successful -
po.plsql.PO_DOCUMENT_ACTION_PVT.do_action:110:unexpected error in action call
End of subprogram

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