Is There an Option Using FSI_SYNC_STAGE to Set the Dimension Member IDs to Code Values? (Doc ID 2264502.1)

Last updated on MAY 10, 2017

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)

Goal

In fsi_sync_stage, the generated IDs are coming from a sequence, and while migrating from OFSAA4.5 to OFSAA8, are using fsi_sync_stage in order to synchronize IDs in the stg tables. Currently, need the generated dimension member ids to be the same as the codes in the stg, as are currently writing back all of these values to OFSAA, so need the ID values to be the same.
Is there is a way to do so?

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