My Oracle Support Banner

Data Model Upload Column Order Is Not the Same As in ERwin Data Model (Doc ID 2744219.1)

Last updated on JANUARY 21, 2021

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.7 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Enterprise Performance Management (EPM)

Symptoms

On 8.0.7.4.0, after uploading a model with a new table, the order of columns appears to be incorrect. For exampled, as per the Erwin Data Model, the expected order is v_filter_code,v_filter_value,v_created_by,d_created_date,f_auth_status.

However, the data model upload created the columns in a different sequence:

DDL from Execution Log:
Query: Create table load_filters (V_FILTER_VALUE VARCHAR2(250 CHAR) DEFAULT NULL Not Null,V_FILTER_CODE VARCHAR2(30 CHAR) DEFAULT NULL Not Null,V_CREATED_BY VARCHAR2(6 CHAR) DEFAULT NULL Null,D_CREATED_DATE DATE DEFAULT NULL Null,F_AUTH_STATUS CHAR(1 CHAR) DEFAULT NULL Null,CONSTRAINT PK_1435 PRIMARY KEY (v_filter_code,v_filter_value))

Database

V_FILTER_VALUE VARCHAR2(250 CHAR) No NULL 1
V_FILTER_CODE VARCHAR2(30 CHAR) No NULL 2
V_CREATED_BY VARCHAR2(6 BYTE) Yes NULL 3
D_CREATED_DATE DATE Yes NULL 4
F_AUTH_STATUS CHAR(1 CHAR) Yes NULL 5

Specific column order is required for performance issues.


The issue can be reproduced at will with the following steps:
1. Run model upload
2. Compare column order in database after model upload to the column order in the Erwin data model.

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


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