My Oracle Support Banner

One Of The Lines In A Set Is Overridden. You Are Not Allowed To Modify Scheduling Attributes On A Set Which Has One Or More Overridden Lines (Doc ID 2750155.1)

Last updated on FEBRUARY 07, 2021

Applies to:

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

Symptoms

Customer is upgrading from rel 12.1.3 12.2.9 and is unable to place orders imported from website (parts store) with multiple lines by selecting "cloxxxxx truck " and Pick up Ship methods
Customer is importing orders and then using OE_Order_PUB Procedure Process_Order API

Customer suspects issue is due to the Ship Set, as customer is overriding the lines in a set

Customer does not use GOP


Issue works fine in rel 12.1.3 but not rel 12.2.9



ERROR
-----------------------
Error 1

For PICK UP Ship Method:
ONT\u0000OE_VAL_DUP_PO_NUMBER\u0000 One of the lines in a set is Overridden. You are not allowed to modify scheduling attributes on a Set which has one or more overridden lines. ORA-01086: savepoint 'PROCESS_ORDER' never established in this session or is invalid\nORA-06510: PL/SQL: unhandled user-defined exception\nORA-06512: at \"APPS.OE_ORDER_PVT\", line 7412 in Package OE_Order_PUB Procedure Process_Order
 

Error 2
FOR CLOxxxxx TRUCK(Plant Direct) Ship Method
ONT\\u0000OE_SCH_OVER_ATP_NO_AUTH_SET\\u0000 One of the lines in a set is Overridden. You are not allowed to modify scheduling attributes on a Set which has one or more overridden lines. ORA-01086: savepoint \\u0027PROCESS_ORDER\\u0027 never established in this session or is invalid\\nORA-06510: PL/SQL: unhandled user-defined exception\\nORA-06512: at \\\"APPS.OE_ORDER_PVT\\\", line 7412 in Package OE_Order_PUB Procedure Process_Order\",\"orderMessage\":\"\\u0000\"}"


3)
3rd error seen at bottom of screen shot

{"Success ":false, "message":"sorry we could not place order. Please try again after sometime or contact customer service. ","hiddenmsg":
{"status":"U","message":"ONT\uD000OE_SCH_OVER_ATP_NO_AUTH_SET\u0000 One of the lines in a set is Overridden. You are not allowed to modify scheduling attributes on a Set which has one or more
overridden lines. ORA-01086: savepoint 'PROCESS_ORDER' never established in this session or is invalid\nORA-06510: PL/SQL: unhandled user -defined exception \nORA-06512: at \"APPS.OE_ORDER_PVT\",
line 7412 in Package OE_Order_PUB Procedure Process_order", "orderMessage":"\u000"}}

Getting error "One of the lines in a set is Overridden. You are not allowed to modify scheduling attributes on a Set which has one or more overridden lines." when trying to create lines with override ATP flag set and are part of a set.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
  
Import orders and then call OE_Order_PUB Procedure Process_Order API


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
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.