Circular Allocation Model Fails Before Launching Sweep Allocation (Doc ID 2061272.1)

Last updated on NOVEMBER 08, 2016

Applies to:

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

Symptoms

In Oracle Financial Services Profitability Management (PFT) 8.0, when you run a Circular Allocation Model that includes multiple circular allocations and one sweep allocation, the process fails before running the sweep allocation. The following problems exist:

1. The Model loops through the Circular Allocations more than the 3 cycles defined in the Model

2. The process fails before going to the Sweep Allocation.  The following SQL is the last SQL listed in the ofspa log:

Module Logging OFS Access module data: /* 204: io_lookup::SetID*/

Module Logging OFS Access module data: delete
delete from FSI_ENGINE_LOOKUP
where FSI_ENGINE_LOOKUP.group_num = 415.00000
and FSI_ENGINE_LOOKUP.num_key = 0.00000


Module Logging OFS Access module data: insert
insert into FSI_ENGINE_LOOKUP(group_num, num_key, char_key,
description)
values (:group_num, :num_key, :char_key, :description )


You cannot get the Allocation Model to process successfully.

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