Issue:
Solution:
Check and verify FND_USER table users end date and do below steps if all users end dated.
Exclude SYSADMIN user from end date.
select * from fnd_user where last_update_date > sysdate-1/4
select sysdate from dual;
create table fnd_user_orignal
as
select * from fnd_user;
restore backup table and update table using below query
select * from fnd_user where created_by<>1
and user_id<>12124
and end_date is null;
update fnd_user
set end_date = sysdate-1
where created_by<>1
and user_id<>12124
and end_date is null
commit;
Application page showing blank
Solution:
Check and verify FND_USER table users end date and do below steps if all users end dated.
Exclude SYSADMIN user from end date.
select * from fnd_user where last_update_date > sysdate-1/4
select sysdate from dual;
create table fnd_user_orignal
as
select * from fnd_user;
restore backup table and update table using below query
select * from fnd_user where created_by<>1
and user_id<>12124
and end_date is null;
update fnd_user
set end_date = sysdate-1
where created_by<>1
and user_id<>12124
and end_date is null
commit;
No comments:
Post a Comment