Is There an Option Using FSI_SYNC_STAGE to Set the Dimension Member IDs to Code Values?
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)
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?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms