How to Get Profile Values in Oracle Forms Personalization

By | November 1, 2014

Problem Statement:

We need to give access for Enter & Maintain page to all employees by linking this function into their self service responsibility but we want to restrict that an employee can see only his data i.e when employee opens this form in Oracle HRMS, it opens with a default search page with employee ID pre-populated in default search page and it should be in read only mode so that employee can search only his data.

Solution Concept: Get Profile Value and set through Personalize default search page

This can be achieved through forms personalization. We shall take the employee number from profile value and on the basis of it , we can populate the employee ID field on initial search page.

Step by Step Solution:

Open the Enter and Maintain Form and go to personalize option as shown below

Get Profile Value Through Oracle Form Personalization

Get Profile Value Through Oracle Form Personalization

Following form will be opened. Create a new rule as shown rule no 97 in picture, Select the Processing mode as ‘Both’ and leave the triggering event as WHEN-NEW_FORM_INSTANCE

 3 

Click on Actions Tab and add an action as per following detail
Get PF No from Person ID
Object Type:  Item
Target Object: EMP_QF.NUMBER
Property Name: VALUE
Value:Use the following query to get the employee number on the basis of user name taken from profile values

=(select employee_number from per_people_x px, fnd_user fu where
 fu.employee_id = px.person_id
 and fu.user_id = fnd_profile.value(‘user_id’))

 5

Add second rule as mentioned below
Get Name
Object Type: Item
Target Object: EMP_OF_FULL_NAME
Property Name: VALUE

Value:
=(select full_name from per_people_x px, fnd_user fu where
fu.employee_id = px.person_id
and fu.user_id = fnd_profile.value(‘user_id’))

6

Add third Action as mentioned below
Disable PF No
Object Type: Item
Target Object: EMP_QF.FULL_NAME
Property Name: ENABLED (APPLICATIONS COVER)
Value: FALSE

 

7

Disable Name
Object Type: Item
Target Object: EMP_QF.NUMBER
Property Name: ENABLED (APPLICATIONS COVER)
Value: FALSE

8

Apply and Save. Now Close and open the form. When you open the form, you get the employee number and name auto populated and in read only mode. So employee can search only his data. This requirement was developed for self service responsibility.

9

For more articles on Oracle Apps Functional Concepts Click Here.
For more articles on Oracle Apps Technical Concepts Click Here.