Pages

Thursday, April 7, 2016

FNDCPASS Utility In Oracle Applications

FNDCPASS Utility In Oracle Applications

FNDCPASS is a Oracle provided FND Utility to change the passwords in Oracle Applications. FNDCPASS submits a concurrent request for completing the FNDCPASS request. Thus creates a log and output file in the location from where FNDCPASS is run. Check the log file for any errors.  We can change the below passwords using:

FNDCPASS

-APPLSYS/APPS
-Oracle EBS Product Schema Passwords e.g. ap, ar, pay etc
-Front End User Passwords e.g. SYSADMIN etc

Tokens Used In FNDCPASS

The SYSTEM token is used when changing the APPLSYS/APPS password.
The ORACLE token is used when changing a SINGLE Applications schema password.
The USER token is used when changing an Applications USER password.
The ALLORACLE token is used when changing ALL Applications schema passwords.

Usage Of FNDCPASS

FNDCPASS <APPS username>/<APPS password> 0 Y <SYSTEM username>/<SYSTEM password> <token> <username> <new_password>

Changing APPS Password:
The following is the usage of FNDCPASS to change APPS Password:
FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS WELCOME
(Here WELCOME denotes new APPS password)

Changing Product Schema Password:
The following is the usage of FNDCPASS to change Product Schema Password:
FNDCPASS apps/apps 0 Y system/manager ORACLE   GL  GL1
(Here GL1 denotes new password of Product Schema GL)

Changing User Password:
To find the syntax, just type FNDCPASS which gives the syntax. The below are the sample examples:
FNDCPASS apps/apps 0 Y system/manager USER VISION WELCOME
(Here WELCOME denotes new password of the Applications User VISION)

Change all ORACLE schema passwords
The ALLORACLE token is used when changing ALL Applications schema passwords.

FNDCPASS <logon> 0 Y <system/password> ALLORACLE <new_password>
FNDCPASS apps/apps 0 Y system/manager ALLORACLE WELCOME

Note If we Changing the APPLSYS password automatically changes the APPS password.
Once you changed the applsys password in Oracle application 11i you need to run autoconfig which in turn update the apps password in the below files if exists. If you don't want to run autoconfig just go and update below files if exists.

1.$IAS_ORACLE_HOME/Apache/modplsql/cfg/wdbsvr.app
2.$FND_TOP/resource/wfmail.cfg
3.$ORACLE_HOME/reports60/server/CGIcmd.dat

-Connect to database as apps schema.
-Start the concurrrent manager script.
-Start web/forms services.
-Submit a concurrent request and check that request completes successfully.

Following activities will take place when we changed applsys password.

-applsys validation. (make sure APPLSYS name is correct)
-re-encrypt all password in FND_USER
-re-encrypt all password in FND_ORACLE_USERID
-update applsys’s password in FND_ORACLE_USERID table.
-Update apps password in FND_ORACLE_USERID table.

Changing APPLSYS password in Oracle Application R12

-Shutdown all the application nodes.
-Shutdown the concurrent node.
-To check syntax
use FNDCPASS and press enter it will give you the syntax.

oracle@testapp]$ FNDCPASS

Note: Changing the APPLSYS password automatically changes the APPS password.

-Connect to database as apps schema.
-Start the concurrrent manager script.
-Shutdown all the application nodes.
-Submit a concurrent request and check that request completes successfully.

Import Notes:

-Oracle Applications system should be shut down before changing any schema passwords. Also FND_USER and FND_ORACLE_USERID tables should be backed up before changing any passwords.

-After changing the Apps password run autoconfig in 11i, but  in R12 it is not required, as it doesn't store apps password in the flat files.

-FNDCPASS logfile is created in the current directory.

0 & Y are flags for FND Executable like FNDCPASS & FNDLOAD where

'0' is request id (request ID 0 is assigned to request ID's which are not submitted via Submit Concurrent Request Form.
'Y' indicates the method of invocation. i.e. it is directly invoked from the command-line not from the Submit Request Form.

Reference metalink Doc ID 437260.1

No comments:

Post a Comment