EBS Customizations (MOSC)

MOSC Banner

How to enable/disable certain DFF fields based on the responsibility

edited Jun 20, 2016 9:04PM in EBS Customizations (MOSC) 14 commentsAnswered ✓

Hello everyone,

  I have a DFF which has 5 fields and all 5 fields are free text (50 characters) , user can enter any value.

Here my requirement is out of 5 fields, 4 fileds should be disabled for other than the Manager responsibilities.

For Manager responsibilities all 5 fields should be enabled.

For this I have created one lookup to keep the List of manager responsibilities

and based on the this created the special value set.

Following is the code in the Special Valuset,

FND SQL  "DECLARE

   ln_cnt        NUMBER := 0;

   ln_resp_id    NUMBER := fnd_profile.value('RESP_ID');

   ls_resp_key   VARCHAR2 (100);

BEGIN

   SELECT responsibility_key

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center