Oracle Financial Services Asset Liability Management (OFSALM)
Course Content:
1) Introduction to Oracle Asset Liability Management
- Overview of Oracle Financial Services Asset Liability Management
- Oracle Asset Liability Management and Other Oracle Financial Services Applications
2) Overview of OFSAA Infrastructure
- OFSAA Infrastructure
- Overview of Dimensionality in OFSAA
- Referential Integrity
- Dimension Attributes
- Hierarchies
- Rollup Members for Dimensions Supporting Hierarchies
- Dimension Types
- Overview of Attributes
- Overview of OFSAA Rules
- OFSAA Expressions
- Folders
- Access Type
- Global Preferences
3) OFSAA Administrative Reporting
- Introduction
- Access Permissions
- Data Quality
- Object Registration
- Security
- Adhoc Reporting – Special Instructions
4) OFSAA Data Entry Forms and Queries
- Introduction to Data Entry Forms and Queries
- Acronyms
- Designing Data Entry Forms
- Creating a New Form
- The Grid Layout
- The Single Record Layout
- The Edit/View Layout
- The Multi Column Layout
- The Wrapping Row Layout
- The Tree View Layout
- Joining Tables
- Applying Rules
- Committing the Batch
- Defining the Form Filter
- Data Versioning
- Specifying Message Details
- Altering an Existing Form
- Copying an Existing Form
- Deleting a Form
- Assigning Rights to a Form
- Message Type Maintenance
- Entering Data
- Viewing Form Details
5 OFSAA Attributes
- Overview
- Summary & Detail Screens
- Navigation within the Summary Screen
- Navigation within the Detail Screen
6 OFSAA Dimension Members
- Overview
- Summary & Detail Screens
- Navigation within the Summary Screen
- Dimension Members Container
- Dimension Members Summary Grid
- Navigation within the Detail Screen
7 OFSAA Hierarchies
- Overview of OFSAA Hierarchies
- Summary & Detail Screens
- Navigation within the Summary Screen
- Navigation within the Detail Screen
- Controlling the Hierarchy Display.
- Adding Hierarchies
- Editing Hierarchies.
8 OFSAA Filters
- Overview of OFSAA Filters
- Summary & Detail Screens
- Navigation within the Summary Screen
- Filters Summary Grid
- Navigation within the Detail Screen
- Data Element Filters
- Hierarchy Filters
- Group Filters
9 OFSAA Expressions
- Expressions
- Summary & Detail Screens
- Navigation within the Summary Screen
- Expressions Container
- Expressions Summary Grid
- Navigation within the Detail Screen
- Entity Type & Entity Name Drop Down List Boxes
- Functions and Operators Sub-Containers
10 OFSAA Rate Management
- Overview
- Interest Rates Summary Screen
- Interest Rates Detail Screen
- Currency
- Currency Rates
- Currency Exchange Rate Validation
- Economic Indicators Summary Screen
- Economic Indicators Detail Screen
11 Simplified Batches
- Overview of Simplified Batches
- Summary and Detail Screens
- Navigation within the Summary Screen
- Navigation within the Detail Screen
- Task Selection
- Running a Simplified batch
- Viewing the Task Logs
- Additional Batch Options
12 Holiday Calendar
- Overview of Holiday Calendars
- Searching for a Holiday Calendar
- Creating a Holiday Calendar
- Executing Holiday Calendar
- Holiday Exceptions
13 The Oracle Asset Liability Management Process
- Overview of the Process
- Reconciling the Data
- Cleansing the Data by performing Cash Flow Edits
- Setting Application Preferences
- Activating Currencies and Loading Exchange Rates
- (Mandatory) Deciding on historical rate information and managing by creating Interest Rate
- Codes
- Defining Economic Indicators
- Capturing Instrument Behavior for non-standard instruments
- (Mandatory) Defining Time Buckets.
- (Mandatory) Defining Product Characteristics
- (Mandatory - Deterministic) Defining Forecast Rate Scenarios
- Defining Prepayments
- Defining Discounting Methods
- Defining Forecast Assumptions
- Defining Transfer Pricing Rules.
- Transfer Pricing Methodologies and Rules
- Defining Transfer Pricing Methodologies Using Node Level Assumptions
- Defining Transaction Strategies
- Defining Formula Results
- (Mandatory – Stochastic) Defining Stochastic Rate Indexing Rules
- (Mandatory) Defining and Running the Asset Liability Management Process
- Reviewing Processing Errors
- Accessing Asset Liability Management, Detail Cash Flow Results for Audit Purposes
- Overview of Common Rule Management Tasks
- The Rule Summary Page
- Searching for Rules
- Creating Rules
- Viewing and Editing Rules
- Copying Rules
- Deleting Rules
- Dependency Checking
15 Application Preferences
- Overview of ALM Application Preferences
- Updating ALM Application Preferences
16 Cash Flow Edits
- Overview of Cash Flow Edit Processes
- Creating Cash Flow Edit Processes
- Executing Cash Flow Edit Processes.
17 User Defined Behavior Patterns
- Overview of User Defined Behavior Patterns
- Searching for Behavior Patterns
- Creating Behavior Patterns
18 User Defined Payment Patterns
- Overview of User Defined Payment Patterns
- Searching for Payment Patterns
- Creating Payment Patterns
19 User Defined Repricing Patterns
- Overview of Repricing Patterns
- Searching for Repricing Patterns
- Creating Repricing Patterns.
20 Time Buckets
- Overview of Time Bucket Rules
- Creating Time Bucket Rules
- Defining Time Bucket Rules
21 Default Product Profiles
- Overview of Product Profiles
- Viewing a seeded Product Profile
- Creating Product Profiles
- Summary of Seeded Product Profiles
22 Product Characteristics
- Overview of Product Characteristic Rules
- Creating Product Characteristic Rules
- Defining Product Characteristic Rules
- Copying Assumptions Across Currencies and Products
23 Forecast Rate Scenarios
- Creating a Forecast Rates Assumption Rule
- Currency Forecast Methods
- Economic Indicator Forecast Methods
- Interest Rate Forecast Methods
- Data Loader Procedure
24 Prepayment Rules
- Overview of Prepayment Rules
- Creating Prepayment Rules
- Defining Prepayment Methodologies.
- Defining Early Redemption Assumptions
- Associating Conditional Assumptions with Prepayment Rules
25 Prepayment Models
- Overview of Prepayment Models
- Creating Prepayment Models
- Editing Prepayment Models
- Editing Prepayment Rates in a Prepayment Model
- Prepayment Rate Data Loader
26 Discount Methods
- Overview of Discount Method Rules
- Creating Discount Method Rules
- Defining Discount Method Rules
27 Rate Dependency Patterns
- Overview of Rate Dependency Patterns
- Searching for Rate Dependency Patterns
- Creating Rate Dependency Patterns.
28 Forecast Balance Rules
- Forecasting Methods
- Rate-Volume Modeling
- Creating a Forecast Balance Rule
- Examples of Forecast Balance Assumptions
29 Forecast – Maturity Mix
- Overview of Maturity Mix Rules
- Creating Maturity Mix Rules
- Defining Maturity Mix Rules
30 Forecast - Pricing Margins
- Overview of Pricing Margin Rules
- Creating Pricing Margin Rules
- Defining Pricing Margin Rules
31 Transfer Pricing Rules
- Overview of Transfer Pricing Rules
- Creating Transfer Pricing Rules
- Defining Transfer Pricing Methodologies
- Defining the Redemption Curve Methodology
32 Adjustment Rules
- Overview of Adjustment Rules
- Creating Adjustment Rules
- Defining Adjustment Methods
33 Transaction Strategies
- Creating a Transaction Strategy Rule
34 Formula Results
- Overview
35 Stochastic Rate Indexing
- Overview of Stochastic Rate Indexing Rules
- Defining Stochastic Rate Indexes
36 ALM Processing
- Overview of ALM Processes
- Creating an ALM Process Rule
- Executing an ALM Process
37 Andrew Davidson and Company (ADCo) Prepayment Method
- Overview of ADCo Prepayment Method
- Deployment of ADCo Libraries on OFSAAI
- Procedure For Setting Up ADCo Process
- ADCo Mapping
- Limitations