Deleting Shipments From Non Approved Purchase Order Is Not Removing the Data From The Shipments Table PO_LINE_LOCATIONS_ALL (Doc ID 2243380.1)

Last updated on APRIL 20, 2023

Applies to:

Symptoms

Using Purchasing, when deleting shipments on a line, form says transaction saved but when re-querying the Purchase Order (PO) the shipment is still there.


Go to Purchase orders
Create standard PO-> Shipments -> do multiple lines -> Save
Go and delete 1 shipment. Save-> Forms says Transaction Saved.
Requery PO -> you see deleted shipment remains.


ERROR
-------------------
APP-PO-14142 DELETE_SHIPMENT-010 ORA-01403: NO DATA FOUND

SHIPMENT not deleted


STEPS
-------------------
1. Login to the E-Business Suite and choose the Purchasing Module.

2. Go to Purchase orders
3. Create standard PO-> Shipments -> Do multiple lines -> Save
4. Go and delete 1 Shipment. Save-> Forms says Transaction Saved.
5. Requery PO -> Still seeing the Shipment that should have been deleted remaining in form

BUSINESS IMPACT
-----------------------
Due to this issue, users cannot get rid of shipments on a PO in edit

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.