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 DECEMBER 21, 2021
Applies to:
Oracle Purchasing - Version 12.1.3 and laterInformation 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
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
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 |
| Cause |
| Solution |
| References |