Allocation with Static Table Driver Produces No Results - Static Table Driver Edited Manually

(Doc ID 2059412.1)

Last updated on SEPTEMBER 28, 2015

Applies to:

Oracle Financial Services Profitability Management - Version 6.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Profitability Management (PFT) 6.1, when you run a Static Table Driver Allocation, no rows are output by the Allocation.  Data exists in the source table but the merge query generated by the Allocation is not returning rows.  The following message exists in the View Log:

Failed to create updater for summary table"

The Static Table Driver definition contains one Key dimension and one Target dimension.

Additionally, you maintain the Static Table Driver manually instead of using the interface.  You must do this because the Static Table Driver is very large.

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