PO Approval Fails With Document Manager Error Number 3, PO_DOCUMENT_ACTION_AUTH.approve:60:po_req_supply and ORA-00001: unique constraint (MRP.MRP_RELIEF_INTERFACE_U1) violated ORA-06512
(Doc ID 1503416.1)
Last updated on APRIL 04, 2025
Applies to:
Oracle Purchasing - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
Purchase orders approval fails with document manager error number (Doc Mgr Error) 3 and the following sysadmin error:
po.plsql.PO_DOCUMENT_ACTION_AUTH.approve:60:po_req_supply returned false -
po.plsql.PO_DOCUMENT_ACTION_PVT.do_action:110:unexpected error in action call.
wfstat.sql output shows:
*** Error Process Activity Statuses
Begin Date Activity Status RESULT User NID Status
---------------- --------------------------------------- -------- --------- -------- ------ --------
31-OCT-12 08:42 ROOT/DOC_MGR_ERROR COMPLETE #FORCE
31-OCT-12 08:42 DOC_MGR_ERROR/START COMPLETE #NULL
31-OCT-12 08:42 DOC_MGR_ERROR/INITIALISE_ERROR COMPLETE
31-OCT-12 08:42 DOC_MGR_ERROR/IS_DOC_ERROR_RETRY COMPLETE N
31-OCT-12 08:42 DOC_MGR_ERROR/DOCUMENT_MANAGER_FAILED COMPLETE #FORCE USER01 831271 CANCELED
fnd_log_messages show:
po.plsql.PO_SUPPLY.maintain_mtl_supply62.EXCEPTION
-1ORA-00001: unique constraint (MRP.MRP_RELIEF_INTERFACE_U1) violated ORA-06512:
at "APPS.MTL_SUPPLY_T", line 289 ORA-04088: error during execution of trigger
'APPS.MTL_SUPPLY_T';SQLERRM = ORA-00001: unique constraint (MRP.MRP_RELIEF_INTERFACE_U1)
violated ORA-06512: at "APPS.MTL_SUPPLY_T", line 289 ORA-04088: error during execution
of trigger 'APPS.MTL_SUPPLY_T'
po.plsql.PO_SUPPLY.po_req_supply600 maintain_mtl_supply not successful.
po.plsql.PO_SUPPLY.po_req_supplyRETURN Return value = FALSE
po.plsql.PO_SUPPLY.po_req_supplyEND 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 |