Introduction: After upgrading our Oracle E-Business Suite environment to AD-TXK Delta 15, we encountered a front-end access issue the application URLs were not opening even though all services were up…
Read MoreWhen running the ADOP fs_clone command during an Oracle E‑Business Suite patch upgrade, you might encounter an error related to a missing PATCH FS CONTEXT FILE in the FND_OAM_CONTEXT_FILES table.…
Read MoreGetting Smart with Your Business Data: Inside Oracle EBS Enterprise Command Centers (ECC) V9 In Oracle E-Business Suite (EBS), it can be tough to quickly understand all your business information…
Read MoreOverview: In Oracle EBS 12.2 environments, it’s not uncommon to face login failures or form loading issues. These are often caused by oacore server anomalies in WebLogic. This blog walks…
Read MoreIssue :- 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 MoreIntroduction/ 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 MoreIntroduction: 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 Moredeclare 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 Moreselect 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 MoreIntroduction: 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 More