My Oracle Support Banner

Can Unique Index Be Applied in Instrument Table on ISO_CURRENCY_CD Column? (Doc ID 2703806.1)

Last updated on AUGUST 28, 2020

Applies to:

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

Goal

Questions on requirement to apply Unique Index in instrument table such as FSI_D_BORROWINGS on ISO_CURRENCY_CD column:

1. Can same be done through Database only or it is required to be done via Erwin Data Modeler tool?

2. As the instrument table is not empty, what is the approach for this activity?

3. If this can be done through database only, will the change persist upon upgrading the application from 7.x to let's say 8.0.x version?

Solution

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
Goal
Solution


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