New Custom Dimensions Not In LEDGER_STAT After Successful Model Upload (Doc ID 1511261.1)

Last updated on APRIL 27, 2017

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.2 and later
Oracle Financial Services Profitability Management - Version 8.0.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

When attempting to add additional dimensions/leaves into LEDGER_STAT table using Erwin, the columns were not added even though there is no error in the model upload log.

Steps:
1. Create dimension and hierarchy tables for the new leaves.
2. Add the new columns into super-class table: LEDGER LEAF COLUMN CLASS
3. Perform model upload successfully, but the additional are not shown in LEDGER_STAT.
4. Check REV_TAB_COLUMNS and REV_TAB_COLUMNS_MLS for LEDGER_STAT and the new leaf columns have been inserted into the tables.



Cause

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