Allocation Fails With ORA- 00904: "OFSA_IDT_ROLLUP"."NODE_": Errors When Hierarchy Filter Has Selected Lowest Level in Unbalanced Hierarchy
(Doc ID 2025601.1)
Last updated on MARCH 01, 2019
Applies to:Oracle Financial Services Profitability Management - Version 6.1.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
On Oracle Financial Services Profitability Management (PFT) 6.1.1, an allocation using a hierarchy filter has failed with the following error:
Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function:  - oexec(),
oexn() SQL Function:  -
INSERT Oracle Error: ORA- 00904: "OFSA_IDT_ROLLUP"."NODE_":
invalid identifier Driver Function: drv_oci::Execute() SQL
The error appears to be caused by incorrect Reverse Population rows into OFSA_IDT_ROLLUP.
The issue can be reproduced at will with the following steps:
1. Run allocation with hierarchy filter and receive error.
2. Check the hierarchy in OFSA_IDT_ROLLUP and find incorrect data in the NODE_XX column. Some data appears to be missing.
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