My Oracle Support Banner

Lookup Table Return Column Inside Lookup Table Id is Totally Blank with Newly Created Table (Doc ID 377216.1)

Last updated on FEBRUARY 19, 2020

Applies to:

Oracle Profitability Manager - Version 4.5 to 4.5.39 [Release 4.5]
Information in this document applies to any platform.
This problem can occur on any platform.
Oracle Financial Services Applications (OFSA)

Symptoms

Users created a lookup table for use inside the Performance Analyzer Lookup Table Id. The problem is that the column they wish to appear in the Lookup Table Return Column list box is not appearing. The list box is totally blank.

Changes

Sample of a non-working table:

CREATE TABLE TABLE1 (
AS_OF_DATE DATE NOT NULL,
ID NUMBER (8,4) NOT NULL,   <===Problem is here the Precision and Scale
CATEGORIA VARCHAR2 (15) NOT NULL);

Sample of a working table:

CREATE TABLE TABLE2
( ISO_CURRENCY_CD VARCHAR2(15) NOT NULL,
AS_OF_DATE DATE NOT NULL,
EXCHANGE_RATE NUMBER(15) NOT NULL);

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
Changes
Cause
Solution


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