add

About Me

My photo
Oracle Apps - Techno Functional consultant

Friday, September 30

Form Personalization: Restrict the Responsibilities LoV on the form FNDSCAUS

Purpose
The Purpose of this Form Personalization is to restrict the list of responsibilities that a user can assign using the ‘Users’ function that access the form FNDSCAUS.

Description
The implementation of this Form Personalization is divided in 3 steps:
1. Restrict the List of Values of the Responsibilities.
2. Make Read Only the Responsibility START_DATE and END_DATE.
3. Hide the Password Field.

Form Personalization Function Definition
Responsibility: System Administrator
Navigate: Application -> Function
Define a new function that is a copy of the existing ‘Users’ Function (FND_FNDSCAUS). This new function will be called XX_FND_FNDSCAUS:

Snapshot%202009 01 15%2022 21 49 Form Personalization: Restrict the Responsibilities LoV on the form FNDSCAUS

Snapshot 2009 01 15 22 22 39 Form Personalization: Restrict the Responsibilities LoV on the form FNDSCAUS

Snapshot 2009 01 15 22 25 45 Form Personalization: Restrict the Responsibilities LoV on the form FNDSCAUS

Snapshot 2009 01 15 22 26 25 Form Personalization: Restrict the Responsibilities LoV on the form FNDSCAUS

Snapshot 2009 01 15 22 26 47 Form Personalization: Restrict the Responsibilities LoV on the form FNDSCAUS

Snapshot 2009 01 15 22 27 07 Form Personalization: Restrict the Responsibilities LoV on the form FNDSCAUS

Once the function is created, it should be added to one of the existing responsibility.

Form Personalization – Main Screen
The standard form FNDSCAUS before the Form Personalization looks like this:

Snapshot 2009 01 15 22 35 33 Form Personalization: Restrict the Responsibilities LoV on the form FNDSCAUS

The form FNDSCAUS after the Form Personalization will look like this:

Snapshot 2009 01 15 22 33 38 Form Personalization: Restrict the Responsibilities LoV on the form FNDSCAUS

The standard List of Values (LoV) before the Form Personalization looks like this:

Snapshot 2009 01 16 11 38 22 Form Personalization: Restrict the Responsibilities LoV on the form FNDSCAUS

The List of Values (LoV) after the Form Personalization will look lik this:

Snapshot 2009 01 15 22 34 50 Form Personalization: Restrict the Responsibilities LoV on the form FNDSCAUS

Restrict the List of Values of the Responsibilities
Before to start with the Form Personalization, the following profile options should be set to the user making the Form Personalization:
o ‘FND: Diagnostics’ set to ‘Yes’
o ‘Hide Diagnostics menu entry’ set to ‘No’
o ‘Utilities:Diagnostics’ set to ‘Yes’

From the horizontal menu select: Help -> Diagnostics -> Custom Code -> Personalize

In order to restrict the list of responsibilities to be showed in the LoV, we will need to tune the query that generate that LoV modifying the conditions specified in the WHERE clause.

Snapshot 2009 01 15 22 30 58 Form Personalization: Restrict the Responsibilities LoV on the form FNDSCAUS

Snapshot 2009 01 15 22 31 17 Form Personalization: Restrict the Responsibilities LoV on the form FNDSCAUS

Argument:
SELECT R.RESPONSIBILITY_NAME, A.APPLICATION_NAME, R.RESPONSIBILITY_ID, R.APPLICATION_ID FROM FND_APPLICATION_VL A, FND_RESPONSIBILITY_VL R WHERE ( R.APPLICATION_ID = A.APPLICATION_ID AND (R.VERSION = '4' OR R.VERSION = 'W' OR R.VERSION= 'M' OR R.VERSION = 'H') AND (R.END_DATE IS NULL OR (TRUNC(SYSDATE) BETWEEN R.START_DATE AND R.END_DATE)) ) AND (R.RESPONSIBILITY_NAME LIKE '%GB') ORDER BY RESPONSIBILITY_NAME

To customize the list of responsibilities in the LoV, the WHERE clause that should be modified is
AND (R.RESPONSIBILITY_NAME LIKE '%GB')

Snapshot 2009 01 15 22 31 29 Form Personalization: Restrict the Responsibilities LoV on the form FNDSCAUS

Make Read Only the Responsibility START_DATE and END_DATE
To prevent a user from removing the END_DATE of responsibilities already assigned to a user account, it would be needed to make the responsibility END_DATE field not editable. Same action will be taken for the responsibility START_DATE.

Snapshot 2009 01 15 22 31 41 Form Personalization: Restrict the Responsibilities LoV on the form FNDSCAUS

Snapshot 2009 01 15 22 31 54 Form Personalization: Restrict the Responsibilities LoV on the form FNDSCAUS

Snapshot 2009 01 15 22 32 02 Form Personalization: Restrict the Responsibilities LoV on the form FNDSCAUS

Hide the Password Field
To prevent a user from resetting the password of another user account (like SYSADMIN) it would be needed to hide the password.

Snapshot 2009 01 15 22 32 25 Form Personalization: Restrict the Responsibilities LoV on the form FNDSCAUS

Snapshot 2009 01 15 22 32 41 Form Personalization: Restrict the Responsibilities LoV on the form FNDSCAUS

Snapshot 2009 01 15 22 32 50 Form Personalization: Restrict the Responsibilities LoV on the form FNDSCAUS

No comments: