Challenges and Solutions from working on Oracle E-Business Suite.
ERP Cloud Financials Fusion – Cash Management Auto Reconciliation Introduction Bank Statement Reconciliation – Match Statement Lines and Transactions – Automatic and Manu...
Read More
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
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
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
Introduction/ Issue:  CSV file move from client local machine to database table blob column. Why we need to do / Cause of the issue: We can store the C...
Read More
Introduction: Splitting of order lines, this can be done during shipping last part of sales order, generally we come across this scenario, when we want to ship partial quantity whe...
Read More