Unlink and Link

Commands to relink:

Unlink: unlink current

Link:   ln -s /opt/infra/java/jdk1.7.0_79 current

FRM-92050 failed to connect to Server /forms/servlet -1 Applet / Forms not opening on IE8

I was trying to open forms from IE-8 and i was getting the following error. Here are the steps to resolve this problem.

If you are trying to connect to Apps 11i/R12 instance from IE 8 and getting error “FRM-92050 failed to connect to Server /forms/servlet -1“ while opening forms.

Check the version of IE. If version of IE is 8 then disable XSS filter

Go to Tools> Internet Options> Security> then click on the custom level.

Scroll down to the end of the screen and disable the XSS filter. Click on the ok button.

Now you can launch the forms.

How to find the DBC File

It has different paths in 11i and R12.

Path in 11i:
$FND_TOP/secure


Path in R12:
$INST_TOP/appl/fnd/12.0.0/secure

Finding the Personalization and Customizations

1. To find the customizations on the page:

begin
jdr_utils.listCustomizations('"fullPathOfDocument"');
end;


Example:
begin
jdr_utils.listCustomizations('/oracle/apps/.. /.. /webui/PG File Name');
end;

It will give the output something like
/oracle/apps/ar/irec/homepage/webui/customizations/org/7435/ARIHOMEPAGE

then there is a need to run the following command

begin
Jdr_utils.printDocument('/oracle/apps/ar/irec/homepage/webui/customizations/org/7435/ARIHOMEPAGE');
end;

The output of this command will be an xml that will display all the personalizations and customizations on that page.



2. To remove the customizations.

We can delete the customizations through the following command.
begin
Jdr_utils.deleteDocument('/oracle/apps/ar/irec/homepage/webui/customizations/org/7435/ARIHOMEPAGE');
end;


3. The similar approach is for listing the customization for BC4j components. We need to give the name of bc4j component along with complete path for "fullPathOfDocument" in the above command.

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.