Allocation Fails With ORA- 00904: "OFSA_IDT_ROLLUP"."NODE_": Errors When Hierarchy Filter Has Selected Lowest Level in Unbalanced Hierarchy
Last updated on MAY 10, 2017
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.
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