Cancelling Of Line Causing Orphan Work Order Reservation On Another Line To Which WO Was Reserved

(Doc ID 2273792.1)

Last updated on JUNE 14, 2017

Applies to:

Oracle Configure to Order - Version 12.2.4 and later
Information in this document applies to any platform.


On : 12.2.4 version, Supply Process

Cancelling of line causing orphan Work Order reservation on another line to which the same WO was reserved. For one work order that is reserved to two sales order line when cancelling one of the lines, the work order is getting cancelled.
However, the reservation of the work order on another line is remaining active. The issue appears to be in the package WIP_SO_RESERVATION.respond_to_change_order.
In this package, there is direct update to WIP_DISCRETE_JOBS table to change the status to CANCELLED, without a validation if any other reservation exists for the work order.

Expect the cancellation process to verify that the workorder is not associated with any other lines.

The issue can be reproduced at will with the following steps:
1. Have sales order where 2 lines are assigned the same workorder.
2. Cancel line 1
3. Verify workorder is cancelled but reservation still exists.

The issue has the following business impact:
Due to this issue, users cannot progress the lines as the workorder is cancelled.


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