Overview: 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 MoreIssue 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 MoreDelete the concurrent programs Prerequisites: If the concurrent program is not in use, the program details need to be entered in the lookup and then this concurrent program needs…
Read MoreMany of you have asked about the best storage options for a multi-node EBS setup involving a DMZ server with a public load balancer. Here are some insights and best…
Read More