Was this your sequence: 1) checked accounts 2) Ran FNDCPASS 3) Ran adadmin or was this your sequence 1) Ran FNDCPASS 2) Ran autoconfig 3) checked apps and applsys by running sqlplus /nolog 3a) connect apps/new_apps_password 3b) connect applsys/new_apps_password 4) ran adadmin 5) attempted to change back by running, FNDCPASS apps/new_apps_password 0 Y system/system_password SYSTEM APPLSYS old_apps_password 6) ran autoconfig 7) ran adadmin and it still did not work. On Nov 1, 2010, at 8:09 AM, Mostafa Eletriby wrote: > I logged in successfully by these users & accounts are not locked. > Then I used FNDCPASS to change apps password but couldn't be reset & adadmin > still don't work. > Also I don't have a backup from table FND_USERS, I just took backup of table > fnd_oracle_userid , Do you think that decryption of passwords is corrupted ?? > > Please do you have any solutions ? > Thanks a lot > > --- On Mon, 11/1/10, sybin s <sybins@xxxxxxxxx> wrote: > > From: sybin s <sybins@xxxxxxxxx> > Subject: Re: Ad Administration , Ad Patch don't work & Application don't open > To: ora-apps-dba@xxxxxxxxxxxxx > Cc: oracle-l@xxxxxxxxxxxxx, oracle-tips@xxxxxxxxxxxxx > Date: Monday, November 1, 2010, 7:09 AM > > Hi Mostafa, > > Please restore the database or atleast the FND user tables if you have it > from the backup and do the FNDCPASS again and run autoconfig and see... > > -Sybin > > On Thu, Oct 28, 2010 at 2:24 PM, Mostafa Eletriby <m_etrib@xxxxxxxxx> wrote: > Hello DBAs , > > I have a problem at Ad Administration utility, after changing Apps password > by FNDCPASS. > Ad administration & ad patch don't work , also the application doesn't start. > > Instance: R12.1.3 > > > Please help me. > > ============================================== > > > AD Administration is verifying your username/password. > The status of various features in this run of AD Administration is: > > <-Feature version in-> > Feature Active? APPLTOP Data model Flags > ------------------------------ ------- -------- ----------- > ----------- > CHECKFILE Yes 1 1 Y N N Y N > Y > PREREQ Yes 6 6 Y N N Y N > Y > CONCURRENT_SESSIONS No 2 2 Y Y N Y Y > N > PATCH_TIMING Yes 2 2 Y N N Y N > Y > PATCH_HIST_IN_DB Yes 6 6 Y N N Y N > Y > SCHEMA_SWAP Yes 1 1 Y N N Y Y > Y > JAVA_WORKER Yes 1 1 Y N N Y N > Y > CODELEVEL Yes 1 1 Y N N Y N > Y > > > > Identifier for the current session is 31773 > > Reading product information from file... > > Reading language and territory information from file... > > Reading language information from applUS.txt ... > > AD Administration warning: > Product Data File > /u01/oracle/PROD/apps/apps_st/appl/admin/zfaprod.txt > does not exist for product "zfa". > This product is registered in the database but the > above file does not exist in APPL_TOP. The product > will be ignored without error. > > > AD Administration warning: > Product Data File > /u01/oracle/PROD/apps/apps_st/appl/admin/zsaprod.txt > does not exist for product "zsa". > This product is registered in the database but the > above file does not exist in APPL_TOP. The product > will be ignored without error. > > > AD Administration warning: > Product Data File > /u01/oracle/PROD/apps/apps_st/appl/admin/jtsprod.txt > does not exist for product "jts". > This product is registered in the database but the > above file does not exist in APPL_TOP. The product > will be ignored without error. > > > Reading database to see what industry is currently installed. > > Reading FND_LANGUAGES to see what is currently installed. > Currently, the following language is installed: > > Code Language Status > ---- --------------------------------------- --------- > US American English Base > > Your base language will be AMERICAN. > > Setting up module information. > Reading database for information about the modules. > Saving module information. > Reading database for information about the products. > AD Administration error: > DCPW null for "APPLSYS" [0] > > > AD Administration error: > Failed getting PDI list for product 'fnd' > > AD Administration error: > aipspv(): Error setting up PDI list for upgrade > > You should check the file > /u01/oracle/PROD/apps/apps_st/appl/admin/PROD/log/adadmin.log > > for errors. > > [oracle@R12 appl]$ > ======================================= > select ACCOUNT_STATUS from dba_users where username = 'APPS'; > ------------------------------ > ACCOUNT_STATUS > ------------------------------- > OPEN > ======================================== > > Please Support me. > Thanks > > > > > -- Michael Brown dba@xxxxxxxxxxxxxxxxx http://blog.michael-brown.org