Applying and Releasing Sales Order Holds Based on Customer Item Cross-Reference Commodity Code In Oracle Order Management, business rules often require dynamic control over Sales Order processing. In this case,…
Read More Introduction: This blog provides a consolidated SQL query that can be used to generate a Supplier Master Details Report in Oracle Apps R12 (Payables). The report gives a complete…
Read MorePROCEDURE main ( errbuff OUT NOCOPY VARCHAR2, retcode OUT NOCOPY VARCHAR2, p_file_name IN VARCHAR2 ) IS BEGIN start_process (p_file_name); — write_output; EXCEPTION WHEN OTHERS THEN NULL; END; PROCEDURE start_process (p_filename…
Read MoreSELECT DISTINCT aiha.invoice_id, response, aiha.creation_date, ai.invoice_date, (SELECT vendor_name FROM apps.po_vendors WHERE vendor_id = ai.vendor_id) vendorname, (SELECT ai.invoice_num FROM ap_invoices_all ai WHERE ai.invoice_id = aiha.invoice_id) invoice_number, (SELECT ai.invoice_amount FROM ap_invoices_all ai…
Read MoreWith the transition to Oracle E-Business Suite (EBS) R12.2, the technical landscape for customizations shifted significantly. The introduction of Online Patching (adop) and Edition-Based Redefinition (EBR) means that traditional DDL…
Read MoreIntroduction: 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 MoreIntroduction: 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 MoreAPI to Update Item Status in Oracle E-Business Suite Introduction In Oracle E-Business Suite (EBS), Item Status controls key aspects of how an item behaves across different modules such as…
Read MoreAPI to Update the Item Categories in Oracle EBS Introduction In Oracle E-Business Suite (EBS), item categories play a crucial role in organizing and classifying items for inventory, costing, and…
Read MoreSELECT SUM (target_qty) FROM (SELECT segment1, description, mtl.primary_uom_code, moqv.subinventory_code subinv, moqv.inventory_item_id item_id, SUM (transaction_quantity) target_qty FROM apps.mtl_onhand_qty_cost_v moqv, apps.mtl_system_items_vl mtl WHERE moqv.organization_id = :p_organization_id AND moqv.inventory_item_id = :p_inventory_item_id AND moqv.inventory_item_id…
Read More