Oracle Ebuisness Suite Archives - Page 12 of 33

Query to check languages installed in oracle apps

We can have different languages installed in Oracle apps. Here is the Query to check languages installed in oracle apps select LANGUAGE_CODE from fnd_languages where INSTALLED_FLAG in (‘B’, ‘I’); The Installed_Flag has 3 values I- InstalledB- BaseD- Disabled Example sqlplus apps/<apps pass>select LANGUAGE_CODE from fnd_languages where INSTALLED_FLAG in (‘B’, ‘I’);LANG_____USDFR Important Points The above query …

Query to check languages installed in oracle apps Read More »

How to change apps password in EBS R12.2

Oracle, Oracle Ebuisness Suite

Apps password change in R12.1/R12.0 just requires changing password using FNDCPASS and then running autoconfig. But R12.2 introduced weblogic in the Techstack, so we need to change the apps password in WebLogic also. We need to follow a few steps while changing the apps password in EBS R12.2. They are given as below Steps to …

How to change apps password in EBS R12.2 Read More »

Create EBS user from backend & Assign Responsibility

Oracle, Oracle Ebuisness Suite

Oracle EBS users can be created from the front end through Oracle forms or using backend PLSQL Blocks as well. We will see how to create user in oracle apps from the backend in this post Application User can be created from sqlplus using PLSQL Block Set serveroutput on BEGIN fnd_user_pkg.CreateUser(x_user_name => ‘UserName’ ,x_owner => …

Create EBS user from backend & Assign Responsibility Read More »

Oracle apps queries for APPS DBA

Oracle, Oracle Ebuisness Suite

Oracle Apps DBA has too often troubleshoot various issues. I am giving here the Top 30 Useful oracle apps queries for DBA how to find form session id in oracle The below query will provide the session details for all the forms opened in the applications set linesize 1000 column username format a8 heading “User|Name” …

Oracle apps queries for APPS DBA Read More »

How to generate TNS_ADMIN files in R12

Oracle, Oracle Ebuisness Suite

We might have encountered a problem, where the Application TNS_ADMIN files like tnsnames. ora, listener. ora and sqlnet. ora is incomplete or corrupted. The solution for this issue is either we run autoconfig on the application or we can generate the tns_admin file using one command also. Let’s see How to generate TNS_ADMIN files in …

How to generate TNS_ADMIN files in R12 Read More »

How to Clone Oracle Application Server 10g

Oracle, Oracle Ebuisness Suite

Here are the steps outlined for How to Clone the Application Server Given source machine is SUN1 and the target machine is SUN2. Prepare steps 1) On the source and target ensure that the PERL5LIB variable is set. 2) $ export PERL5LIB=$ORACLE_HOME/perl/lib/5.6.1:$ORACLE_HOME/perl/lib/site_perl/5.6.1 3) cd $ORACLE_HOME/clone/bin 4) ./prepare_clone.pl ORACLE_HOME=$ORACLE_HOME Create a tar file and copy it …

How to Clone Oracle Application Server 10g Read More »

Oracle Ebuisness Suite

Oracle E-business Suite also called as Oracle application is a suite of business applications made up of a large number of distinct software modules.Examples are Oracle Supply chain, Oracle financials etc

This page contain all the administration related post for all the Oracle apps version 11i/R12/R12.1/R12.2

Query to check languages installed in oracle apps

How to change apps password in EBS R12.2

Create EBS user from backend & Assign Responsibility

Oracle apps queries for APPS DBA

How to generate TNS_ADMIN files in R12

How to Clone Oracle Application Server 10g