Monday Dec 09, 2013

Fusion Concepts: Lookups

Lookups in applications are used to represent a set of codes and their translated meanings. For example, a product team might store the values 'Y' and 'N' in a column in a table, but when displaying those values they would want to display "Yes" or "No" (or their translated equivalents) instead. Each set of related codes is identified as a lookup type.

Lookups are codes that are defined in the global FND_LOOKUP_VALUES table, which is striped into multiple virtual tables using a VIEW_APPLICATION_ID column. Every product team who owns the lookups specific to their product provides a database view and ADFbc artifacts built on the top of the database view.

[Read More]
About

Follow us on twitter Fusion Applications Extensibility, Customizations and Integration forum Fusion Applications Dev Relations YouTube Channel
This blog offers news, tips and information for developers building extensions, customizations and integrations for Oracle Fusion Applications.

Search

Categories
Archives
« December 2013 »
SunMonTueWedThuFriSat
1
4
6
7
8
10
13
14
15
17
18
20
21
23
24
25
26
27
28
29
31
    
       
Today