Ledger Stat Dimensions Missing Processing Key Column Property After Data Model Upload
Last updated on JUNE 28, 2017
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 7.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
In Oracle Financial Services Analytical Applications Infrastructure (OFSAAI), after you upload a data model with table changes, several user defined dimension (leaf) columns on the LEDGER_STAT table are no longer registered properly. The columns are missing rows in the REV_COLUMN_PROPERTIES table with COLUMN_PROPERTY_CD = 15 (Processing Key). The rows are removed each time you do a model upload and you have to insert them manually.
The missing rows can cause various issues when running OFSAA processes. For example, when you run a Ledger Stat Allocation that should update based on values in the one of the problematic columns, the column is ignored and new rows are inserted instead of updating the existing rows.
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