Customizing Visibility of PUBLIC Data

Oracle Transportation and Global Trade Management includes various data by default such as currency codes, country codes, and reference number qualifiers. It may be desirable at times to remove some of this data from drop downs and pick lists, for example, if you only work in a small number of currencies or do not use the PUBLIC qualifiers. This can be accomplished by attaching a VPD predicate to the table for that data. For example, if you want to restrict currencies to only USD and EUR, create or edit the VPD profile for the users who should only see those currencies to include the following:

Table Name: CURRENCY, Predicate: currency_gid in ('USD','EUR')

(Be sure the "Use External Predicate Rule" box is checked.)