My Oracle Support Banner

Attempting To Add Line To Ship Set On New Or Existing Order Errors With ORA-06503 PL/SQL Function Returned Without Value In Package OE_SCHEDULE_UTIL Procedure Log_Set_Request (Doc ID 2771245.1)

Last updated on SEPTEMBER 07, 2021

Applies to:

Oracle Order Management - Version 12.2.9 to 12.2.10 [Release 12.2]
Information in this document applies to any platform.


Upgraded to Release 12.2.9 from 12.1.3. 

NOTE !!! This issue has been found to be in the following 2 scenarios:

1st scenario:  Attempting to update a configuration for a BOOKED order line with a single ship set ,the following error is raised:


ORA-06503: PL/SQL: Function returned without value in Package OE_SCHEDULE_UTIL Procedure Log_Set_Request


2nd scenario:  When attempting to add an order line to a ship set where order line is in an ENTERED status on an imported or newly entered order,  upon clicking save the ORA-06503 error is raised.
Then when attempting to book the order, the header booking workflow activity errors with the following additional errors:


Header workflow activity: Book - Order, Manual Book Exception Error -20001 ORA-20001
Header Processing Messages: Workflow activity Book has failed. Please fix the errors and retry the activity from the Order Form or the Workflow Monitor.

ORA-06503: PL/SQL: Function returned without value in Package OE_SCHEDULE_UTIL Procedure Log_Set_Request


The issue can be reproduced at will with the following steps:

1. Order Management Super User responsibility
2. Existing booked order with 4 scheduled lines in the same ship set.
-Line 1 is a configured model.
-Lines 2, 3, 4 are items.
3. User re-opens Configurator on line 1. The configuration is updated and user clicks finish.
4. Upon returning to sales order in OM, the error message is raised.

1. Order Management Super User Responsibility
2. Import Order in an Entered status
3. Add ship set to order line
4. Save and schedule error is raised.
5. Try to book and workflow error is raised on order header.


 Upgrade to Release 12.2


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

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