2        Introduction

This chapter provides an understanding of the Oracle Financial Services Regulatory Reporting for Reserve Bank of India Lombard Risk Integration Pack (OFS REG REP RBI) application and its scope.

Topics:

·        Overview

·        OFSAA Regulatory Reporting Architecture

·        Scope

Overview

Oracle Financial Services Regulatory Reporting for Reserve Bank of India Lombard Risk Integration Pack (OFS REG REP RBI) helps the banks to comply with various guidelines issued by RBI, including BCBS 239 regulations. It provides integrating risk data reporting systems and enhances the accuracy of reporting in banks. OFS Risk Regulatory Reporting (REG REP) Solution helps in achieving the objectives by enabling preset steps based on the generalization of a set of solutions. This is made possible by:

·        Providing centralized data storage for risk data through relevant subject areas of the Financial Services Data Foundation (FSDF).

·        Interfacing with a third-party reporting tool such as Lombard Risk Reporter Portal to build necessary template reports to meet the regulatory expectations.

The OFS REG REP RBI solution enables financial services organizations to manage and execute regulatory reporting in a single integrated environment. It automates end-to-end processes from data capture through submission with industry-leading solutions. It leverages Oracle Financial Services Analytical Application (OFSAA) and Oracle Financial Services Data Foundation (OFSDF) for managing analytical application data. The AgileREPORTER in Regulatory Reporting (REG REP) Solution enables firms to automate the final mile of the reporting process. It provides pre-built integration to Lombard Risk Reporting, eliminating the need for further manual intervention. The solution ensures data integrity allowing banks to focus more time on analyzing and gaining new business insight from their growing stores of data instead of preparing data and reports with the sole objective of meeting submission deadlines.

OFSAA Regulatory Reporting Architecture

OFS REG REP RBI supports the regulatory requirements for various reporting requirements such as DSB3ROR, FORM X, BSR VII, RCA111, CRILC and so on, which require enterprise-level data spanning multiple areas of banking. Each of these business areas has different applications to answer their respective processing requirements. REG REP warehouses this data for reporting purposes at a single place. An intermediate data transfer layer specific to the source applications enables data loading to REG REP by using the provided download specifications.


Figure 1: Regulatory Reporting (REG REP) Solution Architecture

This illustration describes the dataflow from OFSAA to AgileREPORTER.

This interface connects the Oracle FSDF to Lombard Risk. As shown in the Architecture of Error! Reference source not found., Data flows from OFSAA to Lombard Risk.

OFSDF is an analytical data warehouse platform for the Financial Services industry. OFSDF combines an industry data model for Financial Services along with a set of management and infrastructure tools that allows Financial Services Institutions to develop, deploy, and operate analytical solutions spanning key functional areas in Financial Services, including:

1.     Enterprise Risk Management

2.     Enterprise Performance Management

3.     Customer Insight

4.     Financial Crime and Compliance Management OFSDF

It is a comprehensive data management platform that helps institutions to manage the analytical data life cycle from sourcing to reporting and business intelligence/BI using a unified, consistent platform and toolset.

AgileREPORTER is a form and workflow tool that enables both creation and submission of regulatory returns. AgileREPORTER addresses the financial reporting requirements of both domestic and international banks and financial institutions by automating compliance with mandated reports to central banks, regulatory agencies. AgileREPORTER works easily with multiple sources of information as it standardizes data elements and automates regulatory report production in prescribed templates with the associated workflow for automatic submission. It is a reliable and efficient infrastructure to compile, generate, and submit regulatory reports. It collects data from a wide universe (not just OFSAA Results). It provides automated repeated manual adjustments, variance analysis, and validation checks. It provides features to explain and justify a number quickly, including links to OBIEE.

The solution provides a pre-built interface or integration between FSDF and AgileREPORTER. With this integration, end-user can automate end to end reporting processes covering data preparation to the last mile of reporting.

Scope

Oracle Financial Services Regulatory Reporting for Reserve Bank of India Lombard Risk Integration Pack covers the following regulatory reports for specified release as mentioned in the table.

Table 2: Scope of Regulatory Reports and Schedules

Report Name

Report Code as per Lombard Portal

Report Description

Report Section Covered in 8.1.1.0.0

LR REPORT

LR V7

Structural Liquidity Return

Additional Mapping for certain sections of the report.

RCAIII

RCAIII_V8

Return on Capital Adequacy

Revised version upgrade along with some fixes.

CRILC

CRLIC_V9

Central Repository of Information on Large Credits

Revised version upgrade along with some fixes.