Drop Ship PO stuck in Pre-Approved status with Error PO_DOCUMENT_ACTION_AUTH.approve:60:po_req_supply Returned False (Doc ID 1956833.1)

Last updated on OCTOBER 16, 2016

Applies to:

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

Symptoms

When attempting to approve a Drop Ship Purchase Order (PO) it remains stuck in a status of Pre-Approved and the following errored Workflow Activities are generated:

• ACTIVITY = APPROVE_PO
• Activity Display Name = Approve The PO
• RESULT = #EXCEPTION
• ERROR_NAME = 1
• ERROR_MESSAGE = User-Defined Exception
• ERROR_STACK = Wf_Engine_Util.Function_Call(PO_REQAPPROVAL_ACTION.APPROVE_DOC, POAPPRV, 11548811-468659, 224970, RUN)

Further the following System Administrator Error Message is generated:

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

The Inventory Debug shows the detail below.  To obtain the inventory debug follow the steps in <Note 1063222.1>.

[12-OCT-14 02:00:25] INV_RESERVATION_AVAIL_PVT: calling RCV get_available_supply_demand
[12-OCT-14 02:00:25] INV_RESERVATION_AVAIL_PVT: return status from RCV_availability.get_available_supply_demand = U
[12-OCT-14 02:00:25] INV_RESERVATION_AVAIL_PVT: available quantity =
[12-OCT-14 02:00:25] INV_RESERVATION_AVAIL_PVT: source uom code =
[12-OCT-14 02:00:25] INV_RESERVATION_AVAIL_PVT: source primary uom code =
[12-OCT-14 02:00:25] INV_RESERVATION_AVAIL_PVT: unexpected error in available_supply_to_reserve
[12-OCT-14 02:00:25] INV_RESERVATION_AVAIL_PVT: SQLCODE:1 SQLERRM:User-Defined Exception
[12-OCT-14 02:00:25] INV_MAINTAIN_RESERVATION_PUB.Maintain_Reservation: l_qty_avail_to_reserve:
[12-OCT-14 02:00:25] INV_MAINTAIN_RESERVATION_PUB.Maintain_Reservation: l_qty_avail:

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