Get data to be modified from customer and load it into a staging table. Use this table in the below script to update Preparer/ Requester for PO Requisitions. DECLARE l_msg_data…
Read MoreUpload catalogue item Images in iProcurement Oracle iProcurement module is widely used by oracle users to raise catalog and non-catalog Purchase Requisitions. iProcurment module is very user…
Read MoreEnabling Link to access Excel file in iProcurement Oracle iprocurement module is widely used by oracle users to raise catalogue and non-catalogue Purchase Requisitions. IProcurment module is very…
Read MoreWhat is Oracle Process Manufacturing? How many modules are covering Oracle Process Manufacturing? What are the Major Functionalities in Product Development? Is Co-Product and By Product are different? Setup Step:1…
Read MoreIntroduction Procurement Team would like to use “Upload” or Excel sheet options to update the Global Blanket Purchase Agreement (GBPA). Using the functionality in R12 has changed. Hence this document…
Read MoreBackground The Purchase order or Requisitions are not valid unless it is approved. In any of the procurement process, most of the issues occur in the approval of the purchasing…
Read MoreWITH PARAMETER AS (SELECT :PERIOD_NAME AS PERIOD_NAME FROM DUAL) SELECT distinct prj.project_id,prj.segment1, (SELECT ROUND(SUM(tot_burdened_cost),2) FROM apps.pa_txn_accum WHERE project_id=prj.project_id AND gl_period =PARAMETER.PERIOD_NAME — and…
Read MoreSELECT DISTINCT aca.payment_method_lookup_code trans_type, TO_CHAR (aca.check_number) invoice_num, TO_CHAR (aca.check_date) invoice_date, …
Read MoreSELECT rctt.description trans_type, TO_CHAR (rct.trx_number) invoice_num, TO_CHAR (rct.trx_date) invoice_date, TO_CHAR (rcl.line_number) ponum_inv_linenum, rcl.description line_desc, TO_CHAR (rcl.quantity_invoiced) requestor_qty_inv, TO_CHAR…
Read MoreSELECT NULL trans_type, ent.transaction_number invoice_num, (SELECT TO_CHAR (trx_date) FROM ra_customer_trx_all WHERE customer_trx_id = aaa.customer_trx_id) invoice_date, …
Read More