My Oracle Support Banner

How to Make Reverse Population Fail With Errors for Hierarchies Greater than 15 Levels (Doc ID 2442131.1)

Last updated on NOVEMBER 14, 2019

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.4 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Data Relationship Management (DRM)
fsi_batchmemberload

Symptoms

On 8.0.4 Reverse population failure when updating OFSA_IDT_ROLLUP does not return error status.

Multiple hierarchies are loaded into stage tables for all dimensions and the drmloader function is ran before the reverse population was executed.
When PFT hierarchies have more than 15 levels, reverse population does not update the OFSA_IDT_ROLLUP table.
This is expected scenario but the function fsi_batchHierarchyLoad does not return the error status due to which user is not able to identity whether reverse population is successful for all hierarchies of that dimension or not at all.
Since the rules are not generating allocation outputs, when business executes the allocation rule, user has to manually check the table and logs if all hierarchies are loaded into OFSA_IDT_ROLLUP, as the fsi_batchHierarchyLoad function does not return error status.

The issue can be reproduced at will with the following steps:
1) Load the multiple hierarchies for one dimension with one hierarchy have more than 15 levels
2) Run the drmloader for the dimension
3) Run the reverse population for that dimension like below,
L_REVPOP_STATUS :=fsi_batchMemberLoad(p_batch_run_id ,p_as_of_date,10,NULL,2);
L_REVPOP_HIER_LOG_STATUS := fsi_batchHierarchyLoad(p_batch_run_id ,p_as_of_date,10,NULL,2);
4) Except for the hierarchies having more than 15 levels, everyone else is updated in OFSA_IDT_ROLLUP table
5) The fsi_batchHierarchyLoad function does not return error status

Cause

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
Symptoms
Cause
Solution
References


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