Total Pageviews

Search This Blog

Monday, December 8, 2014

Restricting DFF Values (Value Set) Based on Form Values

Hi All,

There is interesting option I came across recently (Thanks to Venkat) to restrict DFF value based on Main Form Value,

Lets say, Based on Qualification (Oracle HRMS) I wanted to restrict sub Qualification at the DFF. Hence say if we select Qualification in main screen as "Master Degree" based on this automatically ,SUb Qualification DFF should restrict

Here while creating value set for Sub Qualification (Table Type) use :BLOCK.FIELD_VALUE, this will solve easily our requirement.

Example:

WHERE
AND TO_NUMBER(ATTRIBUTE1)=:QUALIFICATION.QUALIFICATION_ID

"Team Work" More We Less Me.

No comments:

Post a Comment