Modern Oracle DBA

  Step 1 : Login the application Step 2: Use below script $FND_TOP/sql/afsvcpup.sql Cd $FND_TOP/sql/ Sqlplus apps/apps SQL> @ afsvcpup.sql Select component id for Workflow Notification Mailer - default is 10006 Enter Component Id: 10006 Show you the parameters and their values for the mailer Select the comp param id for the Override address (it will say Test Address ) - default is 10093 This script will display the following: You have selected parameter: Test Address Current value of parameter: NONE Enter a value for the parameter: <Here you will put the email address > Retest the Workflow mailer and confirm the override now works as expected.   Using SQL Query’s to set email address First check the current address use below query SELECT fscpv.parameter_value FROM fnd_svc_comp_params_tl fscpt, fnd_svc_comp_param_vals fscpv WHERE fscpt.display_name = 'Test Address' AND fscpt.parameter_id = fscpv.parameter_id;   Update email addre

  If we forget the apps password for r12.2 instance follow the below steps to recover the password Step 1 : Login to Database server sqlplus / as sysdba STEP 2 : Create Function for to decrypt the encrypted password SQL> create FUNCTION apps.decrypt_pin_func(in_chr_key IN VARCHAR2,in_chr_encrypted_pin IN VARCHAR2) RETURN VARCHAR2 AS LANGUAGE JAVA NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String'; / Function created. STEP 3 : Query for encrypted password SQL> select ENCRYPTED_FOUNDATION_PASSWORD from apps.fnd_user where USER_NAME='GUEST'; Output ENCRYPTED_FOUNDATION_PASSWORD -------------------------------------------------------------------------------- ZG37E123746712BDB2D99E048FE44AE662F2713E2EDB443391BABA0414CADDB7A2E6DD45BBAFA7270A663E5EEBA837F5548A STEP 4: Query for decrypt the password SELECT apps.decrypt_pin_func('GUEST/ORACLE','ZG37E123746712BDB2D99