Sales Order Line Error: User-Defined Exception in Package OE_Line_Fullfill Procedure Process_Fulfillment ORA-01403: No Data Found ORA-06512
(Doc ID 2856526.1)
Last updated on AUGUST 21, 2023
Applies to:
Oracle Order Management - Version 12.2.9 and laterInformation in this document applies to any platform.
Symptoms
When attempting to progress sales order but some of the lines
are stuck in Fulled with Fulfilled Activity workflow and the
following error occurs.
ERROR
-----------------------
ORA-01403: no data found ORA-01403: no data found ORA-06512: at "APPS.OE_LINE_UTIL", line nnnn
ORA-01403: no data found in Package OE_Line_Fullfill Procedure Process_Fulfillment_Set
ORA-01403: no data found in Package OE_Line_Fullfill Procedure Cancel_Line
Validation failed for the field - Org
The order line is on hold. Action: Release hold.
User-Defined Exception in Package OE_Line_Fullfill Procedure Process_Fulfillment
Workflow activity Fulfill has failed. Please fix the errors and retry the activity from the Order Form or the Workflow Monitor.
Error: The update request cannot be executed now because the source lines have at least one delivery line that is in a confirmed delivery or has been shipped.
STEPS
-----------------------
1. Responsibility: Order Management Super User
2. Order Organizer > Query Sales Order: nnnn506
3. Header: Booked
Header WF: Close - Order Wait Null Deferred
4. Lines > Cancelled > 1.1, 2.1, 9.1, 10.1, 18.1
Lines > Shipped > 3.1, 8.1, 11.1, 16,1, 171, 19.1 thru 35.1
Line WF: ENP: Line Flow - ATO Item (Deferred Scheduling) - Phase In Fulfill Exception Error
Lines > Supply_Eligible > 20.1
Line WF: ENP: Create Supply Order - Line, Automatic Create Supply Order - Eligible Notified
Lines > Awaiting_Fulfillment > 4.1, 5.1, 6.1, 7.1, 12.1, 13.1,14.1, 15.1
Line WF: ENP: Line Flow - ATO Item (Deferred Scheduling) - Phase In Fulfill Exception Error
Bug 33925377 - USER-DEFINED EXCEPTION IN PACKAGE OE_LINE_FULLFILL PROCEDURE PROCESS_FULFILLMENT Bug 33925377 - USER-DEFINED EXCEPTION IN PACKAGE OE_LINE_FULLFILL PROCEDURE PROCESS_FULFILLMENT Bug 33925377 - USER-DEFINED EXCEPTION IN PACKAGE OE_LINE_FULLFILL PROCEDURE PROCESS_FULFILLMENT Bug 33925377 - USER-DEFINED EXCEPTION IN PACKAGE OE_LINE_FULLFILL PROCEDURE PROCESS_FULFILLMENT
Bug 33925377 - USER-DEFINED EXCEPTION IN PACKAGE OE_LINE_FULLFILL PROCEDURE PROCESS_FULFILLMENT
Bug 33925377 - USER-DEFINED EXCEPTION IN PACKAGE OE_LINE_FULLFILL PROCEDURE PROCESS_FULFILLMENT Bug 33925377 - USER-DEFINED EXCEPTION IN PACKAGE OE_LINE_FULLFILL PROCEDURE PROCESS_FULFILLMENT
Changes
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 |
Changes |
Cause |
Solution |
References |