Questions on PFT Requirements for the LEDGER_STAT Unique Index
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)
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?
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