Validating SYSADMIN PASSWORD in EBS
COMMAND
select fnd_web_sec.validate_login('SYSADMIN','<SYSADMIN PASSWORD>')
from dual;
from dual;
EXAMPLE
select fnd_web_sec.validate_login('SYSADMIN','sysadmin')
from dual;
from dual;
EBS R12.2 Autoconfig Failed. Resolved
Hi, Please do the following and retest the issue: Due to the method required for "cleaning out" / "re-synchronizing" the following tables, it is EXPECTED / REQUIRED that the Applications have been shutdown. The only thing running should be the Database Tier. Note: A full backup should also be taken before any testing begins. Test the following steps in a development instance, and then migrate accordingly once the desired result is confirmed: 1. Backup the fnd_oam_context_files, fnd_nodes, and adop_valid_nodes tables in the EBS env: sqlplus applsys/pwd create table fnd_oam_context_files_bkp as select * from fnd_oam_context_files; create table fnd_nodes_bk as select * from fnd_nodes; create table adop_valid_nodes_bk as select * from adop_valid_nodes; 2. Truncate the following tables: truncate table fnd_oam_context_files; truncate table fnd_nodes; truncate table adop_valid_nodes; 3. Run AutoConfig on the DB tier ...
Comments
Post a Comment