How to read the excel file in Oracle R12 using PL-SQL.
Tag: Oracle R12
PO Update Script in Oracle R12
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
Purchasing Org of an Operating Unit in Oracle R12
How to set up and query the purchasing org of an operating unit in Oracle R12.
Approved Supplier List( ASL) Creation Script in Oracle R12
PL-SQL Script for Approved Supplier List creation for item(s) In Oracle R12 using API po_asl_api_pub.create_update_asl