ERROR: While running autoconfig i am getting below error, autoconfig failing – jtfictx.sh Solution: SQL> exec ctxsys.ctx_adm.set_parameter(‘file_access_role’, ‘public’) PL/SQL procedure successfully completed. After executing this run autoconfig.
Read MoreError: Perl lib version v5.8.3 doesn’t match executable version v5.10.0 Solution: export ORACLE_HOME=/u01/oracle_home/db/tech_st/12.1.0.2 export PERL5LIB=$ORACLE_HOME/perl/lib/5.10.0:$ORACLE_HOME/perl/site_perl/5.10.0:$ORACLE_HOME/appsutil/perl export PATH=$ORACLE_HOME/perl:$ORACLE_HOME/perl/lib:$ORACLE_HOME/perl/bin:$PATH check again perl version
Read MoreUseful query to get user id, responsibility id and application id in EBS. To know about User Id use below Query:- SQL> select user_id from fnd_user where user_name=’DOYEN’; To know…
Read MoreHow to enable or disable the event oracle.apps.icx.security.session.created 1. Login to E-Business and navigate to Workflow Administrator Web Application > Business Event.Search for oracle.apps.icx.security.session.created 2. Then click on clock…
Read MoreHow to add legal entity to bank account Solution: 1. Using below navigation, please check if Workflow background engine is up and running: System Administrator -> Oracle application Manager ->…
Read MoreHow to change read write the Permissions on Concurrent Log and Output Files Solution Add umask 002 in .bash_profile(Linux). And then bounce the services.
Read MoreFollow these steps to perform an upgrade. 1. Confirm that both the Excel4apps and Excel4apps Reports Wand applications have been registered on you system. a. Log on to the Oracle…
Read Moreset serveroutput on; begin for i in ( select sid, serial# from gv$session where status=’INACTIVE’ and type=’USER’ and program=’APEX Listener’ and last_call_et/60 > 5) loop dbms_output.put_line(‘begin’); dbms_output.put_line(‘rdsadmin.rdsadmin_util.kill(‘); dbms_output.put_line(‘sid =>’||i.sid||’,’); dbms_output.put_line(‘serial…
Read Moreselect ‘Soft Parses ‘ “Ratio” ,round( ((select sum(value) from v$sysstat where name = ‘parse count (total)’) – (select sum(value) from v$sysstat where name = ‘parse count (hard)’)) /(select sum(value) from…
Read MoreAutoconfig Error: adgentns.pl exiting with status 2 after Clone/Refresh Error: adgentns.pl exiting with status 2 /u01/apps/apps_st/appl/ad/12.0.0/bin/adgentns.pl 2 No of scripts failed in CVM phase: 1 AutoConfig is exiting with status…
Read More