My Oracle Support Banner

How to Generate an IDENTITY_CODE for FSI_DATA_IDENTITY When Loading Multiple Management Ledgers (Doc ID 2595376.1)

Last updated on FEBRUARY 17, 2021

Applies to:

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

Goal

For Oracle Financial Services Profitability Management (PFT) 8.0.6 and higher, for a case where multiple Management Ledgers are used to store different sets of data, how can you generate IDENTITY_CODE values in FSI_DATA_IDENTITY for different data sets and different Management Ledgers?

For example: If you define the IDENTITY_CODE values as <As of Date>+code identifying the data source, it will not work when loading multiple Management Ledgers because you will get a unique constraint error on FSI_DATA_IDENTITY.

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
References


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