Download Reports Batch User Manual

Reports
Table of Contents
1.
ABOUT THIS MANUAL................................................................................................................................ 1-1
1.1
1.2
1.3
1.4
1.5
2.
INTRODUCTION ........................................................................................................................................... 1-1
AUDIENCE .................................................................................................................................................. 1-1
ORGANIZATION .......................................................................................................................................... 1-1
CONVENTIONS USED IN THIS MANUAL ....................................................................................................... 1-1
GLOSSARY OF ICONS .................................................................................................................................. 1-1
RETRIEVING INFORMATION IN ORACLE FLEXCUBE ..................................................................... 2-1
2.1
INTRODUCTION ........................................................................................................................................... 2-1
2.1.1
Generating reports............................................................................................................................. 2-1
2.1.2
Specifying the Output of a Report ...................................................................................................... 2-1
2.1.3
Contents of the report ........................................................................................................................ 2-2
2.2
MAINTAINING PRINTER .............................................................................................................................. 2-2
2.2.1
Maintaining Report Spool Path ......................................................................................................... 2-4
2.3
VIEWING MESSAGES FOR UNAUTHORIZED CONTRACTS ............................................................................. 2-4
3.
REPORTS BATCH ......................................................................................................................................... 3-1
3.1
REPORT BATCH MAINTENANCE.................................................................................................................. 3-1
3.2
REPORT BATCH EXECUTION ....................................................................................................................... 3-1
3.2.1
Viewing Reports ................................................................................................................................. 3-2
3.2.2
Printing / Spooling the Reports.......................................................................................................... 3-3
4.
RBI REGULATORY REPORTS ................................................................................................................... 4-1
4.1
INTRODUCTION ........................................................................................................................................... 4-1
4.2
MAINTAINING DATA ELEMENT DETAILS .................................................................................................... 4-1
4.3
VIEWING DATA ELEMENT DETAILS ............................................................................................................ 4-3
4.4
GENERATING REPORTS ............................................................................................................................... 4-4
4.5
BILL EVIDENCE FAILURE (BEF) REPORT ................................................................................................... 4-5
4.5.1
System Data Mapping for BEF Part I ................................................................................................ 4-5
4.5.2
System Data Mapping for BEF Part II .............................................................................................. 4-6
4.6
BASIC STATISTICAL RETURN 1 (BSR 1) STATEMENTS................................................................................ 4-7
4.6.1
System Data Mapping for BSR 1A ..................................................................................................... 4-8
4.6.2
System Data Mapping for BSR 1B ................................................................................................... 4-12
4.6.3
System Data Mapping for BSR 1 Summary ..................................................................................... 4-13
4.7
BASIC STATISTICAL RETURN 2 (BSR 2) STATEMENTS.............................................................................. 4-13
4.7.1
System Data Mapping for BSR 2 Part I ........................................................................................... 4-14
4.7.2
System Data Mapping for BSR 2 Part II .......................................................................................... 4-15
4.7.3
System Data Mapping for BSR 2 Part III ........................................................................................ 4-17
4.7.4
System Data Mapping for BSR 2 Part IV ......................................................................................... 4-19
4.7.5
System Data Mapping for BSR 2 Part V .......................................................................................... 4-21
4.8
BASIC STATISTICAL REPORT 3 (BSR 3) STATEMENTS .............................................................................. 4-22
4.8.1
System Data Mapping for BSR 3 ..................................................................................................... 4-22
4.9
MATURITY AND POSITION (MAP) REPORTS ............................................................................................. 4-23
4.9.1
System Data Mapping for MAP ....................................................................................................... 4-24
4.10 INTEREST RATE SENSITIVITY (SIR) REPORTS ........................................................................................... 4-29
4.10.1
System Data Mapping for SIR.......................................................................................................... 4-29
4.11 RETURN 13 – FORM VIII .......................................................................................................................... 4-33
4.11.1
System Data Mapping for Return 13 – Form ................................................................................... 4-33
4.12 R-RETURN – FET-ERS REPORTING.......................................................................................................... 4-41
4.12.1
R-Return User Intreface Workflow .................................................................................................. 4-43