That Oracle error smells like a bug. Open a case with support, making sure to specify how you created this app ( classic from scratch, classic updated from previous release, through copyapp, epma etc etc).
If I'm not mistaken, there is a note in the readme regarding invalid records. Please check the readme for HFM, and I think you'll see a note to the effect that you should run "delete invalid records" in the database module (after first backing up your schema).
Looks like you are using 22.214.171.124 version??
If so i am facing the same issues and i have already raised this issue with oracle support team, have not heard back from them.
We recently upgraded from 11.1.2 to 126.96.36.199 and we are facing lot of issues and one of them is consolidation issues.
And let me know if you have tired the below solution:
Hyperion Financial Management - Version: 188.8.131.52.00 and later [Release: 11.1 and later ]
Information in this document applies to any platform.
Consolidation hangs at 100% for a specific Scenario/Year POV. The consolidation does not complete and the hsvdatasource process eventually has to be killed.
The Parent has CN status, whereas all its children have OK status, from Entity currency to Contribution total.
The following error is generated in the Hsveventlog log:
File: DataTransactions.cpp Version: 184.108.40.206.50.2839 Line: 3163
Error: (-2147213696)(0x80041E80)(An unknown error has occurred in the HsvDSData2 object.)
If the UseConsolidationRules are disabled, the consolidation then completes.
The database schema is missing tables for the affected POV, scenario x and year yyyy:
Two of three tables, RTS and RTD, are used if ConsolidateRules is set to Y or R, and this is the direct cause of the error message generated. It is not known whether these tables ever existed or have been inadvertently deleted.
Restore Financial Management (HFM) repository database from the backup, if the missing tables exist in a prior backup. If no suitable backup exists, contact Oracle Support. A script may be provided by Oracle Development to create the missing tables and corresponding sequence and indexes.
Version is 220.127.116.11，The database schema's not missing tables (_ETX_, RTD ,_RTS_ all exist).
I create a HFM aplication using EPMA for testing, then import C1-C4 dimension memeber from database interface, redeployment application and data synchronization using EPMA batch client, first consolidation using task automation is OK.
Then I run batch script once again, import member, redeployment and data synchronization. Now the Parent has CN status, its children have OK SC status. run consolidation all task, failed, HsvDSData2 error in message, the Parent has CN status, its children have OK status.