Deleting Shipments From Non Approved Purchase Order Is Not Removing the Data From The Shipments Table PO_LINE_LOCATIONS_ALL
Last updated on MARCH 12, 2018
Applies to:Oracle Purchasing - Version 12.1.3 to 12.2.6 [Release 12.1 to 12.2]
Information in this document applies to any platform.
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.
APP-PO-14142 DELETE_SHIPMENT-010 ORA-01403: NO DATA FOUND
SHIPMENT not deleted
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
Due to this issue, users cannot get rid of shipments on a PO in edit
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