post clone db

Create a backup table fnd_user:

create table fnd_user_bkp as select * from fnd_user;

　

　

1.

disable email addreess of fnd_users;

select * from fnd_user Where EMAIL_ADDRESS is not null;

update fnd_user set EMAIL_ADDRESS='';

1070

　

2.DIsable user account in ebs:

update fnd_user set END_DATE='28-Jun-2018' where USER_NAME like '%T';

912

　

update fnd_user set END_DATE='28-Jun-2018' where USER_NAME like '%C';

18

　

select * from fnd_user where END_DATE is not null;

update fnd_user set END_DATE='28-Jun-2018' where USER_NAME like 'E%';

　

　

update WF_NOTIFICATIONS set mail_status = 'SENT' where mail_status = 'MAIL';

　

select * from WF_NOTIFICATIONS where mail_status = 'MAIL';

50000

　

update fnd_concurrent_requests

set phase_code = 'C', status_code = 'X'

where status_code in ('Q','I')

and requested_start_date > SYSDATE

and hold_flag = 'N';

　

Update applsys.fnd_concurrent_requests set hold_flag='Y' where phase_code in ('R','P','I');

　

　

3.

　

update fnd_user set email_address = null where email_address is not null;

　

　

update per_all_people_f set email_address = null where email_address is not null;

select * from per_all_people_f;

　

4.

select OUTFILE_NAME from FND_CONCURRENT_REQUESTS;

　

5.

select COUNT(*) from WF_NOTIFICATIONS where mail_status ='SENT';

436987

　

select * from WF_NOTIFICATIONS where mail_status ='MAIL';

5

status=open,closed

　

6.

select SESSION_COOKIE_DOMAIN from ICX_PARAMETERS;

select home_url from ICX_PARAMETERS;

http://tosh02.ebs.in:8050/OA_HTML/AppsLogin

　

7.

select * from dba_db_links;

　

drop public database link EBS_TO_ASCP.JSW_IN;

　

8.

select NODE_NAME SUPPORT_CP,SUPPORT_FORMS,SUPPORT_WEB,SUPPORT_ADMIN,SERVER_ADDRESS from FND_NODES;

9.

EXEC FND_CONC_CLONE.SETUP_CLEAN;

　

10.

Run /var/orastage/cloning/cmclean.sql as APPS user

　

11.

select profile_option_value from apps.fnd_profile_option_values where PROFILE_OPTION_ID=125;

　

EDIT fnd_profile_option_values where PROFILE_OPTION_ID=125;

ASR

　

12.

update XDO_CONFIG_VALUES set value='&applptmp_dir' where PROPERTY_CODE='SYSTEM_TEMP_DIR';

　

select * from XDO_CONFIG_VALUES;

　

13.

select execution_options from apps.fnd_CONCURRENT_PROGRAMS where concurrent_program_name like '%TJTG%';

　

select execution_options,concurrent_program_name from apps.fnd_CONCURRENT_PROGRAMS where concurrent_program_name is not null;

13.

　

Post Clone Steps:-

　

1) Recompile all objects on Target Database

Query existing invalid objects

SELECT OWNER, OBJECT_TYPE, COUNT(*)

FROM DBA_OBJECTS

WHERE STATUS = 'INVALID'

GROUP BY OWNER, OBJECT_TYPE;

　

　

2) Run the following as a SYSDBA user to recompile all invalid PL/SQL objects:

SQL> @Oracle_Home/rdbms/admin/utlrp.sql

　

　

select profile_option_value from apps.fnd_profile_option_values where profile_option_value like 'http%8061%';