Lot Genealogy Report
Introduction: This blog has the SQL query that retrieves the complete lot genealogy, detailing the full lifecycle of product creation. Cause of the issue: Business wants a report that contains…
Read MoreQuality Test Sample Throughput Report
Introduction: This blog has the SQL query that retrieves all Quality test samples along with their corresponding results. Cause of the issue: Business wants a report that contains the details…
Read MoreHow to Expose Custom PL/SQL API as a REST Webservice?
How to Expose Custom PL/SQL API as a REST Webservice? Oracle E-Business Suite Integrated SOA Gateway (ISG) provides an infrastructure to deploy, consume, and administer Oracle E-Business Suite web services.…
Read MoreProcedure to Upload Purchase Quotations
PROCEDURE load_purchase_quotation as lv_currency_code fnd_currencies_vl.currency_code%type; lv_verify_flag varchar2 (1); lv_error_message varchar2 (5000); ln_vendor_id po_vendors.vendor_id%type; ln_vendor_site_id po_vendor_sites_all.vendor_site_id%type; ln_ship_to_locn_id hr_locations.location_id%type; ln_bill_to_locn_id hr_locations.location_id%type; ln_inventory_item_id mtl_system_items_b.inventory_item_id%type; lv_legacy_quotenum varchar2 (30); ln_batch_id number (3); ln_term_id number; lv_freight_code…
Read More