my requirement is i have to restrict the records on trading partner column based on the responsibility.
i have written an query, when i ran it outside of the form personalization then its working fine but when i placed in the form by using default_where clause its not working. It just returning all the records.
First, while we understand that something might be urgent to you, however, you have to realize that all of the people that participate in the forum are "Volunteers." Therefore, your urgency is not our urgency.
Second, Forms Personalization is not a feature of Oracle Forms, but a feature of the Oracle Enterprise Business Suite (EBS). Please post your question in the appropriate forum (EBS General Discussions).