Sales Order Line Is Closed , Still Linked With Wip Job (Doc ID 1085643.1)

Last updated on MAY 23, 2016

Applies to:

Oracle Order Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
WIP
JOB
Delink
link
Sales Order
orphan reservations
Demand
APP-WIP-25332


Symptoms


On :  11.5.10.2 version, Trx Changes & Cancellations

upgrade to 11.5.10 from 11.5.9
Find customer needs to delete the reservation related to the sales order.  They are orphan reservations as the sales order is already closed.  Demand has been fulfilled by that wip job, but still it is linked with sales order.

Customer tried solution provided in Note 125638.1
tried these 2 queries :

select wip_entity_id from apps.wip_entities where
 wip_entity_name = '111111' ; -- entity name is job name


select demand_source_header_id, demand_source_line,
 quantity_allocated,quantity_completed,demand_class
 from apps.wip_so_allocations
 where wip_entity_id = '222222' ; -- entity id from above query

and the second one did not return any row.

Customer simply needs a script or instructions on how to manually unlink the job.


Error when trying to cancel:
APP-WIP-25332: Inventory reservation procedure failed.
Cannot delete reservation.




EXPECTED BEHAVIOR
-----------------------
Expect wip job to cancel when OM line is closed.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Order Management Super User
2. Navigate: Order, Returns > Find Sales Order  > Press 'View' button > Select order line > Shows wip job
3. WIP (it'll show the job number)Sales Order Number linked with wip job number 11111


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot close the wip job linked to the sales order.

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