Schedule Orders Does Not Update Schedule Ship Date SSD oe_order_lines_all ORA-0000 After Patch 11825106 (Doc ID 1631866.1)

Last updated on JULY 26, 2017

Applies to:

Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Transaction Scheduling

After applying <Patch 11825106>:R12.ONT.B with updated file: OEXWSCHB.pls 120.12.12010000.5,
When running Schedule Orders Program for some items, user intermittently end with wf error at the end of the log file.
The Schedule Ship Date is not getting updated to the oe_order_lines_all but there is no failure message and the data is getting inserted into the mrp_atp_schedule_temp table.
Workflow activity 'Schedule' is getting 'Incomplete'.



ERROR in Schedule Orders log file - (end of file):
-----------------------
ENTERING PROCESS_CHILD_LINES
EXITING PROCESS_CHILD_LINES
In WF save messages
ENTER Save_API_Messages
l_errmsg ORA-0000: normal, successful completion
EXIT Save_API_Messages
Entering Procedure Clear_Request in Package OE_Delayed_Requests_Pvt
ENTERING DELETE_ATTRIBUTE_CHANGES -1
R2 PROCESSED: 0 FAILED: 0
Entering Procedure Clear_Request in Package OE_Delayed_Requests_Pvt
ENTERING DELETE_ATTRIBUTE_CHANGES -1
Execution Result : 0
ENTER SAVE_MESSAGES
EXIT SAVE_MESSAGES
LEAVING OE_MSG_PUB.INITIALIZE
Total Lines Selected : 0
Lines Failed : 0
Lines Successfully Processed : 0

====================================
After doing some analysis, we found that there is a code snipped added in OE_OEOL_SCH package.

--11825106
IF oe_schedule_util.OESCH_SET_SCHEDULING = 'Y' THEN
resultout := 'COMPLETE:COMPLETE';
OE_STANDARD_WF.Clear_Msg_Context;

Bulk_Mode_Copy_Sch_Attribs
(p_line_rec => l_line_rec);
ELSE
resultout := 'COMPLETE:INCOMPLETE';
-- moved this line up to for the bug fix 2884452
ROLLBACK TO SAVEPOINT Schedule_line;
OE_STANDARD_WF.Save_Messages;
OE_STANDARD_WF.Clear_Msg_Context;
--commit; /* Added this line to fix the bug 2884452 */
OE_Delayed_Requests_PVT.Clear_Request
(x_return_status => l_return_status);
--oe_schedule_util.OESCH_SET_SCHEDULING :='Y';
END IF;

The variable oe_schedule_util.OESCH_SET_SCHEDULING is getting set in the oe_delayed_requests_pvt procedure as part of <Patch 11825106>:R12.ONT.B.

<Patch 11825106>:R12.ONT.B seems to have introduced this new issue.  However, we have found it only errors in certain conditions.
***************************
We found another sample order that worked successfully and here is the log file without error:
This line scheduled successfully using same WF and running 'Schedule Order' program, see below snippet of end of log file for successfully scheduling (complete log is in file 'file_successful.txt':

ENTERING PROCESS_CHILD_LINES
EXITING PROCESS_CHILD_LINES
-- bulk mode set results on global record
IN OEOL_SELECTOR , FUNCMODE:TEST_CTX OEOL 0000000
G_RESET_APPS_CONTEXT IS TRUE
G_UPGRADE_MODE IS FALSE
ORG ID IS 0000
 Exiting OEOL_SELELECTOR , RESULT = TRUE ITEMTYPE = OEOL ITEMKEY = 0000000
P_RESULT:TRUE
R2 PROCESSED: 0 FAILED: 0
Entering Procedure Clear_Request in Package OE_Delayed_Requests_Pvt
ENTERING DELETE_ATTRIBUTE_CHANGES -1
Execution Result : 0
ENTER SAVE_MESSAGES
EXIT SAVE_MESSAGES
LEAVING OE_MSG_PUB.INITIALIZE
Total Lines Selected : 2
Lines Failed : 0
Lines Successfully Processed : 2

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Order Management Super user
2. Navigate: Orders Workbench, Order Organizer > Run Schedule Orders for order
3. See error in log file
4. Run HTMomse12.sql and can verify, the line is still in workflow status: Schedule INCOMPLETE


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot schedule the line in error.



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