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 Introduction to Admin Console
- 2.4 System Configuration
- 2.5 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
Creating New Forms in Form Designer
- 3.4.1.5.1 Creating Forms Using Excel Upload
- 3.4.1.5.2 Creating Forms Using Data Entry Option
- 3.4.1.5.3 Creating Forms Using Data Exporter
- 3.4.1.5.4 Creating Data Filters for New Form Definitions
- 3.4.1.5.5 Enabling Data Security for New Form Definitions
- 3.4.1.5.6 Enabling User Security for New Form Definitions
- 3.4.1.6 Approving and Rejecting New Form Definitions
- 3.4.1.7 Managing Form Definitions
- 3.4.1.8 Viewing Form Definitions
- 3.4.1.9 Editing/Amending Form Definitions
- 3.4.1.10 Copying Form Definitions
- 3.4.1.11 Re-Uploading Form Definitions
- 3.4.1.12 Deleting Form Definitions
- 3.4.2 Data View
- 3.4.3 Adding DMI Tasks in Scheduler Service
-
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 Data Housekeeping
- 3.8 PBSM Balance Reconciliation
- 3.9 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 Reference Period Compound Rate
- 5.3.4.1.15 Mid-Period Repricing Option
- 5.3.4.1.16 Defining Transfer Pricing Methodologies Using Node Level Assumptions
- 5.3.4.1.17 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.3.1 Process Details
- 5.3.9.3.2 Calculation Selection
- 5.3.9.3.3 Product Selection
- 5.3.9.3.4 Transfer Pricing Rule Selection
- 5.3.9.3.5 Ledger Migration Process
- 5.3.9.3.6 Direct Transfer Pricing of Ledger Balances
- 5.3.9.3.7 Add-On Rate Rule Selection
- 5.3.9.3.8 Alternate Rate Output Mapping
- 5.3.9.3.9 Migration
- 5.3.9.3.10 Audit Option
- 5.3.9.3.11 Finalize Process
- 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 Process Errors
- 5.3.11 Break Identification
- 5.3.12 Rate Lock Option Volatility Curve
- 5.3.13 Rate Cards
- 5.3.14 Account Audit
-
5.1
Reference Data
-
6
Operations
- 6.1 Scheduler Services
- 6.2 Object Migration
- 6.3 Changing Object Ownership
-
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 Creating Adhoc Reports and Analysis
-
7.1.4
Raw Data Analysis
- 7.1.4.1 Staging Instrument Data
- 7.1.4.2 Staging Instrument Supplementary Data
- 7.1.4.3 Staging Ledger Data
- 7.1.4.4 Staging Transaction Summary Data
- 7.1.4.5 Processing Instrument Data
- 7.1.4.6 Processing Instrument Supplementary Data
- 7.1.4.7 Processing Ledger Data
- 7.1.4.8 Processing Transaction Summary Data
- 7.1.5 Operational Analysis
- 7.1.6 Data Insights
-
7.1.7
Processed Data Insights
-
7.1.7.1
Process Results Data
Analysis
- 7.1.7.1.1 Common Filters
- 7.1.7.1.2 Report Hierarchies
- 7.1.7.1.3 Report Data Action
- 7.1.7.1.4 Transfer Rate Outliers
- 7.1.7.1.5 Rate & Charge Credit
- 7.1.7.1.6 Rate Bands
- 7.1.7.1.7 FTP Margin
- 7.1.7.1.8 Regional FTP Margin Rate
- 7.1.7.1.9 Regional FTP Margin Amount
- 7.1.7.1.10 Detailed Acct Level Info
- 7.1.7.1.11 STD Deviation
-
7.1.7.1
Process Results Data
Analysis
- 7.2 Account Audit Report
-
7.1
Funds Transfer Pricing Cloud Service Reports
& Analytics
- 8 Technical Documents