No Data Found in Package OE_PURCHASE_RELEASE_PVT Procedure PURCHASE_RELEASE (Doc ID 1682862.1)

Last updated on JULY 13, 2016

Applies to:

Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Transaction Fulfillment

When attempting to progress sales orders that have been created through iStore the following error occurs.

ERROR
-----------------------
User-Defined Exception
OE_OEOL_SCH.Release_to_purchasing (OEOL, 15050, 236214, RUN) Wf_Engine_Util.Function_Call(OE_OEOL_SCH.RELEASE_TO_PURCHASING, OEOL, 15050, 236214, RUN)

User-Defined Exception in Package OE_Purchase_Release_PVT Procedure Purchase_Release
ORA-01403: no data found in Package OE_Purchase_Release_PVT Procedure Purchase_Release
Workflow activity Purchase Release has failed. Please fix the errors and retry the activity from the Order Form or the Workflow Monitor.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create sales order line through iStore.
2. Order Booked
3. Run program – Workflow Background Program for OM Order Line
4. Order line status remains = Booked


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