Archives for Oracle Apps DBA
FNDFS Error- unable to view Concurrent program LOG and OUT files
Simple way to find out SYSADMIN password in R12, Please review below for the same 1) Connect to APPS USER 2) Create PACKAGE and PACKEGE BODY. 3) Query for PASSWORD…
Find Concurrent manager logs on Oracle Apps
Concurrent Mangers log files are located in the $APPLCSF/$APPLLOG location. cd $APPLCSF/$APPLLOG For ICM Log –> ls -lrt *$TWO_TASK* For Standard manager Log –> ls -lrt w*.mgr For…
Imporatant – Concurrent Manager Issues
1) Running Note : In the case of a clone instance, it is strongly recommended to clean the non – existing nodes FND_NODE table contains the node entries of both…
New Feature – AFPASSWD utility in EBS 12.1.2
Oracle has introduced a new utility to change the Oracle E-Business Suite passwords in , AFPASSWD is an enhanced version of FNDCPASS utility. 1) AFPASSWD only prompts for passwords required…
Concurrent Manager Issue : FND_DCP.REQUEST_SESSION_LOCK / DBMS_LOCK.Request
Error in Concurrent manager logfile : ========================= Routine received a result code of 1 from the call to Possible resultCall to establish_icm failed The Internal Concurrent Manager has encountered an…
Enable/Disable Maintenanace Mode from SQLPLUS Session (Without adadmin)
We can enable or disable maintenance mode without using adutility (adadmin), Perform the same from SQLPLUS session. Check the current status of Maintenance Mode: select (‘APPS_MAINTENANCE_MODE’) from dual; MAINT = …
cmclean.sql : Cleaning the Concurrent Manager tables
To cleanup running and pending requests we use , If we stop concurrent managers using abort options then concurrent requests will be in running state ,Next when we start concurrent…
HOW TO FIND APPS PASSWORD – R12
Simple way to find out apps password in R12, Please review below for the same 1) Connect to SYSTEM or SYS USER 2) Create Function for to decrypt the encrypted…
Function not available to this responsibility : When accessing CUSTOM FORM
After fresh clone, Application technical team used to report that ‘Function not available to this responsibility’ error when they are trying to access custom form. CAUSE: Missing the entry of…
EBS LOGIN URL from database:
Connect to apps user $sqlplus apps/apps QUERY 1: SELECT home_url FROM icx_parameters; QUERY 2: SELECT profile_option_value FROM fnd_profile_option_values WHERE profile_option_id= (SELECT profile_option_id FROM fnd_profile_options WHERE profile_option_name = ‘APPS_FRAMEWORK_AGENT’) AND…