EBS

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

R12 – 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 More

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

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

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

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

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

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

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

Oracle Service Contract Cycle in Oracle EBS R12

oracle-service-contract-cycle-in-oracle-ebs-r12

Read More