Issue: During an Oracle E-Business Suite (EBS) patching cycle, the Prepare phase was observed to be stuck and not progressing further. The process continued to run without any visible error in the adop…
Read MoreIntroduction: While accessing Oracle E-Business Suite Embedded Command Center (ECC), users may encounter the error “400 Bad Request: Current user not authorized to access data set” for specific ECC datasets…
Read MoreIntroduction: Java-based middleware components such as Apache Tomcat and ORDS are highly dependent on correct JVM configuration. Misalignment between Java versions and heap settings can result in critical startup failures.…
Read MoreWith the transition to Oracle E-Business Suite (EBS) R12.2, the technical landscape for customizations shifted significantly. The introduction of Online Patching (adop) and Edition-Based Redefinition (EBR) means that traditional DDL…
Read MoreIntroduction In the oracle EBS the concept of Purging and before purging the order management related tables, pre-requisite to be done for the smooth purging process. The below script will…
Read MoreIntroduction/ Issue: This SQL query is designed to extract Batch Header and Material Details from Oracle Process Manufacturing (OPM). It consolidates information such as company code, plant, batch number, recipe,…
Read MoreIssue: The Work Orders for a specific item loaded from EBS into Fusion Supply Chain Planning are appearing in the Buyer Material Plan within the supply plan. However, they are…
Read MoreEBS 12.2 Cloning Issue – adcfgclone Fails Due to Incorrect JAVA_HOME in commEnv.sh Background During one of my Oracle E-Business Suite (EBS) 12.2 cloning activities, I encountered an issue where…
Read MoreManaging Partitions in Oracle Database – A Complete Guide for DBAs Partitioning in Oracle Database offers a powerful way to improve performance, manageability, and scalability for large datasets. By dividing…
Read MoreIntroduction: This blog has the SQL query that can be used for Item where used Report in Oracle Apps R12. Cause of the issue: Business wants a PLSQL excel based report…
Read More