USA: +1-703-445-4802
UK:+44 20 3287 2021
India:+91-8143111555 / +91-8790216888
WhatsApp: +91-8143110555

Oracle Financial Services Asset Liability Management (OFSALM) Training in Hyderabad

Oracle Financial Services Asset Liability Management (OFSALM)

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 
    14 Common Rule Management Tasks
    • 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 
    Natural    Natural   Natural   Natural   Natural   Natural   Natural   Natural   Natural   Natural   Natural