Table of 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
- Drilling into Data
- FDMEE Architecture
- Configuring Oracle Data Integrator With FDMEE
- 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
- How Dimensions Are Processed
- How Languages Are Processed
- How Currencies Are Processed
- Defining Metadata Rules
- Loading Source System Hierarchies into EPM Dimensions
- Navigating FDMEE
-
Administration Tasks
- Predefining a List of Profiles
- Setting up Source Systems
-
Registering Target Applications
- Creating a Custom Target Application
- Adding Lookup Dimensions
- Defining Application Dimension Details
- Defining Application Options for Essbase and Planning
- Registering a Profitability and Cost Management Application
- Defining Application Options 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
-
2
Integrating Tasks
-
Working with Import Formats
- Defining the Import Format
- 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
-
Import Expression Types
- 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
- 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
- Defining Category Mappings
-
Working with Import Formats
-
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
- Using Special Characters in the Target Value Expression
- Format Mask Mapping for Target Values
- 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 SAP Adapters
- SAP Integration Process Background
- Defining Source Filter Options for the SAP_FDM_GLBALANCES_CLASSICS Adapter
- Defining Source Filter Options for the SAP_FDM_GLBALANCES_NEW Adapter
- Defining Source Filter Options for the SAP_FDM_COST_CENTER Adapter
- Defining Source Filter Options for the SAP_FDM_PROFIT_CENTER Adapter
- Defining Source Filter Options for the SAP_FDM_CUSTOMER_BALANCES Adapter
- Defining Source File Options for the SAP_FDM_VENDOR_BALANCES Adapter
- Defining Source Filter Options for JD Edwards GL Source Systems
- 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
-
Defining Data Load Rule Details
- Managing Data Load Rules
- Using Drilling Through
- Integrating with the EPM Cloud
- Using the Data Load Workbench
- Viewing Process Details
-
Integrating Oracle ERP Cloud Oracle General Ledger Applications
- 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 ERP Cloud
- Writing Back to the Oracle ERP Cloud
- Writing Back Budgets to the Oracle ERP Cloud
- Writing Back Actuals to the Oracle ERP Cloud - Oracle General Ledger
- Using Excel Trial Balance Files to Import Data
- Using Journal Templates to Import Data
-
Loading Data Using a Universal Data Adapter
- Defining a Universal Data Adapter in Oracle Database Integrator (ODI)
- Configuring SAP HANA
- Working with a Universal Data Adapter in FDMEE
- 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
- Financial Close Management Integration with FDMEE
-
Creating Member Mappings
-
Data Load, Synchronization and Write Back
- Overview
-
Synchronizing and Writing Back Data
- Data 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 Data
- 4 Logic Accounts
- 5 Check Rules
-
6
Batch Processing
- Working with Batch Definitions
- Adding a Batch Group
- Executing Batches
- Using Open Batches
- Scheduling Jobs
- Working with Batch Scripts
-
7
Creating and Using Scripts
- Overview
- Key Jython Concepts
- Using the Script Editor
- Using Import Scripts
- Using Mapping Scripts
- Using Event Scripts
- Using Custom Scripts
- Using the JAVA API
- Visual Basic
-
8
FDMEE Reports
- FDMEE Reports
- Working with Query Definitions
- Working with Report Definitions
- Running Reports
-
FDMEE Detail Reports
- Audit Reports
- Check Reports
-
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
- Location Analysis
- Process Monitor Reports
- Variance Reports
- A FDMEE REST APIs
- B Source System Tables Used by FDMEE
- C Creating an Alternate Schema in an Enterprise Resource Planning (ERP) Source System
- D Staging Tables
- E Archiving the TDATAMAPSEG Table
- F PeopleSoft Commitment Control
- G Report Query Table Reference
- H System Maintenance Tasks
- I Setting up Jython, Eclipse and Python