How to Change and Find the Erwin Model Level UDP Version (Doc ID 2264906.1)

Last updated on MAY 11, 2017

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Oracle Financial Services Profitability Management - Version 8.0.0 and later
Oracle Financial Services Hedge Management and IFRS Valuations - Version 8.0.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.0.0 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)
CA Erwin Data Model
Model Upload
Sliced Model Upload
Incremental Model Upload

Goal

A model level User Defined Property (UDP) known as “VERSION” is available with every model.  5 digits OFSA version numbering is followed for model versions. Each table will inherit the model version into Table version as Table level UDPs. Model upload registers the version against each entity during the model upload process.  This version can be found in the Erwin file by checking: Toolbar--Model > Model Properties > UDP Tab > VERSION.

Sliced model upload checks the model version to decide if columns should be dropped or not. When the SLICE and BASE models have common tables and if BASE entity version is higher than SLICE, then entity in the BASE is retained unchanged. If SLICE entity version is higher than or equal to BASE version, entity in the SLICE will replace the BASE. Once the entity is brought into BASE model, the version of it is stamped against it. Any models/ tables prior to OFSAAI version 80100 is defaulted to version 80000.

Model upload registers the version against each entity during the model upload process. This document provides with the steps to change the version of model.

Solution

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