User cannot login to Oracle EBS

A particular user cannot login to Oracle EBS. After changed the password from SYSADMIN responsibility also he faces the same problem.

Issue faced : 
ORA-20001: Oracle error -20001: ORA-20001: -: While executing SQL in profile FND_INIT_SQL:BEGIN

After searching the metalink for a while, found a document which solved my issue.

Reason for the issue is, user has enabled profile option at user level to produce trace file and forget to disable that.

Solution:
Run the below query to find what profile option has been enabled.

set serveroutput on
set echo on
set timing on
set feedback on
set long 10000
set linesize 120
set pagesize 132
column SHORT_NAME format A30
column NAME format A40
column LEVEL_SET format a15
column CONTEXT format a30
column VALUE format A60 wrap
select p.profile_option_name SHORT_NAME,
n.user_profile_option_name NAME,
decode(v.level_id,
10001, 'Site',
10002, 'Application',
10003, 'Responsibility',
10004, 'User',
10005, 'Server',
10007, 'SERVRESP',
'UnDef') LEVEL_SET,
decode(to_char(v.level_id),
'10001', '',
'10002', app.application_short_name,
'10003', rsp.responsibility_key,
'10005', svr.node_name,
'10006', org.name,
'10004', usr.user_name,
'10007', 'Serv/resp',
'UnDef') "CONTEXT",
v.profile_option_value VALUE
from fnd_profile_options p,
fnd_profile_option_values v,
fnd_profile_options_tl n,
fnd_user usr,
fnd_application app,
fnd_responsibility rsp,
fnd_nodes svr,
hr_operating_units org
where p.profile_option_id = v.profile_option_id (+)
and p.profile_option_name = n.profile_option_name
and upper(p.profile_option_name) like '%FND_INIT_SQL%'
and usr.user_id (+) = v.level_value
and rsp.application_id (+) = v.level_value_application_id
and rsp.responsibility_id (+) = v.level_value
and app.application_id (+) = v.level_value
and svr.node_id (+) = v.level_value
and org.organization_id (+) = v.level_value
order by short_name, level_set;

Once obtained the result, login to Front-End using sysadmin user and disable the particular profile option which has been set at user level and try to login.

Navigation to disable the profile option:

System Administrator > Profile > System. 

Query for the user as below

After the profile option has been disabled, user can login without any issue. if you still face any issues, once again reset the password and try to login.

Ref : How To Login Again After Wrongly Changed "Initialization SQL Statement - Custom" (FND_INIT_SQL) Profile Option? (Doc ID 795820.1)

****************************நன்றி****************************