This chapter provides an understanding of the Oracle Financial Services Regulatory Reporting Data Sets and Governance for Asia Pacific and Middle East Jurisdictions application and its scope.
Topics:
· Overview
· OFSAA Regulatory Reporting Architecture
· Scope
Regulatory reporting is the submission of the financial institutions data to regulators. Typically, this data originates from diverse internal systems, while the ultimate submissions are structured and need to be aligned to strict and detailed regulatory requirements. With the increasing complexity of reporting requirements from regulators around the globe, financial institutions are struggling to keep up with the constant pace of change. Asia Pacific & Middle East Jurisdictions are constantly evolving and strengthening the regulatory reporting requirement and gradually moving to a more detailed and complex reporting for all financial institutions. In Australia, the latest and most significant change being the reporting via Economic and financial statistics (EFS) or in Singapore the overhaul of MAS Notice 610 -Submission of Statistics and Returns.
The Oracle Financial Services Regulatory Reporting Data Sets and Governance for Asia Pacific and Middle East Jurisdictions delivers an integrated regulatory reporting solution to solve the biggest challenges that banks undergo such as quality, quantity and granularity of the data and transparency of the reporting ecosystem. It brings together the industrys best-in-class data foundation, complete transparency and data lineage throughout the application. The 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 solution provides mechanism to integrate the generated results to a third-party end mile reporting template solution, thus helping with final submission to the respective regulator. The solution comes with pre-built integration to Vermeg Agile Reporter for end mile reporting; however, it does not restrict the customer here. 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.
Figure 1: Regulatory Reporting (REG REP) Solution Architecture
This interface connects the Oracle FSDF to Lombard Risk. As you can see in the Architecture figure above, Data flows from OFSAA to Lombard Risk.
OFSDF is an analytical data warehouse platform for the Financial Services industry which 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 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, you can automate the end-to-end reporting process covering data preparation to the last mile of reporting.
Oracle Financial Services Regulatory Reporting Data Sets and Governance for Asia Pacific and Middle East Jurisdictions covers the following regulatory reports for specified release as mentioned in the table:
Report |
Report Name |
Jurisdiction |
Released Version |
|---|---|---|---|
ARF 720_0A |
ABS/RBA Statement of Financial Position (Standard) |
APRA |
8.1.1.0.0 |
ARF 720_0B |
ABS/RBA Statement of Financial Position (Reduced) |
APRA |
8.1.1.0.0 |
ARF 720_1A |
ABS/RBA Loans and Finance Leases (Standard) |
APRA |
8.1.1.0.0 |
ARF 720_1B |
ABS/RBA Loans and Finance Leases (Reduced) |
APRA |
8.1.1.0.0 |
ARF 720_2A |
ABS/RBA Deposits (Standard) |
APRA |
8.1.1.0.0 |
ARF 720_2B |
ABS/RBA Deposits (Reduced) |
APRA |
8.1.1.0.0 |
ARF 720_3 |
ABS/RBA Intra-group Assets and Liabilities |
APRA |
8.1.1.0.0 |
ARF 720_4 |
ABS/RBA Debt Securities Held |
APRA |
8.1.1.0.0 |
ARF 720_5 |
ABS/RBA Equity Securities Held |
APRA |
8.1.1.0.0 |
ARF 720_6 |
ABS/RBA Securities on Issue |
APRA |
8.1.1.0.0 |
ARF 720_7 |
ABS/RBA Bill Acceptances and Endorsements |
APRA |
8.1.1.0.0 |
ARF 741.0 |
ABS/RBA Business Finance |
APRA |
8.1.1.0.0 |
ARF 742.0A |
ABS/RBA Business Credit Stocks, Flows and Interest Rates (Standard) |
APRA |
8.1.1.0.0 |
ARF 742.0B |
ABS/RBA Business Credit Stocks, Flows and Interest Rates (Reduced) |
APRA |
8.1.1.0.0 |
ARF 743.0 |
ABS/RBA Housing Finance |
APRA |
8.1.1.0.0 |
ARF 744.0A |
ABS/RBA Housing Credit Stocks, Flows and Interest Rates (Standard) |
APRA |
8.1.1.0.0 |
ARF 744.0B |
ABS/RBA Housing Credit Stocks, Flows and Interest Rates (Reduced) |
APRA |
8.1.1.0.0 |
ARF 745.0 |
ABS/RBA Personal Finance |
APRA |
8.1.1.0.0 |
ARF 746.0A |
ABS/RBA Personal Finance Stocks, Flows and Interest Rates (Standard) |
APRA |
8.1.1.0.0 |
ARF 746.0B |
ABS/RBA Personal Finance Stocks, Flows and Interest Rates (Reduced) |
APRA |
8.1.1.0.0 |
ARF 747.0A |
ABS/RBA Deposit Stocks, Flows and Interest Rates (Standard) |
APRA |
8.1.1.0.0 |
ARF 747.0B |
ABS/RBA Deposit Stocks, Flows and Interest Rates (Reduced) |
APRA |
8.1.1.0.0 |
ARF 748.0A |
ABS/RBA Wholesale Funding Stocks, Flows and Interest Rates (Standard) |
APRA |
8.1.1.0.0 |
ARF 748.0B |
ABS/RBA Wholesale Funding Stocks, Flows and Interest Rates (Reduced) |
APRA |
8.1.1.0.0 |
B1 |
Statements of Financial Position - Assets |
MAS |
8.1.1.0.0 |
B1_1 |
Cash |
MAS |
8.1.1.0.0 |
B1_2 |
Cash and Balances, AR under Reverse Repos, NCD, Debt Securities, Equity Investments, Loans and Bills |
MAS |
8.1.1.0.0 |
B1_3 |
Unlisted Investments, Intangible Assets and Properties and Equipment |
MAS |
8.1.1.0.0 |
B2 |
Statements of Financial Position - Liabilities & Equity |
MAS |
8.1.1.0.0 |
B2_1 |
Deposits and Balances, Amounts Payable under Repurchase Agreements, Bills Payable, Negotiable Certificates of Deposit and Debt Securities |
MAS |
8.1.1.0.0 |
B2_2 Part I |
Deposits and Balances by Type and by Source of Non-Bank customers |
MAS |
8.1.1.0.0 |
B2_2 Part II |
Deposits by Size of Non-Bank Customers |
MAS |
8.1.1.0.0 |
B2_3 Part I |
Adjusted Capital Funds for Banks Incorporated Outside Singapore |
MAS |
8.1.1.0.0 |
B2_3 Part II |
Capital Funds and Adjusted Capital Funds for Foreign-Owned Banks Incorporated in Singapore |
MAS |
8.1.1.0.0 |
B2_4 |
Reserves by Type |
MAS |
8.1.1.0.0 |
B3_1 |
Contingent Liabilities |
MAS |
8.1.1.0.0 |
B3_2 Part I |
Commitments |
MAS |
8.1.1.0.0 |
B3_2 Part II |
Commitments |
MAS |
8.1.1.0.0 |
B3_4 Part I |
Financial Derivatives by Type and Risk Category (trades booked in Singapore) |
MAS |
8.1.1.0.0 |
B3_4 Part II |
Financial Derivatives by Type and Risk Category (Singapore as trading location) |
MAS |
8.1.1.0.0 |
B3_4 Part III |
Financial Derivatives by Type and Risk Category (Standalone and Consolidated levels) |
MAS |
8.1.1.0.0 |
B3_5 |
Assets Under Management and Assets Held Under Custody |
MAS |
8.1.1.0.0 |
B3_6 |
Assets Pledged |
MAS |
8.1.1.0.0 |
B3_7 |
Structured Entities |
MAS |
8.1.1.0.0 |
C1_1 |
Assets and Liabilities by Bank Counterparty, Related Banks and Related Corporations |
MAS |
8.1.1.0.0 |
C1_2 |
Interbank Indebtedness by Counterparty in Singapore |
MAS |
8.1.1.0.0 |
C1_4 |
Related Banks in Singapore |
MAS |
8.1.1.0.0 |
C1_5 |
Related Corporations in Singapore |
MAS |
8.1.1.0.0 |
C1_6 Part I |
Related Banks outside Singapore |
MAS |
8.1.1.0.0 |
C1_6 Part II |
Related Corporations outside Singapore |
MAS |
8.1.1.0.0 |
D1 |
Assets, Contingent Items and Commitments by Country/Jurisdiction and by Counterparty - All Currencies (Ultimate Risk) |
MAS |
8.1.1.0.0 |
D2_1 |
ASSETS, CONTINGENT ITEMS AND COMMITMENTS BY COUNTRY/JURISDICTION AND BY COUNTERPARTY - IMMEDIATE BORROWER PART 1 |
MAS |
8.1.1.0.0 |
D2_2 |
ASSETS, CONTINGENT ITEMS AND COMMITMENTS BY COUNTRY/JURISDICTION AND BY COUNTERPARTY - IMMEDIATE BORROWER PART 2 |
MAS |
8.1.1.0.0 |
D2_3 |
ASSETS, CONTINGENT ITEMS AND COMMITMENTS BY COUNTRY/JURISDICTION AND BY COUNTERPARTY - IMMEDIATE BORROWER PART 3 |
MAS |
8.1.1.0.0 |
D3_1_1 |
PART I: ASSETS AND CONTINGENT ITEMS BY SECTOR (All Currencies) |
MAS |
8.1.1.0.0 |
D3_1_2 |
PART II: ASSETS AND CONTINGENT ITEMS BY SECTOR (BY RESIDENCY) |
MAS |
8.1.1.0.0 |
D3_1_3 |
PART III: ASSETS AND CONTINGENT ITEMS FOR TREASURY CENTRES (All Currencies) |
MAS |
8.1.1.0.0 |
D3_2_1_2 |
ASSETS AND CONTINGENT ITEMS BY PURPOSE |
MAS |
8.1.1.0.0 |
D3_2_3_4_5 |
ASSETS AND CONTINGENT ITEMS BY PURPOSE - PROJECT FINANCE |
MAS |
8.1.1.0.0 |
D4_1 |
LIABILITIES BY COUNTRY/JURISDICTION AND BY COUNTERPARTY - PART 1 |
MAS |
8.1.1.0.0 |
D4_2 |
LIABILITIES BY COUNTRY/JURISDICTION AND BY COUNTERPARTY - PART 2 |
MAS |
8.1.1.0.0 |
D5 |
RMB BUSINESS ACTIVITIES |
MAS |
8.1.1.0.0 |
E_1 |
Classification and Fair Value Measurements of Assets and Liabilities |
MAS |
8.1.1.0.0 |
E_2 |
Statement of Financial Position, Contingent Liabilities, Commitments, Derivatives and Other Items (Islamic Banking) |
MAS |
8.1.1.0.0 |
E_3 |
Asset Ageing Analysis by Counterparty and by Purpose |
MAS |
8.1.1.0.0 |
F_1 |
Assets by MAS Notice 612/1005 Classification and by Country/Jurisdiction |
MAS |
8.1.1.0.0 |
F_2 |
Classified Assets by Sector, Purpose and Counterparty |
MAS |
8.1.1.0.0 |
F_3 |
Classified Assets by Sector and by Country/Jurisdiction |
MAS |
8.1.1.0.0 |
G_1 |
Interest Rate Repricing (All Currencies) |
MAS |
8.1.1.0.0 |
G_2 |
Interest Rate Repricing (one form for each material currency) |
MAS |
8.1.1.0.0 |
H |
Real Property Loan to Value Ratio (For the Purchase of Real Property, and Loans Collaterised on Real Property) |
MAS |
8.1.1.0.0 |
I_Part I |
Foreign Exchange Turnover - Spot, Forwards, FX Swaps, Currency Swaps, Over the counter (OTC) Options, Exchange-traded Options and Currency Futures |
MAS |
8.1.1.0.0 |
I_Part II |
Interest Rate Derivatives Turnover - Forward Rate Agreements, Overnight Indexed Swaps, Other Swaps and OTC Options |
MAS |
8.1.1.0.0 |
J |
Selected Statistics for Reporting Period |
MAS |
8.1.1.0.0 |
K |
Deposit rate of Singapore Dollar Denominated Deposits for Non-Banks |
MAS |
8.1.1.0.0 |
L_1 |
Covered bonds held |
MAS |
8.1.1.0.0 |
L_2 |
Covered bonds issued |
MAS |
8.1.1.0.0 |
M |
Notes to Reporting Forms |
MAS |
8.1.1.0.0 |
RCA III |
RWA |
RBI |
8.1.1.0.0 |
RCA III |
Regulatory Capital-Basel |
RBI |
8.1.1.0.0 |
RCA III |
CR On BS excl. Sec. (S) |
RBI |
8.1.1.0.0 |
RCA III |
CR on BS Sec. |
RBI |
8.1.1.0.0 |
RCA III |
CR Off BS Sec. |
RBI |
8.1.1.0.0 |
RCA III |
CR on BS ReSec. |
RBI |
8.1.1.0.0 |
RCA III |
CR NMR Off BS |
RBI |
8.1.1.0.0 |
RCA III |
CR MR Off BS |
RBI |
8.1.1.0.0 |
RCA III |
Failed Transaction |
RBI |
8.1.1.0.0 |
RCA III |
CCR |
RBI |
8.1.1.0.0 |
RCA III |
CR QCCP |
RBI |
8.1.1.0.0 |
RCA III |
Market Risk |
RBI |
8.1.1.0.0 |
RCA III |
Operation Risk |
RBI |
8.1.1.0.0 |