Unable To Select Simple Dimension User Lov For Use In Table Registration (Doc ID 452395.1)

Last updated on DECEMBER 04, 2008

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.10
This problem can occur on any platform.
FEM

Symptoms

-- Problem Statement:
On 11.5.10, created a custom instrument table (Customer Account Profitability Table) and with a field called "COST_TRANSFER_ID" with a datatype of NUMBER which mapped to its corresponding interface table column name "COST_TRANSFER_DISPLAY_CODE" with a datatype of VARCHAR(2).

This field is intended to be a simple dimension and mapped to one of the User LOVs for this purpose.
During table registration, after selecting the CPM datatype as "Dimension" and when searching for 'User
LOV1', it does not appear in the search pop-up screen. Some dimensions are displayed but many are missing in the search results and none of the User LOV dimensions are displayed.

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