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 > > > >