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 MoreUsing 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 MoreOracle 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 MoreNew tax rate creation
Business requested a new VAT to apply the tax at the invoice level. Steps: Go to Set up and Maintenance > Financials > Transaction Tax > Manage Tax Rates and…
Read MoreOracle 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_headers qph,APPS.HZ_CUST_ACCOUNTS_ALL HCAA,APPS.HZ_CUST_ACCT_SITES_ALL HCASA,APPS.HZ_CUST_SITE_USES_ALL HCSUA,APPS.HZ_PARTIES HPWhere hcaa.account_number = –Customer Account Numberand HCAA.CUST_ACCOUNT_ID = HCASA.CUST_ACCOUNT_IDand HCASA.CUST_ACCT_SITE_ID = HCSUA.CUST_ACCT_SITE_IDAND HCSUA.PRICE_LIST_ID = QPH.LIST_HEADER_IDAND HCAA.PARTY_ID=HP.PARTY_ID
Read MoreDynamic JSON Storage in Oracle APEX Forms
Introduction Oracle APEX applications often require storing complex, structured data in a flexible way. Instead of creating multiple tables for dynamic data structures, we can leverage JSON storage in a…
Read MoreHow to pass multiple parameters in REST API web service
Introduction: The purpose of this document is to demonstrate how we pass multiple set of parameters in REST API through Postman. Cause of the issue: Whenever we test any REST…
Read MoreExploring the New Security Features in Oracle Database 23ai
Oracle Database 23ai introduces advanced security features designed to enhance data protection, simplify configurations, and align with modern security standards. These updates strengthen the database’s security posture and improve usability…
Read MorePurchase Invoice GL to AP Drill down for Account Analysis Reconciliation
Introduction: This document outlines how to reconcile Oracle General Ledger (GL) and Oracle Payables (AP) for Purchase Invoice analysis by using a specific SQL script to drill down to the…
Read MoreAP: Create Accounting Completed In Warning with Offsets Error
Issue Overview: The error “The accounting program cannot create this journal line because the debit or credit that offsets it cannot be found” occurs when attempting to run the Create…
Read More