My Oracle Support Banner

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 later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.