My Oracle Support Banner

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

Last updated on MARCH 07, 2019

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)


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
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,
values (:group_num, :num_key, :char_key, :description )

You cannot get the Allocation Model to process successfully.


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.