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
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,
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