Yearly Archives: 2025

AR Customer Dunning Strategy Status Report

Introduction: This blog has the SQL query that can be used to pull the data for the AR Customer Dunning Strategy Status Report Cause of the issue: Business wants to see the AR Customer Dunning Strategy Status Report How do we solve:   Create a BI report in fusion using below SQL query to extract the details. With cust  as ( select hp.party_id, hp.party_number cust_number, hp.party_name cust_name, hca.cust_account_id, hca.account_number CUST_ACCOUNT_NUMBER from   hz_parties hp, hz_cust_accounts hca where  hp.party_id = hca.party_id ) , cltr as ( select acl.collector_id, acl.employee_id, acl.name collector, pmail.email_address collector_email from   ar_collectors acl, per_email_addresses_v pmail where  acl.employee_id = pmail.person_id ) , stg_temp as ( select WORK_ITEM_TEMP_ID, name task, DESCRIPTION from IEX_STRY_TEMP_WORK_ITEMS_VL group by WORK_ITEM_TEMP_ID, name, DESCRIPTION )…

Read More

Not able to submit the Print statement in AR

Issue :- Not able to submit the Print statement in AR Cause of the issue: ​Statement Periods are not defined for the New Year. How do we solve: We need…

Read More

Need to delete the incorrect receipt entry from Account receivables

Introduction/ Issue:   Need to delete the incorrect receipt entry from Account receivables User has mistakenly made Receipt entry by selecting wrong customer  now they need to delete the incorrect receipt…

Read More

Update the Project Status using API

Introduction: This blog has the SQL Script to update the Project Status using API along with each task.   Cause of the issue: To update status of the project and…

Read More

API Script To Update Supplier Details

This blog has the script to update the supplier details using API AP_VENDOR_PUB_PKG.UPDATE_VENDOR.   Cause of the issue: Some of the fields are not visible and don’t have option to…

Read More

Implementing Inline Child Reports in Oracle APEX Interactive Reports

Introduction/ Issue:  In Oracle APEX, users often need to display additional details related to a record without navigating to a new page. This can be achieved by creating an inline…

Read More

Refresh Main Page on Dialog Close Using JavaScript in Oracle APEX

Introduction/ Issue:  When working with Oracle APEX, it is common to open a modal dialog for updating records. Once the update is completed and the dialog is closed, refreshing the…

Read More

New TDS rate creation

Business requested a new TDS rate for the supplier to apply at invoice level.  Steps: Load new recovery tax rate.  Navigator: Setup and Maintenance à Financials à Manage tax codes …

Read More

Using UTL_MATCH for Fuzzy Search in Oracle APEX

Introduction Oracle APEX applications often require efficient search functionality. However, traditional SQL LIKE searches do not handle typos or similar words effectively. A fuzzy search can improve search accuracy by…

Read More

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,dbms_lob.session); :g_clob := dbms_xmlquery.getXml(l_ctx); end;

Read More