Table of Contents

• Title and Copyright Information
• 1 Preface
  • 1.1 Preface
    • 1.1.1 What is New in this Release of OFSDF Application Pack
      • 1.1.1.1 New Features
      • 1.1.1.2 Deprecated Features
      • 1.1.1.3 Desupported Features
    • 1.1.2 Audience
    • 1.1.3 Access to Oracle Support
    • 1.1.4 Related Information Sources
• 2 Introduction to OFSDF
  • 2.1 Overview
  • 2.2 Components of OFSDF
  • 2.3 Relationship to Oracle Financial Services Analytical Applications
  • 2.4 OFSDF Prerequisite Components and Tools
• 3 Other OFSDF Result Tables
  • 3.1 Background
  • 3.2 OFSDF Architecture
  • 3.3 Differences from Traditional Warehouse Architecture
  • 3.4 Staging Data Model
    • 3.4.1 Overview/Design
    • 3.4.2 Details of the Staging Data Model
      • 3.4.2.1 Business Data
      • 3.4.2.2 Product Processors
      • 3.4.2.3 Reference/Master Data
  • 3.5 Reporting Data Model
  • 3.6 Overview
  • 3.7 Reporting Area Details
• 4 Catalog Viewer
• 5 Dimension Loading Process
  • 5.1 Dimension Table Population
  • 5.2 Overview of Seeded Dimensions
  • 5.3 Overview of SCD Process
    • 5.3.1 Type 1 SCDs - Overwriting
    • 5.3.2 Type 2 SCDs - Creating another dimension record
    • 5.3.3 Type 3 SCDs - Creating a current value field
  • 5.4 Prerequisites
  • 5.5 Tables Used by the SCD Component
    • 5.5.1 SYS_TBL_MASTER
    • 5.5.2 SYS_STG_JOIN_MASTER
  • 5.6 Guidelines for Configuring User Defined (Custom) SCDs
  • 5.7 Executing the SCD Component
  • 5.8 Checking the Execution Status
  • 5.9 Different Methods of Loading or Executing the Dimensions
    • 5.9.1 LOAD DIM TABLES THROUGH SCD
    • 5.9.2 LOAD KEY DIMENSIONS USING DRMLOADER AND HIERARCHY FLATTENING
    • 5.9.3 Loading Data from STG_INTF Tables to DIM_INTF Tables
    • 5.9.4 Executing The Loading Procedure using Batch Framework
    • 5.9.5 Executing The Hierarchy Flattening Procedure using Batch Framework
    • 5.9.6 Executing The SCD for Loading Key Dimensions using Batch Framework
    • 5.9.7 Improving SCD Performance
• 6 Reclassification of Standard Dimensions
  • 6.1 Overview of the Reclassification of Standard Dimensions
  • 6.2 Overview of the Reclassification of Standard Dimensions Population
  • 6.3 Dimension Data Expectations through SCD
  • 6.4 Overview of the Mappers for the Reclassification of Standard Dimensions
  • 6.5 Maintenance of the Mapper for the Reclassification of Standard Dimensions
    • 6.5.1 Prerequisites for Mapper Maintenance
    • 6.5.2 Possible Mapping Combinations
  • 6.6 Loading Mapper Maintenance through Backend
  • 6.7 Usage of Mapper Tables in Data Flow and Reports
• 7 Legal Entity Consolidation
  • 7.1 Introduction
  • 7.2 Consolidation Procedures
  • 7.3 Types of Consolidation
  • 7.4 Consolidation Activities
  • 7.5 Legal Entity Consolidation Data Flow
• 8 Executing Run through Process Modelling Framework in OFSDF
  • 8.1 Overview
  • 8.2 Process Modeling Framework Roles
  • 8.3 Accessing the Process Modeling Framework
  • 8.4 Using the Process Modeling Framework in OFSDF
    • 8.4.1 Process Modeller
    • 8.4.2 Process Monitor
  • 8.5 Designing a Pipeline in OFSDF
    • 8.5.1 Designing a Run Pipeline
      • 8.5.1.1 Creating a new Run Pipeline
      • 8.5.1.2 Designing a Process Flow for a Run Pipeline
    • 8.5.2 Executing the Run Pipeline
      • 8.5.2.1 Selecting the Run Parameters and Executing the Run
      • 8.5.2.2 Verifying the Run Execution
      • 8.5.2.3 Aborting, Resuming, or Rerunning the Run Pipeline Process
    • 8.5.3 Verifying the Execution Logs
  • 8.6 Creating Filter using DIM_DATA_ORIGIN
• 9 Process Execution Summary
• 10 Run Execution from Command Line
  • 10.1 Run Execution from the Command Line
• 11 External Engine
  • 11.1 Why is External Engine Required
  • 11.2 About the External Engine
  • 11.3 POI Tables and External Engine T2Ts
  • 11.4 How to Configure and Use the POI Tables
• 12 Big Data in OFSDF
  • 12.1 Overview
  • 12.2 OFSDF Big Data Architecture
    • 12.2.1 Staging and Results on Hive
    • 12.2.2 Staging on Hive and Results on RDBMS
    • 12.2.3 Workarounds in the Staging and Results on Hive
      • 12.2.3.1 Modifications
      • 12.2.3.2 Workarounds
  • 12.3 List of Supported SCDs and T2Ts
    • 12.3.1 List of Supported SCDs
    • 12.3.2 Run Enabled T2Ts
    • 12.3.3 List of Supported T2Ts
    • 12.3.4 List of Unsupported SCDs and T2Ts
    • 12.3.5 List of Unsupported SCDs
    • 12.3.6 List of Unsupported T2Ts
  • 12.4 Executing Run through Rules Run Framework for Hive
• 13 Account Dimension Table
  • 13.1 Overview of Account Dimension
  • 13.2 Overview of Account Dimension Population
  • 13.3 Executing the Account Dimension SCD
    • 13.3.1 Handle Multiple GAAP Codes for Same Account Number for the Same MIS Date in SCD
    • 13.3.2 Handle Multiple Load Runs for Same Account Number for the Same MIS Date in SCD
• 14 Customer Dimension Table
  • 14.1 Customer Dimension Loading Overview
  • 14.2 Customer Dimension Population using Stage Party Master Entity
    • 14.2.1 Prerequisites
  • 14.3 Customer Dimension Population using Stage Customer Master Entity
    • 14.3.1 Prerequisites
  • 14.4 Execution of Customer Dimension Population Batch
  • 14.5 For Party Master Flow
    • 14.5.1 Error Messages
  • 14.6 For Customer Master Flow
    • 14.6.1 Error Messages
• 15 Loading Multiple Load Runs in OFSAA
  • 15.1 Objective
  • 15.2 Design Details
  • 15.3 Implementation
  • 15.4 Loading OFSAA Staging Tables
    • 15.4.1 Complete Snapshot Load Example
    • 15.4.2 Incremental Snapshot Load Example
  • 15.5 Post Stage Load Process
    • 15.5.1 Register Load Run Details
    • 15.5.2 Updating Load as Completed
  • 15.6 Loading data into OFSAA Results Tables from Staging Tables
    • 15.6.1 Complete Snapshot Load Scenario
    • 15.6.2 Incremental Load Scenario
• 16 Restatement Support Feature in OFSDF
  • 16.1 Features Supporting Restatement
    • 16.1.1 Data Versioning
      • 16.1.1.1 Data Versioning in Seeded Data
      • 16.1.1.2 Data Versioning in Mappers
      • 16.1.1.3 Incremental Data Load
    • 16.1.2 Data Flow
  • 16.2 Prerequisites
  • 16.3 Use Case for Restatement in OFSDF
  • 16.4 Assumptions for the Implementation of Restatement
• 17 Exchange Rates Tables
  • 17.1 Handling Alternate Currency
  • 17.2 Business Use Case Indicating the Requirement of two Exchange Rates Tables
  • 17.3 Overview of the Exchange Rates Tables
    • 17.3.1 Data loading method supported from the OFSDF 8.1.0.0.0 release
    • 17.3.2 Data loading method supported for the OFSDF 8.0.9.0.0 and earlier versions
  • 17.4 About Exchange Rates T2Ts (Result Table)
    • 17.4.1 About Exchange Rates T2T for the STG_EXCHANGE_RATE_HIST table
    • 17.4.2 About Exchange Rates T2T for the STG_FORWARD_EXCHG_RATES table
  • 17.5 Multiple Execution of T2Ts using the Runchart
  • 17.6 Populating Exchange Rates T2T Result Tables
• 18 Account Summary Tables
  • 18.1 Overview of the Account Summary Tables
  • 18.2 Overview of the Account Summary Population
  • 18.3 Executing the Account Summary T2Ts using PMF
    • 18.3.1 Execution through PMF
  • 18.4 Checking the Execution Status
  • 18.5 Retrieving the Account Summary T2T Definitions
• 19 Customer Summary Tables
  • 19.1 Overview of the Common Customer Summary Tables
  • 19.2 Prerequisites
  • 19.3 Executing the Customer Summary T2T using PMF
    • 19.3.1 Error Messages
• 20 Fact Transaction Summary Tables
  • 20.1 Fact Transaction Summary T2Ts
  • 20.2 Executing the Fact Transaction Summary T2Ts using PMF
• 21 Loan Account Summary Tables
  • 21.1 Overview of the Loan Account Summary Tables
  • 21.2 Overview of the Loan Account Summary Population
  • 21.3 Executing the Loan Account Summary T2Ts using PMF
    • 21.3.1 Error Messages
  • 21.4 Checking the Execution Status
  • 21.5 Retrieving the Loan Account Summary T2T Definitions
• 22 Deposit Borrowings Summary Tables
  • 22.1 Overview of the Deposit Borrowings Summary Tables
  • 22.2 Overview of the Deposit Borrowings Summary Population
  • 22.3 Executing the Deposit Borrowings Summary T2Ts using PMF
    • 22.3.1 Error Messages
  • 22.4 Checking the Execution Status
  • 22.5 Retrieving the Deposit Borrowings Summary T2T Definitions
• 23 Cards Summary Tables
  • 23.1 Overview of the Cards Summary Tables
  • 23.2 Overview of the Cards Summary Population
  • 23.3 Executing the Cards Summary T2Ts using PMF
    • 23.3.1 Error Messages
  • 23.4 Checking the Execution Status
  • 23.5 Retrieving the Cards Summary T2T Definitions
• 24 Mitigants Results Tables
  • 24.1 Overview of the Mitigants Results Tables
  • 24.2 Overview of the Mitigants Results Population
  • 24.3 Executing the Mitigants Results T2Ts using PMF
    • 24.3.1 Error Messages
  • 24.4 Checking the Execution Status
  • 24.5 Retrieving the Mitigants Results T2T Definitions
• 25 Fiduciary Services Investment Summary Tables
  • 25.1 Overview of the Fiduciary Services Investment Summary Tables
  • 25.2 Overview of the Fiduciary Services Investment Summary Population
  • 25.3 Executing the Fiduciary Services Investment Summary T2Ts using PMF
    • 25.3.1 Error Messages
  • 25.4 Checking the Execution Status
  • 25.5 Retrieving the Fiduciary Services Investment Summary T2T Definitions
• 26 Party Attributes
  • 26.1 Overview of the Party Attributes Results Tables
  • 26.2 Overview of the Party Attributes Results Population
  • 26.3 Executing the Party Attribute T2Ts using PMF
  • 26.4 Error Messages
  • 26.5 Checking the Execution Status
  • 26.6 Retrieving the Party Attributes Result T2T Definitions
• 27 Placed Collateral Tables
  • 27.1 Overview of the Placed Collateral Tables
  • 27.2 Overview of the Placed Collateral Population
  • 27.3 Executing the Placed Collateral T2Ts using PMF
    • 27.3.1 Error Messages
  • 27.4 Checking the Execution Status
  • 27.5 Retrieving the Placed Collateral Result T2T Definitions
• 28 Credit Score Model and Probability of Default Model
  • 28.1 Overview of the Credit Score Model and Probability of Default Model
  • 28.2 Overview of the Credit Score Model and Probability of Default Model Population
    • 28.2.1 Staging Data Expectation for Credit Score Model
  • 28.3 Overview of the Mapper for Credit Score Model to Regulatory Credit Score Model
  • 28.4 Maintenance of the Mapper for Credit Score Model to Regulatory Credit Score Model
    • 28.4.1 Prerequisites for Mapper Maintenance
    • 28.4.2 Possible Mapping Combinations
      • 28.4.2.1 One to One Mapping
      • 28.4.2.2 Many to One Mapping
  • 28.5 Loading the Mapper Maintenance through Backend
  • 28.6 Executing the Credit Score Model and Probability of Default Model T2Ts using PMF
    • 28.6.1 Error Messages
  • 28.7 Checking the Execution Status
  • 28.8 Retrieving the Credit Score Model and Probability of Default Model T2Ts
• 29 GL to Management Reporting
  • 29.1 Overview of the GL to Management Reporting Result Table
  • 29.2 Populating the GL to Management Reporting Result Table
  • 29.3 Overview of the Mapper for GL to Management Reporting Result Table
  • 29.4 Maintaining the Mappers for GL to Management Reporting Result Table
    • 29.4.1 Prerequisites for Mapper Maintenance
    • 29.4.2 Possible Mapping Combinations
      • 29.4.2.1 Mapping Combinations at Child Hierarchy Level
        • 29.4.2.1.1 One-to-One mapping with or without Debit Credit Indicator
        • 29.4.2.1.2 Many-to-One mapping with or without Debit Credit Indicator
        • 29.4.2.1.3 Many-to-One mapping with or without Debit Credit Indicator
      • 29.4.2.2 Mapping Combinations at Parent and Child Hierarchy Level
        • 29.4.2.2.1 One Parent to One Reporting Line Code mapping with or without Debit Credit Indicator
        • 29.4.2.2.2 Many Parents to One Reporting Line Code with or without Debit Credit Indicator
        • 29.4.2.2.3 Many Parents to Many Reporting Line Codes with or without Debit Credit Indicator
      • 29.4.2.3 Mapping Combinations at Parent Hierarchy Level without Descendants
      • 29.4.2.4 Mapping Combinations at Parent Hierarchy Level by Removing one or more Descendants
    • 29.4.3 Performing Multiple Sets of Mapping Combinations
  • 29.5 Loading the Mapper Maintenance from Backend
  • 29.6 Executing the GL to Management Reporting T2T using PMF
    • 29.6.1 Error Messages
  • 29.7 Checking the Execution Status for GL to Management Reporting Result Table
  • 29.8 Retrieving the GL to Management Reporting Result T2T Definitions
• 30 Other OFSDF Result Tables
  • 30.1 Overview of the Other Results Tables
  • 30.2 Overview of the Other Results Population
  • 30.3 Executing the Other T2Ts and Dimensions
  • 30.4 Checking the Execution Status
  • 30.5 Retrieving the Other Result T2T Definitions
• 31 BASEL Processing to FSDF Results Integration
  • 31.1 Overview of the BASEL Processing to FSDF Results Integration Tables
  • 31.2 Overview of the BASEL Processing to FSDF Results Integration
  • 31.3 Executing the BASEL Processing to FSDF Results Integration T2Ts
    • 31.3.1 Execute SCDs through Seeded Batches
    • 31.3.2 Execute the T2Ts using PMF
    • 31.3.3 Error Messages
  • 31.4 Checking the Execution Status
  • 31.5 Retrieving the BASEL Processing to FSDF Results Integration T2T Definitions
• 32 LLFP Processing to FSDF Results Integration
  • 32.1 Overview of the LLFP Processing to FSDF Results Integration Tables
  • 32.2 Overview of the LLFP Processing to FSDF Results Integration
  • 32.3 Executing the LLFP Processing to FSDF Results Integration T2Ts
  • 32.4 Checking the Execution Status
  • 32.5 Retrieving the LLFP Processing to FSDF Results Integration T2T Definition
• 33 LRS Pack Processing to FSDF Results Integration
  • 33.1 Overview of the LRS Pack Processing to FSDF Results Integration Tables
  • 33.2 Overview of the LRS Pack Processing to FSDF Results Integration
  • 33.3 Executing the LRS Pack Processing to FSDF Results Integration T2Ts
  • 33.4 Checking the Execution Status
  • 33.5 Retrieving the LRS Pack Processing to FSDF Results Integration T2T Definitions
• 34 Metadata Browser
  • 34.1 Overview
  • 34.2 Object View
  • 34.3 Metadata Publish
  • 34.4 Metadata Object to Application Map
• 35 Metadata Report Utility
  • 35.1 Prerequisites
  • 35.2 Additional Configurations for User defined Metadata and Application Integration
  • 35.3 Additional Configurations for Data Transformation
  • 35.4 Verifying Logs
  • 35.5 Validating Lineage Outputs
  • 35.6 Utility to Generate a Lineage Report in CSV Format
  • 35.7 Utility to Generate a Lineage Report in Json Format
  • 35.8 Lineage Properties
• 36 Time Dimension Table
  • 36.1 Overview of Time Dimension Population
  • 36.2 Prerequisites
  • 36.3 Tables Used by the Time Dimension Population Transformation
  • 36.4 Executing the Time Dimension Population Transformation
  • 36.5 Checking the Execution Status
• 37 Recommendation for Backdated Run
  • 37.1 Overview of Backdated Run Execution
  • 37.2 Required Changes
  • 37.3 Recommendations
  • 37.4 Backdated Run Execution using Latest Record Indicator (LRI) batch
• 38 Using OFSDF
  • 38.1 Delivery Mechanism
  • 38.2 Installing OFSDF
  • 38.3 OFSDF Supporting Documentation
  • 38.4 Data Dictionary
  • 38.5 Download Specifications
  • 38.6 Extending OFSDF Physical Data Model
    • 38.6.1 Customization Process Guidelines
    • 38.6.2 Staging Area Design Guidelines
    • 38.6.3 Results Area Design Guidelines
    • 38.6.4 Upgrading Data Model
• 39 Key Business Data Use Cases
  • 39.1 Hypothecated Deposits
    • 39.1.1 Usage
    • 39.1.2 Inferences
    • 39.1.3 Handling Hypothecated Deposits in OFSDF
  • 39.2 Credit Lines and Commitment Contracts
    • 39.2.1 Commitment Contract
    • 39.2.2 Credit Line
      • 39.2.2.1 Differences and Similarities between Credit Lines and Commitment Contracts
        • 39.2.2.1.1 Differences between Credit Lines and Commitment Contracts
        • 39.2.2.1.2 Similarities between Credit Lines and Commitment Contracts
  • 39.3 Handling Participated/Syndicated Contracts
    • 39.3.1 Net Share Computation Logic for Participated/Syndicated Contracts
  • 39.4 Sourcing Account Balances
    • 39.4.1 Dynamic Sourcing of the Amount and Balance Columns in the Product Processors Independent of OFSDF
    • 39.4.2 About Balance Type Dimension Table
    • 39.4.3 About Standard Balance Type Dimension Table for Reclassification
    • 39.4.4 About Account Balances T2T Population
  • 39.5 Sourcing Special Terms and Covenants
    • 39.5.1 About Special Term Dimension Table
    • 39.5.2 About Standard Special Term Dimension Table for Reclassification
    • 39.5.3 About Special Terms Covenants T2T Population
• 40 Data Quality Rules Execution
  • 40.1 Data Quality Framework
    • 40.1.1 Data Quality Summary
    • 40.1.2 Create Data Quality Rule
    • 40.1.3 View Data Quality Rule
    • 40.1.4 Modify Data Quality Rule
    • 40.1.5 Copy Data Quality Rule
    • 40.1.6 Approve/Reject Data Quality Rule
    • 40.1.7 Delete Data Quality Rule
  • 40.2 Data Quality Groups Summary
    • 40.2.1 Create Data Quality Group
    • 40.2.2 Execute Data Quality Group
    • 40.2.3 View Data Quality Group
    • 40.2.4 Modify Data Quality Group
    • 40.2.5 Copy Data Quality Group
    • 40.2.6 View Data Quality Group Summary Log
    • 40.2.7 Delete Data Quality Group
    • 40.2.8 Data Quality Rules For Staging Tables
    • 40.2.9 Data Quality Groups for Staging Tables
      • 40.2.9.1 DQ Group Execution
      • 40.2.9.2 Batch Execution of DQ Rules
• 41 Compare Data Model Reports and Generate Data Model Difference Report
  • 41.1 Extract the Data Model Report from the erwin Data Modeler application
• 42 APPENDIX A: Naming Conventions Used in OFSDF Data Model
  • 42.1 Naming Conventions Used in OFSDF PDM
    • 42.1.1 OFSDF Physical Data Model Naming Conventions
      • 42.1.1.1 PDM Logical View Mode Naming Conventions
      • 42.1.1.2 PDM Physical View Mode Naming Conventions
    • 42.1.2 Domains (PDM)
• 43 APPENDIX B: Standard Data Expectations
  • 43.1 Rate and Percentage
  • 43.2 Custom Reporting Line Codes
• 44 APPENDIX C: How to Define a Batch
  • 44.1 Batch Definition
• 45 APPENDIX D: Template to Generate Data Dictionary and Download Specification for erwin 2019R1 or a higher version