WFL Failed: ORA-00001: Unique Constraint (PO.PO_REQUISITION_HEADERS_U2) Violated (Doc ID 2111278.1)

Last updated on FEBRUARY 28, 2016

Applies to:

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

Symptoms

PAR re-submission after the Reject is failing unique constraint error
Wf_Engine_Util.Function_Call(PO_PAR_REQ_CREATE_UTIL.create_dummy_req_wf
1. For a PAR that previously failed the Funds Check:
  a. Workflow Background Process should be run with Deferred = 'Y'.
  b. Notification received but does not include PAR # so recipient don't have any information in order to identify the document.
  c. Update description
  d. Submit for approval
  WFL failed: ORA-00001: unique constraint (PO.PO_REQUISITION_HEADERS_U2) violated
  Wf_Engine_Util.Function_Call(PO_PAR_REQ_CREATE_UTIL.create_dummy_req_wf


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