Questions on PFT Requirements for the LEDGER_STAT Unique Index (Doc ID 2068379.1)

Last updated on APRIL 21, 2017

Applies to:

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

Goal

Question 1: For Oracle Financial Services Profitability Management (PFT) , can you remove ISO_CURRENCY_CD from the LEDGER_STAT unique index if multi-currency is not used?

Question 2: For PFT, can you remove ACCUM_TYPE_CD, CONSOLIDATION_CD, and BALANCE_TYPE_CD from the unique index if only 1 year is kept in LEDGER_STAT and ACCUM_TYPE_CD, CONSOLIDATION_CD and BALANCE_TYPE_CD are constant?

Question 3: Is there a required order for the columns in the LEDGER_STAT unique index? (OFSA 4.5 had requirements listed in <Document 158126.1>.)

Question 4: Is there a name requirement for the LEDGER_STAT unique index?

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