Yearly Archives: 2020

Disabling Language Selection Option In AppsLocalLogin.jsp

Introduction: The below post discusses about disabling language selection option available in AppsLocalLogin.jsp. Method to disable the language selection: Check the version of file AppsLocalLogin.jsp which is under $OA_HTML This…

Read More

Glimpse of External Tables in Oracle Database

  Introduction: In this article, we can see what External Tables are and how to manage those tables within the Oracle Database. About External Tables: External tables are defined as tables…

Read More

Adcfgclone failing with Error: AFTER PASTEBINARY COMMENV.SH FILE IS POPULATED WITH INCORRECT JAVA_HOME PATH in EBS 12.2

Adcfgclone failing with Error: AFTER PASTE BINARY COMMENV.SH FILE IS POPULATED WITH INCORRECT JAVA_HOME PATH in EBS 12.2 Oracle Support notes: ===================== 12.2 E-Business Suite Applications Manager Rapidclone Fails With…

Read More

Steps to Implement Transparent Data Encryption(TDE) using fast offline conversion for Oracle Databases

Prerequisite: Make sure you have applied the patch 23315889(fast offline conversion patch) if you are on Oracle 11g Database or latest CPU patches are applied which already include all the…

Read More

DBCA Configure Database option is greyed out in Oracle

Database Configuration Assistant was not showing the database and Configure Database Options and it was greyed out(disabled). We tried setting up ORACLE_SID and ORACLE_HOME and ran dbca but it was…

Read More

Gather Schema Statistics – Program error with Locks and Duplicate columns

Oracle E-Business Suite Release 12 uses cost–based optimization in order to choose the most efficient execution plan for SQL statements.Gather Schema Statistics is the favourite one among Apps DBA’s and…

Read More

How to open Concurrent Out file in excel format

An *.out file is a compiled executable file created by various source code compilers in Unix-like operating systems, such as Linux and AIX. *.out files are most commonly seen as…

Read More

No Write Permission on ACFS Mount Point

I managed to create the ACFS Mount Point after resolving the issue “ACFS-9459: ASVM/ACFS is not supported on this os version”. But, after creating the ACFS Mount Point, I’m unable…

Read More

Oracle Learning Management – Training History report

The sample query can be used to extract the Training history report for an employee in Oracle OLM(Learning Management) Query : Oracle Learning Management – Training History report SELECT full_name,…

Read More

Oracle PMS : Employee KRA (Objectives & competencies) report query

The below sample query can be used to extract the objectives , competencies for an employee in Oracle EBS PMS Query: KRA Report (Objectives & Competencies) for an person id,…

Read More