FDM 11.1.x Issues Loading Periodic Data

Overview

When using Oracle Hyperion Financial Data Quality Management (FDM) to load data into Oracle Hyperion Financial Management (HFM), you have the option of specifying the DataView as either year to date (YTD) or periodic.

By default, FDM loads HFM with year to date formatted files.  In this case, the user does not need to specify the DataView.  However, some data sets are required to load as periodic, most notably Budget and Forecast scenarios.  To load periodic data, you specify the DataView in the location's corresponding import format.

Since FDM version 11.1 and later there has been two known issues preventing FDM from loading periodic data into HFM.  Below is an overview of the issues with information on how to correct them.

Part 1 - Export Script Does Not Properly Handle Periodic Data

The first issue requires a change to the HFM Export adapter script.  The script is missing essential code necessary in identifying and processing periodic data.  The code change requires a new block of code to assess the DataView of the current processed record.

Oracle Information

• Oracle Knowledge Base ID: 840319.1
• Oracle Knowledge Base Article: Periodic Data Export Fails Loading into HFM with "No Such Member PER" [ID 840319.1]
• Oracle Bug ID: 8588253
• Version Impact: Release: 11.1 and later, including 11.1.2.1

Part 2 - Intersection Validation Fails When Processing Periodic Data

Issue # 2 requires another adapter script change, this time to the CheckIntersections adapter script.  This script is executed during the Validate workflow step.  Without changes, the CheckIntersections adapter script truncates the periodic label value - "PERIODIC" becomes "PERIO".

Oracle Information

• Oracle Knowledge Base ID: 838559.1
• Oracle Knowledge Base Article: DataView is Truncated from Periodic to Perio and Causes a Failure During the Intersection Validation for Financial Data Quality Management (FDM) [ID 838559.1]
• Oracle Bug ID: 8580652
• Version Impact: Release: 11.1 and later, including 11.1.2.1