My Oracle Support Banner

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

Last updated on MARCH 20, 2019

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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.