a oaf page personalization needs:
Supplier Query page, for a duty, the user can only query vendors with the vendor type of "employee" and cannot query other types of vendors.
Personalization Steps:first refer to the article "Enable OAF page personalization three configurations (Profiles)" To enable personalization for oaf.
when enabled, click Personalize page in the upper-right corner, then personalize the field in the page hierarchy to personalize it by clicking the Pencil icon.
in the responsibility layer, set initial value to employee, and set read only to True.
apply Personalization and then go back to the vendor page and find that the vendor type is non-modifiable and must be an employee type.
But there is another problem, which is that we set the vendor type as employees, but after the query, we find that the actual returned query results contain non-employee type suppliers, but there is a workaround--
You can also personalize the query statement . also click on the Personalization page in the upper-right corner, select table, and locate the tables: Vendor list.
Responsibility Layer Personalization query Statement
in the Query statement personalization page, you can increase the condition, you can also set the collation, basically is SQL in the WHERE statement behind the things can be almost done. Adding a vendor type is an employee's condition, and then back to the Supplier page, the query results are only for the employee type Vendor.
Reference
Ten New Forms and OAF personalization Examples for R12.1
An example of Oracle oaf personalization--Personalized query conditions