My Oracle Support Banner

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 JULY 28, 2019

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.