No-Column-Defined in Lookup Return Value When Creating Lookup Table Driver Definition (Doc ID 1303720.1)

Last updated on APRIL 28, 2016

Applies to:

Oracle Financial Services Profitability Management - Version: 5.2 and later   [Release: 5 and later ]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Profitability Management (OFSPM), when you try to define a Lookup Table Driver Definition, the drop down list for "Lookup Return Value" only contains "No-Column-Defined".  There are no columns from the Lookup table available for selection.

Alternatively, you may see a column in the Lookup Return Value list but you do not see the column you want to select for the definition.

Steps to Reproduce:
  1. Go to Financial Services Applications > Profitability Management
  2. Go to Rule Specification > Lookup Table Driver
  3. Click the "Add" icon
In the Lookup Table Driver Definition screen, the Lookup Return Value drop down list only contains "No-Column-Defined" or is missing the column you want to use.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms