Ledger Stat Dimensions Missing Processing Key Column Property After Data Model Upload (Doc ID 1156263.1)

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)

Symptoms

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.

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