Table of Contents
- Title and Copyright Information
- 1 About This Content
-
2
Getting Started
- 2.1 Getting Started with Oracle Cloud
- 2.2 Funds Transfer Pricing Cloud Service
-
2.3
Admin Console
- 2.3.1 Introduction to Admin Console
- 2.3.2 System Configuration
- 2.3.3 Identity Management
-
3
Data Administration
- 3.1 Data Model Extension
- 3.2 Data File Specification
- 3.3 File Upload and Download Utility
-
3.4
Data Maintenance Interface
-
3.4.1
Data Maintenance Interface
- 3.4.1.1 Process of DMI Windows
- 3.4.1.2 User Role Mapping and Access Rights
- 3.4.1.3 Access the Data Maintenance Interface
- 3.4.1.4 Form Designer Summary Page
- 3.4.1.5 Accessing Information in Summary Page
-
3.4.1.6
Creating New Forms in Form Designer
- 3.4.1.6.1 Creating Forms Using Data Exporter
- 3.4.1.6.2 Creating Forms Using Excel Upload
- 3.4.1.6.3 Creating Forms Using View
- 3.4.1.6.4 Creating Forms Using Designer
- 3.4.1.6.5 Creating Data Filters for New Form Definitions
- 3.4.1.6.6 Enabling Data Security for New Form Definitions
- 3.4.1.6.7 Enabling User Security for New Form Definitions
- 3.4.1.7 Approving and Rejecting New Form Definitions
- 3.4.1.8 Managing Form Definitions
-
3.4.2
Data View
- 3.4.2.1 Viewing Data Entry
- 3.4.2.2 Data Entry – Forms Created Using Designer
- 3.4.2.3 Forms Created Using Excel Upload
- 3.4.2.4 Approving and Rejecting Records
- 3.4.2.5 Exporting Forms Creating Using Data Exporter - View Option
- 3.4.2.6 Exporting Forms Creating Using Data Exporter - Table Option
- 3.4.2.7 Audit Trail
-
3.4.1
Data Maintenance Interface
-
3.5
Data Quality Framework
- 3.5.1 Introduction to Data Quality Framework
- 3.5.2 Roles and Functions for Managing DQ Framework
- 3.5.3 Data Quality Rules
- 3.5.4 Data Quality Groups
- 3.5.5 Adding a DQ Check Task
- 3.5.6 Execution Summary
- 3.6 Data Verification
- 3.7 Cash Flow Edits
-
4
On-prem to SaaS Migration
- 4.1 Introduction
- 4.2 Metadata Migration
- 4.3 Data Migration
- 4.4 Pre-Mapped Dimensions for Migration
-
4.5
Deprecated Columns in Data Tables
- 4.5.1 FSI_D_ANNUITY_CONTRACTS
- 4.5.2 FSI_D_BORROWINGS
- 4.5.3 FSI_D_BREAK_FUNDING_CHARGES
- 4.5.4 FSI_D_CASA
- 4.5.5 FSI_D_CREDIT_CARDS
- 4.5.6 FSI_D_CREDIT_LINES
- 4.5.7 FSI_D_FUTURES
- 4.5.8 FSI_D_FX_CONTRACTS
- 4.5.9 FSI_D_GUARANTEES
- 4.5.10 FSI_D_INVESTMENTS
- 4.5.11 FSI_D_LEASES
- 4.5.12 FSI_D_LEDGER_STAT_INSTRUMENT
- 4.5.13 FSI_D_LOAN_COMMITMENTS
- 4.5.14 FSI_D_LOAN_CONTRACTS
- 4.5.15 FSI_D_MERCHANT_CARDS
- 4.5.16 FSI_D_MM_CONTRACTS
- 4.5.17 FSI_D_MORTGAGES
- 4.5.18 FSI_D_MUTUAL_FUNDS
- 4.5.19 FSI_D_OTHER_SERVICES
- 4.5.20 FSI_D_RETIREMENT_ACCOUNTS
- 4.5.21 FSI_D_SWAPS
- 4.5.22 FSI_D_TERM_DEPOSITS
- 4.5.23 FSI_D_TRUSTS
-
5
Business Rules Administration
-
5.1
Reference Data
- 5.1.1 Currencies Setup
- 5.1.2 Interest Rates
- 5.1.3 Economic Indicators
-
5.1.4
Dimension Management
- 5.1.4.1 Object Security
- 5.1.4.2 Components of Dimension Management
- 5.1.4.3 Members
- 5.1.4.4 Attributes
- 5.1.4.5 Hierarchy
- 5.1.4.6 Viewing Data in a Summary Page
- 5.1.5 Behavior Patterns
- 5.1.6 Payment Patterns
-
5.2
Common Rules
- 5.2.1 Preferences
- 5.2.2 Holiday Calendars
- 5.2.3 Management Ledger Configuration
- 5.2.4 Filters
-
5.3
Application Specific Rules
- 5.3.1 Propagation Patterns
- 5.3.2 Propagating Transfer Pricing Results
- 5.3.3 Replicating Portfolio
-
5.3.4
Transfer Pricing Rules
-
5.3.4.1
Overview of Transfer Pricing
Methodologies and Rules
- 5.3.4.1.1 Cash Flow: Average Life
- 5.3.4.1.2 Cash Flow: Duration
- 5.3.4.1.3 Cash Flow: Weighted Term
- 5.3.4.1.4 Cash Flow: Zero Discount Factors
- 5.3.4.1.5 Moving Averages
- 5.3.4.1.6 Straight Term
- 5.3.4.1.7 Spread from Interest Rate Code
- 5.3.4.1.8 Spread from Note Rate
- 5.3.4.1.9 Redemption Curve
- 5.3.4.1.10 Tractor Method
- 5.3.4.1.11 Caterpillar
- 5.3.4.1.12 Weighted Average Perpetual
- 5.3.4.1.13 Unpriced Account
- 5.3.4.1.14 Mid-Period Repricing Option
- 5.3.4.1.15 Defining Transfer Pricing Methodologies Using Node Level Assumptions
- 5.3.4.1.16 Defining Transfer Pricing Methodologies using Conditional Assumptions
- 5.3.4.2 Working with Transfer Pricing Rules
- 5.3.4.3 Creating Transfer Pricing Rules
- 5.3.4.4 Navigating in the Summary Screen
- 5.3.4.5 Defining Transfer Pricing Methodologies
- 5.3.4.6 Defining the Redemption Curve Methodology
- 5.3.4.7 Copying Assumptions across Currencies
-
5.3.4.1
Overview of Transfer Pricing
Methodologies and Rules
- 5.3.5 Add-on Rate Rules
- 5.3.6 Prepayment Rules
- 5.3.7 Prepayment Models
- 5.3.8 Alternate Rate Output Mapping Rules
-
5.3.9
Transfer Pricing Standard
Processes
- 5.3.9.1 Navigating in the Summary Screen
- 5.3.9.2 Create a Transfer Pricing Standard Process
- 5.3.9.3 Process Definition Screens
- 5.3.9.4 Standard Process with only Rate Propagation
- 5.3.9.5 Standard Process with only Transfer Rate Calculations
- 5.3.9.6 Standard Process with only Transfer Rate Calculations
- 5.3.9.7 Standard Process with Customized Calculations Selection
- 5.3.9.8 Execute a Transfer Pricing Process from Standard Process UI
- 5.3.9.9 Executing a Transfer Pricing Process from the Scheduler Service
- 5.3.10 Break Identification
- 5.3.11 Rate Lock Option Volatility Curve
- 5.3.12 Rate Cards
- 5.3.13 Account Audit
-
5.1
Reference Data
-
6
Operations
-
6.1
Scheduler Services
- 6.1.1 Accessing Scheduler Services
- 6.1.2 User Roles and Functions
- 6.1.3 Define Batch
- 6.1.4 Define Tasks
-
6.1.5
Schedule Batch
- 6.1.5.1 Task Definitions of a Batch
- 6.1.5.2 Execute a Batch and Batch Group
- 6.1.5.3 Schedule Once
- 6.1.5.4 Daily Batch Scheduling
- 6.1.5.5 Weekly Batch Scheduling
- 6.1.5.6 Monthly Batch Scheduling
- 6.1.5.7 Schedule Cron Expression
- 6.1.5.8 Re-start a Batch
- 6.1.5.9 Re-run a Batch
- 6.1.5.10 Edit Dynamic Parameters
- 6.1.6 Monitor Batch
- 6.1.7 Scheduler Service Dashboard
- 6.1.8 External Scheduler Interface
- 6.2 Object Migration
-
6.1
Scheduler Services
-
7
Reports & Analytics
-
7.1
Funds Transfer Pricing Cloud Service Reports
& Analytics
- 7.1.1 Access Business Intelligence (BI) Reports
- 7.1.2 Preparing Data using SQL Query Browser
-
7.1.3
Raw Data Analysis
- 7.1.3.1 Staging Instrument Data
- 7.1.3.2 Staging Instrument Supplementary Data
- 7.1.3.3 Staging Ledger Data
- 7.1.3.4 Staging Transaction Summary Data
- 7.1.3.5 Processing Instrument Data
- 7.1.3.6 Processing Instrument Supplementary Data
- 7.1.3.7 Processing Ledger Data
- 7.1.3.8 Processing Transaction Summary Data
- 7.1.4 Operational Analysis
- 7.1.5 Data Insights
-
7.1.6
Processed Data Insights
-
7.1.6.1
Process Results Data
Analysis
- 7.1.6.1.1 Common Filters
- 7.1.6.1.2 Report Hierarchies
- 7.1.6.1.3 Report Data Action
- 7.1.6.1.4 Transfer Rate Outliers
- 7.1.6.1.5 Rate & Charge Credit
- 7.1.6.1.6 Rate Bands
- 7.1.6.1.7 FTP Margin
- 7.1.6.1.8 Regional FTP Margin Rate
- 7.1.6.1.9 Regional FTP Margin Amount
- 7.1.6.1.10 Detailed Acct Level Info
- 7.1.6.1.11 STD Deviation
-
7.1.6.1
Process Results Data
Analysis
- 7.2 Balance Reconciliation
- 7.3 Account Audit Report
-
7.1
Funds Transfer Pricing Cloud Service Reports
& Analytics
- 8 Technical Documents