Multiple Iteration of Change Order from DOO to Ebusiness Suite fails with Error "ORA-01403: no data found ORA-06512: at "APPS.OE_LINE_UTIL", line 11333 ORA-01403: no data found in Package OE_Order_PVT Procedure Lines" (Doc ID 1684196.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Order Management Pack for Oracle Fusion Distributed Order Orchestration and E-Business Suite - Version 11.1.6.0.0 and later
Information in this document applies to any platform.

Symptoms

DOO PIP 11.1.6.0.0

Order Quantity Update from DOO to e-Business Suite, ProcessFulfillmentOrderFusionDOOToEbizABFProcess fails with the error

ERROR
++++++
ORA-01403: no data found ORA-06512: at "APPS.OE_LINE_UTIL", line 11333 ORA-01403: no data found in Package OE_Order_PVT Procedure Lines

Steps to Reproduce
++++++++++++++++++
1. A Order is Submitted for an Item with Qty 3 from DOO to e-Business Suite and it's created in DOO / EBS.
2. This order is modified/ changed to Qty 10 and submitted from DOO to e-Business SUite -- Success
3. Again the same Order is modified/changed to Qty 2 and submitted to DOO/EBS - Failed

Business Impact
+++++++++++++++
Order Modification is not possible for more than 1 iteration

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