1 Reply Latest reply on Dec 8, 2009 9:29 PM by Bryan Meek-Oracle

    Unable to Configure Adapter FM11x-G5-C

    699972
      Good afternoon,

      I am setting up FDM application on version 11.1.1.3. using adapter FM11x-G5-C
      Following the "fm_g5_c_target_adapter_readme.pdf" I need to Configure the FDM adapter.

      I right click on the adapter and get the following error message:

      Unable to localize string Key =A_FM11x-G5C_COM_Admin_1
      Unable to localize Error message. Error Code=10069

      Are there any suggestions what to do?

      Thank you in advance
      Kind regards,
      Joelle
        • 1. Re: Unable to Configure Adapter FM11x-G5-C
          Bryan Meek-Oracle
          Oracle released a patch that allows you to manually install this on other releases.

          Perhaps try the manual steps? It is on the support portal under patch number 8947795

          The readme details follow here.....



          README for 8947795

          Patch Details

          Oracle® Hyperion Financial Data Quality Management Adapter for Oracle Hyperion Financial Management

          Release G5-A

          Readme

          Purpose. 1

          Overview.. 1

          Installation. 2

          Configuration. 3

          Single Sign-On and Drillback Setup. 5

          Setting Up an Intercompany Location. 7

          Intercompany Module Process Overview.. 8

          Notes. 8



          Purpose

          This document includes important, late-breaking information about this release of the Oracle® Hyperion Financial Data Quality Management, Fusion Edition (FDM) adapter for Oracle Hyperion Financial Management, Fusion Edition (Financial Management) and the FDM Intercompany adapter for use with Financial Management. Review this information thoroughly before installing the adapter.

          Top of Document

          Overview

          Standard Adapter

          The FDM adapter for Financial Management is a target adapter that allows users to load data from FDM into Financial Management.

          Intercompany Adapter

          FDM supports the loading of intercompany detailed transactions to Financial Management Intercompany Transaction Module. The FDM Intercompany adapter allows you to import, map, and load intercompany transactions at the invoice level.

          Date Created: 09/12/2008

          Adapter Versions: FM11x-G5-A.xml (Financial Management)

          FM11i-G5-A.xml (Intercompany)

          Compatibility: FDM 9.3.1 – 11.1.1.x

          See the FDM readme for Financial Management compatibility information.



          Key Features of the Intercompany Module

          · Imports, maps, and loads detailed intercompany transactional data to the Financial Management Intercompany Transaction Module.

          · Supports all Financial Management Intercompany Transaction Module fields.

          · Automatically attaches scanned invoices as memo items to detailed lines when importing A/R extracts.

          · Employs the FDM standard validation reporting to verify that the intercompany transactions posted by the Intercompany Module match the ledger intercompany balances.

          · Uses all of the FDM standard features:

          · User interface

          · Workflow process

          · Mapping capabilities

          · Validation reporting

          · Audit trail features

          Top of Document

          Installation

          This section includes important information about installing this release of the FDM Adapter for Financial Management.
          To add the Financial Management adapter to an FDM application:
          1. Create an Adapters folder in one of the following locations if it does not exist. Note: depending on your version of FDM, the FDM adapters directory may be located in one of the following locations:

          · <hyperion home>\FDM\Shared Components\

          · <hyperion home>\FDM\

          · <hyperion home>\products\FinacialDataQuality\

          2. Extract the contents of the zip file to the FDM adapters directory.

          3. Use the following commands to register the adapter:

          · For 32-bit Windows operating systems

          a. C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\RegAsm.exe /codebase "<Path to your adapters folder>\FM11x-G5-A\fdmAdapterCOMadmin\fdmAdapterCOMadmin.dll"

          b. C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\RegSvcs.exe "<Path to your adapters folder>\FM11x-G5-A\fdmFM11xG5A\fdmFM11xG5A.dll"

          · For 64-bit Windows operating systems

          a. C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\RegAsm.exe /codebase "<Path to your adapters folder>\FM11x-G5-A\fdmAdapterCOMadmin\fdmAdapterCOMadmin.dll"

          b. C:\WINDOWS\Microsoft.NET\Framework64\v2.0.50727\RegSvcs.exe "<Path to your adapters folder>\FM11x-G5-A\fdmFM11xG5A\fdmFM11xG5A.dll"

          4. From FDM Workbench, open an FDM application.

          5. Select the Adapters tab.



          6. Select File > Import.

          The Open Metadata Import File dialog box is displayed.

          7. Perform an action:

          a. To install the Financial Management adapter, browse to find the file named FM11x G5-A.xml, and click Open.

          b. To install the Intercompany adapter, browse to find the file named FM11i-G5-A.xml and click Open.

          8. Click OK.

          The FDM adapter for Financial Management or Intercompany is displayed in the list of imported target adapters.

          9. Right-click on the Financial Management adapter and select Configure.

          The FDM Adapter COM Admin screen is displayed.

          10. In the User Name, Password, Confirm Password, and Domain fields, enter the appropriate information for the FDM service account.

          This should be the same user used to configure the other FDM components.

          11. Click OK.

          Top of Document

          Configuration
          To configure the adapter:
          1. In FDM Workbench, from the Adapters tab, select the adapter.

          2. Right-click and select Options.

          The Adapter Options dialog box is displayed. The Options menu enables you to select any of the options and change the option settings.

          3. Set the adapter options per the guidelines in the following table:

          Option Name
          Information Required

          Application Name (required)
          Name of Financial Management application in which to load data.

          Logon Method
          Select 1-Unified or 2-Global. Default setting is 1 – Unified.

          Global Logon Information
          UserID and password for Financial Management account (format UID;PW). Only used if Logon method is set to 2 – Global.

          Use SSO
          On/Off switch to enable Hyperion Single Sign-On when a token is passed to FDM. Default setting is off.

          Use Sticky Server
          On/Off used to force usage of one server for Load, Consolidate, and Check. This enables the Financial Management application server cache delay. Default setting is off.

          Enable Intersection Validation
          On/Off switch used to enable Financial Management intersection validation. Default setting is on.

          Generate XML Intersection Report
          On/Off switch used to enable the XML intersection report. Default setting is off.

          FDM Web Server Name
          Name of Web server on which FDM Web client is running. Only used (required) when XML Intersection Report setting is turned on.

          Use SSL
          On/Off switch to enable FDM Web server SSL indicator. Only used (required) when XML Intersection Report setting is turned on. Default setting is off.

          Enable Load
          On/Off switch used to enable Load action. Default setting is on.

          Enable Line Item Detail Loading
          On/Off switch used to enable Line Item Detail loading (only for single-period load). Default setting is off.

          Enable Journal Loading
          On/Off switch used to enable loading of FDM journals as Financial Management journals. Default setting is off.

          Enable Cell Text Loading
          On/Off switch used to enable cell text loading (only for single-period load). Default setting is off.

          Enable Consolidation
          On/Off switch used to enable Consolidation Action. This switch also controls Force Calculate and Force Translate. Default setting is on.

          Enable Validation Report
          On/Off switch used to enable Validate action. Default setting is on.

          Enable Controls Review
          On/Off switch used to enable Controls Review Integration action. Default setting is off.

          Enable Process Mgmt
          On/Off switch used to enable Financial Management Process Promotion following the FDM Controls Submit action. Default setting is off.

          Enable Chain Load
          On/Off switch used to enable FDM Chain Load Integration action. Default setting is off.

          Enable Data Protection
          On/Off switch used to enable Data Protection capability. Default setting is off.

          Protection Value
          Value <protection value> This is required only when Enable Data Protection is turned on.

          Protection Operator
          Select operator (= or <>). This is used only when Enable Data Protection is turned on. Default setting is “=”

          Force Calculate
          On/Off switch used to enable calculation of cell prior to consolidation. Default setting is off.

          Force Translate
          On/Off switch used to enable Translation call prior to consolidation. Default setting is off.

          Translation Level
          Select Parent Currency, Parent Currency Total, Parent Currency Adj, Entity Currency, Entity Curr Total, or Entity Curr Adj). This option is only used when Force Translate is turned on. Default setting is Parent Currency.

          Consolidation Type
          Select 0-Impacted, 1-All With Data, 2-All, 3-Entity Only, or 4-Force Entity Only. Default setting is 0-Impacted.

          Line Item Detail Load Type
          Select 1-Summarized or 2-Load Detail. This option is only used when Line Item Detail Loading is turned on. Default setting is 2-Load Detail.

          Journal Status
          Select 1-Working, 2-Submitted, 3-Approved, 4-Posted, or 5-Rejected. This option is only used when Loading Journals. Default setting is 4-Posted.

          Journal Default Data Value
          Select Contribution Adjs, Parent Adjs, Entity Curr Adjs, Parent Curr Adjs). This option is only used when Loading Journals. Default setting is <Entity Curr Adjs>.

          Journal Enable JV ID Per Entity
          On/Off switch used to control journal numbering (On = One ID for each entity in the POV, Off=One ID for all data in the POV). This option is only used when Loading Journals. Default setting is on.

          Journal Load Balancing Attribute
          Select B-Balanced, U-Unbalanced, or E‑Balanced By Entity. This option is only used when Loading Journals. Default setting is U-Unbalanced.

          List All Periods
          On/Off switch used to toggle between all periods listed or only base periods listed. Default setting is off.

          Load Method
          Select 0-Replace, 1-Merge, 2-Accumulate, or 3-Replace by Security). Default setting is 0-Replace.

          Load Operation
          Select 0-Load, or 1-Scan. Default setting is 0-Load.

          List2 (Not Used)
          n/a

          List3 (Not Used)
          n/a

          Calc Switch (Not Used)
          n/a

          Accumulate in File
          On/Off switch used to enable Calculate in File option. Default setting is on.

          File Has Ownership Data
          On/Off switch used to enable File Has Ownership Data option. Default setting is off.

          Status3 (Not Used)
          n/a


          Top of Document

          Single Sign-On and Drillback Setup

          Use this procedure to configure Financial Management and FDM to enable the FDM Drillback/Drill Through functionality.

          Important: This procedure to use SSO only applies when using FDM versions 11.1.0 and earlier. For FDM versions 11.1.1.1 and later, use the CSS option detailed in Chapter 6 of the FDM Configuration Guide.

          Procedure

          1. Create a link to FDM in Financial Management.

          2. Enable the FDM Load Balancer SSO Authentication Script.

          3. Enable FDM to Pass Back the SSO Token to the Target System.

          4. Enable Drillback Functionality in Financial Management.

          5. Create a Link to FDM.

          1. Create a Link to FDM in Financial Management

          1. From Hyperion Workspace, log in to a Financial Management application.

          2. Select Administration > Manage Documents.

          3. Click the Links tab.

          4. Click New.

          The New Link page is displayed.

          5. In the Link field, enter the following: http://<servername>/<wwwwwwww>/ AuthorizedPages/LogonPage.aspx?AppName=<xxxxxxxx>, where:

          • <server name> is the web server address.

          • <wwwwwwww> will be HyperionFDM for 9.3.1 and higher.

          • <xxxxxxxx> is the FDM application name (optional).

          6. Clear Tasklist opens link within same page.

          7. Check Include the Single Sign On information in page request.

          8. Click Save.

          9. Enter a name and description for the link and click OK.

          The New Link screen closes and returns to the previous screen.

          10. Click Cancel.

          The link to FDM now appears on the Manage Documents–Links screen.

          2. Enable the FDM Load Balancer SSO Authentication Script

          1. From the FDM server, open the Load Balance Manager Configuration tool by selecting Start > All Programs > Oracle EPM System > Financial Data Quality Management > Load Balance Manager > Load Balance Configuration.

          2. From the Authentication Providers tab, click Add.

          The Add Authentication Provider dialog box is displayed.

          3. From the Add Authentication Provider dialog box, select Visual Basic Script SSO Authentication and click OK.

          The Visual Basic Script SSO Provider screen is displayed.

          4. In the Description field, enter a description.

          5. Delete the existing script contents and replace with the following:



          Function AuthenticateSSO(token, applicationName)

          ' Place your single sign-on authentication script here

          ' To signify an authentication failure, you should

          ' Raise an error by calling the following method:

          ' Err.Raise [error number over 1000], [source], [description]



          Const strProcSig = "AuthenticateSSO"

          Dim strUsername

          Dim strDomain

          Dim objHFMSSO

          Dim strClusterName ' HFM cluster name

          Dim strAppName ' HFM application name



          Set objHFMSSO = CreateObject("fdmFM11xG5A.clsFMAdapter")

          If Not objHFMSSO Is Nothing Then

          strClustername = "< HFM Cluster Name>"

          strAppName = "<HFM Application Name>"

          strUsername = objHFMSSO.GetUsernameFromToken(CStr(Token), strClustername, strAppName)



          If Trim(strUsername & "") = "" Then

          ' Blank user name means the token is invalid.

          Set objHFMSSO = Nothing

          Err.Raise 2655, strProcSig, "The Single Sign-on token is invalid."

          Else

          ' Return the user name from the authenticated token.

          AuthenticateSSO = strUsername

          End If

          End If

          Set objHFMSSO = Nothing



          End Function



          6. Add more Select Case statements as necessary.

          7. Click OK.

          The authentication providers are updated.

          8. From the General tab, re-enter the service account password and click OK.

          3. Enable FDM to Pass Back the SSO Token to the Target System

          1. From FDM, select Administration > Integration Settings.

          The Integration Settings screen is displayed.

          2. From Options, select Use SSO.

          3. Select On/Off.

          4. Click Save.

          4. Enable Drillback Functionality in Financial Management

          Refer to the Financial Management documentation for detailed information regarding enabling drillback functionality.

          5. Create a Link to FDM

          1. Select Start > Programs > Hyperion > Financial Management > Server and Web Configuration (not required in 11.x).

          The Financial Management Configuration Utility dialog box is displayed.

          2. Select the Web Server tab.

          3. In the Financial Data Management URL field, enter the following: http://<server name>/HyperionFDM/AuthorizedPages/IntersectionSummaryByLocation.aspx where <server name> is the FDM Web server name.

          4. In DCOM User Info, enter a DCOM service account and password.

          5. Click OK.

          Top of Document

          Setting Up an Intercompany Location

          1. Log in to the FDM Workbench and import in the FDM intercompany adapter (xml file).*

          2. Configure machine profiles and integration settings using the same procedure for configuring the standard HFM adapter.*

          3. Redefine custom 1-4 dimensions as they are defined in the main HFM adapter. Disable the intercompany dimensions that will not be used (optional).

          · The intercompany adapter contains all the pre-defined HFM intercompany fields.

          4. Designate a FDM location as an intercompany detail location.

          · In the Locations screen, create a new location, and specify from Target Adapter the Intercompany adapter from the list.

          · When the Intercompany adapter has been assigned to a location, the location data will load to the HFM Intercompany Transaction Module upon export.

          5. Change the FDM POV to the intercompany location and build an import format to read in all the HFM intercompany fields from the source extract files.**

          · Multiple import formats may be required for the same location depending on source file format (A/P file and A/R file, for example) and an event script is required to switch import formats before the import event fires.

          · Assign the import format to the intercompany location.

          6. Build mapping tables for the intercompany location.

          · Mapping is also required for the pre-defined HFM intercompany fields. In most cases this would require a * to * map for the intercompany fields.

          7. Modify the existing ImportProcess event script. This script attaches scanned invoices to the detail AR imported data by matching the invoice file names with the imported Transaction ID (optional).

          8. Import, validate, and export intercompany-detailed data to the HFM Intercompany Transaction Module.

          Top of Document

          Intercompany Module Process Overview

          1. Import detailed intercompany data files into a FDM intercompany location.

          2. Automatically attach scanned detail invoices to the imported source A/R intercompany detail lines.

          3. Validate and fix mapping errors.

          4. Export and load intercompany data into HFM Intercompany Transaction Module.

          5. Perform matching and posting process within the HFM Intercompany Transaction Module for specified entities.

          6. Investigate any non-matching transactions by reviewing details in the offsetting intercompany FDM location. Can review attached invoices if they were linked to the A/R intercompany source data lines during the import process.

          Optional Steps

          7. Perform normal GL import and load for associated non-intercompany FDM location.

          8. Map general ledger intercompany accounts to HFM statistical accounts.

          9. Run FDM validation report to verify that the intercompany account balances loaded using the HFM Intercompany Transaction Module tie out to the GL intercompany account balances loaded to statistical accounts.

          Top of Document

          Notes

          · This adapter is compatible with 32-bit operating systems and 64-bit operating systems running in 32-bit emulation mode.

          · Bug #7359133 – Fixed error that could cause the data load to fail when the data contains line item detail information.

          Top of Document



          Copyright © 2009, Oracle and / or its affiliates. All rights reserved.
          http://www.oracle.com