Truncate Login Related Tables in NONLIVE Instance/Cloned Instance
This I generally do a post clone steps to purge the login related information.
$ADMIN_SCRIPTS_HOME/adopmnctl.sh stopall
truncate table APPLSYS.FND_LOGINS;
truncate table APPLSYS.FND_LOGIN_RESP_FORMS;
truncate table APPLSYS.FND_LOGIN_RESPONSIBILITIES;
truncate table APPLSYS.FND_UNSUCCESSFUL_LOGINS;
truncate table ICX.ICX_SESSIONS;
truncate table ICX.ICX_FAILURES;
truncate table ICX.ICX_SESSION_ATTRIBUTES;
truncate table ICX.ICX_TEXT;
truncate table ICX.ICX_CONTEXT_RESULTS_TEMP;
truncate table ICX.ICX_TRANSACTIONS;
truncate table APPLSYS.FND_SESSION_VALUES;
$ADMIN_SCRIPTS_HOME/adopmnctl.sh startall
Also if you are not able to execute purge signon conc prog, due to huge volume of data in the underlying tables then truncate is an option that you can pursue. OR you have to delete in multiple iterations.
Relevant Concurrent Program to Purge: Purge Signon Audit Data
Purge Inactive Sessions E-Business suite R12: $FND_TOP/sql/FNDDLTMP.sql
This I generally do a post clone steps to purge the login related information.
$ADMIN_SCRIPTS_HOME/adopmnctl.sh stopall
truncate table APPLSYS.FND_LOGINS;
truncate table APPLSYS.FND_LOGIN_RESP_FORMS;
truncate table APPLSYS.FND_LOGIN_RESPONSIBILITIES;
truncate table APPLSYS.FND_UNSUCCESSFUL_LOGINS;
truncate table ICX.ICX_SESSIONS;
truncate table ICX.ICX_FAILURES;
truncate table ICX.ICX_SESSION_ATTRIBUTES;
truncate table ICX.ICX_TEXT;
truncate table ICX.ICX_CONTEXT_RESULTS_TEMP;
truncate table ICX.ICX_TRANSACTIONS;
truncate table APPLSYS.FND_SESSION_VALUES;
$ADMIN_SCRIPTS_HOME/adopmnctl.sh startall
Also if you are not able to execute purge signon conc prog, due to huge volume of data in the underlying tables then truncate is an option that you can pursue. OR you have to delete in multiple iterations.
Relevant Concurrent Program to Purge: Purge Signon Audit Data
Purge Inactive Sessions E-Business suite R12: $FND_TOP/sql/FNDDLTMP.sql
No comments:
Post a Comment