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 MAY 23, 2024

Applies to:

Symptoms

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:

ERROR

or

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:


ERROR

STEPS

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.

Changes

 Upgrade to Release 12.2

Cause

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