Go to main content
1/599
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
Scripting on this page enhances content navigation, but does not change the content in any way.