Friday, January 8, 2016

Oracle Applications shows a blank page

Issue:

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