My Oracle Support Banner

Supply Record Still Exists For Returned Requisition After Delete PO Line or Shipment (Doc ID 2100672.1)

Last updated on MAY 06, 2020

Applies to:

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


Returned requisition does not delete mtl_supply records.

Steps to reproduce the issue.
Case 1:
1) Create a Req with 2 lines.
2) Autocreate one of the Req Lines onto PO.
3) Return the Req.
4) Delete the PO Line which was autocreated from the Req Line.
5) Verify the mtl_supply data.


At Step3 - the Requisition line in Autocreate was removed from mtl_supply as
soon as we did a return, the Req Line on the PO was still showing up
mtl_supply After Step 4 - Although the PO line was deleted , the line still
shows up in mtl_supply and the requisition says RETURNED

Case 2:
1) Create a Req with 2 lines.
2) Return the Req.
3) Verify the mtl_supply data.

After Step 3 , everything was removed from mtl_supply as expected


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.