EBS

Configuring Work Orders to Align with Resource Requirements in Fusion Supply Chain Planning

Issue:   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 More

Troubleshooting EBS 12.2 adcfgclone Failure: JAVA_HOME Issue in commEnv.sh

EBS 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 More

Oracle Table Partitioning Strategies

Managing 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 More

Item Where-Used Analysis Report (Excel – PL/SQL)

Introduction: 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

Procedure to create Quality Spec INV Validity Rule in OPM through API

    Introduction: 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 More

The Oracle Migration Challenge – Datatype Conversion Nightmares

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 More

 Invalid APPS Database User Credentials in txkPostPDBCreationTasks After PDB Creation in Oracle EBS 12.2

Introduction: 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

Oracle EBS Front-End Inaccessible After AD-TXK Delta 15 Upgrade Fixed by Updating Mod-security Rules

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 More

Resolving the “Missing PATCH FS CONTEXT FILE” Error in FND_OAM_CONTEXT_FILES

When 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 More

What New In ECCV9?

Getting 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 More