Invalid Identifier when Adding a New Simple Dimension Member (Doc ID 2186905.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.0 and later
Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On : 8.0.2 version,

When attempting to create a new dimension member to a newly created Simple Dimension, the following error occurs.

Error
Error Occurred: Invalid Identifier

Steps
1. Created a one new simple dimension following the steps from the Data Model Utilities User guide.
    The following are the _CD and _MLS tables created.

Table Name :  FSI_MARKET_TYPE_CD

COLUMN_NAME

DATA_TYPE

NULLABLE

MARKET_TYPE_CD

NUMBER(5,0)

No

LEAF_ONLY_FLAG

VARCHAR2(1 CHAR)

No

ENABLED_FLAG

VARCHAR2(1 CHAR)

No

MARKET_TYPE_DISPLAY_CODE

VARCHAR2(5 CHAR)

Yes

CREATED_BY

VARCHAR2(30 CHAR)

No

CREATED_TS

TIMESTAMP(6)

No

LAST_UPDATED_BY

VARCHAR2(30 CHAR)

No

LAST_UPDATED_TS

TIMESTAMP(6)

No

DEFINITION_LANGUAGE

VARCHAR2(4 CHAR)

No

 

Table Name :   FSI_MARKET_TYPE_MLS

COLUMN_NAME

DATA_TYPE

NULLABLE

MARKET_TYPE_CD

NUMBER(5,0)

No

LANGUAGE

VARCHAR2(3 CHAR)

No

MARKET_TYPE

VARCHAR2(40 CHAR)

No

DESCRIPTION

VARCHAR2(255 CHAR)

Yes

CREATED_BY

VARCHAR2(30 CHAR)

No

CREATED_TS

TIMESTAMP(6)

No

LAST_UPDATED_BY

VARCHAR2(30 CHAR)

No

LAST_UPDATED_TS

TIMESTAMP(6)

No


2. Post model changes, Dimension Leaf Registration and Dimension object registration and validation able to view the simple dimension under the Dimension Management screen.
3. Add a new value to the dimension then error out.


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