3.5.5 Lookup Table Driver Definition

Post registration and validation, the lookup table is available within Lookup Table Driver definition of OFSAA Profitability Management application.

Following is the criteria for columns to be displayed in the Source - Lookup Mapping grid:

• Column needs to be Primary Key or be part of composite primary key.
• Processing Key user defined property should be set for the column under UDP tab as shown following.

Mapping of Column to Processing Key

Following is the criteria for columns to be part of the Range:

Figure 3-1 Mapping of Column to Processing Key

• Balance Range user defined property should be set for the column under UDP tab as displayed.

Mapping of Column for Range Property

Following is the criteria for columns to be part Lookup Return Value:

Figure 3-2 Mapping of Column for Range Property

• Column should not be primary key/processing key or be part of composite primary key.
• Column domain should be defined as NUMBER under General Tab as displayed.

Mapping of Column for Look up Return Value

Figure 3-3 Mapping of Column for Look up Return Value