PFT Hourglass Spins Opening Upgraded Allocation

(Doc ID 1632762.1)

Last updated on FEBRUARY 10, 2018

Applies to:

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


On  Oracle Financial Services Profitability Management (PFT), upon editing and saving several allocation rules are becoming corrupt and now the hourglass spins when re-opening the allocation.


Allocation rules are becoming corrupt because of leaf_num_id = 709, on FSI_M_ALLOC_LEAF_SELECTION is saving leaf_node as NULL for preexisting rules.


Expect proper leaf_node value is saved for the CUSTOMER_ID dimension so they do not become corrupt.

Steps to reproduce
The issue can be reproduced at will with the following steps:
1. Open an existing rule that was migrated from OFSA 4.5 and then save the rule without making any changes.
2. Try opening the rule again and the rule fails to open/render the hour glass keeps spinning.


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