EBS Technical

Integrating Oracle EBS with Oracle Apex

Introduction / 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…

WIP Move Transaction

Automating 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…

Applying and Releasing Sales Order Holds Based on Customer Item Cross-Reference Commodity Code

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,…

Supplier Master Details in Oracle Apps R12

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…

Sample Code for AP PO Accrual Write off and Close PO

PROCEDURE 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…

Query for AP Invoices Pending for Approval

SELECT 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…

Creation of Bursting using XML Data Template

Step 1: Create XML Data Template <?xml version=”1.0″ encoding=”UTF-8″ ?> <dataTemplate name=”AP_INVOICE_DETAILS” description=”AP_INVOICE_DETAILS” version=”1.0″> <properties> <property name=”xml_tag_case” value=”upper”/> <property name=”Include_Parameters” value=”True”/> </properties> <parameters> <parameter name=”P_VENDOR_ID” dataType=”NUMBER”/> <parameter name=”P_INVOICE_NUM” dataType=”CHARACTER”/> <parameter…

We take you from best practices to next practices of software implementation

Solutions that Ensure You Stay Ahead of Competition

Your Partner for Strategic Technology Solutions

Guiding Your Digital Transformation Journey