API Fails With Set Xxx Has Been Closed.You Cannot Insert New Lines Into A Closed Set. (Doc ID 2094255.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.2.3 version, Transaction Entry

Trying to cancel a line on a booked order and re-add the same items to the order with a new fulfillment set by API, but receiving error.

We found that if there is a cancel (ie UPDATE and Cancel_flag = Y) AND the new lines in the same API call, it errors out. If removing the lines that trying to cancel from the API call, and leave the new CREATE lines with the new fulfillment set, the update occurs fine. Somewhere there is a bug trying to cancel a line and adding a new model line at the same time.


The sample scripts are from our DEV environment. The issue is reproducible

ERROR
-----------------------

Process order api returned: U
Process order api returned ERROR..
Set 103037 has been closed. You cannot insert new lines into
a closed set.




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Run attached API call script.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
This is occurring in PROD and causing us delay in getting the product to our customer. Customer currently have 5000 orders need to be fixed.

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