My Oracle Support Banner

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

Last updated on NOVEMBER 20, 2018

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
  Symptoms
  Cause
  Solution
  References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.