Setting up JDeveloper

While setting up the jdeveloper we require some values.

Application Short Name and Responsibility Key:
This Query will take the user_name as input and will return the application short name and responsibility key.

SELECT fa.application_short_name, fu.responsibility_key,
fu.responsibility_name
FROM fnd_application fa,
fnd_responsibility fr,
(SELECT resp.responsibility_key, resp.responsibility_name
FROM apps.fnd_responsibility_vl resp
WHERE responsibility_id IN (
SELECT responsibility_id
FROM apps.fnd_user_resp_groups_direct
WHERE (responsibility_id, responsibility_application_id) IN (
SELECT responsibility_id, application_id
FROM apps.fnd_responsibility
WHERE ( VERSION = '4'
OR VERSION = 'W'
OR VERSION = 'M'
))
AND (user_id IN (SELECT user_id
FROM apps.fnd_user
WHERE user_name = :user_name)))) fu
WHERE fa.application_id = fr.application_id
AND fr.responsibility_key = fu.responsibility_key
**********************************************************************

How to find the Jdeveloper version to start with

Before going to start the development, we should get the correct Jdeveloper.


The first step is to get the OA Framework Version Information. Type the url like ":/OA_HTML/OAInfo.jsp">http://:/OA_HTML/OAInfo.jsp" in the browser. It will provide the OA Framework Version Information. Now once we have the OAF version information, we need to find out the Jdeveloper version to use for the development.

The JDeveloper version can be find from metalink MOS Doc 787209.