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

Last updated on JULY 28, 2006

Applies to:

Oracle Profitability Manager - Version: 4.5 to 4.5.39
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 TASACOSTO (
AS_OF_DATE DATE NOT NULL,
TASA_COSTO NUMBER (8,4) NOT NULL,   <===Problem is here the Precision and Scale
CATEGORIA VARCHAR2 (15) NOT NULL);

Sample of a working table:

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

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