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

Last updated on APRIL 04, 2025

Applies to:

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

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