My Oracle Support Banner

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

Last updated on JUNE 30, 2020

Applies to:

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


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


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

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

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.


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

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