How can I unreserved quantity, Reserved against a closed / canceled sale order


In one of my operating unit sale officer enter order and released to ware house, after that sale officer cancel that sale order. Now it showing me quantity reserved for that sale order in system but actually order is canceled how can I unreserved this quantity


For 11i – 11.5.7 / INV.G and above

Download and review Patch.3170660 “script i2471362.sql not correcting orders for cancelled qty”

Run i2471362.sql to remove any old reservations

To delete a reservation manually

NAVIGATE to INV/On hand Availability/ Reservations Query up the item and find the associated row for the order Place cursor on the row to be deleted and click on delete icon and save icon.


Metalink Note Id 150081.1

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s