Sql Financial Accounting Enterprise Edition User Manual

  1. Sql Enterprise Edition Cost
  2. Sql Server Enterprise Edition Download
  3. Financial Accounting Manual Pdf

Title and Copyright Information

Documentation Accessibility

Documentation Feedback

1 Using FDMEE

  • Key FDMEE Benefits
  • Drilling Through
  • Configuring Oracle Data Integrator With FDMEE
  • Integration Process Overview
    • Integrating Metadata
      • Member Properties Sourced from the Enterprise Resource Planning (ERP) System
      • Defining Metadata Rules
  • Navigating FDMEE
    • Task Pane Options
    • Using the POV Bar
  • Administration Tasks
    • Predefining a List of Profiles
      • Setting Application-Level Profiles
      • Setting Security Options
    • Setting up Source Systems
    • Working with Source Adapters
      • Defining Source Adapter General Information
      • Defining Source Adapter Detail
    • Registering Target Applications
      • Defining Application Options for Essbase and Planning
      • Defining Application Options for Financial Management
    • Loading Excel Data

2 Integrating Tasks

Feb 29, 2016  As with many questions about business, it depends on your situation! I will look at more than one scenario. Scenario 1 - Your accounting system is run on a relational database. In this scenario, it often happens, as a common sub-scenario, that. Jul 02, 2014  A074-Unblock SQL in Avast Anti Virus. A053 Solution Maximum User Reached Problem - SQL Accounting Software by syntaxtechnologies. A052 Regedit Important Video - SQL Accounting. Download sql accounting software full version for free. Business software downloads - SQL Financial Accounting Import by E Stream Software Sdn Bhd and many more programs are. The FDMEE user interface is consistent with the Oracle Hyperion Planning and Oracle Hyperion Financial Management user interfaces. Unable to select an accounting entity when FDMEE is deployed on the WebSphere Application Server. The name was changed to reflect the new Oracle Hyperion Financial Data Quality Management Enterprise Edition.

  • Working with Import Formats
    • Defining the Import Format
      • Adding Import Formats
    • Adding Import Expressions
      • Import Expression Types
    • All Data Types Data Loads
      • Setting the Import Format for Multi-Column Data Types
  • Defining Period Mappings
  • Defining Category Mappings

3 Integrating Data

  • Loading Data
    • Creating Member Mappings
      • Automap Wildcarding
      • Format Mask Mapping for Target Values
    • Defining Data Load Rules to Extract Data
      • Defining Data Load Rule Details
    • Managing Data Load Rules
    • Using Drilling Through
    • Integrating with the EPM Cloud
    • Using the Data Load Workbench
      • Processing Data
      • Using the Workbench Data Grid
    • Integrating with the Oracle Financials Cloud
    • Using Excel Trial Balance Files to Import Data
    • Using Journal Templates to Import Data
      • Integrating Financial Management Journals
      • Defining Journal Templates
      • Processing Journals
    • Loading Data Using a Universal Data Adapter
      • Defining a Universal Data Adapter in Oracle Database Integrator (ODI)
      • Working with a Universal Data Adapter in FDMEE
    • Integrating Data Relationship Management with FDMEE
  • Data Load, Synchronization and Write Back
    • Synchronizing and Writing Back Data
      • Data Synchronization
      • Write-Back
  • Loading Human Resources Data
    • Requirements
    • Defining Human Resource Data Load Rules
    • Managing Human Resource Data Load Rules

4 Logic Accounts

Sql Enterprise Edition Cost

  • Creating Accounts in a Simple Logic Group
    • Logic Group Fields
  • Creating Complex Logic Accounts
    • Complex Logic Example 1: CashTx
    • Complex Logic Example 2: CashTx

5 Check Rules

  • Creating Check Rules
    • Using the Rule Logic Editor to Create Check Rules
      • Adding Rule Logic

6 Batch Processing

  • Using Open Batches
    • Creating Open Batches
  • Scheduling Jobs
  • Working with Batch Scripts
    • Executing the Batch Script for Data Load Rules
    • Executing the Batch Script for Metadata Rules
    • Executing the Batch Script for HR Data Rules
    • Executing the Batch Script to Import Mapping Rules
    • Running a Batch

7 Creating and Using Scripts

  • Using the Script Editor
  • Using Import Scripts
    • Using Import Script Functions
    • Storing and Retrieving Temporary Variables
  • Using Mapping Scripts
  • Using Event Scripts
    • Creating Event Scripts
  • Using Custom Scripts
    • Working with Custom Scripts
    • Custom Script Sample using Jython
  • Using the JAVA API
  • Using Visual Basic API and Samples
    • Visual Basic API List
    • Visual Basic Sample Scripts

8FDMEE Reports

  • Working with Report Definitions
  • FDMEE Detail Reports
    • Audit Reports
      • Map Monitor for User
    • Check Reports
    • Base Trial Balance Reports
    • Listing Reports
    • Location Analysis
    • Process Monitor Reports
      • Process Status Period Range (Cat, Start Per, End Per)
    • Variance Reports

AFDMEE Web Service

Sql Server Enterprise Edition Download

BFDMEE REST APIs

C Source System Tables Used by FDMEE

D Creating an Alternate Schema in an Enterprise Resource Planning (ERP) Source System

E Staging Tables

  • FDMEE Staging Tables
  • PeopleSoft Human Capital Management Staging Tables

F Archiving the TDATAMAPSEG Table

G Working with Open Interface Adapters

  • Setting up the Open Interface Adapter
    • Customizing ODI to Load Data from a Custom Source

H PeopleSoft Commitment Control

I Report Query Table Reference

J System Maintenance Tasks

K Setting up Jython, Eclipse and Python

Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Table of Contents:

This document includes important, late-breaking information about this release of Oracle Hyperion Financial Data Quality Management Enterprise Edition. Review this Readme thoroughly before installing FDMEE.

New Installation, Architecture, and Deployment Features

For new features relating to installation, architecture, and deployment changes in this release, see “New Features in this Release” in the Oracle Enterprise Performance Management System Readme.

Documentation Now Certified on Apple Mobile Devices

Documentation files for Release 11.1.2.3 are now available in two mobile formats: MOBI files, available previously, and EPUB files. EPUB documentation files are supported on all Apple Mobile devices (iPad, iPhone, and iPod Touch). EPUB files are supported on many mobile devices; however, they are certified only on Apple Mobile devices. Additional devices will be certified over time.

If you are coming from Release 11.1.2.0, 11.1.2.1, or 11.1.2.2, use the Cumulative Feature Overview tool to review the list of new features added between those releases. This tool enables you to identify your current products, your current release version, and your target implementation release version. With a single click, the tool quickly produces a customized set of high-level descriptions of the product features developed between your current and target releases. This tool is available here:

In Release 11.1.2.3, FDMEE is offered as the full-featured successor to Oracle Hyperion Financial Data Quality Management ERP Integration Adapter for Oracle Applications (ERP Integrator) and Oracle Hyperion Financial Data Quality Management (FDM). FDMEE represents the integration of both products. It captures key functionality from Oracle Hyperion Financial Data Quality Management, and preserves the ERP Integrator framework that enables users to load metadata and data, and to drill-through and write-back.

Key benefits for legacy FDM users:

  • Improved User Experience—Integrated into the Oracle Enterprise Performance Management System. The FDMEE user interface is consistent with the Oracle Hyperion Planning and Oracle Hyperion Financial Management user interfaces.

  • Improved user interface and data load performance

  • Oracle Hyperion Shared Services integration—All native Shared Services features are supported (for example, user groups).

  • Support for multiple browsers—Internet Explorer and Firefox

  • Support for Oracle Hyperion Enterprise Performance Management System Lifecycle Management—Consistent Lifecycle Management support like other EPM System products.

  • Support for multiple platforms as defined in the support matrix. If integrating with Financial Management, only the Windows operating system is supported.

  • Consistent Scaling and Load Balancing—All scale out configuration and load balancing steps are consistent with other EPM System products.

Key feature enhancements for legacy ERP Integrator users:

  • Improved User Experience—Easy to navigate Oracle Hyperion Enterprise Performance Management Workspace tabs that enables users to switch between Workflow and Setup functions.

  • Supports FDM Workflow processes:

    • Import source data

    • Validate source data against mapping tables

    • Validate target system data

    • Review and validate internal financial control

  • Support for FDM Logic Accounts—Logic accounts are dynamically generated accounts that are used to calculate supplemental values that are not provided in source files.

  • Support for FDM Check Rules—Create Check rules to enforce data integrity.

  • Reporting Functionality—FDMEE provides prebuilt reporting tools that capture business critical operations and revenue generating activities within your organization. The new report functionality is implemented using Oracle Business Intelligence Publisher. Key features include:

    • User-defined report query definitions

    • Based on RTF templates for easy customization

    • Output formats include: PDF, Microsoft Word, Microsoft Excel, and HTML.

    • Existing FDM reports can be migrated to FDMEE.

      .

  • Scheduling—The new Scheduler enables you to run batches on specific days, times or fixed intervals.

  • File Based Data Load—Requirement to regenerate ODI scenario eliminated for file based data loads.

  • Support for Signage in Data Rule—When extracting data from Oracle E-Business Suite/Fusion/Peoplesoft, users can now select the signage for the amount. Three new signage options are available in the data rule section:

    • Absolute—Naturally negative accounts are reversed from source; naturally positive accounts remain the same as source.

    • Same as source—No change in signage from source

    • Reverse from source—Signage is reversed from source.

  • Data Load Mapping—Enhancements include:

    • All mapping types from Oracle Hyperion Financial Data Quality Management are now supported in FDMEE.

    • New “In” type that enables you to map a list of nonsequential source accounts to one target account.

    • Exporting and importing of mapping rules are now supported.

    • Mapping rules can now be associated with data load rules.

    • The data load rules displayed are now based on the Point of View (POV) category.

    • Data load rules can be scheduled.

  • Financial Management Adapter Parity—Key support is available for:

    • Data protection

    • Line item detail

    • Load process

    • Load method

  • Enhanced process logging and error handling

  • Batch Processing—Support added for all rules types added.

  • Enhanced System and Security options

    • Provides eight additional intermediate roles (2-9) that allows an administrator to define access to specific features in FDMEE.

In this release, FDMEE supports a SAP BW (Business Warehouse) data load.

Key features include:

  • Certified on SAP BW release 7.0

  • Data extraction is available from any SAP BW Infocube:

    • User provides cube and package name.

    • Single button click to import details into FDMEE.

    • Auto-generates ODI details required for integration.

In this release, when you install and configure FDMEE, Oracle Data Integrator is automatically installed and configured for you. The database for Oracle Data Integrator is in the same database as FDMEE and the Oracle Data Integrator agent deployed to the FDMEE Managed Server.

Late-breaking information about the installation of EPM System products is provided in the Oracle Enterprise Performance Management System Installation and Configuration Readme. Review this information thoroughly before installing EPM System products.

Information about system requirements and supported platforms for EPM System products is available in spreadsheet format in the Oracle Enterprise Performance Management System Certification Matrix. This matrix is posted on the Oracle Fusion Middleware Supported System Configurations page on Oracle Technology Network (OTN):

Information about supported languages for EPM System products is available in spreadsheet format on the Translation Support tab in the Oracle Enterprise Performance Management System Certification Matrix. This matrix is posted on the Oracle Fusion Middleware Supported System Configurations page on OTN:

You can upgrade to EPM System Release 11.1.2.3 from the following releases:

Note: For upgrading instructions, see the Oracle Enterprise Performance Management System Installation and Configuration Guide, “Upgrading EPM System Products.

Table 1. Supported Paths to this Release

Upgrade Path From Release ..To Release 11.1.2.3
11.1.2.x

Apply the maintenance release to Release 11.1.2.3.

For Oracle Hyperion Financial Close Management, applying the maintenance release is supported only from Release 11.1.2.1 and 11.1.2.2.

11.1.1.4.x

Upgrade to Release 11.1.2.3.

Release 11.1.1.0.x to 11.1.1.3.x

Apply the maintenance release to Release 11.1.1.4 and then upgrade to Release 11.1.2.3.

An environment that includes multiple releases, which can include an environment with one instance of Shared Services or an environment with two instances of Oracle Hyperion Shared Services

See 'Upgrading from an Environment with Multiple Releases' in the 'Upgrading EPM System Products' chapter in the Oracle Enterprise Performance Management System Installation and Configuration Guide.

Note: If you are starting from an earlier release, Oracle recommends that you upgrade to the highest level release that directly supports upgrade from your starting release.

This section includes defects fixed in Release 11.1.2.3.000. To review the list of defects fixed between earlier releases, use the Defects Fixed Finder. This tool enables you to identify the products you own and your current implementation release. With a single click, the tool quickly produces a customized report of fixed-defect descriptions with their associated platforms and patch numbers. This tool is available here:

  • 14812909 -- Orphans are imported into EPMA when the ignore option is selected in metadata rules.

  • 14768204 -- Budgets can only be selected against the base language.

  • 14738283 -- When loading data, missing CCIDs occur between an E-Business Suite data source and ERPI.

  • 14695975 -- Unable to run data rule when using the SID (security identifier).

  • 14646037 -- Correlate initialization of source systems to the ODI scenario.

  • 14607083 -- Unable to validate source values in explicit mappings when concatenating two segments in the import format.

  • 14462917 -- System Settings page becomes blank when saving it with single quote (') in the Application Root directory/File Archive directory.

  • 14269722 -- When registering a target application, custom dimensions are set in the wrong order.

  • 14257269 -- The metadata rule for Financial Management fails when a prefix or suffix is not defined.

  • 14247266 -- Some multidimensional maps are not imported correctly.

  • 14247087 -- PROCESS_ID is not ordered in the RAC environment.

  • 14232523 -- Metadata attribute settings are not functioning correctly.

  • 14226555 -- Add “Delete All” button to the Data Load Rule screen to delete data loaded by the rule.

  • 14053934 -- The message: [DRILLDOWNAMIMPL] SCENARIO MISSING is shown on the SYSOUT log.

  • 13776769 -- Drill-down to PeopleSoft fails for an account with no activity in any period.

  • 13587906 -- The default language is always set to American English for the Account Reconciliation Manager.

  • 13438487 -- UNICODE VARCHAR is always used when loading tables in SQL server.

  • 13032082 -- Exporting member mappings fails when using a non-English language.

The following are the noteworthy known issues of this release:

  • 16602782 -- Imported multi-dimension data load mappings are not working in the SQL server environment.

    Workaround: Run the following SQL in the FDMEE database to fix the imported maps:

  • 16584509 -- In Lifecycle Management, a non-ASCII application name appears as garbled.

  • 16580178 -- An error occurs when running a budget check for an entity that is assigned to multiple budget revisions.

  • 16571720 -- Metadata load does not perform the auto cube refresh for Planning.

    Workaround: After loading data to Planning, run the “Refresh Database” feature from the Planning application.

  • 16561574 -- The Export feature fails in the Data Load Workbench when no files are specified in the data rule.

    Workaround: Include a valid file name in the data load rule.

  • 16543063 -- The Data Load Rule screen lists all Budget Revisions irrespective of the decision package.

    Workaround: none. Carefully select the required budget revision because they are not filtered by the selected decision package.

  • 16524431 -- Specific schema entry for SQL Server defaults to “DBO.

    Workaround: Log in to ODI Studio and connect to the FDMEE database. Navigate to the Account Reconciliation Manager server and FDMEE server topology under Microsoft SQL Server, and then change the schema from “dbo” to epm. Rerun the data load. No restart is needed.

  • 16506321 -- Data is exported to Financial Management files when the user adds lookup dimension for the Financial Management target application.

    Workaround: Remove any lookup dimensions from the import format.

  • 16457209 -- Unable to connect to the ODI Agent after running a compact deployment.

    Workaround: Add a localhost entry in the host file with the actual IP. For example in Windows, in the c:windowssystem32driversetchosts folder, add the 10.111.222.33 localhost.

  • 16456640 -- In Lifecycle Management, artifacts that contain delimited file import formats from Release 11.1.2.2 cannot be exported to FDMEE Release 11.1.2.3.000. This issue will be fixed in a future update.

    Workaround: Recreate the import format that specifies delimited file details manually in the target system.

  • 16448061 -- In Release 11.1.2.3.000, write-back load rules from Release 11.1.2.2.000 to Release 11.1.2.3.000 fail.

    Workaround: Delete the system generated maps, and redo them as needed. Then rerun the write-back rule.

  • 16447128 -- In Release 11.1.2.3.000, the Lifecycle Management import and export of security settings do not consider the Security by Location feature.

    Workaround: Recreate security by location details in the target system.

  • 16388740 -- Fusion source system initialization process fails when a duplicate tree code exists in the source system.

    Workaround: Rerun the initialization process a second time.

  • 16371283 -- The Entity dimension does not show on the Metadata screen for a mapping when the type is “Country.

    Workaround: Do not use the dimension class of “country” in Oracle Essbase.

  • 16371129 -- In Release 11.1.2.3.000, the Oracle Hyperion Enterprise Performance Management System Lifecycle Management Import feature fails for source period mappings.

    Workaround: Create period mappings in the target system manually.

  • 16324913 -- The Validation tab shows unclear error messages when a Lookup dimension exists.

  • 16267246 -- The Check report is blank when an account dimension is not specified.

    Workaround: Include the account dimension in the Check Report.

  • 16263348 -- In Release 11.1.2.3.000 FDMEE runs out of Weblogic data source connections.

    Workaround: Manually increase the connection pool size for the data source aif_datasource using the Web Logic Admin Console.

  • 16237177 -- In Release 11.1.2.3.000 parent and entity records are not returned in the Check Entity Group.

  • 16220846 -- Application folders are not created when write permission is not assigned to the “Everyone” user in the FDMEE Application Share folder.

    Workaround: Update permissions on the file server to allow creation of folders.

  • 16165610 -- Unmapped currency results in load failure, and no user message is shown.

    Workaround: When a data load failure occurs, confirm that the currency is mapped properly.

  • 16027311 -- Notification messages are gabled in the HTML report generated using the Log Analysis Utility.

    Workaround: Access messages in English.

  • 15954013 -- Metadata loads to Classic Hyperion Financial Management shut down the FDMEE service.

    Workaround: Use the ODI Standalone Agent instead of the J2EE Agent.

    To install the ODI Standalone Agent:

    1. Unzip the file MIDDLEWARE_HOME/odi/setup/manual/oracledi-agentoracledi-agent-standalone.zip to MIDDLEWARE_HOME/odi

    2. Rename the appropriate HFM Driver DLL under oracledi.sdklib.

      If you are on 64 bit, rename HFMDriver64_11.1.2.2.dll to HFMDriver.dll.

      If you are on 32 bit, rename HFMDriver32_11.1.2.2.dll to HFMDriver.dll.

    3. Add oracledi.sdklib to the path in the Windows system.

    4. Define a new agent in the ODI Master Repository.

    5. Edit MIDDLEWARE_HOME/odi/oracledi/agent/bin/odiparams.bat and update the following master repository connection information: SUPERVISOR password information and ODI_JAVA_HOME.

    6. Start the standalone agent.

    7. Update the ODI URL in the FDMEE System Settings page.

  • 15844671 -- FDMEE fails to load data to Essbase when duplicate members exist across dimensions.

    Workaround: Remove duplicate dimension member names. This issue results when the same dimension member name exists in more than one dimension.

  • 15833920 -- Reports are opened in the same pane from which they are run and do not provide a way to return to the previous screen.

    Workaround: Select an output type other than HTML.

  • 14342028 -- The Query Data tab is not available.

    Workaround: Use reports to query data.

  • 13831793 -- Number format should be locale sensitive for the amount.

  • 13775349 -- Essbase applications should be fully functional after upgrade.

    Workaround: Refresh metadata for each Essbase application after the upgrade.

  • 13743427 -- The target account is not displayed for data load mappings in Edit mode.

    Workaround: You can change the target member by clicking Edit next to the source, and then updating the target on the Multi-Dimension screen.

  • 13623601/16232449 -- When you run a data rule after upgrading from release 11.1.1.4 to 11.1.2.2.00, an additional drill-down link is created.

    Workaround: Manually delete the duplicate drill region directly in the Essbase Administration Services console (EAS). This should only be done when duplicate drill regions are shown for a cell in a Planning application. The obsolete drill region that needs to be removed is in the form of:

    'Year' : 'Scenario' : 'Version'

    For example, you might remove: 'FY10' : 'Current' : 'BU Version_1'

    The drill region that remains should be in the form: 'Year' : 'Scenario'

    For example, the following drill region would be kept: 'FY10' : 'Current'

  • 13558551 -- Unable to select an accounting entity when FDMEE is deployed on the WebSphere Application Server.

    Workaround: Create an accounting entity group for the source system. After creating the accounting entity group, select the accounting entity in the Entity tab.

    Interactive features include: playback, tempo control, transposition, melody instrument selection, adjustable note size, and full-screen viewing. This edition: Interactive Download. Published by Hal Leonard - Digital Sheet Music (HX.37070).Item Number: HX.37070About Interactive DownloadsInteractive Downloads are dynamic sheet music files that can be viewed and altered directly in My Digital Library from any device. Once you download your personalized sheet music, you can view and print it at home, school, or anywhere you want to make music, and you don’t have to be connected to the internet. Hans zimmer piano manual download.

  • 13104202 -- Write-back fails for an EPMA deployed ASO Essbase application.

    Workaround: Write-back for an EPMA deployed ASO is not supported. Use the classic Oracle Essbase ASO.

FDMEE Manual Configuration Steps for Upgrade Customers

Financial Accounting Manual Pdf

Upgrade customers must perform the following FDMEE configuration steps manually:

  • Set up the Data Server is required for customers upgrading from all versions.

    See Setting up the Data Server Based on the ERP Source System.

  • Regenerate the ODI Scenarios is required for customers upgrading from 11.1.2.1.50X or 11.1.2.2.

    See Regenerating the ODI Scenario in the Import Format.

  • Create period mapping applicable for customers upgrading from 11.1.1.4.

    See Creating Period Mappings.

Setting up the Data Server Based on the ERP Source System

You need to set up the appropriate data servers based on the ERP source system used to source metadata and/or data.

  • When importing from ERP sources (EBS/PeopleSoft/Fusion/JD Edwards/SAP), set up the applicable data servers listed below:

    • EBS_DATA_SERVER—For Oracle E-Business Suite General Ledger

    • PSFT_FMS_DATA_SERVER—For PeopleSoft General Ledger and Commitment Control

    • PSFT_HCM_DATA_SERVER—For PeopleSoft Human Capital Management (HCM)

    • FUSION_DATA_SERVER—For Fusion General Ledger

    • JDE_DATA_SERVER—JD Edwards Enterprise (JDE) General Ledger

    • SAP_SERVER—SAP FICO

  • When loading metadata to EPM system setup the following data servers:

    • HFM_DATA_SERVER—For loading metadata to Oracle Hyperion Financial Management

    • HPL_DATA_SERVER—For loading metadata to Oracle Hyperion Planning

To update server connections information:

  1. Access the Oracle Data Integrator Console.

  2. Select the Browse tab.

  3. Expand Topology.

    Panasonic rx-4940 user manual download. Supplied accessories Table of contentsPlease check and identify the supplied accessories. Followthe safety instructions on the unit.

  4. Select the operating data server to update, and click Edit.

    For example, select EBS_DATA_SERVER or PSFT_FMS_DATA_SERVER.

  5. In Edit Data Servers, and then under JDBC Details, in JDBC Driver, enter the JDBC driver.

    For example, enter oracle.jdbc.OracleDriver

  6. In JDBC URL, enter the JDBC URL address.

    For example, enter jdbc:oracle:thin:@<host>:<port>:<sid>

  7. In User, enter the user name.

  8. In JDBC Password, enter the password.

  9. Click Save.

Regenerating the ODI Scenario in the Import Format

When you use an Open Interface adapter, JD Edwards adapter, or SAP adapter, regenerate the ODI Scenario in the import format. Normally regenerating the ODI scenario is executed after loading the source data.

To regenerate the ODI scenario in the import format:

  1. On the Import Format screen, define a new import format.

    1. Select the source system and the adapter.

    2. Map the source columns to the appropriate target dimensions.

  2. When the import format mappings are complete, select Regenerate ODI Scenario.

    This step generates the ODI Scenario based on the import format mappings.

When you have target applications with a data load method not based on FDMEE, create period mappings before running any data loads. Due to a difference in structure of period mappings, they are not upgraded from Release 11.1.1.4 to Release 11.1.2.3.

To update period mappings:

  1. From the Setup tab, select Integration Setup, and then select Period Mappings.

  2. Define the Global Period mapping, and if required, add the Application Period mapping.

To refresh metadata:

  1. From the Setup tab, select Register, and then select Target Application.

  2. Select the application, and then click Refresh Metadata.

When you install and configure FDMEE, Oracle Data Integrator is automatically installed and configured for you. The database for Oracle Data Integrator is in the same database as FDMEE and the Oracle Data Integrator agent deployed to the FDMEE Managed Server. Optionally, you can install ODI Studio using the ODI_Studio_11123.zip.

To install ODI Studio from a zip file:

  1. Unzip ODI_Studio_11123.zip.

  2. Change the directory to: <Zip Extract Location>Disk1install<Platform>

    For example, if you unzipped to: C:Tempodi and the platform is Windows 64 bit, then go to: C:TempodiDisk1install

  3. Run the setup.exe.

  4. When prompted for JAVA_HOME, enter the location where JDK is installed.

  5. Provide the necessary information and run.

    If you get a warning message, for example, “File Not Found C:/Temp/odi/.../DataFiles/filegroup.jar,” press “Continue” to complete the install.

    Note:

    The ODI Master Repository is installed in the FDMEE schema/database. When you are prompted for the ODI Master Repository name, provide the Oracle Hyperion Financial Data Quality Management Enterprise Edition connection information. The name of the work repository is “FDMEE.

If you plan to use the SAP ERP Financials or SAP BW integration, you must download the ERPI-SAP Adapter from the Oracle partner Bristlecone’s website. Please register at the website http://www.bristleconelabs.com/edel/edel_login.asp to obtain login information. In addition, refer to the documentation provided by Bristlecone for details regarding the SAP Adapter configuration.

The most recent version of each EPM System product guide is available for downloading or viewing from the EPM System Documentation area of the OTN website (http://www.oracle.com/technology/documentation/epm.html). You can also use the EPM System Documentation Portal (http://www.oracle.com/us/solutions/ent-performance-bi/technical-information-147174.html), which also links to EPM Supported Platform Matrices, My Oracle Support, and other information resources.

Deployment-related documentation is also available from the Oracle Software Delivery Cloud website (http://edelivery.oracle.com/EPD/WelcomePage/get_form).

Individual product guides are available for download on the Oracle Technology Network website only.

When you cut and paste code snippets from a PDF file, some characters can be lost during the paste operation, making the code snippet invalid. Workaround: Cut and paste from the HTML version of the document.

In Release 11.1.2.3, the name of the Oracle Hyperion Financial Data Quality Management ERP Integration Adapter for Oracle Applications Administrator's Guide has been changed to Oracle Hyperion Financial Data Quality Management Enterprise Edition Administrator's Guide. The name was changed to reflect the new Oracle Hyperion Financial Data Quality Management Enterprise Edition product name.

Send feedback on product documentation to the following email address:

EPMdoc_ww@oracle.com

Follow EPM Information Development on these social media sites:

  • YouTube - http://www.youtube.com/user/OracleEPMWebcasts

  • Google+ - https://plus.google.com/106915048672979407731

  • Twitter - https://twitter.com/HyperionEPMInfo

  • Facebook - https://www.facebook.com/pages/Hyperion-EPM-Info/102682103112642

  • Linked In - http://www.linkedin.com/groups?home=&gid=3127051&trk=anet_ug_hm

Our goal is to make Oracle products, services, and supporting documentation accessible to the disabled community. EPM System products support accessibility features, which are described in the product's Accessibility Guide. Find the most up-to-date version of this guide in the Oracle Enterprise Performance Management System Documentation Library on the Oracle Technology Network (http://www.oracle.com/technology/documentation/epm.html).

In addition, this Readme file is accessible in HTML format.