Identify versions of components in EBS
Useful commands to find the versions of various components used in Oracle E-Business Suite Find Apache Version or Oracle Application server version in R12 Log in to the Application server…
Read MoreHow to Expose Custom PL/SQL API as a REST Webservice?
How to Expose Custom PL/SQL API as a REST Webservice? Oracle E-Business Suite Integrated SOA Gateway (ISG) provides an infrastructure to deploy, consume, and administer Oracle E-Business Suite web services.…
Read MoreR12 – Accounting Setup Manager Checklist
r12_setup_check_list Accounting Setup Manager Checklist The following table describes the steps to create accounting setups using Accounting Setup Manager. Each required setup step must be completed before you can complete…
Read MoreQuery to fetch Routing Details
Introduction: Routing is a set of operations that will be performed in sequence to manufacture an assembly Item. The below query will give the operation sequence details. Query to fetch…
Read MoreHow to overcome ORA-01102: cannot mount database in exclusive mode?
Introduction: While starting the Oracle database in the mount stage was failed (ORA-01102: cannot mount database in exclusive mode) with the below error Error: SQL> alter database mount; alter database…
Read MoreAdop hot patch failed with unexpected Error in EBS 12.2.8
Introduction: This blog is intended for DBA’s who may pass off with the below error message on applying a patch as hot patch in the instance. While applying adop hot…
Read MoreWebLogic AdminServer Error-“unable to get file lock, will retry”
Cause: When WebLogic Server Starts,it creates a lock file with .lok extension under $DOMAIN_HOME/server/<Server_Name>/tmp location It cleans .lok file when weblogic server stops If OS or Server abnormally rebooted during…
Read MoreCAUSE AND FIX for MISSING RESPONSIBILITIES issue in EBS R12
CAUSE AND FIX for MISSING RESPONSIBILITIES issue in EBS R12 =================================================== 1) Run the Concurrent Program “Workflow Directory Services User/Role Validation” with the following Parameters Batch Size : 100000 Fix…
Read MoreSteps to apply EBS12_2 CPU July 2023 with AD and TXK 14 upgrade
REFERENCES :- ============ Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1) Document 1594274.1, Oracle E-Business Suite Release 12.2: Consolidated List…
Read MoreEBS-R12.2.5:adpreclone.pl Fails with Error Message – Edit session is enabled in domain
Getting ”edit session is enabled error” when running adpreclone.pl command in ebs R12.2.5 Cause: Lock&Edit session is enabled in weblogic console. Solution: Login to weblogic console Click Release configuration on…
Read More