Database Blog

User Notification Preference Updated to DISABLED in Workflow

Introduction: User’s notification preferences are being disabled in WF_LOCAL_ROLES table and the administrator is receiving email notification such as following: To SYSADMIN Sent 10-Nov-2011 14:25:32 ID 5208 What happens and…

Read More

Determine the version of Berkeley Database in Oracle Unified Directory

Introduction: In this article we will see how to determine the version of Berkeley Database in Oracle Unified Directory (OUD). Ways to determine the version: There are 3 known ways…

Read More

Remote Connections Via the Listener to the Database Fail with TNS-12526, TNS-12527 or TNS-12528

Introduction: Connections via the listener to an instance that is in RESTRICTED status or in NO MOUNT status may fail with TNS-12526, TNS-12527 or TNS-12528 even when supplying the credentials…

Read More

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

Examples of Partition Methods and Keys for Oracle EBS Tables

This is not an exhaustive list, just an example of some of partitioning designs that may work well for some customers. There are many other examples that are not covered…

Read More

WebAdi Download Is Failing Intermittently performance issue

The download of WEBADI is taking too long and has a Performance issue. It takes 1 minute to 8 minutes when users expect 8 seconds to 30 seconds. The user…

Read More

Upgrade Excel To 2013 64-bit Error ‘The code in this project must be updated for use on 64 bit systems’ Uploading Data To WEBADI Template

After upgrading Microsoft Excel to version 2013 64bit, when uploading data to the template WEBADI, the template is blank. However when looking at the Excel Macro Information, the following Error…

Read More

WEB ADI Performance Issue When Data Entry Rows is High

WEB ADI Performance Issue When Data Entry Rows is High While updating the Data Entry Rows in the Lines section to 30000, then the upload takes a long time (10…

Read More

Forms memory consumption

The Following query is to get the memory consuming forms sessions. #!/bin/sh ALLPROCS=`ps -ef|grep “f60webmx webfile=” | grep -v grep | tr -s ” ” | cut -f3 -d” “`…

Read More