APPSINFODB – Information Technology Group

Finding Solutions for DBA's to smile…….!!!!!!! DBA its just not Administration, its core of customer’s data integrity

  • Blog Stats

    • 36,440 hits
  • Visitors

    free counters
  • Vistors Access

  • Calendar

    November 2008
    M T W T F S S
    « Aug   Feb »
     12
    3456789
    10111213141516
    17181920212223
    24252627282930
  • Archives

  • Authors

How to use FNDCPASS

Posted by appsinfo on November 15, 2008

 Security – > FNDCPASS

Note: To change APPS/APPLSYS password, we need to give mode as SYSTEM

To change product schema passwords, i.e., GL, AP, AR, etc., we need to give mode as ORACLE

To change end user passwords, i.e., SYSADMIN, OPERATIONS etc., we need give mode as USER

Steps to change Apps Password using FNDCPASS

1. Take backup of FND_USER and FND_ORACLE_USERID

create table fnd_users_backup as select * from fnd_users;

create table fnd_oracle_userid as select * from fnd_oracle_userid

FNDCPASS APPS/APPS 0 Y SYSTEM/MANAGER SYSTEM APPLSYS <NEWAPPSPWD>

Post steps after changing the Apps Password

$IAS_ORACLE_HOME/Apache/modplsql/cfg

–In some instances you might have to change in CGIcmd.dat at $ORACLE_HOME/reports60/server

–You also have to change in any custom concurrent manager start up script (If you have any)

Test the changed password:

 <<http://hostname.domainname:8010/OA_HTML/jsp/fnd/aoljtest.jsp>>

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: