Contents

Title and Copyright Information

Documentation Accessibility

Documentation Feedback

1 Using FDMEE

• Supported Source Systems
• File-Based Data Loads
• Supported EPM System Target Applications
• Key FDMEE Benefits
  • FDMEE Application Folder Architecture
• FDMEE Architecture
• Drilling Through
  • Drilling Through to the FDMEE Landing Page
• Configuring Oracle Data Integrator With FDMEE
  • Set up the Data Server Based on the Enterprise Resource Planning (ERP) Source System
  • Setting up Physical Schemas
  • Setting up the ODI Context Code
  • Setting up ODI to Integrate with JD Edwards
• Security
• Integration Process Overview
  • Extracting General Ledger Data
  • Writing Back Data from EPM Applications
  • Integrating Metadata
    • Understanding General Ledger Integration
    • Requirements
    • Required Dimensions
    • Member Properties Sourced from the Enterprise Resource Planning (ERP) System
      • Account
      • Entity and Intercompany
      • Scenario
      • Version
      • View
      • Year and Period
      • Alias
      • Custom
    • How Dimensions Are Processed
    • How Languages Are Processed
    • How Currencies Are Processed
    • Defining Metadata Rules
      • Defining the Metadata Rule Details
      • Defining Dimension Attributes
      • Managing Metadata Rules
    • Loading Source System Hierarchies into EPM Dimensions
  • Extracting Human Resource Data
• Navigating FDMEE
  • Toolbars
  • Help Menu
  • Task Pane Options
    • Workflow Tasks
    • Setup Tasks
  • Working with Data in Grids
  • FDMEE User Interface Elements
  • Advanced Search Options
  • Using the POV Bar
    • Selecting the Location POV
    • Setting the Period POV
    • Setting the Category POV
    • Locking and Unlocking a POV
• Administration Tasks
  • Predefining a List of Profiles
    • Setting System-Level Profiles
    • Setting Application-Level Profiles
      • Locking and Unlocking All (POV) Locations
    • Setting User Level Profiles
    • Setting Security Options
      • Role Level Security
      • Defining User Interface Security
      • Defining Report Security
      • Defining Batch Security
      • Defining Custom Script Security
      • Defining Location Security
  • Setting up Source Systems
    • Registering Enterprise Resource Planning (ERP) Source Systems
    • Registering File-Based Source Systems
    • Deleting Registered Source Systems
    • Editing Registered Source System Details
    • Adding File-Based Data Load Definitions
  • Working with Source Adapters
    • Using a Prepackaged Integration for SAP
    • Adding Source Adapter Definitions
    • Defining Source Adapter General Information
      • Adding a Source Adapter
      • Deleting a Source Adapter
      • Exporting a Source Adapter
      • Importing a Source Adapter
      • Copying a Source Adapter Key
      • Using the SAP BW Source Adapter
    • Defining Source Adapter Detail
      • Selecting Source Columns
      • Defining Parameters
      • Defining URLs for Drill Through
  • Registering Target Applications
    • Creating a Custom Target Application
    • Adding Lookup Dimensions
    • Defining Application Dimension Details
    • Defining Application Options for Essbase and Planning
      • Working with Duplicate Members in Essbase
      • Using Calculation Scripts
    • Defining Application Options for Profitability and Cost Management (HPCM)
    • Defining Application Options for Public Sector Planning and Budgeting
    • Defining Application Options for Financial Management
      • Enabling Intercompany Partner Dimensions for Financial Management
    • Deleting Registered Target Applications
    • Reusing Target Application Names Multiple Times
  • Selecting Source Accounting Entities
  • Assigning General Ledger Responsibility
  • Working with Source Accounting Entity Groups
  • Loading Excel Data
    • Downloading to Excel
    • Uploading from Excel

2 Integrating Tasks

• Working with Import Formats
  • Defining the Import Format
    • Viewing Import Format Information
    • Adding Import Formats
      • Import Formats and Data Load Rules
    • Deleting an Import Format
    • Querying by Example
  • Defining Import Format Mappings
  • Defining the Import Format Mappings
  • Concatenating Source Dimensions for Enterprise Resource Planning (ERP) Segments
  • Adding Import Expressions
    • Import Expression Types
      • Nonstandard Numeric Sign Conventions
      • Displaying Debit and Credit Columns
      • Converting from European to U.S. Notation
      • Padding Fields with Leading Fills
      • Padding Fields with Trailing Fills
      • Multiplying by Whole-Number and Decimal Factors
      • Disabling Zero Suppression
      • Stacking Import Expressions
      • Defining a Multiple Period Data Load in Import Formats
    • Processing Order
  • Defining Import Formats for File-Based Mappings
  • Concatenating Source Dimensions for a File-Based Source
  • Using the Import Format Builder
  • All Data Types Data Loads
    • All Data Types Data Load Process Description
    • Setting the All Data Types Load Method
    • Setting the All Data Types Load Method
    • Setting the Import Format Data Types
    • Setting the Import Format for Multi-Column Data Types
      • Adding an Import Expression for a Data Driver
      • Assigning Driver Dimension Members
    • Loading Incremental Data using the LINEITEM Flag to an EPM Application
    • Loading Multi-Column Numeric Data
    • Loading Periods as a Column from the Data File
  • Write-Back Mappings
  • Defining Import Formats for Data Synchronization Between EPM Applications
  • Defining Import Formats for Data Synchronization Between Enterprise Resource Planning (ERP) and EPM Applications
  • Defining the Write-Back Mappings (E-Business Suite and PeopleSoft only)
• Defining Locations
• Defining Period Mappings
  • Global Mappings
  • Application Mappings
  • Source Mappings
• Defining Category Mappings
  • Global Mappings
  • Application Mappings

3 Integrating Data

• Loading Data
  • Creating Member Mappings
    • Creating Mappings Using the Explicit Method
    • Creating Mappings Using the Between Method
    • Creating Mappings Using the In Method
    • Creating Mappings Using the Multi-Dimension Method
    • Using Special Characters in Multi-Dimensional Mapping
    • Creating Mappings Using the Like Method
    • Using Special Characters in the Source Value Expression for Like Mappings
    • Automap Wildcarding
      • Example Automap
      • Example General Ledger Trial Balance Records
      • Resulting Record Conversion
      • Explanation of the Conversion Process
      • Conditional Mapping using a Mapping Script
    • Using Special Characters in the Target Value Expression
    • Format Mask Mapping for Target Values
      • #FORMAT Mapping Type Components
      • Replacing Segments
      • Replacing Segments with String Operations
      • Replace Segments with String Operations and Using an Prefix or Suffix
      • Using the #FORMAT Mapping Type
    • Ignoring Member Mappings
    • Importing Member Mappings
    • Downloading an Excel Template (Mapping Template)
    • Importing Excel Mappings
    • Exporting Member Mappings
    • Deleting Member Mappings
    • Restoring Member Mappings
  • Defining Data Load Rules to Extract Data
    • Defining Data Load Rule Details
      • Defining Source Filter Options for E-Business Suite Source Systems
      • Defining Source Filter Options for PeopleSoft Enterprise Financial Management Source Systems
      • Defining Source Filter Options for JD Edwards GL Source Systems
      • Defining Source Filter Options for SAP Adapters
      • Defining Source Filter Options for the Open Interface Adapter
      • Defining Source Filter Options for Financial Management
    • Defining Data Load Rule Details for a File-Based Source System
    • Defining Source Parameters for Planning and Essbase
    • Defining Source Parameters for Financial Management
  • Managing Data Load Rules
    • Editing Data Load Rules
    • Running Data Load Rules
    • Scheduling Data Load Rules
    • Checking the Data Load Rule Status
    • Deleting Data Load Rules
    • Working with Target Options
    • Creating Custom Options
    • Loading Exchange Rates to Financial Management
  • Using Drilling Through
    • Creating the Drill Region
    • Drill Through Components
    • Adding the Server Component for the Drill Through URL
    • Adding the Detail Component for the Drill Through URL
    • Viewing the Drill Through Results
  • Integrating with the EPM Cloud
    • Configuring the Secure Sockets Layer (SSL) Certificate
    • Pre-requisites
    • Setting up the EPM Cloud Deployment
    • Loading Data to the EPM Cloud or On-Premise Application
    • Exporting the EPM Cloud Application
  • Using the Data Load Workbench
    • Workflow Grid
    • Processing Data
      • Step 1: Importing Source Data
      • Step 2: Validating Source Data
      • Step 3: Exporting Data to Target Applications
      • Step 4: Checking the Data
    • Using the Workbench Data Grid
      • Viewing Data
      • Formatting Data
      • Showing Data
      • Drilling Through to Source Data and Viewing Mappings
      • Opening Loaded Data in Microsoft Excel
      • Querying by Example
      • Freezing Data
      • Detaching Data
      • Wrapping Text
      • Attaching Cell Text and Documents to a Data Cell
      • Intersection Check Report Errors
  • Viewing Process Details
  • Integrating with the Oracle Financials Cloud
    • Integration Process Description
    • Configuring a Source Connection
    • Working with Import Formats
    • Defining Locations
    • Defining Category Mappings
    • Data Load Mapping
    • Adding Data Load Rules
    • Processing Oracle General Ledger Adjustment Periods
    • Adding Filters for Data Load Rules
    • Drilling Through to the Oracle Financials Cloud
    • Writing Back to the Oracle Financials Cloud
  • Using Excel Trial Balance Files to Import Data
    • Text Trial Balance Files Versus Excel Trial Balance Files
    • Downloading an Excel Trial Balance Template
    • Defining Excel Trial Balance Templates
    • Adding a Multiple Period Data Load Using Excel
    • Importing Excel Mapping
  • Using Journal Templates to Import Data
    • Additional Considerations for Loading Journal Templates
    • Integrating Financial Management Journals
      • Financial Management Application Options
      • Data Values
    • Downloading a Journal Template
    • Defining Journal Templates
      • Metadata Structure
      • Creating Range Names Within Journal Templates
    • Processing Journals
      • Loading Journals
  • Loading Data Using a Universal Data Adapter
    • Defining a Universal Data Adapter in Oracle Database Integrator (ODI)
      • Create a Data Server and Physical Schema for the Universal Data Adapter Source
    • Configuring SAP HANA
    • Working with a Universal Data Adapter in FDMEE
      • Working with Universal Data Adapter Source Systems
      • Working with Universal Data Adapter Source Systems and Target Applications
      • Creating the Source Adapter
      • Adding Source Columns
      • Defining Parameters
      • Defining URLs for Drill Through
    • Universal Data Adapter Source Systems and Import Formats
    • Universal Data Adapter Source Systems and Locations
    • Data Load Mapping for Universal Data Adapter Related Sources
    • Data Load Rules for Universal Data Adapter Related Source
  • Integrating Data Relationship Management with FDMEE
    • Setting up the Integration
    • Data Relationship Management and FDMEE Locations
    • Data Relationship Management and FDMEE Metadata Rules
    • Importing Data Load Mappings from Data Relationship Management
  • Financial Close Management Integration with FDMEE
• Data Load, Synchronization and Write Back
  • Overview
  • Synchronizing and Writing Back Data
    • Data Synchronization
      • Using Data Load Rules for Synchronization
    • Write-Back
      • Data Load Rules for Write-Back
      • Available Source to Target Write-Backs
      • Write-Back Security Access
      • Creating Write-Back Mappings
      • Defining Data Load Rules for Write-Back Scenarios (Data from EPM Cloud / Essbase Applications to Oracle Enterprise Resource Planning (ERP) Sources)
      • Defining the Source Filter Option
      • Defining Target Options (for Data Load Rules to Write back)
      • Defining Financial Management to E-Business Suite Data Load Rules to Write-Back
      • Defining PeopleSoft Commitment Control Data Load Rules to Write-Back
      • Running Data Load Rules to Write Back
      • Exporting to Target
      • Loading Data into Supported Source Systems
• Loading Human Resources Data
  • Understanding Human Resource Data Integration
  • Requirements
    • Running Processes in PeopleSoft Human Capital Management
    • Defining the Data Load Settings in Planning
  • Public Sector Planning and Budgeting Dimensions
  • Smart Lists
  • Using Loaded Data in Public Sector Planning and Budgeting
  • Defining Human Resource Data Load Rules
    • Defining the Rule Details
    • Creating Rule Line Definitions by Copying
    • Creating Rule Line Definitions by Using a Template Mapping
    • Creating Rule Line Definitions
    • Creating Mapping Definitions
  • Managing Human Resource Data Load Rules
    • Editing Human Resource Data Load Rules
    • Running Human Resource Data Load Rules
    • Deleting Human Resource Data Load Rules
    • Checking the Human Resource Data Load Rule Status

4 Logic Accounts

• Overview of Logic Accounts
• Creating a Logic Group
• Creating Accounts in a Simple Logic Group
  • Logic Group Fields
    • Operator and Value/Expression
    • Expressions and Functions
    • Value/Expression
    • Seq
    • Export
    • Creating Summarized Logic Accounts
• Creating Complex Logic Accounts
  • Complex Logic Example 1: CashTx
    • Sample Imported Values
    • Sample Imported Account Names
    • Final Result
  • Complex Logic Example 2: CashTx
    • Sample Imported Values
    • Logic Members
    • Final Result

5 Check Rules

• Overview of Check Rules
• Creating Check Rule Groups
• Creating Check Rules
  • Rule Logic
  • Using the Rule Logic Editor to Create Check Rules
    • Adding Rule Logic
      • Rule Logic Intersection
      • Multidimensional Lookup
      • Math Operators
      • If/Then/Else
    • Adding a Rule Logic Statement as Free Form Text
    • Testing Check Rule Expressions
    • Running Check Reports for Profitability and Cost Management BSO Essbase Cube
• Creating Check Entity Groups

6 Batch Processing

• Working with Batch Definitions
• Adding a Batch Group
• Executing Batches
• Using Open Batches
  • Name Format for Open Batch Files
  • Naming Conventions
  • Open Batch Import and Export Load Methods
  • Creating Open Batches
    • Creating an Open Batch to Run an Integration with E-Business Suite
  • Creating Open Batches for Multiple Periods
• Scheduling Jobs
  • Canceling a Scheduled Job
• Working with Batch Scripts
  • Using Password Encryption
  • Executing the Batch Script for Data Load Rules
    • Setting the Parameters for Data Load Rules
  • Executing the Batch Script for Metadata Rules
    • Setting the Parameters for Metadata Rules
  • Executing the Batch Script for HR Data Rules
    • Setting the Parameters for HR Data Rules
  • Executing the Batch Script to Import Mapping Rules
    • Setting the Parameters to Import Mappings Rules
  • Executing the Batch Script for Data Load Rules to Write Back
  • Running a Batch
    • Setting the Parameters for Running the Batch

7 Creating and Using Scripts

• Overview
• Key Jython Concepts
• Using the Script Editor
  • Overview
  • Launching the Script Editor
  • Script Editor Layout
• Using Import Scripts
  • Overview
  • Creating Import Scripts
  • Import Script Parameters
  • Assigning Import Scripts to Import Formats
  • Using Import Script Functions
    • Extracting Beginning Characters
    • Extracting Middle Characters
    • Extracting End of String
    • Using Split Functions
    • Using the Skip Function (Conditional Skip)
  • Storing and Retrieving Temporary Variables
    • Storing Temporary Variables
    • Retrieving Temporary Variables
  • Import Script Sample
• Using Mapping Scripts
  • Overview
  • Creating Mapping Scripts
  • Using Jython Objects with Mapping Scripts
  • Mapping Script Samples
• Using Event Scripts
  • Overview
  • FDMEE Supported Event Scripts
  • Creating Event Scripts
    • Stopping the Execution of FDMEE from within a Script
  • Dynamically Changing Import Formats
  • Using the File System Object in Event Scripts
  • Events Script Sample
• Using Custom Scripts
  • Overview
  • Creating a Custom Script
  • Working with Custom Scripts
    • Adding a Custom Script Group
  • Registering Scripts
  • Executing a Custom Script
  • Executing a Custom Script from a Command Line
  • Custom Script Sample using Jython
    • Submitting a Data Load Rule
    • Submitting a Report
• Using the JAVA API
  • Overview
  • JAVA API List
  • Working with UNICODE Characters in Jython Scripts
  • Using JAVA IDE to Develop Scripts
• Using Visual Basic API and Samples
  • Overview
  • Registering the Visual Basic API DLL Manually
  • Visual Basic API List
    • API Class (clsAppServerDM)
    • Application Class (clsApp)
    • Connection Class (clsConnection)
    • DataManipulation Class
    • Utilities Class (clsUtilities.cls)
    • Data Access Class (clsDataAccess)
    • SQL Manager Class (clsSQLMgr)
    • SQL Class (clsSQL)
    • DB Tools Class (clsDBTools)
    • Maintenance Manager Class (clsMaintenanceMgr)
    • POV Manager Class (clsPOVMgr)
    • State Class (clsState)
  • Visual Basic Sample Scripts
    • Visual Basic Script to Send Email
    • Visual Basic Script to Copy a File to the Inbox
    • Visual Basic Script to Execute SQL
    • Visual Basic Script to Access Various Properties

8 FDMEE Reports

• FDMEE Reports
• Working with Query Definitions
• Working with Report Definitions
  • Adding Report Groups
  • Working with Report Definitions
  • Creating a Report Template
  • Creating a XLIFF File for Translated Report Templates
• Running Reports
• FDMEE Detail Reports
  • Audit Reports
    • Account Chase Wildcard (TargAcct, Per, Cat)
    • Account Chase - Freeform (TargAcct, Per, Cat)
    • Map Monitor for Location
    • Map Monitor for User
      • Intersection Drill Down (Per, Cat)
  • Check Reports
    • Check Report
    • Check Report Period Range (Cat, Start Per, End Per)
    • Check Report With Warnings
    • Check Report By Validation Entity Seq.
  • Base Trial Balance Reports
    • TB Current Location, with Targets (Cat, Per)
    • TB Current Location with Rules (Cat, Per)
    • TB Current Locations, All Dimensions-Targets, by Target Entity-Account (Cat, Per)
    • TB Current Locations, All Dimensions-Targets (Cat, Per)
    • TB Current Location, by Target Acct (Cat, Per)
    • TB Current Location, By Target Entity Account (Cat, Per)
    • TB Converted Current Location by Target Entity/Account
  • Listing Reports
    • Import Formats by Location
    • Location Listing
  • Location Analysis
    • Dimension Map (Dimension)
    • Dimension Map For POV (Dimension, Cat, Per)
  • Process Monitor Reports
    • Process Monitor (Cat, Per)
    • Process Status Period Range (Cat, Start Per, End Per)
      • Template
    • Process Monitor All Categories (Cat, Per)
  • Variance Reports
    • Account Chase Variance
    • Trial Balance Variance

A FDMEE Web Service

• executeDataRule
• executeMetaDataRule
• getDataRuleNames
• getLocationNames
• getPeriodNames
• lockPOV
• unlockPOV

B FDMEE REST APIs

• URL Structure for FDMEE
• Running Data Rules
• Running Batch Rules
• Import Data Mapping
• Export Data Mapping
• Execute Reports

C Source System Tables Used by FDMEE

• Fusion and E-Business Suite Source System Tables
• PeopleSoft Enterprise Financial Management Source System Tables
• PeopleSoft Human Capital Management Source System Tables
• PeopleSoft Commitment Control Source System Tables
• Creating Synonyms for E-Business Suite Tables

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

E Staging Tables

• FDMEE Staging Tables
  • Staging Table Used for Import from Source
  • Data Tables Used for Drill Through
  • Views Used for Export to Target
• PeopleSoft Human Capital Management Staging Tables
  • PS90HCM
  • CHARTFIELD

F Archiving the TDATAMAPSEG Table

G Working with Open Interface Adapters

• Setting up the Open Interface Adapter
  • Using the Open Interface Table
  • Loading Source Data using Custom Loaders
  • Customizing ODI to Load Data from a Custom Source
    • Migrating the Customization

H PeopleSoft Commitment Control

I Report Query Table Reference

• TDATASEG Table Reference
• TLOGPROCESS Table Reference

J System Maintenance Tasks

• Maintain Application Folder
• Maintain Process Tables
• Maintain EBS GL Balances Table
• Maintain PeopleSoft Ledger Table
• Maintain Data Table by Application
• Executing Purge Scripts

K Setting up Jython, Eclipse and Python