Unable To Select Simple Dimension User Lov For Use In Table Registration
Last updated on DECEMBER 04, 2008
Applies to:Oracle Enterprise Performance Foundation - Version: 11.5.10
This problem can occur on any platform.
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.
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