Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Friday, September 30, 2011

Form Personalization: Limit Site Level Profile Options Access on the form FNDPOMPV

Purpose
The Purpose of this Form Personalization is to limit the access to the profile option settings restricting the LoV of the profile options displayed.

Description
The implementation of this Form Personalization is divided in 2 steps:
1. Restrict the Profile Options List of Values.
2. Hide and Disable the un-needed fields.

Form Personalization Definition
Responsibility: System Administrator
Navigate: Application -> Function
Define a new function that is a copy of the existing ‘Profile System Values Function (FND_FNDPOMPV). This new function will be called XX_FND_FNDSCAUS_MDM:

howto restrict the profile option LoV 01 Form Personalization: Restrict the Profile Options LoV on the form FNDPOMPV

howto restrict the profile option LoV 03 Form Personalization: Restrict the Profile Options LoV on the form FNDPOMPV

howto restrict the profile option LoV 04 Form Personalization: Restrict the Profile Options LoV on the form FNDPOMPV

howto restrict the profile option LoV 05 Form Personalization: Restrict the Profile Options LoV on the form FNDPOMPV

howto restrict the profile option LoV 06 Form Personalization: Restrict the Profile Options LoV on the form FNDPOMPV

Once the function is created, it should be added to one of the existing responsibility.Form Personalization Main Screen
The standard form FNDPOMPV before the Form Personalization looks like this:

Snapshot 2009 01 16 15 18 00 Form Personalization: Restrict the Profile Options LoV on the form FNDPOMPV

space Form Personalization: Restrict the Profile Options LoV on the form FNDPOMPV

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

howto restrict the profile option LoV 07 Form Personalization: Restrict the Profile Options LoV on the form FNDPOMPV

Restrict the Profile Options List of Values
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

This step needs to be done to avoid querying profile options related the site level.

howto restrict the profile option LoV 08 Form Personalization: Restrict the Profile Options LoV on the form FNDPOMPV

howto restrict the profile option LoV 09 Form Personalization: Restrict the Profile Options LoV on the form FNDPOMPV

Value (to be customized)::
START_DATE_ACTIVE <= SYSDATE and NVL(END_DATE_ACTIVE,SYSDATE) >= SYSDATE and ( SITE_ENABLED_FLAG = 'Y' or APP_ENABLED_FLAG = 'Y' or RESP_ENABLED_FLAG = 'Y' or USER_ENABLED_FLAG = 'Y' or SERVER_ENABLED_FLAG = 'Y' or SERVERRESP_ENABLED_FLAG = 'Y' or ORG_ENABLED_FLAG = 'Y') and (USER_PROFILE_OPTION_NAME = 'HZ: Generate Party Number' or USER_PROFILE_OPTION_NAME = 'HZ: Generate Party Site Number' or USER_PROFILE_OPTION_NAME = 'HZ: Maintain Location History' or USER_PROFILE_OPTION_NAME = 'HZ: Allow Update to Standardized Address')

Hide the un-needed fields
After the restriction of the Profile Option LoV, it’s possible to disable the other fields that will not be needed.

howto restrict the profile option LoV 10 Form Personalization: Restrict the Profile Options LoV on the form FNDPOMPV

howto restrict the profile option LoV 11 Form Personalization: Restrict the Profile Options LoV on the form FNDPOMPV

howto restrict the profile option LoV 12 Form Personalization: Restrict the Profile Options LoV on the form FNDPOMPV

howto restrict the profile option LoV 13 Form Personalization: Restrict the Profile Options LoV on the form FNDPOMPV

howto restrict the profile option LoV 14 Form Personalization: Restrict the Profile Options LoV on the form FNDPOMPV

howto restrict the profile option LoV 15 Form Personalization: Restrict the Profile Options LoV on the form FNDPOMPV

howto restrict the profile option LoV 16 Form Personalization: Restrict the Profile Options LoV on the form FNDPOMPV

howto restrict the profile option LoV 17 Form Personalization: Restrict the Profile Options LoV on the form FNDPOMPV

No comments:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect