Table of Contents

• Title and Copyright Information
• 1 Preface
  • 1.1 About the Guide
  • 1.2 Scope of the Guide
  • 1.3 Intended Audience
  • 1.4 Related Documents
• 2 Introduction
  • 2.1 Basel Committee on Banking Supervision (BCBS) 239
  • 2.2 Oracle Financial Services Analytical Applications Solution for BCBS 239 Regulations
  • 2.3 Data Governance for North America Regulatory Reporting
  • 2.4 Important Features
• 3 Components of Data Governance for North America Regulatory Reporting
• 4 Mapping the Business Terms
  • 4.1 Viewing a Business Term
  • 4.2 Creating a Business Term
  • 4.3 Creating a Usage Term
  • 4.4 Approving or Rejecting a Business Term
• 5 Identifying the Critical Data Elements
  • 5.1 Viewing Critical Data Elements
  • 5.2 Creating a Critical Data Element (CDE)
  • 5.3 Approving or Rejecting a CDE
• 6 Key Indicator Assessment Configuration
  • 6.1 Configuring Key Indicators
• 7 Control Assessment Parameters
  • 7.1 Configuring Control Assessment Parameters
• 8 Key Indicator Threshold
  • 8.1 Configuring Key Indicator Threshold
• 9 DGS Application Configuration
  • 9.1 Configuring DGS Application
• 10 Controls
  • 10.1 DQ Checks and Controls
  • 10.2 Control Creation through Batches
  • 10.3 Quality Control Assessment
  • 10.4 Control Assessment Logic
  • 10.5 Viewing Controls
  • 10.6 Editing an Issue
    • 10.6.1 Creating an Action
• 11 Inbox
  • 11.1 Logging an Issue
• 12 Data Adjustments from Controls Module
  • 12.1 Types of Data Adjustments
  • 12.2 User Roles and Actions
    • 12.2.1 Actions Performed by Users
  • 12.3 Settings for Data Adjustments
    • 12.3.1 Prerequisites for Data Adjustments
  • 12.4 Creating a Data Adjustment
    • 12.4.1 Create a Data Quality Errors based Data Adjustment
    • 12.4.2 Create a Business based Data Adjustment
    • 12.4.3 Create a Regulatory Reporting based Data Adjustment
      • 12.4.3.1 Export and Import Data Updates
      • 12.4.3.2 Save and Submit a Data Adjustment
      • 12.4.3.3 View the Pre and Post Adjusted Data
  • 12.5 Approve or Reject Data Adjustments
  • 12.6 Modify a Rejected Data Adjustment
  • 12.7 Executing a Data Adjustment Batch
    • 12.7.1 Regulatory Adjustments
    • 12.7.2 Data Quality Adjustments
  • 12.8 Creating a New Batch and a Task
  • 12.9 Refresh Adjustments
  • 12.10 Monitoring the Data Adjustment Batch through the Batch Monitor Pane
• 13 Data Adjustments from Inbox
  • 13.1 Types of Data Adjustments
  • 13.2 User Roles and Actions
    • 13.2.1 Actions Performed by Users
  • 13.3 Settings for Data Adjustments
    • 13.3.1 Prerequisites for Data Adjustments
  • 13.4 Creating a Data Adjustment
    • 13.4.1 Create a Data Quality Errors based Data Adjustment
    • 13.4.2 Create a Business based Data Adjustment
    • 13.4.3 Create a Regulatory Reporting based Data Adjustment
      • 13.4.3.1 Export and Import Data Updates
      • 13.4.3.2 Save and Submit a Data Adjustment
      • 13.4.3.3 View the Pre and Post Adjusted Data
  • 13.5 Approve or Reject Data Adjustments
  • 13.6 Modify a Rejected Data Adjustment
  • 13.7 Executing a Data Adjustment Batch
    • 13.7.1 Triggering the Adjustment Batch
      • 13.7.1.1 Regulatory Adjustments
      • 13.7.1.2 Data Quality Adjustments
    • 13.7.2 Creating a New Batch and a Task
    • 13.7.3 Monitoring the Data Adjustment Batch through the Batch Monitor Pane
• 14 Plan Monitoring
  • 14.1 Creating a Reporting Plan
  • 14.2 Viewing and Editing a Reporting Plan
• 15 Regulatory Reporting Integration
  • 15.1 Refresh Adjustments
  • 15.2 Deploy to DGS
• 16 Dashboards
  • 16.1 Data Quality Dashboards
    • 16.1.1 Distribution of Error Records by the Attribute Count
    • 16.1.2 Distribution of Error Records by Error Type
    • 16.1.3 Distribution of Defaults by Attribute Count
    • 16.1.4 Data Quality Exception Report
  • 16.2 Controls Dashboard
    • 16.2.1 Summary
      • 16.2.1.1 Quality Controls by Rating
      • 16.2.1.2 Quality Control Effectiveness Trend
      • 16.2.1.3 Data Quality Controls
    • 16.2.2 Controls by Regulatory Reports
  • 16.3 Key Indicators Dashboards
    • 16.3.1 Key Indicators - Summary
      • 16.3.1.1 Viewing Key Indicator Details
      • 16.3.1.2 Viewing Key Indicator Conditions Details
    • 16.3.2 KIs by Regulatory Reports
  • 16.4 Regulatory Report Monitoring
    • 16.4.1 Plan Analysis by Report
    • 16.4.2 Create a New Issue
    • 16.4.3 Create Action
    • 16.4.4 Data Origin Analysis
  • 16.5 Variance Mapping Analysis Dashboard
    • 16.5.1 Current Period Report
      • 16.5.1.1 Drill Down Report
        • 16.5.1.1.1 Dimensions Supported in Variance Analysis drill-down
        • 16.5.1.1.2 New and Closed Account
      • 16.5.1.2 Creating an Issue through the Dashboard
  • 16.6 Variance Analysis Dashboard
    • 16.6.1 Populating Data for Account Drill down Granularity (Variance Analysis dashboard)
    • 16.6.2 Current Period Report
      • 16.6.2.1 Drill Down Report
        • 16.6.2.1.1 Dimensions Supported in Variance Analysis drill-down
        • 16.6.2.1.2 New and Closed Account
      • 16.6.2.2 Creating an Issue through the Dashboard
    • 16.6.3 Prior Period Report
    • 16.6.4 Business View Report
    • 16.6.5 Prior Period Runs
  • 16.7 Data Schedule Dashboard
  • 16.8 Integrating Agile Reporter with Data Governance Variance Analysis Dashboard
    • 16.8.1 Launching Data Governance Variance Analysis Dashboard with Agile Reporter
    • 16.8.2 Launching Data Governance Variance Analysis from Agile Reporter Analysis
• 17 Metadata Report
  • 17.1 Prerequisites
    • 17.1.1 Verifying Logs
    • 17.1.2 Validating Lineage Outputs
  • 17.2 Create and Export Metadata Report Templates for XML and Excel
  • 17.3 View Metadata Report Templates
  • 17.4 Modify or Edit Metadata Report Templates
  • 17.5 Delete Metadata Report Templates