Introduction / Issue In Oracle Shipping Execution (WSH), it’s common to run into a situation where a delivery has been closed, but the associated trip remains open because the trip…
Read MoreIntroduction In Oracle Applications R12, supplier bank account details are not stored in a single, easily queryable table. They’re spread across the Oracle Payments (IBY) schema and Accounts Payable (AP)…
Read MoreIntroduction / Issue Organizations often develop custom applications in Oracle APEX to extend the functionality of Oracle E-Business Suite (EBS). However, one common challenge is integrating Oracle APEX with Oracle…
Read MoreAutomating Oracle EBS WIP Move Transactions with PL/SQL Moving a discrete job through its routing — queue, scrap, hold, or across plants — is another WIP activity that’s fine to…
Read MoreApplying 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 MoreIntroduction/ Issue: This blog contains an API and that can be used in Oracle EBS to create Quality samples and the corresponding results. Why we need to do / Cause…
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 More