Not able to cancel the ATO model (Doc ID 1563525.1)

Last updated on MAY 28, 2017

Applies to:

Oracle Work in Process - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Supply Process

Behavior observed: Not able to cancel the ATO model like using API. Initially they were trying to cancel the ATO model line using API. API was returning success but cancellation was not happening.
So they tried to cancel the line using form but this was not successful either. They are getting error and they have provided the OM debug file when getting this error.

Expected behavior: The User should be able to cancel ATO model line even if config item is in Production open status and WIP job is Unreleased.

Customer did review steps in Note 746798.1 - Script To Cancel An Existing Order Line using OE_ORDER_PUB , however they still are not able to get to the Model level.

If we unreserve the sales order the respective WIP Job is still in Unreleased status.
And, more over when trying to cancel ATO Model line, as per standard functionality it should cancel the line and unreserve the
respective item and it also keeps the respective WIP Job on hold automatically.

Other way around, we have created CTO sales order,
and star item got created and it is in Production Open Status. Now we
would like to change the one of the option under ATO model. In this case
it should cancel the old option automatically and new option should
tagged to the ATO model and respective WIP job goes to on hold status.


The error is coming from the wip code in the api wip_so_reservations.respond_to_change_order as shown below.
delink_item: Error: Failed in wip_so_reservations.respond_to_change_order with expected error.
LEAVING OE_MSG_PUB.COUNT_AND_GET 0
delink_item: ERROR: CTOCITMB.delink:517
delink_item: ERROR: CTOCITMB.delink: xErrorMessage is null
delink_item: ERROR: CTOCITMB.delink: xMessageName is now CTO_DELINK_ITEM_ERROR


The issue can be reproduced at will with the following steps:
1. Cancel the ATO model line using API
2. Receiving the error and not able to continue



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