How to add the external URL Dynamically in Oracle Application Framework ( OAF). This can be used to open external URL in a new tab.
Category: R12
Dynamically Adding Update Icon in OAF
How to add the update icon ( Or any other icon) dynamically in OAF. It helps when it should be visible conditionally
Excel File Reading using PL-SQL in Oracle R12
How to read the excel file in Oracle R12 using PL-SQL.
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.