Oracle Application Blog

Challenges and Solutions from working on Oracle E-Business Suite.

Arun Kumar / Oracle Application Blog / 01 Jul 2025

Streamlining Oracle EBS Application Tier Patching with ETPAT-AT

Patching Oracle E-Business Suite (EBS) application tier technology components has always been a delicate balance of precision, downtime planning, and repeatability. To ease this pr...

Read More

Bhaskar / Bank / Oracle Application Blog / Oracle Apps / Oracle Cloud / Cash Management / Reconciliation / 26 Mar 2025

ERP Cloud Financials Fusion – Cash Management Auto Reconciliation

ERP Cloud Financials Fusion – Cash Management Auto Reconciliation Introduction Bank Statement Reconciliation – Match Statement Lines and Transactions – Automatic and Manu...

Read More

Joy Soundararajan / APEX / Database Blog / EBS / EBS Functional / EBS Technical / Fusion / Oracle Application Blog / PL/SQL / SQL Queries / 24 Mar 2025

Oracle PLSQL to Generate XML Tag Using Standard Functionality

declare l_ctx dbms_xmlquery.ctxHandle; l_clob clob; begin l_ctx := dbms_xmlquery.newContext(‘select * from <TABLE_NAME>’); dbms_lob.createtemporary(:g_clob,true,d...

Read More

Joy Soundararajan / EBS / EBS Technical / Oracle Application Blog / PL/SQL / SQL Queries / 24 Mar 2025

Oracle R12 SQL Query – Price List or Fee Schedule for Customer

select HP.PARTY_NAME “Customer Name”,HCAA.ACCOUNT_NUMBER,HCAA.ACCOUNT_NAME,qph.name “Price List Name”,HCSUA.SITE_USE_CODE,HCSUA.LOCATION from qp_list_header...

Read More

Ramesh Gnanasekaran / Oracle Application Blog / PL/SQL / 04 Feb 2025

Blob File Move From DB to Directory

Introduction/ Issue:   CSV blob file to raw file move from database table blob column to database directory. Why we need to do / Cause of the issue:  WeÂ...

Read More