With 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 MoreIntroduction: This blog has PLSQL query that can be used to create Quality Spec INV Validity Rule using oracle seeded API. Cause of the issue: Business will…
Read MoreWhen 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 More