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 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)

Symptoms

On Oracle Financial Services Profitability Management (PFT) 6.1.1, an allocation using a hierarchy filter has failed with the following error:

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
  Statement:

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.

Cause

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