Last updated on JANUARY 26, 2017
Applies to:Oracle Financial Services Profitability Management - Version 8.0.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.0.0 and later
Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Is it possible to re-order Level in REV_HIER_FLATTENED to be the same as DIM_<dimension>_HIER table.
After flattening a hierarchy for a given dimension (eg. ORG_UNIT_ID) the results are populated in REV_HIER_FLATTENED.
But, the levels displayed on the User Interface and that of DIM_ORG_UNIT_HIER are just opposite showing from Level 20 instead of Level 1.
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