My Oracle Support Banner

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: [4] - oexec(),
  oexn() SQL Function: [3] -
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

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