Oracle APPS DBA
How to clean FND_NODES table in Oracle Applications
[edsanimate_start entry_animation_type= “fadeIn” entry_delay= “0” entry_duration= “1.5” entry_timing= “linear” exit_animation_type= “” exit_delay= “” exit_duration= “” exit_timing= “” animation_repeat= “infinite” keep= “yes” animate_on= “load” scroll_offset= “” custom_css_class= “”]
Note: Remember That All the Latest Cloning Patches Should Be Applied to avoid Any Ambiguity.
[edsanimate_end]
Step 1: Login to Database with Apps User
$ sqlplus apps/apps
SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN;
SQL>COMMIT;
SQL>EXIT;
It will delete all old data from the table.
Step 2: Run AutoConfig on all tiers, first on the DataBase Tier and then on APPS Tier to repopulate the required system tables.
ERROR
ORA-04063: package body “APPS.AP_ACCTG_DATA_FIX_PKG” has errors
ORA-06508: PL/SQL: could not find program unit being called:
“APPS.AP_ACCTG_DATA_FIX_PKG”
ORA-06512: at line 38
(more…)
How to Get Apps Password From Backend
STEP 1. First login to Database through Command Prompt
sqlplus / as sysdba
STEP 2 : Create Function From Below Script to decrypt the encrypted password
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’;
STEP 3 : Run the Below Query for Retrieving AppsPassword
SQL> select ENCRYPTED_FOUNDATION_PASSWORD from apps.fnd_user where USER_NAME=’GUEST’;
ENCRYPTED_FOUNDATION_PASSWORD
——————————————————————————–
ZHA49B7AB1BB637F7A4347721229CF2F31A95DEC86B3CCFAEF9B40D4EB9AA8F0030EDDFC2324D873
AB2FFFA3B302AEE6EBD1
STEP 4: Run the Below Query to get the Password
SELECT apps.decrypt_pin_func(‘GUEST/ORACLE123′,’ZHA49B7AB1BB637F7A4347721229CF2F31A95DEC86B3CCFAEF9B40D4EB9AA8F0030EDDFC2324D873AB2FFFA3B302AEE6EBD1’) from dual;
APPS.DECRYPT_PIN_FUNC(‘GUEST/ORACLE’,’ZHA49B7AB1BB637F7A4347721229CF2F31A95DEC86B3CCFAEF9B40D4EB9AA8F0030EDDFC2324D873AB2FFFA3B302AEE6EBD1′)
——————————————————————————–
APPS
STEP 5: Now Login With the Password Retrieved.
SQL> conn apps/APPS;
Connected.
ERROR
JSP Error:
Request URI:/OA_HTML/RF.jsp
Exception:
java.lang.NoClassDefFoundError
JSP Error:
Request URI:/OA_HTML/AppsLocalLogin.jsp
Exception:
java.lang.NoClassDefFoundError