Allocation Rule Generating Zero Records Due to Scientific Notation Values for Large Dimension Members and Nodes
(Doc ID 2425651.1)
Last updated on MARCH 25, 2019
Applies to:Oracle Financial Services Profitability Management - Version 8.0.5 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)
On PFT 8.0.5, an allocation rule is generating zero records when selecting a dimension node. When checking the ofspa log, the SQL generated for the Hierarchy Filter contains scientific notation.
where node_03 = 4E+07
and sys_id_num = 202940
Have created Allocation rule EXP_S_ST_MKT_CONTRACTOR which is producing 0 records even though it is expected rule to process data. Have observed that one of the underline SQL is using scientific notation value (9.9991e+10) . Similar incorrect scientific notation value makes the SQL for FSI_M_DATA_IDENTITY_DETAIL table fail.
The issue can be reproduced at will with the following steps:
1. Create dimension node 99991037210
2. Select the node from hierarchy in allocation
3. Run allocation
4. Check pft debug log
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