Can you give some more details/screenshot about DFF such as attribute name , value set and SQL used in value set.
to give more details further, my DFF allows the End User to select their positions from Per_assignments_x.
here's the query:
select NAME, NAME, POSITION_ID
where position_id in (SELECT paf.position_id
FROM per_assignments_x paf
WHERE paf.person_id = FND_GLOBAL.EMPLOYEE_ID) AND ATTRIBUTE3 = 'PURCHASE REQUISITION'
order by name
Example, User 123 uses DFF, he/she can enter data 1, 2 and 3 and saves it into the Table. (Record User123)
However, when User 456 checks Record User123, Oracle would prompt an error, because User 456 does not have 1, 2, 3 as his/her data.
any idea how i can disable the validation when using PR Summary Screen?
In your sql you have put the dynamic employee id means employee id of login user.
means when user 123 login, it will returns the employee id of 123 and when user 456 login, it will returns the employee id of 456.
I think the error msg coming is ok as per your sql.
You alter your sql with :BLOCK.VARIBLE as per your need.
Thanks Sanjay Desai EBS, yes that's exactly the cause of the error message.
However, i think the Form 1 (that user 123 accesses) and Form 2 ( that user 456 accesses) doesn't have a common :Block.Variable.
It isn't possible to just disable the validation when Form 2 is used?