Hyperion Financial Data Quality Management (FDM) and ERP Integrator

Hyperion Financial Data Quality Management (FDM) and ERP Integrator [ID 1134897.1]

Modified 01-MAR-2012

Type DIAGNOSTIC TOOLS  

Status PUBLISHED 

In this Post :

     Purpose---

     Hyperion Financial Data Quality Management (FDM) and ERP Integrator

     Source System Issues:

     Data Loads:

     Metadata Loads:

     EBS Tables:

     WebLogic Plugin:

     Workspace Issues:

     Scripting

     Logs:

Applies to:

Hyperion Financial Data Quality Management - Version: 11.1.1.3.00 and later   [Release: 11.1 and later ]

Information in this document applies to any platform.

Purpose ---

The purpose of this article is to provide information on FDM and ERPI.

HYP: Financial Data Quality Management group.

Product line is Middleware

Product ID: 4389

Product Name: Hyperion Financial Data Quality Management

Component is EPM Integrator.

Hyperion Financial Data Quality Management (FDM) and ERP Integrator

EPM release 11.1.2.1.000 is now generally available---Please review the following Articles prior to installation.

Release Announcement:   Document 1306738.1

EPMA Mandatory Patch:   Document 1308127.1

DRM Recommended PSU: Document 1309442.1

The following information is available for FDM and ERPI:

Confirming Patches on EBS:

Document 780874.1  How to Verify EBS Setup for DrillBack to EBS in FDM

Missing Function ID in URL:

Document 976791.1  Drill Down from the ERP Integrator Displays a Blank Page due to Missing Function ID in the URL

Jobs Stuck in ERPI:

Document 1062523.1  How to Reset the Status of an Expired ERPi Job Stuck in "RUNNING" Mode

Installation stages for HFM/FDM/ERPI Configuration:

Document 951369.1  (11.1.1.3) Configure and use ERPi as a Replacement to the Financial Data Quality Management EBS Adapter

Document 1169565.1  (11.1.2) Configure and use ERPi 11.1.2 to Load Data into Financial Data Quality Management from EBS

Document 423712.1 How To Set Up ODI Agents As Windows Services

Drill Configuration/Errors:

Document 1076849.1  When Drilling Back to the EBS Source System After an ERPI Load Has Completed Unexpected Data is Seen

Document 1301241.1  Drilling from FDM to EBS or Peoplesoft Gives the Meassage: "Error calling ERPIDrillService"

Document 976791.1 Drill Down from the ERP Integrator Displays a Blank Page due to Missing Function ID in the URL

Document 1264774.1 ERPi Landing Page is not Displaying EBS Source Records

Document 1069485.1 Drill Back from FDM to ERPI is Not Working With a Copy of ERPI Adapter

Document 780874.1 How to Verify EBS Setup for DrillBack to EBS in FDM

FDM ERPI Adapter Issues

Document 1300758.1 FDM ERPI Import Error:"Error: Import failed" and "Error in getting data" Attempting to Make a Database Connection

Document 1163483.1 Using ERPI Adapter Getting Error "Error: Import Failed" "Error in getting data" During Import

Document 1052154.1 How to Leverage Multiple FDM ERPi Adapters

Document 1069485.1 Drill Back from FDM to ERPI is Not Working With a Copy of ERPI Adapter

Document 1338573.1 FDM Timing Out When Running ERPi Data Rule Import Using ERPi-Fin-B Adapter

Document 1153125.1 Open Source System from FDM into ERPi Returns No Period Activity Records When Leveraging the HFM Adapter

Source System Issues:

Document 1154124.1 How Can an Additional EBS Database be Added within ERPi/ODI for use with FDM?

Document 1234313.1 Troubleshooting Problems Encountered When Initializing a Source System in ERPi

Document 1173240.1When Initialising a Source System in ERPI 'Extract Id : null' is Returned and Initialization Does Not Occur

Data Loads:

Document 988072.1 ERPI - Data Rule Fails - ORA-01438: Value Larger Than Specified Precision Allowed for this Column

Document 1173193.1 ERPI Data Load Does Not Include All The Balances Which Were Expected or Data That Has Been Loaded Does Not Correctly Reconcile With The Source System

Metadata Loads:

Document 1078322.1 New EBS Code Combination IDs are not Updated Inside of ERPi

Document 1157855.1 Running an ERPI EBS GL Dimension Load Rule Fails With ORA-00942: table or view does not exist

EBS Tables:

Document 974390.1 Outline of eBusiness Suite Tables that ERPi 11.1.1.3.00 Requires and the Level of Access

WebLogic Plugin:

Document 1076750.1 ERPI Deployed on Weblogic: Multiple Sets of ODI Scenarios Are Triggered When Running a Single ERPI Data Load Rule From FDM

Document 1275584.1 Multiple Sets of ODI Scenarios are Triggered when Running ERPI Data Load Rule from FDM 11.1.2 (OHS)

Workspace Issues:

Document 1147940.1 ERPi Not Available in Workspace and shows up as "${ERPI}"

Scripting

Document 1335753.1 How To Add An Index in Oracle EBS to Increase Performance in ERPi for Data Load Rule

Document 1077823.1 How to Extract YTD Data from ERPI into FDM in 11.1.1.3

Document 1388960.1 How To Extract YTD Data From EBS Using ERPI Without FDM

Document 1393240.1 How to Extract YTD Data From EBS Using ERPI Into FDM in 11.1.2

Document 1241804.1 Invoking The Erpi Web Services

Logs:

Document 1269052.1 Where are the Logs for ERPI and its Associated Products Stored?

EPM System Defects Fixed Finder Document 1292603.1