Resolving Error: 3335 During FDMEE Data Export

Cause

Oracle Hyperion Financial Data Quality Management, Enterprise Edition data export from Planning Modules may fail with the following error:

ERROR
-----------------------
21 04:18:34,392 DEBUG [AIF]: Fetching rule file from essbase server for data loading: AIF0061
2018-05-21 04:18:34,401 INFO [AIF]: Starting executeDataRuleFile...
2018-05-21 04:18:34,402 DEBUG [AIF]: Locked rule file: AIF0061
2018-05-21 04:18:34,410 INFO [AIF]: Loading data into cube using data file...
2018-05-21 04:18:35,655 INFO [AIF]: Load data encountered the following errors:

| Error: 3335 | 100 | "100","110","Working","BaseData","P_000","Actual","FY18","Jan",1111 |
This issue exists in the following situations:
  • The mapped target dimension member does not exist
  • The same member name exists in more than one dimension

Solution

  • Ensure that the target dimension member included in the mapping exists in the target application.
  • Ensure that the mapping is properly defined.
  • Make sure that member names are unique across dimensions. Identical member names should not be present in more than one dimension.