Solution for the error "Oracle Discoverer Desktop has encountered a problem and needs to close. We are sorry for the inconvenience."

Sometimes we will not be able to launch the Discoverer Desktop from our PC due to the error "Oracle Discoverer Desktop has encountered a problem and needs to close. We are sorry for the inconvenience" .

This error will not be resolved even if we try to re-install the Discoverer. Follow the below simple step to resolve this error.

1. Go to C:\Windows >> Try to find the dis51usr.INI file >> Rename that file or Delete that file.

2. You should now be able Launch the Discoverer Desktop successfully.

Note: Once  after launching the Discoverer Desktop, a new dis51usr.INI appears in C:\
Windows.

Query to find the Direct Responsibilities attached to a User

select
urg.user_id,
fu.user_name,
urg.responsibility_id,
fr.responsibility_name
from
fnd_user_resp_groups_direct urg,
fnd_responsibility_tl fr,
fnd_user fu
where
urg.user_id=fu.user_id and
urg.responsibility_id=fr.responsibility_id and
fu.user_name='<user_name>'

Query to find the Execution File Name of any Concurrent Program

select
a.application_id,
a.user_concurrent_program_name,
c.executable_name,
c.execution_file_name
from
fnd_concurrent_programs_tl a,
fnd_concurrent_programs b,
fnd_executables c
where a.user_concurrent_program_name ='<Concurrent_Program_Name>'
and a.concurrent_program_id=b.concurrent_program_id
and b.executable_id=c.executable_id

Query to know the Attributes(DFF Fields) Actual Column Names in Oracle tables

SELECT

b.APPLICATION_TABLE_NAME,

b.DESCRIPTIVE_FLEXFIELD_NAME,

a.DESCRIPTIVE_FLEX_CONTEXT_CODE,

a.APPLICATION_COLUMN_NAME,

a.END_USER_COLUMN_NAME

FROM

FND_DESCR_FLEX_COLUMN_USAGES a,

FND_DESCRIPTIVE_FLEXS_vl b

WHERE

b.APPLICATION_TABLE_NAME in (UPPER('<table_name>')) AND

b.DESCRIPTIVE_FLEXFIELD_NAME=a.DESCRIPTIVE_FLEXFIELD_NAME AND b.APPLICATION_ID=a.APPLICATION_ID