Introduction/ Issue: In Oracle E-Business Suite R12 Warehouse Management System (WMS), Cost Group Rules are commonly used to dynamically assign cost groups during inventory transactions. Once a cost group rule…
Read MoreHow to Configure Peer-to-Peer Replication in SQL Server: Complete Guide Introduction: In high-availability environments, applications often require data to be available for both read and write operations across multiple…
Read More Introduction: In Oracle Apps R12 Order Management, users create Sales Orders using the Sales Order Form (OEXOEORD). By default, the form allows users to select any Order Type assigned…
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 MoreIncrease on-hand quantity interface using miscellaneous receipt To increase on-hand quantity via a miscellaneous receipt interface, you use an ERP/Inventory system ( to record items found during a physical count that exceed…
Read MoreCreating a BOM Item Creating a Bill of Materials (BOM) item in Oracle Apps R12 involves defining the parent assembly and its components within the Bills of Material module, ensuring prerequisites like items…
Read MoreIntroduction: – This document explains the process of creating a custom button inside an Interactive Grid (IG) and dynamically setting the value of another column by using JavaScript and PL/SQL…
Read MoreIntroduction: – This document explains how to dynamically change column labels on page load for an Interactive Grid (IG) in Oracle APEX using JavaScript. This approach helps when column names…
Read More