Wednesday, 6 January 2016

During Oracle Apps Login, Responsibilities Assigned to Users is not appearing in the Navigator Page

While User Login on Oracle Application then some time Responsibility not showing to user then use the below steps to resolve this issue. 

User data in the FND_USER, FND_RESPONSIBILITY, WF_LOCAL_USER_ROLES, and WF_USER_ROLE_ASSIGNMENTS tables is not valid. To synchronize data follow the steps below.


1. Navigate to the define user form (FNDSCAUS).
2. Query up the user (that is having the issue) and insure the responsibility is NOT end dated. 
3. END DATE the USER (not the responsibility) and save the record. 
4. UNEND DATE the USER and save the record. 
5. Run the request 'Sync responsibility role data into the WF table'.
6. Run the request "Synchronize WF LOCAL tables". 
7. Run the request "Workflow Directory Services User/Role Validation" (with parameters 10000, yes, yes, yes). 
8. Have the user log off and back on and verify that the responsibility appears.

After that clear the apache cache.

How to clear Apache Cache from Application without bouncing listener.

1. Navigate to "Functional Administrator" responsibility.
2. Once logged in click on the "Core Services" tab.
3. Click on "Caching Framework" link in the blue menu bar.
4. Click on "Global Configuration" link in the left vertical menu.
5. In the "Cache Policy" region click on the "Clear All Cache" button.
6. Click the "Yes" button to confirm the action.
7. Click the "Apply" button to apply the changes.

The above steps will clear the apache cache without the need of bouncing by the DBA's


Tuesday, 2 June 2015

[Solved] FRM-92095: Oracle Jnitiator version too low


After logging into Java application in any browser (Chrome, Firefox, or Internet Explorer), Windows produces an error indicating that the Jinitiator version is too low, system pop up below error message:

Solution 1:

Issue

While accessing Oracle EBS (R12) forms

FRM_92095


Cause

The cause is the JRE version is not compatible. Oracle made an internal changed in the Java plugin after Java 7 that causes Oracle Forms (Banner) to not recognize that Java is correctly installed.

Solution

1. Go to start and search for ‘Java’ 

2. Click on Java tab and then View

java_setting

3. Add the following text in the ‘Runtime Parameters’ box and then click OK

-Djava.vendor=”Sun Microsystems Inc.”

runtime parameters


4. Click Apply

Java control Panel


5. Close browser and retest, forms should be accessible now

After adding Runtime Parameters Djava.vendor=”Sun Microsystems Inc.” in Java Runtime Environment Settings, we could access forms with no issues.

Solution 2:

Uninstall your JRE 8, and re-install JRE 6 since Java 7 currently incompatible with Banner Forms