PO Update needs to be done? Programmatically? Well, Oracle has provided an API to do just that. API Name is po_document_update_grp.update_document. Below is a sample PO Update Script which we can use to delete the shipments. Alter the cursor for your requirement. Set Serveroutput on;/ --PO Update ScriptDECLARELV_PO_HEADER_ID NUMBER := 11551815; CURSOR GET_rECORDS(p_in_n_po_header_id IN NUMBER… Continue reading PO Update Script in Oracle R12
Category: shipment
Item Shipment History Query in Fusion
Query to fetch the shipment history like item number, shipment date, Inventory, ship to site, ship to party, quantity , sales order number etc
Shipment Details Query In Oracle Fusion
SQL to fetch the shipment details like Shipment, carrier, Bill of Lading, item, inventory, sub inventory , ship to party etc