When Database Migrations Go Wrong: Snowflake to Oracle Every database migration project starts with optimism: “We’ve mapped the tables, the data looks similar – how hard can it be to…
Read MoreIntroduction: When performing a Post-PDB Creation Task in Oracle EBS 12.2, you may encounter the following error while running the txkPostPDBCreationTasks.pl script: FUNCTION: main::validateAppsSchemaCredentials [ Level 1 ] ERRORMSG: Invalid…
Read MoreIntroduction: 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 More