An example of Oracle oaf personalization--Personalized query conditions

Source: Internet
Author: User


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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.