Home

Reports Batch User Manual

1. Fisheries Others Number of accounts The outstanding balance Total Number of accounts The outstanding balance The report displays number of accounts disbursed amount and the balance outstanding under E term loans classified according to purpose They are e Minor irrigation e Reclamation development e Tractors implements e Plantations e Other term loans Total Minor irrigation Reclamation development Tractors implements Plantations Other term loans The total for the number of accounts and the amount of the various purposes is displayed in the Total field of the report The following table gives the details of number of accounts disbursed amount and the balance outstanding under E Term loans Columns Description Conditions E Term loans classified according to purpose Disbursement During the The number of accounts and Account must be open and 4 91 ORACLE Columns Description Conditions Year amount is displayed must have a balance Balance Outstanding The number accounts and The number of accounts and amount is displayed amount is displayed for Disbursed and balance outstanding in the year 4 23 Special Return lll Disbursal of Advances to Priority Sectors The Special Return III statement which is a bank wise report is forwarded by authorized dealers to RBI annually on the last reporting Friday o
2. Vostro Column Bank Private Exchange Operati House on Name Place and This is the Name place This is the Name Place Country of the bank and country of the Banks and country of the Private branch or Exchange House correspondent Opening Balance This is the Closing This is the Closing balance of the previous balance of the Previous 4 49 ORACLE Vostro Column Bank Private Exchange Operati House on Vostro Cover page Vostro Cover page 3A Transaction with Sum of all bill Sum of all bill transactions Public Imports transactions below 5 below 5 lakhs are Below 5 lakhs lakhs are displayed displayed Credit to Credit to Vostro in BC Vostro in BC 3B Transaction with Sum of all Bill Sum of all Bill Public Imports 5 transactions equal to or transactions equal to or lakhs and above above 5lakhs are above 5lakhs are displayed Credit to displayed Credit to Vostro in BC Vostro in BC 4A Transaction with Sum of all other Sum of all other Public Others transactions below transactions below Below 5 lakhs 5lakhs Credit to Vostro 5lakhs Credit to Vostro in in FT and other Modules FT and Other Modules 4B Transaction with Sum of all credits equal Sum of all credits equal or Public Others 5 or more than 5 lakhs more than 5 lakhs Credit lakhs and above Credit to Vostro in FT to Vostro in FT and Other and Other Modules Modules 5 Funding Sum of funding Sum of funding Transac
3. 13 a Amount in cash deposited with RBI by Banking company incorporated outside India under section 11 2 of the Banking Regulation Act 1949 LCY Balance for the GLs maintained under CASH_DEP_RBI_GL 13 b Cash in hand or in case of a non scheduled Bank excess of 9 over 8 if any show against 10 excess of 9 over 8 if any show against 10 Derived value 9 8 13 c Excess balance if any show against 12 c above Derived value 13 d Net balance in current account maintained by a scheduled bank 4 above Derived value 13 e Balances maintained by a RRB in call or fixed deposit with its Sponsor bank LCY Balance for the GLs maintained under RRB_GL 13 f Gold value at a rice not exceeding the market price Manual Entry 13 g Unencumbered approved securities valued on the basis of the method of valuation determined by RBI Manual Entry 13 h Approved securities deposited with RBI by a Banking company incorporated Manual Entry 4 40 ORACLE S No Columns Description Conditions outside India under section 11 2 of the Banking regulation act 1949 valued on the basis of method of valuation determined by RBI Total of 13 a to13 Total of 13 a to13 h Manual Entry h 14 13 11 Total of 13 a t013 h 14 Manual Entry 4 12 R Return FET ERS Repo
4. Account_Class_ Data_Ele ment and Gl_Data_Element will be provided to include and exclude the Account Classes and GL s respectively 3 4 Certificate of deposits Sum of LCY balance of GL COD gets updated COD GL must be maintained as data element Borrowings Label 4 1 Call and Short Notice Sum of LCY balance of Call Money Borrowing GL s and credit balance of Nostro GLs Data Element for GL s and Data Elements to provide Percentage for all the buckets 4 2 Inter Bank Term Sum of LCY balance From MM contract Inter Bank borrowings is maintained as a product 4 3 Refinances REFINANCES PRODUC TS should be maintained as a Data Element From MM contract 4 4 Others Specify Sum of LCY balance Based on the Other Borrowing GL maintenance in the Data Element maintenance 4 60 ORACLE S Name Head of FCUBS Data Conditions No Accounts 5 Other Liabilities amp Label Provisions 5 1 Bills Payable It is the sum of LCY balance of Bills due amount from contract 5 2 Provisions It is the sum of LCY balance Provision GLs must be outstanding of the Provision GLs maintained as data element 5 year bucket 5 4 Others Sum of LCY balance of Interest Interest Accrued GLs Accrued GLs must be maintained as data element Only above 5 years time bucket gets filled Items not representing cash payables i e income received
5. Current which has a balance 2 Sum of LCY balance of the Current Deposit GL s The GLs are Redemption GLs Collection Account GL Unclaimed Deposit GL Credit Balance GL Matured Deposit GL In operative account GL Gold Auction balance The Current Deposit GLs must be maintained as data element In the Day 1 2 7 days and 8 14 days time buckets depending upon the experience and estimates of banks and the core portion may be placed in over 1 3 years bucket Account_Class_Data_Ele ment and GI_Data_Element will be provided to include and exclude the Account Classes and GL s respectively 3 2 Savings Bank It is the sum of 1 and 2 Sum of Outstanding balance of CASA account Savings which has a balance Sum of LCY balance of Savings GL The Savings Deposit GLs must be maintained as data element Inoperative account GL must be maintained as a 4 59 ORACLE No Name Head of Accounts FCUBS Data Conditions like In operative account SB gets updated data element In the Day 1 2 7 days and 8 14 days time buckets depending upon the experience and estimates of banks and the core portion may be placed in over 1 3 years bucket 3 3 Term Deposits It is the sum of 1 and 2 1 Sum of LCY Balance of TD accounts principal component 2 Sum of LCY Balances of the following Manual GLs gets updated Manual GL must be maintained as data element
6. The data extraction is branch wise for the all files except URS6 In URS6 RBI predefines the branches and the dates on which the fortnightly reports are required Priority Sector Advances PSA Reports The PSA Report which is a bank wise report is forwarded by the banks to RBI on a half yearly basis The data with respect to the number of accounts and outstanding that occurred in the BC CASA and CL modules is maintained in the system The priority sector wise number of accounts and amount disbursed including for those of weaker sections is extracted based on the UDFs maintained in the system You can generate the report using MIS Date and Bank as the search criteria Following are the 2 parts of a PSA report e PartI displays the number of accounts limits sanctioned balance outstanding for various priority sections and the number of accounts and balance outstanding for the weaker sections e Part Il displays the number of accounts limits sanctioned and balance outstanding for weaker sections like SC ST women and other categories under the weaker sections on the basis of amount of advance and net position reported in Part of the PSA report System Data Mapping for PSA Report Part PSA report Part 1 records the date based on the following classification e Priority Sector the priority sector UDF ACTIVITY_OCCUPATION is captured at the transaction level e Weaker Sections th
7. DLIAB_RD_GL LCY Balance for the GLs maintained under DLIAB_TELEGRAPHIC_T RNF_GL 4 34 ORACLE S No Columns Description Conditions LCY Balance for the GLs maintained under DLIAB_MAIL_TRNF_GL LCY Balance for the GLs maintained under DLIAB_DEMAND_DRAFT _GL LCY Balance for the GLs maintained under DLIAB_UNCLAIMED_TD_ GL LCY Credit Balance for the GLs maintained under DLIAB_CASH_CREDIT_G E LCY Balance for the GLs maintained under DLIAB_DEP_AS_SECURI TY_GL 1b Time Liabilities those which are payable LCY Balance for the GLs otherwise than on demand maintained under that include fixed deposits TLIAB_TD_GL y LCY Balance for the GLs 9 maintained under deposits time liabilities TLIAB CASH CERT GL portion of savings bank deposits staff security LCY Balance for the GLs deposits margin held maintained under against letters of credit if TLIAB_RD_GL not payable on demand lara held lias ann oe Gls for advances which are not s payable on demand and TLIAB SB_DEP GL Gold deposits LCY Balance for the GLs maintained under TLIAB_STAFF_SEC_DEP GL LCY Balance for the GLs maintained under TLIAB_LC_GL LCY Balance for the GLs maintained under TLIAB_DEP_AS_SECURI TY_GL LCY Balance for the GLs maintained under TLIAB_GOLD_DEP_GL 4 35 ORACLE S No Columns Description Cond
8. 5b Balances in other Savings Deposits Loans LCY Balance for the GLs accounts with Banks and notified Financial Institutions maintained under SAV_AC_SBI_GL LCY Balance for the GLs maintained under SAV_AC_OTHERBANK_G L LCY Balance for the GLs maintained under TD_SBI_GL LCY Balance for the GLs maintained under TD_OTHERBANK_GL LCY Balance for the GLs maintained under LOAN_SBI_GL LCY Balance for the GLs 4 37 ORACLE S No Columns Description Conditions maintained under LOAN_OTHERBANK_GL 5c Money at call and Nostro GLs must be Sum of LCY balance of the short notice maintained as data Nostro GLs gets updated Semen LCY Balance for the GLs MM contract maintained under MONEY_SHORT_NOTICE _GL 5 d Advances to Loans OD LCY Balance for the GLs banks due from maintained under Banks INTER_BANK_LOAN_ GL 5 e Other Assets Other Assets GLs must be LCY Balance for the GLs maintained as data maintained under element OTHER_ASSETS_GL Total 5 Total of 5 6 Net balance in 5 a i 1 a i Derived value current accounts 5 a i 1 a i 7 Net Liabilities for 1 5 2 if is a plus figure Derived value the purpose of section 18 and 24 of regulation act 1949 Net Liabilities to Banking System Other demand and time liabilities 1 5 2 if is a plus figure Or 2 only if 1 5 isa minus fi
9. Conditions Pre Shipment Credit Rupee Credit Disbursed amount LCY balance Pre Rupee Credit Data in case of Loans outstanding is the Element created with with disbursement Outstanding balance l date between of loan EU aia E aeii And a Products P minimum date All Loans with Packing Credit Product set to Yes And in LCY PCFC Pre PCFC Data Element 4 70 ORACLE Columns shipment Credit in Foreign Currency Disbursement Balance Outstanding Conditions created with All Packing Credit products in Foreign Currency All Loans with Packing Credit Product set to Yes And in FCY Post Shipment Credit Rupee Credit Sum of Disbursed amount in case of bills with purchase discount date between maximum and minimum date Disbursed amount in case of Loans with disbursement date between maximum and minimum date Sum of LCY outstanding balance of bill LCY balance outstanding is the Outstanding balance of loan Post Rupee Credit Data Element created with Export Bill products and Export Bill Rupee Advance products that are linked to a Loan Product All Active Loans linked to Bills and Bills have LCY Advancing set to Yes And Loan in LCY EBR Rediscounting of Export Bills Abroad Scheme Disbursed amount in case of bills with purchase discount date between maximum and minimum date LCY balance outstanding is
10. Maturity and Position MAP Reports The MAP statements which are branch wise reports are forwarded by authorized dealers to RBI assets and liabilities and their residual gap data with respect to the FX TD MM BC CL modules are maintained in the system You can then generate the MAP2 report using MIS Date and Bank as the search criteria The data extraction is based on the difference between the MIS date and the To date For the FX transaction the To date is the Liquidation date and for the TD MM BC and CL modules the To date is the Maturity date 4 23 ORACLE The only pre requisite for MAP reports is that the contract should be active The following details are available at the bottom of the report Name Name of the Authorized Official Designation Authorized Dealers Designation A D Code Authorized Dealers Code Address of Authorized Dealer Address of AD Place Place of Signing Date Date of signing 4 9 1 System Data Mapping for MAP The following table gives the system data mapping for MAP reports Field FCUBS Data Conditions A Off Balance Sheet Items Label a Items in the nature of Label Liabilities a 1 Merchant Sales Sum of Foreign Currency balance for FX Contracts Sell Deal Sell flag as S Sell leg is a FCY FX Product defined by Data Element Merchant Sales a 2 Inter Bank Sales If Buy Sell flag is Buy then
11. transaction reported the sequence number of the Record in earlier in Part of pravious REPS BEF statement Date of receipt Bill Entry Data In BOE subsystem BCDONBOE Remittance Bill Amount liquidated advanced In Contract Main tab Currency and amount Remittance amount Bill amount in LCY In Contract Main tab Rupee equivalent Remarks Bill Reference Number This is a remark with respect to the transaction record The user can also comment manually on the report Example Consider the following details Import Bill reference Number B1 Import Bill Date 12 May2009 Bill of exchange date commitment 15 May 2009 Liquidated Advanced 15 August 2009 Bill of Entry is not produced in the tenure June 2009 to Dec 2009 Bill of Entry is produced on Jan 2010 Import Bill reference Number B2 Import Bill Date 12 May2009 Bill of exchange date commitment 15 May 2009 Liquidated Advanced 15 August 2009 Bill of Entry is produced in the tenure June 2009 to Dec 2009 When the half yearly BEF report is taken as on Dec 2009 B1 will be reported in Part of the BEF report whereas B2 will not be produced as the Bill of Entry has been produced by B2 When the half yearly BEF report is taken as on June 2010 B1 will be reported in Part II of the BEF report since the Bill of entry was produced in the current half year and the Bill of exchange date 90 days 4 6 Basic Statistical Return 1
12. 4 19 1 System Data Mapping for Advances to Minority Communities Report Part A osses 4 82 4 19 2 System Data Mapping for Advances to Minority Communities Reportl Part B o oo 4 82 4 19 3 System Data Mapping for Advances to Minority Communities Report 2 ccccsccesseseeereenteereees 4 83 4 20 FORM VIII RETURN 11 UNCLAIMED DEPOSITS ccccessssesessesseeenseseeecnseseeecnseseencnseseeecneeseeesnseaeensnaenees 4 84 4 20 1 System Data Mapping for Form VIII Return 11 wis eeccesccescceseeceeseeeseeeeeeeeeeeeeeecnsecesecnaecaaecaeeeaeeeseees 4 84 4 21 BALANCE HELD ABROAD BAL STATEMENTS ccsssccccesseececseceececsnceeceeaeeecssseeeeceeeeseesaeeessenaeeesseeeeenes 4 87 4 21 1 System Data Mapping for BAL 0 0 cceccceccecceecceeecesecesecesecnsecaeecaeecaeecseeeseeeceeseeeseeaeesaecaecaaesaeeeaeeeneees 4 87 4 22 SPECIAL RETURNI DISBURSAL OF CREDIT TO AGRICULTURE cccessssessssesseecsseseeeceesececnacsecessacnscesnaenees 4 89 4 22 1 System Data Mapping for Special Return 1 Section 1 w ceccecceeccescesseesseeseeseeeeecesecesecnsecuecseeeseeeneees 4 89 4 22 2 System Data Mapping for Special Return 1 Section 2 o cceccceccessesseessesceeeeeeecesecesecnsecneceeeaeeeneees 4 90 4 23 SPECIAL RETURN III DISBURSAL OF ADVANCES TO PRIORITY SECTORS ccccssccsssesscssseeseeeenseseeessaenees 4 92 4 23 1 System Data Mapping for Special Return ID cc ccccsccesccesecesecsseesseeeeeeeeseeeeseeseceseceaecaecaecaeeeneeeneees
13. Amount Outstanding Outstanding of the term deposits with the interest range 15 and Code No 511 above No of Accounts Total Count of the term deposits Code No 511 from 501 511 Amount Outstanding Total Outstanding of the term Code No 511 deposits from 501 511 4 7 4 System Data Mapping for BSR 2 Part IV The BSR 2 Part IV reports are used to obtain information on outstanding amount of term deposits as on the reference days of the return classified according to the size of deposits The deposit size is maintained as a data element The UDE is used to select the interest rate The data is classified as follows e Individual e Corporate e Total of individuals and corporate excluding deposits from banks Following are the details which include all types of non resident rupee and foreign currency deposits displayed for BSR 2 Part IV reports Field FCUBS Data Conditions 4 19 ORACLE Field FCUBS Data Conditions No of Accounts Count of the term deposits with the deposit less than Rs 25000 Code No 601 Amount Outstanding Outstanding of the term deposits with the deposit less than Rs 25000 Code No 601 No of Accounts Count of the term deposits with the deposit in the range Rs 25 000 amp above but less than Rs 1 lakh Code No 602 Amount Outstanding Outstanding of the term deposits with the deposit in the range of Rs 25 000 amp above but less than Rs 1
14. Oracle Financial Services Software Limited Oracle Park Off Western Express Highway Goregaon East Mumbai Maharashtra 400 063 India Worldwide Inquiries Phone 91 22 6718 3000 Fax 91 22 6718 3001 www oracle com financialservices Copyright 2007 2015 Oracle and or its affiliates All rights reserved Oracle and Java are registered trademarks of Oracle and or its affiliates Other names may be trademarks of their respective owners U S GOVERNMENT END USERS Oracle programs including any operating system integrated software any programs installed on the hardware and or documentation delivered to U S Government end users are commercial computer software pursuant to the applicable Federal Acquisition Regulation and agency specific supplemental regulations As such use duplication disclosure modification and adaptation of the programs including any operating system integrated software any programs installed on the hardware and or documentation shall be subject to license terms and license restrictions applicable to the programs No other rights are granted to the U S Government This software or hardware is developed for general use in a variety of information management applications It is not developed or intended for use in any inherently dangerous applications including applications that may create a risk of personal injury If you use this software or hardware in dangerous applications then you shall be r
15. Outstanding balance of loan EBR Data Element created with Post shipment Export Bill Rediscounted products both Sight amp Usance with operation in Purchase and Discount All Active bills that have Rediscount Date greater than Bill Shipment Date The amount of bills discounted rediscounted under EBR Scheme on without recourse basis 4 71 ORACLE 4 17 4 17 1 Columns Disbursement Balance Outstanding Conditions should be excluded from the balance outstanding Deferred Payments None None Deferred Data Element created with Deferred Products Note Currently these values are empty Other Govt None None Payments Other Product Data Element created with Other Products Note Currently these values are empty SJSRY and SGSY Reports The SURY and SGSY Monthly quarterly progress reports and half yearly recovery statement reports which are bank wise reports are forwarded by the banks to RBI Swarna Jayanti Shahari Rozgar Yojana SJSRY Reports The SJRY monthly quarterly progress reports and half yearly recovery statement reports which is a bank wise report are forwarded by the banks to RBI All the data with respect to the number of disbursed advanced and the outstanding amount in the CL module are extracted and maintained in the system You can generate the report using MIS Date and Bank as the search criteria Following are th
16. Term Deposits and element other placements and balances with eas other banks 4 Investments includ Sum of LCY balance of the Investment GLs must be ing those under security shares bonds debentures maintained as data Repos but and investment GLs gets updated element excluding Reverse Repos Mutual Funds 1 Day bucket 5 Advances Label 4 63 ORACLE S Name Head of System Data Conditions No Accounts 5 1 Bills It is the sum of Bills are Operation Purchased and f Discount Purchase Discounted Sum of Purchase amount sum o including bills Liquidated amount in LCY for FCY Purchased GL must be inder DUPN Bill Balance outstanding Unlinked maintained as data FX Rate of the Bill element Sum of Purchase amount sum of Liquidated amount in LCY for other bills in LCY 5 2 Cash Credits It is the sum of 1 and 2 The GLs must be and Loans Sum of Outstanding balance of maintained as data repayable on GAGA cans whose account is element It contains demand Open and not liquidated Advance GL Sum of LCY balance of Temporary Others GL Overdraft GL Advance GL AND Other s GL Suit CASA GL Over 1 3 years bucket 5 3 Term Loans Sum of Outstanding Amount of The Term Loan is Loans where account is not retrieved from the liquidated and 6 NPAs Advances It is the sum of For the account balance and Investments Asset Classification code LCY balance of Other s GLs gets must not in 1
17. amp above but less than 1 4 21 ORACLE 4 8 4 8 1 year No of Accounts Count of the term deposits with the Code No 706 maturity period as 1 year amp above but less than 3 years Amount Outstanding Outstanding of the term deposits Code No 706 with the maturity period as 1 year amp above but less than 3 years No of Accounts Count of the term deposits with the Code No 707 maturity period as 3 years amp above but less than 5 years Amount Outstanding Outstanding of the term deposits Code No 707 with the maturity period as 3 years amp above but less than 5 years No of Accounts Count of the term deposits with the Code No 708 maturity period as 5 years amp above Amount Outstanding Outstanding of the term deposits Code No 708 with the maturity period as 5 years amp above No of Accounts Sum of the accounts referring to Code No 700 code nos 701 708 Amount Outstanding Outstanding of the accounts Code No 700 referring to code nos 701 708 Basic Statistical Report 3 BSR 3 Statements The BSR 3 statements which are bank wise reports are forwarded by banks to RBI on a monthly basis last Friday of every month The disbursement details of all the active contracts in the CL CASA and BC modules are maintained in the system You can then generate the BSR 2 report using MIS Date and Bank Code as the search criteria The data extraction is d
18. gt 12 or lt 36 of above 1 year and upto and Mod le is Loan inclusive of 3 years Loan Product is not a Packing Credit product 5 2 Long Term Loans i e loans and 42 Months between the maturity date and advances granted for a period value date of the account is gt 36 above d Yeats Module is Loan Loan Product is not a Packing Credit product 6 Packing credit 50 If the loan product is a Packing Credit Product all export pre shipment finance 4 10 ORACLE S Type of Account Code Conditions No under any type of facility should be coded as packing credit 7 Export bills purchased 61 If the bill product is an Export Sight product with Operation as Purchase 8 Export bills discounted 62 If the bill product is an Export Usance product with Operation as Discount 9 Export bills advanced against 63 Export Bill Advanced Data Element is defined to have Export Bill Rupee Advance Manual liquidation Payment method as D Loan product 10 Advance against Export cash 64 Duty Drawback Data Element with Duty incentives and Duty draw back Drawback Loan products claims 11 Inland bills purchased 71 Outward Export Sight Bills with Operation as Purchase Inland bills purchased can be defined as data Element to restrict to Inland bills Purchased 12 Inland bills discounted 72 Outward Export Usance Bills with Operation as Discount Inland bills discounted can be defined as data
19. 4 92 4 24 DRT STATEMENTS SUIT FILED AND DECREED ssssccceessececsessececsnceecessaeeecseneeeecseeeesesuececsesaeeesseeeeees 4 92 4 24 1 System Data Mapping for Suit Filed and Decreed cccsccesceseesseeseeeeeeeeeeceeecesecnsecaeceaecaaeeaeeeneees 4 93 4 25 PMR Y REPORTS ose neoe e erae REEN REE E AE EE E A OEA E EEE EEE T 4 93 4 25 1 System Data Mapping for PMRY Reports Monthly Progress sossessseseeeeeseeereereresrrrresrsreeee 4 94 4 25 2 System Data Mapping for PMRY Reports Quarterly Progress ccccccccsseesceseceseceecnsetnseeeeeneees 4 95 4 25 3 System Data Mapping for PMRY Reports Half yearly Recovery 4 98 4 26 STATEMENT OF ADVANCES TO AGRICULTURE ccccsssssessessescssesseecseseeecsseseeecnaeseeecssesseesnaeaeeesnaeaeeesnaenees 4 99 4 26 1 System Data Mapping for Advances to Agriculture Part A scccccsscescsesseeesceeecesecnsecusecneeaeeeseees 4 99 4 26 2 System Data Mapping for Advances to Agriculture Part Bo eccceccescesceeseeceeeeeetecenecesecnseeaetaas 4 100 5 ANNEXURE A USER DEFINED FIELDS AND DATA ELEMENTS ccscsscsssssssscssssesscsnsesesessseeees 5 1 ORACLE 1 About this Manual 1 1 Introduction This manual lists the details of various reports that you can generate for all the modules of Oracle FLEXCUBE 1 2 Audience This manual is intended for the Customer Service Representatives CSRs and staff in charge of retrieving information for the various tra
20. 7 1 System Data Mapping for BSR 2 Part The BSR 2 Part reports are mainly used to obtain information from each office on the deposits classified according to type The additional information on female accounts is also collected in Part The inter bank deposits are also separately reported here The data is classified as follows e Individual e Corporate e Total of individuals and corporate excluding deposits from banks Following are the details which include all types of non resident rupee and foreign currency deposits displayed for BSR 2 Part reports Field FCUBS Data Conditions No of Accounts Count of the Current accounts Amount Outstanding Outstanding amount of all the current accounts Code No 201 all Current accounts Code No 301 current account held by Females No of Accounts Count of the Savings accounts Amount Outstanding Outstanding amount of all the savings accounts Code No 202 all Savings accounts Code No 302 current account held by Females No of Accounts Count of the term deposit accounts Code No 203 all term deposits 4 14 ORACLE Field FCUBS Data Conditions Amount Outstanding Outstanding amount of all Code No 303 current account held by accounts Amount Outstanding Total Outstanding amount of the current savings and term deposit accounts the term deposit accounts Females Total Co
21. BSR 1 Statements The BSR 1 statements which are branch wise reports are forwarded by authorized dealers to RBI on a yearly basis Data from BC CASA and CL modules are extracted and maintained in the system You can then generate the BSR 1 report using MIS Date and Branch as the search criteria 4 7 ORACLE Following are the two parts of a BSR 1 report e BSR1 A relates to accounts with individual credit limits of over Rs 2 Lakh e BSR1B consists of consolidated information on the occupation wise totals of accounts with individual credit limits of Rs 2 lakhs and less The following values are defaulted in BSRI reports e Name of the bank e Name and address of the branch e Uniform Branch Code 4 6 1 System Data Mapping for BSR 1A The pre requisites for data population in BSR 1A reports are as follows e The modules are BC and CL e For BC module the account is active e The limit amount is greater than 200000 e The account outstanding balance is greater than or equal to zero If the outstanding balance is zero then a hyphen should be mentioned e Closed accounts are not reflected Following are the details displayed for BSR 1A reports which includes the total of the credit limit outstanding and accounts Report Item FCUBS Data Conditions Name of the Bank This is the name of the Bank Report Header Name and address of AD branch This is the name of the Branch reporting
22. Browser is detailed in the Common Procedures manual You can specify the destination of the report you want to generate The options available are e Print The report will be printed directly on to a printer of your choice e View The details of the report will be displayed on the screen e Spool The details of the report will be stored in a spool file and can be printed later Print At If you choose the Print option indicate the location of printing by choosing one of the following values e Client e Server Printer Specify the printer details Printer From the option list select the name of a printer defined in the Printer Maintenance table The report will be printed on this printer 2 1 3 Contents of the report The contents of the report are discussed under the following heads Header The Header section of the report carries the title of the Report information on the User who generated the report the branch code the date and time and the page number of the report Body of the report The actual contents of the report are displayed in this section It is detailed for each report in the subsequent sections of this document 2 2 Maintaining Printer In Oracle FLEXCUBE you can maintain the printers for the reports using Printer Maintenance screen You can invoke this screen by typing RPDRNMNT in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow
23. Element to restrict to Inland bills discounted 13 Advances against import bills 80 Import Bill Crystallization Loan data element to be defined for Import Bill Crystallization Loan Products 14 Foreign Currency Cheques 90 Foreign Cheque Purchase Bill products TCs DDs TTs MTs purchased Clean Export Sight Bills not under LC and operation as Purchase Foreign Outward Remittance FT product If the account type is not in the above conditions then Type of Account code is defaulted as 30 ORACLE The UDF ORGSUBTYPE is used to identify the organization code The following table the asset classification codes for the borrowal account S Organization Code Conditions No 1 Standard Assets 01 This is based on the user defined status field for the contract 2 Sub standard 02 Assets 3 Doubtful Assets 03 4 Loss Assets 04 4 6 2 System Data Mapping for BSR 1B The pre requisite for data population in BSR 1B reports is that the account status for CL accounts should not be Closed Liquidated Reversed and on Hold Following are the details displayed for BSR 1A reports Report Item FCUBS Data Conditions No of accounts Number of accounts Credit Limit The credit limit sanctioned Amount outstanding Additional value populated other than all occupations Sum of LCY balance of advance GL s Festival Advance Interest Free Rent Advance Manual Cheques Purc
24. Form A special return Section 42 2 as on 3ist March of the survey year Basic Statistical Return 2 BSR 2 Statements The BSR 2 statements which are branch wise reports are forwarded by authorized dealers to RBI on a yearly basis The data with respect to the number of accounts and outstanding which occur in the CASA and TD modules are maintained in the system You can then generate the BSR 2 report using MIS Date and Branch as the search criteria Following are the five parts of a BSR 2 report Part l Classification of Deposits according to Type 4 13 ORACLE e Part Il Classification of Term Deposits according to Original Maturity e Part Il Classification of Term Deposits according to Interest Rate Range e Part IV Classification of Term Deposits according to Size e Part V Classification of Term Deposits according to Residual Maturity The only pre requisite for data population in BSR 2 reports is that all the accounts should be in Open status All the deposits in the TD and CASA modules are maintained in the system The BSR 2 report contains details on the number of accounts amount outstanding and their totals based on the following account categories e Individual e Other accounts Corporate excluding deposits from banks The report also contains the following details e Name of the bank e Name and address of the branch e Uniform Branch Code the first 7 digits for the AD code 4
25. The disbursed amount of loans gets displayed 5 DWCUA Label 5 1 Subsidy amount No values currently filled disbursed 5 2 No of applications No values currently filled Pending 5 3 No of applications No values currently filled Rejected 4 17 1 3 System Data Mapping for SJSRY Half yearly Recovery Report The following table contains the recovery report details on the state wise amount classification based on the Demand Recovery over dues and percentage recovered for both USEP and DWCUA S No Columns Description State District is maintained as UDF State will be derived from the Data store la Demand The Principal due from the customers under the USEP category 2a Recovery The amount recovered under the USEP category Limit sanctioned Outstanding 3a Overdue The amount outstanding post the due date in Loans under USEP category 4a Recovery Demand Derived value of 1a and 2a 1b Demand The Principal due from the customers under the DWCUA category 2b Recovery The amount recovered under the DWCUA category Limit sanctioned Outstanding 3b Overdue The amount outstanding post the due date in Loans under DWCUA category 4 75 ORACLE S No Columns Description 4b Recovery Demand Derived value of 1b and 2b 4 17 2 Swarnajayanti Gram Swarozgar Yojana SGSY Reports The SJRY monthly quarterly progress reports and half yearly recovery statement report
26. a data element The data is classified as follows e Individual e Corporate e Total of individuals and corporate excluding deposits from banks Following are the details which include all types of non resident rupee and foreign currency deposits displayed for BSR 2 Part IV reports Field FCUBS Data Conditions No of Accounts Count of the term deposits with the Code No 701 maturity period as 1 14 days Amount Outstanding Outstanding of the term deposits Code No 701 with the maturity period as 1 14 days No of Accounts Count of the term deposits with the Code No 702 maturity period as 15 28 days Amount Outstanding Outstanding of the term deposits Code No 702 with the maturity period as 15 28 days No of Accounts Count of the term deposits with the Code No 703 maturity period as 29 90 days Amount Outstanding Outstanding of the term deposits Code No 703 with the maturity period as 29 90 days No of Accounts Count of the term deposits with the Code No 704 maturity period as 91 days amp above but less than 6 months Amount Outstanding Outstanding of the term deposits Code No 704 with the maturity period as 91 days amp above but less than 6 months No of Accounts Count of the term deposits with the Code No 705 maturity period as 6 months amp above but less than 1 year Amount Outstanding Outstanding of the term deposits Code No 705 with the maturity period as 6 months
27. about the various events in the life of a specific contract or across contracts at a specific point in time You can have analysis reports daily reports exception reports reports on events that ought to have taken place on the contract but have not due to various reasons history reports and so on A set of report formats is pre defined for every module 2 1 1 Generating reports From the Application Browser select the Report option The system displays a list of all the modules to which you have access rights Each module contains a list of all reports that you can access Select the report that you want to generate The system displays a screen where you can set the filters for the reports to be generated Set the filters and click OK button to generate the report To cancel the operation click Exit button 2 1 2 Specifying the Output of a Report You can set your preferences as to the output of a report The Print Options screen x EJ Format Output Output Print View Spool PrintAt Client Server Printer Printer z In Oracle FLEXCUBE you may generate a report in three formats e HTML e RTF e PDF e Excel 2 1 ORACLE Output You can direct a report to one of the following destinations e The printer e On line e Stored as spool files and printed later using the spool The reports that have been spooled can be printed or viewed through the Reports Browser screen The Reports
28. button Z Data Element Maintenance Webpage Dialog Report ID Report Description Data Element Details Element id Element Description Entity id Query Operator Data Element Values Serial Number Element Values Description Maker I Authorized Checker H Open Specify the following Report ID System displays a unique id for the report Alternatively you can select a report id from the adjoining option list Report Description System displays a brief description of the report maintained 4 1 ORACLE Element Id System displays a unique ld for the element Element Description System displays a brief description of the element maintained Report ID Report Description Element Id and Element Description are factory shipped values Data Element Details Element Id System displays the element id maintained Element Description System displays a brief description of the element id maintained Entity Id System populates a unique id for the entity Query System displays the query Operator Select an operator from the adjoining drop down list This list displays the following values e Include e Exclude e Equal To e Greater Than e Greater Than or Equal To e Less Than e Less Than or Equal To e None Select the Include or Exclude options for more than one record For the remaining options only one data element value can be provided By de
29. button 2 2 ORACLE ze Printer Maintenance Web Page Dialog 2 xi Printer Printer Id 01 Printer Name KYOCERA Branch CHO Printer Roles ag Printer Users F T Role Identification E iO User Id EJ I abMin 33 7 ABHI 2 Input By ELIZA3 Date Time Modification Number Iv Open Authorized By Date Time I Authorized Here you need to specify the following details Printer ID Specify a unique printer ID This ID will be used to identify the printer Printer Name Specify the name of the printer Branch The system defaults the current branch code However you cannot modify this Printer Roles Identify the user who can use the printer You can add more rows to the list of roles using Add icon Select appropriate role from the option list Printer Users Identify the users who can use the printer You can add more rows to the list of roles using Add icon Select the user from the option list Once you have captured the details click Save icon to save the maintenance The system makes the printer available for the selected roles to the users maintained Further if you choose to print a report the system will send the reports for print as per the options specified 2 3 ORACLE 2 2 1 Maintaining Report Spool Path You can maintain a location to spool the reports for a specific branch using Reporting System Parameters screen You can invoke this screen by typ
30. fetch records e Authorization Status e Branch e Record Status Select any or all of the above parameters for a query and click Search button The records meeting the selected criteria are displayed System displays the following details pertaining to the fetched records e Authorization Status e Record Status e Branch e Branch Description 4 45 ORACLE 4 12 4 Viewing the R Return Nostro Cover Page Data Extraction Logic The file data is extracted using the schedule and purpose code mapping You can edit the Nostro cover page data that has been extracted based on the data mapping and extracting logic You can view the extracted data for the Nostro cover page using the R Return Extracted Data summary screen You can invoke this screen by typing MDSRRETQ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button e R Return Extracted Data Summary Webpage Dialog Authorization Status ecord Status Transaction Date Serial Number Bill Number To Date Q Search Advanced Search Records per page 15 v 3 x Lock 1 or 4 Authorization Status Record Status Transaction Date Serial Number Bank Reference Number Currency Nostro Vostro Indicator Vostro C All the records in this screen have to be authorized manually During extraction if any record is un authorized system gives an alert message and extraction will not be possible You can query the records with
31. in advance etc may be placed in over 5 years bucket 6 Lines of credit Label The Classification is based on the Customer 6 1 Institutions Facility defined for Corporate Type customers 6 2 Customers Facility defined for Individual Based on the facility and customers the maturity date Term Loans are maintained as UDF 7 Un availed portion of For ODs sanctioned amount Account status is not Cash Credit Demand Loan component of Working Capital amount disbursed Cash Credit un utilized portion of the Facility closed liquidated reversed or hold Difference between Sanctioned amount and Outstanding balance must be gt 0 In all the buckets based on the outstanding as on the MIS date At the facility level UDF is maintained for Cash Credit Demand Loan component of Working 4 61 ORACLE S Name Head of FCUBS Data Conditions No Accounts Capital TYPE_OF _ACCOUNT UDF 8 Letters of Sum of Liability Outstanding In all the buckets based Credit Guarantees Amount in LCs and guarantees on the outstanding as on the MIS date 9 Repos Repos GLs should be maintained as a Data Element 10 Bills Sum of LCY balance of the Bill rediscounted DUPN overdue amount is considered 11 Swaps Buy Sell Sum of LCY balance of FX FX product Data Element itia t d Contracts must be maintained as maturing forwards d ta element Only for Purchase Buy le
32. maintained under ODTLIAB _ BANKINGSYS_GL LCY Balance for the GLs maintained under ODTLIAB _ PART_CERT_GL LCY Balance for the GLs maintained under ODTLIAB _ BLOCKED_AC_GL LCY Balance for the GLs maintained under ODTLIAB _ BILLS_MARGIN_GL LCY Balance for the GLs maintained under ODTLIAB _ GOLD_BORROW_GL Total 2 Total of 2 4 36 ORACLE S No Columns Description Conditions 3 Cash in Hand 24 per cent on their total 24 of Total 1 Total 2 net demand and time liabilities NDTL 4 Balances in Demand Liabilities include LCY Balance for the GLs current account all liabilities which are maintained under with Reserve bank payable on demand that CURR_AC_AT_RBI_GL include current deposits maintained in RBI 5 Assets in India Label with Banking System 5 a Balances in Label current account with 5 a i State bank of Assets with the banking LCY Balance for the GLs India subsidiary system include balances maintained under Banks and with banks in current CURR_AC_AT_SBI_GL Corresponding accounts with State New Banks bank of India subsidiary Banks and Corresponding New Banks 5 a ii Other Banks and Assets with the banking notified Financial system include balances Institutions with banks in current pcre cree Ag GLs accounts maintained in A Other Banks and notified ign AC_AT_OTHR_BA Financial Institutions
33. sum of Foreign Currency balance of contract else sum of Sold Amount for FX Contracts Either Buy Sell deal Sell leg is a FCY FX Product defined by Data Element Inter Bank Sales a 3 Overseas Sales If Buy Sell flag is Buy then sum of Foreign Currency balance of contract else sum of Sold Amount for FX Contracts Either Buy Sell deal Sell leg is a FCY The customer residence is outside India Data Element OVERSEAS_ SALES a 4 Sales to RBI If Buy Sell flag is Buy then sum of Foreign Currency balance of contract else sum of Sold If the customer is RBI Data Element SALES_TO_RBI SALES_TO_RBICUSTO 4 24 ORACLE Amount for FX Contracts MERS Either Buy Sell deal Sell leg is a FCY a 5 Currency Swaps Label a 5 1 Sales against INR If Buy Sell flag is Buy then sum of Foreign Currency balance of contract else sum of Sold Amount for FX Contracts Either Buy Sell Deal Sell leg is a FCY Bought Leg in INR FX Product defined by Data Element Sales against INR a 5 2 Cross Currency If Buy Sell flag is Buy then sum of Foreign Currency balance of contract else sum of Sold Amount for FX Contracts Either Buy Sell Deal Sell leg is a FCY Bought Leg is not LCY FX Product defined by Data Element Cross Currency a 6 Others Based on the LIABILITIES OTHERS _ GL maintenance in the Data Element maintenance Total To be i
34. the Data The AD Code is maintained as Branch level UDF Name of the Party The customer Name of the party of the advances is displayed in this field Account Number Displays the account number of the BC CL BC Bill ref No CL Loan Acc No The account number is appended with the Branch code District Code of the place of utilization of credit District code of the utilization credit is got from the UDF UTILIZED_DISTRICT details Population group code of the place of Population group of the utilization credit is got from the UDF POPCODE details This 4 8 ORACLE Report Item FCUBS Data Conditions utilization of credit is associated to every Branch Type of account Refer the Type of account table We will not code consider OD Organization code Refer the Organization Code table Occupation code Based on UDF ACTIVITY_OCCUPATION the code is obtained Category of the Based on the BORROWAL UDF code is borrower code defaulted If none of the condition is satisfied the borrowal code is defaulted to 99 Asset classification Refer the Asset Classification Code of the code of the borrowal borrowal account table account Secured Un 1 Secured If sum of Collateral Amounts Balance Secured Loan Code 2 Un Secured Outstanding is greater than 0 then 1 else 2 Fixed Floating rate of interest flag The Fl
35. the district of the minority community 4 82 ORACLE e UDF ACTIVITY OCCUPATION at the transaction level to identify the Priority Sector The following table contains the details for Advances to Minority Communities Report1 Part A No of Total me PROPONE aN Accounts outstanding i Christians Number of The UDF MINORITY 1 accounts outstanding Muslims amount UDF MINORITY 2 Buddhists UDF MINORITY 3 Sikhs UDF MINORITY 4 Zoroastrian UDF MINORITY 5 Total A Summation of UDF MINORITY 1 to 5 Others B All Advances not belonging Minority Community for the State Total P S Advances in Identified Sum of A and B Districts C 4 19 3 System Data Mapping for Advances to Minority Communities Report 2 System identifies the above Advances to Minority Communities classification based on the following e UDF MINORITY at the customer level to identity Christians Muslims Buddhists Sikhs Zoroastrian e UDF ACTIVITY OCCUPATION at the transaction level to identify the Priority Sector The report contains the following data e Name of the Urban Co operative Bank e Statement for the half year as on 31 March or 30 September The following table contains the details for Advances to Minority Communities Report1 Part A Report Item Description Conditions Amount outstanding as The no of accoun
36. the end of the quarter 4 16 1 System Data Mapping for Return 25 All Exports The report is classified as follows e Disbursement e Balance outstanding as on the last reporting Friday of the quarter The following table contains the details for Return 25 reports Columns Disbursement Balance Outstanding Conditions Pre Shipment Credit Label Rupee Credit Disbursed amount in case of Loans with disbursement date between maximum and minimum date LCY balance outstanding is the Outstanding balance of loan Pre Rupee Credit Data Element created with All Packing Credit Rupee Advance Rupee Loan Products 4 68 ORACLE Columns Disbursement Balance Outstanding Conditions PCFC Pre shipment Credit in Foreign Currency All Loans with Packing Credit Product set to Yes And in LCY PCFC Data Element created with All Packing Credit products in Foreign Currency All Loans with Packing Credit Product set to Yes And in FCY Post Shipment Credit Label Rupee Credit Sum of Disbursed amount in case of bills with purchase discount date between maximum and minimum date Disbursed amount in case of Loans with disbursement date between maximum and minimum date Sum of LCY outstanding balance of bill LCY balance outstanding is the Outstanding balance of loan Post Rupee Credit Data Eleme
37. values currently filled 4 17 2 2 System Data Mapping for SGSY Cumulative Progress The SGSY Cumulative Progress report which should be submitted on a monthly quarterly basis contains the details of the total loans disbursed to SGHs and the individual applicants for a bank and branch The pre requisites for data population in SGSY Cumulative Progress reports are as follows e The customers should be of type General SC ST e Details of SGH Individuals should be available e The customer accounts should be open with balance greater than zero The report contains the following data ORACLE 4 77 e Name of the bank e Report showing the cumulative progress for the month ended e Details on the all the loans to the SGSY scheme The following table contains the details for SGSY Cumulative Progress reports S Columns Description Conditions No 1 Name of the District is maintained as State will be derived from the State UT UDF Data store 2 Annual Financial No values currently filled target 3 Total loans None UDF SHG GROUP is Yes disbursed to SHGs 3 1 No of SHGs No of group for which bank credit is provided is displayed 3 2 No of members None 3 3 Bank Credit Disbursed amount of the loans bills is displayed 3 4 Subsidy No values currently filled 3 5 Total No values currently filled 4 Total loans None UDF SHG GROUP is No with disburs
38. wise report is forwarded by the banks to RBI on an annual basis The deposit details in the TD and CASA modules are maintained in the system You can generate the report using MIS Date and Branch as the search criteria 4 20 1 System Data Mapping for Form VIII Return 11 Form VIII Return 11 contains the following data e Name of the banking company 4 84 ORACLE e Name and designation of the officer submitting the return e Date e Signature The following table contains details for current accounts saving accounts fixed deposits Including Cash certificates recurring deposits etc and the totals Particulars No of Accounts Outstanding Balance Description Balance brought forward from the previous return Number of accounts is displayed The outstanding amount is displayed Current Accounts Savings Accounts Fixed Deposits Including Cash certificates recurring deposits etc The previous year accounts reflected in the previous Form VIII report which remains open as on the current MIS date Accounts if any inadvertently omitted in the previous returns Number of accounts is displayed The outstanding amount is displayed Current Accounts Savings Accounts Fixed Deposits Including Cash certificates recurring deposits etc The previous year accounts not reflected in the previous Form VIII report which remains open as on the current MIS
39. with the interest range 8 and above but less than 9 Code No 505 No of Accounts Count of the term deposits with the interest range 9 and above but less than 10 Code No 506 Amount Outstanding Outstanding of the term deposits with the interest range 9 and above but less than 10 Code No 506 No of Accounts Count of the term deposits with the interest range 10 and above but less than 11 Code No 507 Amount Outstanding No of Accounts Outstanding of the term deposits with the interest range 10 and above but less than 11 Count of the term deposits with the interest range 11 and above but less than 12 Code No 507 Code No 508 4 18 ORACLE Field FCUBS Data Conditions Amount Outstanding Outstanding of the term deposits with the interest range 11 and Code No 508 above but less than 12 Count of the term deposits with the No of Accounts interest range 12 and above but Code No 509 less than 13 Amount Outstanding Outstanding of the term deposits with the interest range 12 and Code No 509 above but less than 13 No of Accounts Count of the term deposits with the interest range 13 and above but Code No 510 less than 15 Amount Outstanding Outstanding of the term deposits with the interest range 13 and Code No 510 above but less than 15 No of Accounts Count of the term deposits with the Code No 511 interest range 15 and above
40. 0039 OBC the total sanctioned amount Disbursed Total amount disbursed by the Bank towards PMRY scheme by bank during the Month No of None Applications Rejected Sent of reexamination 4 94 ORACLE Predominant Reasons for Rejection of Applications by Banks Columns Description Conditions to the Implementing Agency Most None 4 25 2 System Data Mapping for PMRY Reports Quarterly Progress The pre requisites for data population in monthly progress PMRY reports are as follows The account must be open and must have a balance greater than zero The account should be active i e all active loans are considered The following table gives the system data mapping for PMRY reports quarterly progress S No Columns Description Conditions 1 Name of the State District is maintained as UDF State will be derived Union territory from the Data store 2 Target None 3 No of applications None received Total loans sanctioned 4 No of accounts The total number of loan accounts sanctioned 5 Amount The total loan amount sanctioned Total loans disbursed 6 No of accounts The total number of loan accounts disbursed 7 Amount The total disbursed amount 8 of 6 4 Derived value Loans sanctioned to UDF SECTOR value SC out of total 100000029 sanction 4 95 ORACLE S No Columns Descr
41. 2 10 20 updated The Other GL s can be Suit The Other GLs must be u maintained as data Protested Bills element This has below Bad and Doubtful e Only 1 to 14 days time bucket gets filled 7 Fixed Assets Sum of LCY balance of the Asset Asset GLs must be GL gets updated maintained as data element 8 Other Assets Label 8 1 Leased Assets Sum of LCY balance of the Asset GL gets updated 8 2 Others Sum of LCY balance of Interest Accrued GLs Interest Accrued GLs must be maintained as data element 4 64 ORACLE S Name Head of System Data Conditions No Accounts Only Above 5 years time bucket gets filled 9 Reverse Repos Sum of LCY balance of the Repo Repo GLs must be GL gets updated maintained as data element Banks Reverse REPO RBI Reverse REPO 10 Swaps Sell Buy Sum of LCY balance of FX FX product Data Element maturing forwards Contracts must be maintained as data element Only for Sell leg Buying FCY and Selling LCY 11 Bills Rediscounted Sum of LCY balance of Bill Bills Rediscounted GLs DUPN rediscounted GL gets updated must be maintained as data element 12 Interest Sum of LCY balance of Interest Interest Receivable GLs receivabl Receivable GL must be maintained as acta data element Interest Receivable on Investments Interest receivable on Call Money Interest receivable on IBD INR Interest receivable on IBD Foreign Dep 1
42. 3 Committed Lines Sum of LCY balance of CBLO GLs must be of Credit CBLO Collateralized Borrowing amp maintained as data Lending GL element 1 Day bucket 14 Export Refinance Export Refinance GLs from RBI must be maintained as data element 15 Others specify Sum of LCY balance Based on the Other GL maintenance in the Data Element maintenance C TOTAL INFLOWS Sum of all the inflows D MISMATCH C A Total Inflows Total Outflows 4 65 ORACLE S Name Head of System Data Conditions No Accounts E MISMATCH as Calculated from the A and D D A to OUTFLOWS D as to A F CUMULATIVE Cell F1 D1 MISMATCH Cell F2 D1 D2 Cell F3 F2 D3 Cell F4 F3 D4 Cell F5 F4 D5 Cell F F5 D6 Cell F7 F6 D7 Cell F8 F7 D8 Cell F9 F8 D9 Cell F10 F9 D10 Total F10 G CUMULATIVE Derived Value F B MISMATCH as a to CUMULATIVE OUTFLOWS F as a to B 4 15 Export Billing Outstand XOS Reports The XOS report which is a branch wise report is forwarded by the authorized dealers to RBI on a half yearly basis at the end of June and December every year Following are the 3 parts of the XOS report Part Outstanding export bills other than those on deferred payment terms Part Il Exports on deferred payment terms including interest that are outstanding beyond due date Part Ill Summary of Part and Part II 4 15 1 System Data Mapping XOS Reports Part 1 The pr
43. 4 33 ORACLE S No Columns Description Conditions Part A Liabilities in India to the Banking System excluding any loan taken by a Regional Rural Bank from its sponsor Bank Label Demand Liabilities Label Balances in Current accounts of State bank of India subsidiary Banks and Corresponding New Banks Demand Liabilities include all liabilities which are payable on demand that include current deposits maintained in State bank of India subsidiary Banks and Corresponding New Banks LCY balance for GLs maintained under the data Element DLIAB_ BAL IN CURR_G L 1 a ii Other Demand Liabilities demand liabilities portion of savings bank deposits margins held against letters of credit guarantees balances in overdue fixed deposits cash certificates and cumulative recurring deposits outstanding Telegraphic Transfers TTs Mail Transfer MTs Demand Drafts DDs unclaimed deposits credit balances in the Cash Credit account and deposits held as security for advances which are payable on demand LCY Balance for the GLs maintained under the data Element DLIAB_BAL_SAV_GL LCY Balance for the GLs maintained for the data element DLIAB_LCGTY_GL LCY Balance for the GLs maintained under DLIAB_OVERDUE_TD_GL LCY Balance for the GLs maintained under DLIAB_CASH_CERT_GL LCY Balance for the GLs maintained under
44. ACLE RBI Mod Repo Detailed UDF M Data Element Whether Return ules rtld Summary IS Data Name Element isManda tory Non Mandato ry DSB FX SIR Summary NA TD_FCNR_PRODUCTS Mandator return TD EEFC_GL y no XI MM TD_RFC_PRODUCTS statemen Bills OVERDRAFTS_ NOSTRO_GL t of CL INTER_BANK_BORROW_GL interest BORROWING_OTHERS rate NOSTRO_BALANCE_GL sensitivit PCFC_PRODUCTS y forex FCNR_PRODUCTS DISC_BILLS_ PRODUCT OTHR_LOAN_ASSET_PRODUC TS INTER_BANK_LENDING_PROD UCTS OTHR_ASSET_ PRODUCTS R Return Bills RRE Summary NA NA NA cover FT TVO page Vostro Unclaim CAS RET Summary NA CURRENT_AC_STATUSES Mandator ed A _11 CURRENT AC PRODUCTS y deposit TD SAVINGS _AC_STATUSES not MM SAVINGS AC PRODUCTS operated Bills TD_STATUSES for more CL TD_PRODUCTS than 10 CURR_AC_OPERATIVE_STAT years USES SAV_AC_OPERATIVE_STATUS ES TD_OPERATIVE_STATUSES BAL CAS BAL Summary NA LCY_CCY PRODU Special A LCY_ COUNTRY CT_ELE Fortnight CL PRODUCT _ELEMENT MENT_M ly Return MM PRODUCT _ELEMENT_MM M SFR Core PRODUCT _ELEMENT_TD PRODU VIII PRODUCT_ELEMENT CL CT_ELE PRODUCT _ELEMENT_EXTERN MENT T AL_ACC D PRODU CT_ELE MENT_C 5 8 ORACLE RBI Return Name Mod ules Repo rt Id Detailed Summary UDF M IS Data Element Whether Data Element isManda tory Non Mandato ry L PRODU CT_ELE MENT _E XTERNA L_ ACC are Ma
45. Branch Code Date Specify the following Group Id Specify the group id for R Return data extraction Alternatively you can select the group id from the adjoining option list Processing Date Specify the processing date or the period ending date Alternatively you can select the processing date from the adjoining calendar button Branch Code Specify the branch code for the URS file generation Date Specify the date for the URS file generation Once you have specified the Group Id and Processing Date click the OK button in this screen Once you click the OK button the data is extracted 4 54 ORACLE 4 13 4 13 1 System runs the data collection batch which is an intra day batch in the transaction input stage This batch collects the data for the inflow and outflow FCY transactions posted on the current date The data required to generate the files is collected as part of this EOD batch When the intraday batch is run after 15 of the month to end of the month the extraction will be from 1 to 15 of the current month When the intraday batch is run from 1 of the month to 15 of month the extraction will be from 16 to end of the previous month The data collected is for the transactions of BC CL TX and FT modules inward and outward remittances The Purpose Code for these transactions is defaulted up from the R Return Maintenance screen or from the purpose codes you have selected
46. GREATEREQUAL15 Part2 Classification of Term Deposits according to Original Maturity 2LESSER30 Part2 Classification of Term Deposits according to Original Maturity 2GREATEREQUALS3S0 Part2 Classification of Term Deposits according to Original Maturity 2LESSER46 Part2 Classification of Term Deposits according to Original Maturity 2GREATEREQUAL46 Part2 Classification of Term Deposits according to Original Maturity 2LESSERQ1 Part2 Classification of Term Deposits according to Original Maturity 2GREATEREQUAL91 Part2 Classification of Term Deposits according to Original Maturity 2LESSER182 Part2 Classification of Term Deposits according to Original Maturity 2GREATEREQUAL182 Part2 Classification of Term Deposits according to Original Maturity 2LESSER365 Part2 Classification of Term Deposits according to Original Maturity 2GREATEREQUAL365 Part2 Classification of Term Deposits 5 5 ORACLE RBI Mod Repo Detailed UDF M Data Element Whether Return ules rtld Summary IS Data Name Element isManda tory Non Mandato ry according to Original Maturity 2LESSER730 Part2 Classification of Term Deposits according to Original Maturity 2GREATEREQUAL730 Part2 Classification of Term Deposits according to Original Maturity 2LESSER1095 Part2 Classification of Term Deposits according to Original Maturity 2GREATEREQUAL1095 Part2 Classification of Term Deposits accordi
47. India Identified by the CIF number allotted to RBI 1 F Sales to overseas banks and branches Credit Nostro Customer Type is Bank Residence Not India 2 D Purchases from other Authorised Dealers in India Debit Nostro Customer type is Bank Residence India 2 E Purchases from Reserve Bank of India Debit Nostro Customer Type is Bank MDTM_REPORT_PARAM table name RBI_CUSTOMER Customer CIF Residence India Identified by the CIF number allotted to RBI 2 F Purchases from overseas banks and branches Debit Nostro Customer Type is Bank Residence Not India For Retail Teller you can capture the value of the UDF PURPOSE_CODE in the screens mentioned below with their function ids e FX Purchase Walk in 8004 e FX Sale Walk in 8203 e DD Liquidation against Account 8312 e DD Liquidation against GL 8311 e DD Liquidation against Walk in 8310 e TCs Purchase Walk in 8003 e TCs purchase against Account 1409 e TCs sale against GL 8205 e TCs sale Walk in 8204 e TC sale against Account 1009 4 42 ORACLE For more details on mapping system branch functions to retail teller products refer section Mapping Oracle FLEXCUBE Branch Functions to Retail Teller Products in the chapter Annexure A in the Retail Teller User Manual 4 12 1 R Return User Intreface Workflow The following diagram describes the workflow of the R Return User Interf
48. MENT SP3 Non Return OD ET3 OR Mandator no 3 of CL y RBI DISTRI Annual CT SJSRY CL SJS Summary DISTRI DWCUAPRODUCT Non Report RY CT USEPPRODUCT mandator SJS SCHE CUMMULATIVE_RECOVERY y RYA ME_TY PE SECT 5 14 ORACLE RBI Mod Repo Detailed UDF M Data Element Whether Return ules rtld Summary IS Data Name Element isManda tory Non Mandato ry OR PHYSI CAL_C HALLE NG SELF HELP GROU P SGSY CL SGS Summary DISTRI CUMMULATIVE_RECOVERY Non Report YA1 CT CUMMULATIVE_PROGESS mandator SGS SCHE CUMMULATIVE_POSITION y YA2 ME_TY SGS PE YA3 SECT OR PHYSI CAL_C HALLE NG SELF HELP GROU P Special Bills SPR Summary ACTIVI CROP_TERM_LOANS_DE ACRES2 Return CL ET1 TY_OC OTHER_TERM_ LOANS ACRESA no 1 of CUPAT SHORT_TERM_ LOANS DE B5 RBI ION TERM LOANS DE ACRESU Annual LAND_ ACRES2 P5 HOLDI ACRESAB5 TERM_T NGS ACRESUP5 ENOR CROP TERM_TENOR SHORT _ TTOTE SHORT_TERM_TENOR TERM_T RM ENOR are Mandator y Return Bills PSS Summary SECT PRODUCT _ELEMENT_SCST Non on CL CST OR mandator SC ST OD PSC ACTIVI y beneficia STA TY_OC ries CUPAT under ION priority SCHE sector ME_TY 5 15 ORACLE RBI Return Name Mod ules Repo rt Id Detailed Summary UDF M IS Data Element Whether Data Element isManda tory Non Mandato ry advance sason last reporting Friday of March and Septemb er PE Prior
49. No of accounts The number of accounts disbursed to OBC out of the total disbursed 25 Amount The amount disbursed to OBC out of the total amount disbursed 26 of 24 6 Derived value Loans sanctioned to The Gender field is women out of total used sanction 27 No of accounts The number of accounts sanctioned to women out of the total sanctioned 28 Amount The amount sanctioned to women out of the total amount sanctioned 29 of 27 4 Derived value Loans sanctioned to The Gender field is women out of total used disbursed 30 No of accounts The number of accounts disbursed to women out of the total disbursed 31 Amount The amount disbursed to women out of the total amount disbursed 32 of 30 6 Derived value Loans sanctioned to UDF Physically handicapped out of PHYSICAL_CHALLENG 4 97 ORACLE S No Columns Description Conditions total sanction yes 33 No of accounts The number of accounts sanctioned to Physical handicapped out of the total sanctioned 34 Amount The amount sanctioned to Physical handicapped out of the total amount sanctioned 35 of 33 4 Derived value Loans sanctioned to physically handicapped out of total disbursed 36 No of accounts The number of accounts disbursed to Physical handicapped out of the total disbursed 37 Amount The amount disbursed to Physical handicapped out of the total amount disbursed 38 of 36 6 Derived
50. ORACLE RBI Return Name Mod ules Repo rt Id Detailed Summary UDF M IS Data Element Whether Data Element isManda tory Non Mandato ry Return 13 Form VII Deposits segregat ed into demand and time deposits NA ret_1 Summary NA DLIAB_BAL_IN_CURR_GL DLIAB_BAL_SAV_GL DLIAB_LCGTY_GL DLIAB_OVERDUE_TD_GL DLIAB_CASH_CERT_GL DLIAB_RD_GL DLIAB_TELEGRAPHIC_TRNF_ GL DLIAB_MAIL_TRNF_GL DLIAB_DEMAND_DRAFT_GL DLIAB_UNCLAIMED_TD_GL DLIAB_CASH_CREDIT_GL DLIAB_DEP_AS_SECURITY_GL TLIAB_TD_GL TLIAB_CASH_CERT_GL TLIAB_RD_GL TLIAB_SB_DEP_GL TLIAB_STAFF_SEC_DEP_GL TLIAB_LC_GL TLIAB_DEP_AS_SECURITY_GL TLIAB_GOLD_DEP_GL ODTLIAB_DEP_GL ODTLIAB_BILLS_PAY_GL ODTLIAB_UNPAID_DIVDND_GL ODTLIAB_SUSPENSE_GL ODTLIAB_BRN_ADJ_GL ODTLIAB_BANKINGSYS_GL ODTLIAB_PART_CERT_GL ODTLIAB_BLOCKED_AC_GL ODTLIAB_BILLS_MARGIN_GL ODTLIAB_GOLD_BORROW_GL CURR_AC_AT_RBI_GL CURR_AC_AT_SBI_GL CURR_AC_AT_OTHR_BANK_G L SAV_AC_SBI_GL SAV_AC_OTHERBANK_GL TD_SBI_GL TD_OTHERBANK_GL LOAN_SBI_GL LOAN_OTHERBANK_GL MONEY_SHORT_NOTICE_GL INTER_BANK_LOAN_GL OTHER_ASSETS_GL SEC_42_GL SCHEDULED_BANK_GL CASH_DEP_RBI_GL Mandator y 5 13 ORACLE RBI Mod Repo Detailed UDF M Data Element Whether Return ules rtld Summary IS Data Name Element isManda tory Non Mandato ry RRB_GL Special Bills SPR Summary SECT PRODUCT ELE
51. PCFC For PCFC Loan products with Sum of Principal Outstanding in ACY Interest Accrued Currency is in Foreign currency Account Status not in Closed and reversed 4 30 ORACLE SI Name Head of FCUBS Data Conditions No Accounts Loan Expiry Date FCNR B Loans For FCNR Loan products with Currency is in Foreign currency Sum of Principal Account Status not in Closed Outstanding in ACY aCrevelsed Interest Accrued Loan Expiry Date Bills Discounted If operation is Discount Export Bill Products with Parchase ifthe Currency is in Foreign currenc piirchasa Armant is PE status AE more or equal to the difference of Bill Operation Code not in Amount FCY and Collection Outstanding Amount l then ine excess Contract Status is Active Purchase Amount is returned else 0 is returned If operation is Discount Purchase Difference between Purchase Amount and Partial Liquidated Amount If any other operation then Outstanding Amount is returned Others Based on the BORROWING_OTHERS_GL maintenance in the Data Element maintenance 4 Inter bank Balance of Money Lending Market Contracts with Currency in FCY 5 Others Based on the Others GL maintenance in the Data Element maintenance Total Assets Summation of total Assets C Liabilities Liabilities Currency Currency Swaps from Liabilities Currency Swaps from Liabilities is calculated Refer the Swaps
52. PREV on the field at the top right corner of the Application tool bar and click on the adjoining arrow button 2 4 ORACLE yy Message Preview Browser Web Page Dialog _ 2 x Module Contract Reference Number Print Options DCN Preview Server Spool First of all specify the Module from which you would like to view messages You can opt to view messages for one or several unauthorized contracts To view messages for an unauthorized contract specify the Contract Reference Number 2 5 ORACLE 3 Reports Batch 3 1 Report Batch Maintenance In Oracle FLEXCUBE you can maintain a list of reports in a branch for batch execution The report function IDs maintained here can be retrieved and executed at a later stage You can invoke this screen by typing BASREPFN on the field at the top right corner of the Application tool bar and click on the adjoining arrow button Z Report Batch Maintenance Web Page Dialog 21x Branch Code 001 Lo Description American Bank NY Branch Report Function ID E Function ID Function Description ZJ V ACRUNCOL 2 Uncollected Funds Print V BCROBEFR 7 List of Bills Eligible for Rediscounting 7 BCRODAPP 7 Under Reserve Report O CYRTCURR a Currency Rates Fields Input By ELIZA Date Time Modification Number Iv Open Authorized By Date Time BB authorized Here you can maintain the following details Branch Code and Description Specify th
53. Reports Oracle FLEXCUBE Universal Banking Release 11 6 0 0 0 October 2015 ORACLE FINANCIAL SERVICES ORACLE Reports Table of Contents 1 ABOUT THIS MANUAL ju cccccescscscesessnesscsssscsssssesessssessssnessessossessessnssessnesessnessessssseessssnesssssessessessoseeeee 1 1 1 1 INTRODUCTION a3 ciccscssstssetslivecitsuecs sees AAEE EE A EAE TEESE EE AEE ARE NE ESE EAE A AT AEEA S sates 1 1 N2 AUDIENCE oera EEEE AEE AE E AE E EREE EE E EER S EE ae 1 1 1 3 ORGANIZATION 1c2sccss 5052 cass bvesssSsecancsvsbucauscaveahenvacsusesus thestenustestssbaueosusats cspusuaceyavateosusues AEREE ER SEEE ae 1 1 1 4 CONVENTIONS USED IN THIS MANUAL iperen iiser e ia eo rena oeei ian e eri e esnearen nEss sesa iaioa ioni 1 1 M25 GLOSSARY OB ICONS siaine oe ae tees E AE A a E E E E a AEE E eSa 1 1 2 RETRIEVING INFORMATION IN ORACLE FLEXCUBE sesesseesseroesesesescesosoeseseseeoesororseseeesoesoroeseeeeeee 2 1 2 1 INTRODUCTION E E E A E E EE EEE 2 1 2 1 1 Generating repor Suie sive vegs lt tyatead susan E E tase E E EEE E E 2 1 2 4 2 Specifying the Output Of A Report sirsiran aera i aa ia E E R REER 2 1 2 1 3 CONTENTS OF TNE TE PONE moreret epea E E E A ined casi ones oasogeaptuuatagpsasteeas curiosity oui 2 2 22 MAINTAINING PRINTER veere ri sccsseicecssesacs seu ncececeecsensdesccsvecseotscsesdeceuedsenssosestees cestevasstcstesntedussesosdsacsctetgesedstents 2 2 2 2 1 Maintaining Report Spool Path u cccecccesccesccesecesecsseense
54. S Data Element Whether Data Element isManda tory Non Mandato ry OUTFLOW_BILLS_REDIS_DUP N_GL SWAPS_BUY_SELL_PRODUCT S OUTFLOW_TD_PRODUCTS OUTFLOW_OTHER_GL CASH_GL BALANCE_WITH_RBI_GL CURRENT_AC_COL1 CURRENT_AC_COL7 CURRENT_AC_GL MONEY_AT_CALL_GL INVESTMENTS_GL INFLOW_BILLS_DUPN_PRODU CTS CASHCR_LOANREPAY_PROD UCTS CASHCR_LOANREPAY_COL1 CASHCR_LOANREPAY_COL2 CASHCR_LOANREPAY_COL8 CASHCR_LOANREPAY_GL TERM_LOAN_PRODUCTS NPA_COL1 NPA_COL2 NPA_COL3 NPA_GL FIXED_ASSETS_GL LEASED_ASSETS_GL OTHRASSETS_OTHERS_GL REVERSE_REPOS_GL SWAPS_SELL_BUY_PRODUCT S INFLOW_BILLS_REDIS_DUPN GL INTEREST_RECEIVABLE_GL COMMIT_LINE_OF_CREDIT_G L EXPORT_REFINANCE_GL INFLOW_OTHERS_GL XOS statemen t Bills XOS Detail IECOD XOS_PRODUCTS XOS_REPORTING_PERIOD Mandator y ORACLE RBI Mod Repo Detailed UDF M Data Element Whether Return ules rtld Summary IS Data Name Element isManda tory Non Mandato ry Report Bills RET Summary GOLD_ PRESHIP_RUPEE_CREDIT_PR Mandator 25 CL 25 CARD_ ODUCTS y Export HOLD PRESHIP_PCFC_PRODUCTS Credit ER POSTSHIP_RS_CREDIT_LOAN Data PRODUCTS POSTSHIP_RS_CREDIT_BILLP RODUCTS POSTSHIP_EBR_BILLPRODUC TS PRESHIP_RUPEE_CREDIT_PR ODUCTS PRESHIP_PCFC_PRODUCTS POSTSHIP_RS_CREDIT_LOAN PRODUCTS POSTSHIP_RS_CREDIT_BILLP RODUCTS POSTSHIP_EBR_BILLPRODUC TS GOLD_CARD_HOLDER 5 12
55. TOR The UDFs used for system data mapping for PRMY reports quarterly progress are DISTRICT SCHEME_TYPE and PHYSICAL_CHALLENG The UDFs used for system data mapping for PRMY reports half yearly recovery are DISTRICT and SCHEME_TYPE 4 93 ORACLE 4 25 1 System Data Mapping for PMRY Reports Monthly Progress The pre requisites for data population in monthly progress PMRY reports are as follows e The account must be open and must have a balance greater than zero e The account should be active i e all active loans are considered The following table gives the system data mapping for PMRY reports monthly progress Columns Description Conditions No of Cases None Received from Task Force during the Month Industry This is the purpose of the loan advance This is captured using Service SCHEME_TYPE UDF Industry PMRYI Business 7 Service PMRYS Business PMRYB Total Summation of Industry Service and Business Women The number of accounts and This is from the Gender sanctioned amount for women out of the total sanctioned amount SC The number of accounts and UDF SECTOR value 100000029 sanctioned amount for SC out of the total sanctioned amount ST The number of accounts and UDF SECTOR value 100000030 sanctioned amount for ST out of the total sanctioned amount OBC The number of accounts and UDF SECTOR value sanctioned amount for OBC out of 10000
56. The following fields are un editable in this screen e Currency e Debit Credit e Transaction Amount e Settlement date e Transaction reference Number e Custom number e Account Number e Vostro country Code e Customer name e Address e Vostro Operation e Module 4 52 ORACLE 4 12 7 Maintaining Grouping Details for R Return File Extraction You can maintain grouping details for the r return file extraction using the Group Maintenance screen You can invoke this screen by typing MDDFTRMT in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button F Group Maintenance Web Page Dialog Group Id Group Description f Fi Interface Id Date Time Mod No WB Authorized ELT Exit Date Time HB open Specify the following Group Id Specify the group id for R Return data extraction Group Description Specify a brief description of the group id maintained Interface Id Specify the interface id for the file extraction 4 53 ORACLE 4 12 8 Maintaining Grouping Details for R Return Ul Data Extraction You can maintain grouping details for R Return User Interface data extraction using the Group Trigger screen You can invoke this screen by typing MDDFTRTG in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button F R Return File Generation Webpage Dialog Group ld Processing Date Oo
57. Women category e UDF ACTIVITY_OCCUPATION at the transaction level to identify the Priority Sector The pre requisites for data population in PSA reports Part II are as follows e The account must be open and must have a balance greater than zero e All active loans are considered e All active import and export bills that are purchased discounted or advanced are considered 4 57 ORACLE The following table gives the data that should be specified for PSA Reports Part II Field FCUBS Data Comments No of Borrower units Number of accounts The credit limit If no limit exists then the disbursed amount is the Limit Sanctioned limit sanctioned The account status is active not in liquidated closed reversed or hold statuses The field data is captured for the Priority Amount Advanced The amount disbursed out of the sectors as defined in the credit limit following table Balance Outstanding Outstanding amount of all the current accounts Amount Overdue under The amount outstanding post the Balance outstanding due date 4 14 ALM Structural Liquidity The Statement of Structural Liquidity which is a bank wise report is forwarded by the banks to RBI on a fortnightly basis This report gives the residual maturity of the outflows inflows across different time periods and their total for the entire time period The data with respect to outstanding amounts in CL CASA FX and TD modules a
58. ace Data Data Extraction ASCII File maintenance Branch level generation Head Mapping office level Data Summary Optional 4 12 2 Maintaining R Return Details You can maintain details required for report generation and submission using the R Return Maintenance screen The maintenance is done at the head office level which is applicable to the associated branches You can invoke this screen by typing MDDRRETM in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button F R Return Maintenance Web Page Dialog Branch Branch Description m Product Type Operation Event Code Amount Tag Purpose Code Maker Date Time Mod No WB Authorized Checker Date Time HB open You have to authorise the records created in this screen Also system does not carry out valiadtions on the details maintained here 4 43 ORACLE Specify the following details here Branch System displays the branch code of the reporting branch as maintained in the bank parameters screen Branch Description System displays brief decription of the branch code as maintained in the bnk parameters screen Product Type Specify the product type The adjoining option list displys a list of all the valid product types maintained in the system You can select the appropriate one Operation Specify the operation The adjoining option list displys a list of all the valid operations mainta
59. aintenance in the Data Element maintenance Total To be indicated with a plus sign Total of all Items in the nature of Assets indicated with plus sign Off Balance Sheet GAP a b Off Balance Sheet GAP a b Sum of all off balance Sheet Items indicated with a minus sign Total of all Items in the nature of Assets indicated with plus sign B Balance Sheet Items Label a Liabilities Label a 1 FCNR B For FCNR TD products Sum of TD Principal Amounts till MIS Date with Account not Closed Currency is FCY like 4 26 ORACLE USD Data element FCNR can be defined to restrict the TD Products a 2 EEFC This shows Sum in Maintained as Account Account Currency Class Always in first Time bucket a 3 RFC Sum of Balance of TD and SA accounts The values will be available only the first bucket for Savings Account else distributed across buckets Account Class level data element is maintenance a 4 Overdrafts in Nostro A c This shows Sum of positive value of Account Currency Balance only when the Balance goes negative for all Nostro GL s All gl s of GL type Nostro a 5 Inter bank borrowings Sum of FCY balance from the MM contracts based on the Product code Product is maintained as Inter bank borrowings a 6 LOC BAF None Total Liabilities To be indicated with a minus sign Summation of total liabiliti
60. area of greater than 5 acres is displayed Balance Outstanding The number of accounts which have a balance outstanding as on 31 March and the outstanding for those accounts provided the area greater than 5 acres is displayed Total of agricultural activities Disbursements during the year The total number of accounts and the amount disbursed during the year is displayed Balance Outstanding The number of accounts which have a balance outstanding as on 31 March and the outstanding for those accounts is displayed 4 22 2 System Data Mapping for Special Return 1 Section 2 The Special Return 1 Section 2 report has the following sections e Allied activities e Total direct finance to Agriculture amp Allied Activities A B C The following table gives the details for Special Return 1 Section 2 reports ORACLE 4 90 Category No of accounts Amount C Allied activities Dairying Number of accounts The outstanding balance Poultry Piggery keeping Number of accounts The outstanding balance Number of accounts The outstanding balance Fisheries Others Number of accounts The outstanding balance Total Number of accounts The outstanding balance Dairying Number of accounts The outstanding balance Poultry Piggery keeping Number of accounts The outstanding balance Number of accounts The outstanding balance
61. arget No values currently filled No of applications received No values currently filled Total Loans sanctioned The no of account sanctioned and the sanctioned amount of loans gets displayed If the Loan sanctioned limit of loans is null the disbursed amount of the loan is the sanctioned amount of loan Total Loans disbursed The no of account disbursed and the disbursed amount of loans gets displayed Total subsidy disbursed No values currently filled Loans sanctioned to SC ST Same as total loans UDF SECTOR IN out of the total sanction sanctioned 100000030 100000029 Loans disbursed to SC ST Same as total loans disbursed out of the total disbursement Loans sanctioned to Same as total loans Filtered using Gender Women out of the total sanctioned from customer details sanction Loans disbursed to Women Same as total loans disbursed out of the total disbursement Loans sanctioned to Same as total loans UDF disabled out of the total 4 73 ORACLE Columns Description Conditions sanction sanctioned PHYSICAL_CHALLENG Loans disbursed to Same as total loans disbursed yss disabled out of the total disbursement No of applications pending No values currently filled sanction No of applications No values currently filled Rejected 4 17 1 2 System Data Mapping for SJSRY Quarterly Report DWCUA The Development of Women and Ch
62. can invoke this screen by typing MDSRRETV in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button n Z R Return Vostro Extracted Data Summary Webpage Dialog Authorization Status Vostro Operation Debit Credit Module Records per page 15 v 3 w Lock Authorization Status Record Status Vostro Operation Transaction Ref Number Record Status Transaction Ref Number Settlement Date Q Search Advanced Search 1 of 1 Debit Credit Currency Transaction Amount Settlement Dat You can query a record with the following details as the search criteria Vostro Operation Transaction Reference Number Settlement Date Debit Credit Authorization Status Record Status 4 51 ORACLE e Module You can invoke the R R Vostro Extracted Data Details screen by clicking on a record in the R Return Extracted Data Details screen The R Return Vostro Extracted Data Details screen contains the details of the individual transactions for Vostro cover page A R Return Vostro Extracted Data Detailed Webpage Dialog Settlement Date Customer Number Currency Account Number Debit Credit Customer Name Transaction Amount Address Transaction Ref Number Module Vostro Country Code Vostro Operation Maker Date Time Mod No Hl Authorized Checker Date Time E Open In this screen you can edit the value of Purpose Code
63. cy and amount Bill amount and Bill Currency In Contract Main Amount outstanding currency and amount This is the outstanding amount and the corresponding currency In Contract Main Outstanding Amount in RS The outstanding amount in Rupee equivalent Rupee outstanding Display only the data in Cash Export and Undrawn balances The undrawn amount captured in GR form will 4 67 ORACLE Field FCUBS Field Conditions be displayed under the Undrawn balance And the GR amount Undrawn balance will be the cash export Remarks Remark in GR Form The user can also enter manually on the report 4 16 Return 25 Export Credit Disbursements and Balance Outstanding The Return 25 report which is a bank wise report is forwarded by the authorized dealers to RBI on a quarterly basis This report contains details on the pre shipment and post shipment disbursement and balance outstanding amounts The disbursement and outstanding details of all the active contracts in BC and CL modules are maintained in the system You can generate the report using MIS Date maximum date and Bank Code as the search criteria The Return 25 report contains the following details e Name of the AD Bank e Statement showing total disbursals and balance outstanding as on the last reporting Friday of the quarter for all exporters e Total number of gold cards issued till
64. date Additions during current year MIS date Number of accounts is displayed The outstanding amount is displayed Current Accounts Savings Accounts Fixed Deposits Including Cash certificates recurring deposits etc The current year accounts which remains open as on the current MIS date 4 85 ORACLE Particulars No of Accounts Outstanding Balance Description Account which have become operative or were closed during the yr of MIS date Number of accounts is displayed The outstanding amount is displayed Current Accounts Savings Accounts Fixed Deposits Including Cash certificates recurring deposits etc The accounts that had been in operative in the Previous year and Reopened closed in Current year Total balance as at MIS date Number of accounts is displayed The outstanding amount is displayed Sum of the following Balance brought forward from the previous return Additions during current year MIS date Add Interest credited to the accounts during the year Number of accounts is displayed The outstanding amount is displayed If Sum of Savings account and deposits balance for the current year is greater than Sum of previous year s savings account balance then Interest Sum of Savings account balance for the current year Sum of previous year s savings account balance Else Interest is Null T
65. ds Goods Description in Document Shipment tab Date of remittance payment Value date of Liquidation or Advance In Contract Main tab Currency and amount Bill amount Liquidated Advanced and Currency In Contract Main tab Rupee equivalent Bill Amount in LCY In Contract Main tab Remarks Bill Reference Number This is a remark with respect to the transaction record The user can also comment manually on the report 4 5 2 System Data Mapping for BEF Part Il The pre requisites for data population in Part Il of BEF reports are as follows e The Bill of Entry date is produced in the Current half year for the records in the Part of the BEF reports extracted before the Current half year e Once a record is reflected in BOE Part Il it is not repeated again Part II The UDF ORGSUBTYPE is used to identify the importer The following table reflects whether the importer is a government body or not Field System Field Conditions Name and address of importer Drawee name and Address in Contract Main tab Parties Tab in BC contract screen Period of the BEF statement and serial No of the The Period is the period in which the Importer had defaulted but has now done the payment listed in the Part of previous BEFs The sequence number is These details are retrieved from Previous BEFs 4 6 ORACLE Field System Field Conditions
66. e 2 parts of a SUSRY report e Recovery half yearly USEP and DWCUA e Progress Quarterly USEP and DWCUA The UDFs for system data mapping for SJSRY Quarterly Report USEP are DISTRICT SCHEME_TYPE SECTOR and PHYSICAL_CHALLENG The UDFs for system data mapping for SJSRY Quarterly Report DWCUA are DISTRICT SCHEME_TYPE and TOTAL MEMBERS The UDFs for system data mapping for SJSRY Quarterly Report SUSRY Half yearly Recovery Report are are DISTRICT and SCHEME_TYPE 4 72 ORACLE 4 17 1 1 System Data Mapping for SJSRY Quarterly Report USEP The Urban Self Employment Programme USEP is applicable for Under employed and unemployed urban youth whose annual family income is below the poverty line and who have got education up to ninth standard shall be assisted with bank s loan and Government subsidy The pre requisites for data population in USEP reports are as follows e Account must be open and must have an outstanding balance e Account status is not closed liquidated reversed or on hold for loans e The UDF SCHEME_TYPE has the value Urban Self Employment Programme Others The following table contains the details on the data which needs to be captured on quarterly basis for States and Union territories for USEP reports Columns Description Conditions Name State Union Territory District UDF will be captured State will be derived from the Data store T
67. e code to identify the branch for which you are maintaining the report batch The option list displays all valid branch codes maintained in the system Select the appropriate one The system displays the branch description based on the branch code selected Function ID and Description You have to specify the function IDs to be maintained You can select one or more function IDs for execution at a time The system displays the description based on the function ID selected To add more rows to the list of function IDs click Add icon Select the function ID from the option list You can remove the unwanted rows using Delete icon Use the check box adjacent to each function ID to indicate that it has to be maintained Once you have specified all the details save the maintenance 3 2 Report Batch Execution In Oracle FLEXCUBE you can execute a batch for a set of reports maintained for a branch You can invoke this screen by typing BAREODFN on the field at the top right corner of the Application tool bar and click on the adjoining arrow button e Report Batch Execution Web Page Dialog i 21x Branch Code az Description View Report Function ID Format z H rl Function ID Function Description Output Output Print Spool Printer Printer z 2 Using this screen you can view print or spool the reports maintained for each branch You need to specify the branch code to initiate the proces
68. e report details for report generation using the Report Generation screen You can invoke this screen by typing MDDRPGEN in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button System generates the reports based on the values specified F Report Generation Web Page Dialog Report ID Extract Report Description O View Generation Date Report Type Summary Detailed Specify the following Report Id Specify a unique id for the report Alternatively you can select the report id from the adjoining option list Report Description Specify a brief description of the report maintained Generation Date Specify the date on which the report should be generated Alternatively you can select the date from the adjoining calendar button Report Type Indicate the type of report you are maintaining You can select one of the following options e Summary e Detailed If you select report type as Detailed then system disables both Summary and Detailed options and by default selects the Detailed option Indicate the type of report generation You can select one of the following options 4 4 ORACLE 4 5 e Extract If you select this option you can extract the data based on the frequency of the report and the generation date e View If you select this option you can view the report in the predefined formats for the Re
69. e requisites for data population in XOS Reports Part are as follows Contract status should be active crystallized Export bills outstanding for more than 180 days from date of shipment and unrealized bills from their due date should be reported 4 66 ORACLE e The data elements used are KOS PRODUCTS and KOS_REPORTING_PERIOD The following table contains the details for XOS Reports Part I Field FCUBS Field Conditions The AD Code number is a 14 ae er A D Code digit number e g 1234567 trai alin asia 1234567 S No Serial number of the record Sequence number Bill No amp Bill Date Bill Reference number and the value date of the Bill In Contract Main Name and Address of the Exporter The Drawer name and Address In Parties Tab IE Code Name and Address of the Exporter An I E UDF at customer level Date of Exports Goods Shipment Date In GR Form Due date of realisation Maturity Date In Contract Main tab Ea ee ETEA ae GR Number In GR Form Port of Shipment Shipment From In GR Form Shipping Bill No amp Date Shipping Bill Number In GR Form Name amp Address of overseas buyer Name and address of the Importer In Contract Main tab Commodity Goods Description In Document Shipment Tab Invoice Currency amp amount Invoice currency and invoice amount In Invoice Form Amount of Realization curren
70. e using the UDF DISTRICT The following table gives the system data mapping for Advances to Agriculture Part B Columns Description Condition State will be derived from the Data store Name of the State Union District is maintained as UDF territory ORACLE 4 100 Balance Outstanding State wise balance outstanding Total Demand Sanctioned amount of the loans is displayed Recovery Recovery amount of the loans is displayed Total Total of the overdue Over dues Label 1 year or less The amount outstanding post the maturity date in Bills and the post the due date in Loans for 1 year or less Over 1 year The amount outstanding post the maturity date in Bills and the post the due date in Loans for more than a year to 1 year Over 2 years The amount outstanding post the maturity date in Bills and the post the due date in Loans for over 2 years to 3 years Over 3 years The amount outstanding post the maturity date in Bills and the post the due date in Loans for over 3 years Percentage of Recovery to Demand Recovery Demand Derived value 4 101 ORACLE 5 Annexure A User Defined Fields and Data Elements The following table gives the details of the UDF values RBI Mod Repo Detailed UDF M Data Element Whether Return ules rtld Summary IS Data Name Eleme
71. e weaker sections scheduled castes scheduled tribes UDF is captured at the customer level The pre requisites for data population in PSA reports Part I are as follows e The account must be open and must have a balance greater than zero e All active loans are considered e All active import and export bills that are purchased discounted or advanced are considered System defaults the following details e Name of the bank e Date of Return 4 55 ORACLE e Total Advances of the bank e Outstanding as on the Date of Return e Total Priority Sector Advances e Percentage of Priority Sector Advances to Total advances e Total Weaker Section Advances e Percentage of Weaker Section Advances to Priority Sector Advances You have to specify the signature of the authorized officials in the system The following table gives the data that should be specified for PSA Reports Part I Field FCUBS Data Conditions No of Borrower units Number of accounts from the modules Bills and Collections Advances CASA overdraft and CL modules The field data is captured for the Private sectors as defined in the following table Limit Sanctioned The credit limit If no limit exists then the disbursed amount is the limit sanctioned The account status is active not in liquidated closed reversed or hold statuses Sanctioned amount of loans Bill Amount The field data is captured for the Priority secto
72. eaeeseeeneenaees 4 17 4 7 4 System Data Mapping for BSR 2 Part V cccccccsccesseesseesseeeeeseeseceeccesecesecnaecaaecaaecaaeeaeeeseeeaeeeeeeneeeaees 4 19 4 7 5 System Data Mapping for BSR 2 Part Viii escecccsscesseesseesseeeeeeceeeceeceseceaecaecuaecaeecaeeeaeeeaeeeaeeeeseneeeaees 4 21 4 8 BASIC STATISTICAL REPORT 3 BSR 3 STATEMENTS c cccesssceceessececseseececseneeceeaeeeceesaeesenneaeeseseseesaes 4 22 4 8 1 System Data Mapping for BSR 3 scenica oere E E Ri 4 22 4 9 MATURITY AND POSITION MAP REPORTS c cccesssececesseececeseeecesaececsessececsaeeceeueeeceesaeessenseeeesseeeseeaas 4 23 4 9 1 System Data Mapping for MAP ssiri ira i 4 24 4 10 INTEREST RATE SENSITIVITY SIR REPORTS c cccccsesceceessececseseececseeeecsesaeeeceeneeeecseeeceeaaeeesseseeeesseeeeees 4 29 4 10 1 System Data Mapping for SIR csccessesscesscesecesecssecnsecneecoeeconscnsseasenseseeseessecssessaesneesaaeceasenseensees 4 29 4 11 RETURN 3 FORM VID ienris EEE EREE E E EA E aos 4 33 4 11 1 System Data Mapping for Return 13 FO M oeeseseseeseeeesereeresrrrreresrreesresrrerereerrerrererreeresreseses 4 33 4 12 R RETURN FET ERS REPORTING presise ron EE ee E KiK NEE aE EE EENE at 4 41 4 12 1 R Return User Intreface Workflow ccccccsescesscesscesscesecnsecncecaeecseeeseeseeeseeseeesaeesecsaecsaessaecaaeeseeeaeees 4 43 ORACLE 4 12 2 Maintaining R Return Details ecccccsccesscccsseceenceenseceenceessecesneeeseeceneeeacectneeeacece
73. ed to customer as Individual individuals 4 1 No of No of individuals Individuals 4 3 Bank Credit Disbursed amount of the loans is displayed 4 4 Subsidy No values currently filled 4 5 Total No values currently filled 5 Physical None Coverage 5 1 Outstanding The Amount Outstanding is the Outstanding balance of loan account 5 2 Overdues Difference between Demand amount and Recovery 4 78 ORACLE S Columns Description Conditions No amount 5 3 SC ST no Displays the no of SC ST UDF SECTOR IN applicants 100000030 100000029 5 4 Women No Displays the no of women Filtered using Gender from applicants customer details 5 5 Disabled No Displays the no of disabled UDF PHYSICAL_CHALLENG applicants yes 4 17 2 3 System Data Mapping for SGSY Recovery Statement The SGSY Recovery Statement reports which are submitted half yearly contains details of zone wise demand recovery overdue percentage of recovery and the total for general and SC ST applicants The only pre requisite for data population in SGSY Recovery Statement reports is that the customer accounts should be open with balance greater than zero The only data present in the report is the name of the bank The recovery details are classified as Individual or Group using the UDF GROUP The following table contains the details for SGSY Recovery Statement reports S Columns Desc
74. eeesaaecseneeeneeceeneeenaees 4 43 4 12 3 Viewing R Return Details ccesssnissnsinnsssecssesesesionssonevonnesseceseossenenessouiennrgndaeseavcdsteesetonsesoeisntensesse 4 45 4 124 Viewing the R Return Nostro Cover Page Data Extraction Logic s 4 46 4 12 5 R Return Vostro Cover Page Data Extraction Logic 1 ccsccecccecesseeseeseeeseeseeeeecesecnseceaecaaecaeeeaeeensees 4 49 4 12 6 Viewing R Return Vostro Cover Page Data cccccccsccescesecesecneeeseeseesseeseeeeeeeecesecesecaecaaecaeeeaeeessees 4 5 4 12 7 Maintaining Grouping Details for R Return File Extraction ccccccccscsesssesecesscesecesecusecceeseeensees 4 53 4 12 8 Maintaining Grouping Details for R Return UI Data Extraction 4 54 4 13 PRIORITY SECTOR ADVANCES PSA REPORTS cccssssceceessececseseececsaceecesaeeecsseeeeeceeeeeeeaueeesseseeeesseeeeees 4 55 4 13 1 System Data Mapping for PSA Report Part u cceeccesccescese este esseeeeeeeeeneeeeeeecesecsecaecuecaeeeseeeaaees 4 55 4 13 2 System Data Mapping for PSA Report Part ui cccecccesccescssecsteenseeeeeeeeseeeseceaeeesecaecaecaaecseeeaeeeneees 4 57 4 14 ALM STRUCTURAL LIQUIDITY rnn a E Soave sas yasadenteesvesaedadedeaseesassaacoecs 4 58 4 14 1 System Data Mapping for ALM Reports ccccccescceescesecee cuss ceeeaseeseeeseeseeeseeesecesecnaesaecuaecaaeeseseneees 4 59 4 15 EXPORT BILLING OUTSTAND XOS REPORTS ccccsessecesssececsessececsesceceesaeeecseseececseeecseaeeecsesaeeesneeeee
75. either N D P C M or A as the bill prefix based on the Central Bank reference Number Bill Number System displays the bill number for the transaction Import Export Code System displays the import or export code for transactions with purpose codes P0101 and P0105 4 48 ORACLE Date of Shipment System displays the shipping bill date here Shipping Bill Number System displays the Shipping bill number here Customer Number System displays the customer number here Under LC System displays one of the following values here 1 Indicates under LC 0 indicates otherwise URS System displays the number of transactions clubbed under Unclassified Receipts Survey for recipients of the foreign exchange transaction when amount is more than INR 500000 or more for a single transaction Beneficiary Name System displays the beneficiary name here only for recipients of the foreign exchange transaction when amount is more than INR 500000 or more for a single transaction Remitter Name System displays the remitter s name here 4 12 5 R Return Vostro Cover Page Data Extraction Logic The Vostro cover page contains a summary of the transactions on the Vostro accounts of banks and private exchange houses Following are the conditions for Vostro transactions e The currency is INR e The Country of the bank private exchange house is not India The data extraction for the Vostro cover page is as follows
76. es indicated with a minus sign b Assets It s a Label in the report b 1 Nostro Balances cash and bank balances Sum of balance of all Nostro GL s for which Balance is positive Nostro GL s should be maintained as a Data Element Always in first Time bucket 4 27 ORACLE b 2 Short Term Investments Balance from the MM placement products b 3 Loans None Label b 3 1 PCFC Sum of Principal Outstanding in LCY For PCFC Loan products with Currency is in Foreign currency Account Status not in Closed and reversed Loan Expiry Date b 3 2 FCNR B Loans Sum of Principal Outstanding in LCY For FCNR Loan products with Currency is in Foreign currency Account Status not in Closed and reversed Loan Expiry Date b 3 3 Bills Discounted If operation is Discount Purchase if the purchase Amount is more or equal to the difference of Bill Amount FCY and Outstanding Amount then the excess Purchase Amount is returned else 0 is returned If operation is Discount Purchase Difference between Purchase Amount and Partial Liquidated Amount If any other operation then Outstanding Amount is returned Export Bill Products with Currency is in Foreign currency Settlement status is active Operation Code not in Collection Contract Status is Active b 3 4 Others Based on the OTHR_LOAN_ASSET_PRO DUCTS maintenance in t
77. eseeeseesseeeeeeseceeceseceaecaecaecsaecseeeseseaeesaeesseeeeenaees 2 4 2 3 VIEWING MESSAGES FOR UNAUTHORIZED CONTRACTS ccccccsesesssesscsesesesseessesecosesesseseeseeeessesssenssneeenenes 2 4 3 REPORTS BATCH ou scscsscscsscsssccncscnscsssnesssenesscssessessssensssssnesscsncssessssnessssnesscsecssesssssossossnesessnessessessoeses 3 1 3 1 REPORT BATCH MAINTENANCE ic csscsncssasseoseesecdeensesvesnecdecvaceeatenteatevensscobvesnedtesiesbentoentestioveunneetvacevsversavecutd 3 1 3 2 REPORT BATCH EXECUTION s5 c c ssccdsvtasscasventeatevaesteanvedneshestortentWantvatenensteunvoasvedoranaseanvangscbevensontevecgeddepvars seis 3 1 3 2 1 VIEWING Reports sscvsanscicvsovscnavacve chenndvenbensaveadadstveancedeve saeveeysaneveaveadaceousonceuaNe obeveevea bevvaunadeuetnesusaleenbetuays 3 2 3 2 2 Printing Spooling the REDOTAS irnia tuateesenesvecdenueteenssbernebe biaevete contsedennes vets 3 3 4 RBI REGULATORY REPORTS ccscescceseccsnsscsesssenssessnesecsneessssssnesesenessssssesessessssssssessesnessessessosees 4 1 4 1 INTRODUCTION oesie nesteeseen ae E a aaea EEEE Ee E Eesi EEE ESEE EEr EE Ae mr E EEE test uesbensaen 4 1 4 2 MAINTAINING DATA ELEMENT DETAILS ju ccseecesesscseeeseseececseeseuesesseeseceseesssesssesesoussussesesseeeeussesenseeenenes 4 1 4 3 VIEWING DATA ELEMENT DETAILS ccccsssscssesssssessesevssssencesssesesesessaseeasassnssensesssessesssssaseeasesessenseseseseesatey 4 3 dd GENERATING REPORTS 2 s 0scs 2kssessiesc
78. esponsible to take all appropriate failsafe backup redundancy and other measures to ensure its safe use Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws Except as expressly permitted in your license agreement or allowed by law you may not use copy reproduce translate broadcast modify license transmit distribute exhibit perform publish or display any part in any form or by any means Reverse engineering disassembly or decompilation of this software unless required by law for interoperability is prohibited The information contained herein is subject to change without notice and is not warranted to be error free If you find any errors please report them to us in writing This software or hardware and documentation may provide access to or information on content products and services from third parties Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third party content products and services Oracle Corporation and its affiliates will not be responsible for any loss costs or damages incurred due to your access to or use of third party content products or services
79. eustsuts n a eee Keep TEE eE EESAC EEEE rE tp Erene KE EAO Eeri Ep ESENE Eaten 4 4 4 5 BILL EVIDENCE FAILURE BEF REPORT css cccssssececesscececssececsssnececsssceceesaeeecsesaeeecensaeesesaeeecsesuecesseatess 4 5 4 5 1 System Data Mapping for BEF Part i cccecccsccesceesteesseesceeecesecesecnsecuaecaaecaaeeaaeeseesseeseeeseeeeseaeenseeaeeaas 4 5 4 5 2 System Data Mapping for BEF Part II ccccccescssseeseeseesscesecesecesecuaecaecaaecsaeeseeeaeeseeeseeeeesaeenaesaeaas 4 6 4 6 BASIC STATISTICAL RETURN BSR 1 STATEMENTS cccssscceeesnececssecececseneecseaeeecsesaeeesseeecseueeeeneeaees 4 7 4 6 1 System Data Mapping for BSR JAnic iisipin caai is ioie riea E 4 8 4 6 2 System Data Mapping for BSR 1B c cccesccesccescsseeseeneeeseeseceseeeseceecnsecuaecuaecsaecaaecaaeeaeeeaeeeeaeneseeeeeaees 4 12 4 6 3 System Data Mapping for BSR 1 Summary o ccccceecesceeseenee ee eeseeeeecesecesecuaeceaecasecaaeeaeeeaeeseeeseeeeeeeaees 4 13 4 7 BASIC STATISTICAL RETURN 2 BSR 2 STATEMENTS cccssssecesssececsenaececseseecesseeecsesaeeesensaeeessneeeeneaas 4 13 4 7 1 System Data Mapping for BSR 2 Part u c cscceccceccesseesseesseeeeeecesecesecesecsecaecuaecasecaeeeseeeseeeaeeeeeeseenaees 4 14 4 7 2 System Data Mapping for BSR 2 Part Du ecccecccsccessesseesseeseeeeeesecesecesecusecaeceaecasecaaeeaeeeseeeaeeseeeneeenees 4 15 4 7 3 System Data Mapping for BSR 2 Part II ccccscccscesseesseeseeesceeseeeccesecesecuaeceaecaaecaaeeaeeesee
80. f June The data with respect to the number of accounts and disbursals that occurred in BC CASA and CL modules are maintained in the system You can generate the report using MIS date and the bank code as the search criteria 4 23 1 System Data Mapping for Special Return Ill The following table gives the system data mapping for Special Return III reports Columns Description Conditions State Union District is maintained as UDF State will be derived from the Territory Data store State Code As defined by RBI No of Accounts Total number of accounts to Priority sectors Amount The total amount disbursed to Priority sectors SC ST No of The number of accounts allotted to UDF SECTOR 100000029 accounts SC ST out of the Priority sectors SC 100000030 ST SC ST Amount The total amount disbursed to SC ST UDF SECTOR 100000029 out of the Priority Sectors SC 100000030 ST 4 24 DRT Statements Suit Filed and Decreed The DRT Statement which is a bank wise report is forwarded by the banks to RBI both quarterly and annually The data from the CL module is extracted and maintained in the system You can generate the report using MIS date and the branch as the search criteria Here the suit filed decreed accounts individual and aggregated data are displayed The only pre requisite for data population in DRT statements is that the aggregated outstanding should be greater
81. fault system displays the Include option Data Element Values Serial Number Specify the serial number This is a mandatory input Element Values Specify the element value to be selected based on the operator Alternatively you can select the element value from the adjoining option list 4 2 ORACLE Description Specify a brief description for the element value maintained Viewing Data Element Details You can view the data element values for each report in the Data Element Maintenance summary screen You can invoke this screen by typing MDSDEMNT in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button 7 Data Element Maintenance Webpage Dialog Authorization Status Record Status Report ID Q Search Advanced Search Records per page sv 3 tock Authorization Status Record Status Report Description In the above screen you can base your queries on any or all of the following parameters and fetch records e Authorization Status e Report ID e Record Status Select any or all of the above parameters for a query and click Search button The records meeting the selected criteria are displayed System displays the following details pertaining to the fetched records e Authorization Status e Record Status e Report ID 4 3 ORACLE 4 4 e Report Description Generating Reports In Oracle FLEXCUBE you can define th
82. follows e Individual e Corporate e Total of individuals and corporate excluding deposits from banks Following are the details which include all types of non resident rupee and foreign currency deposits displayed for BSR 2 Part IIl reports Field FCUBS Data Conditions Count of the term deposits with the Code No 501 Noot ApEaUMS interest range lt 5 Amount Outstanding Outstanding of the term deposits Code No 501 with the interest range lt 5 4 17 ORACLE Field FCUBS Data Conditions No of Accounts Count of the term deposits with the interest range of 5 and above but less than 6 Code No 502 Amount Outstanding Outstanding of the term deposits with the interest range 5 and above but less than 6 Code No 502 No of Accounts Count of the term deposits with the interest range 6 and above but less than 7 Code No 503 Amount Outstanding Outstanding of the term deposits with the interest range 6 and above but less than 7 Code No 503 No of Accounts Count of the term deposits with the interest range 7 and above but less than 8 Code No 504 Amount Outstanding Outstanding of the term deposits with the interest range 7 and above but less than 8 Code No 504 No of Accounts Count of the term deposits with the interest range 8 and above but less than 9 Code No 505 Amount Outstanding Outstanding of the term deposits
83. g ro Forana Buying 12 Interest Payable Sum of Projected Interest for Open Interest Payable GLs TD must be maintained as data element 13 Others specify LCY Balance Based on the Other GL maintenance in the Data Element maintenance A TOTAL OUTFLOWS Sum of all the outflows B CUMULATIVE Cell B1 A1 UTERO Cell B2 A1 A2 Cell B3 B2 A3 Cell B4 B3 A4 Cell B5 B4 A5 Cell B6 B5 A6 Cell B7 B6 A7 Cell B8 B7 A8 Cell B9 B8 A9 Cell B10 B9 A10 Total B10 4 62 ORACLE The following table gives the outflow details for all the active accounts that have balance S Name Head of System Data Conditions No Accounts 1 Cash Sum of LCY balance of the Cash Cash GL must be GLs gets updated maintained for data Cash on hand GL element Cash at ATM GL and Foreign Currency Notes GL Bay bucket 2 Balances with RBI Sum of LCY balance of the Balance Balance with RBI GL with RBI GL gets updated must be maintained for data element Day 1 bucket 3 Balances with Label other Banks 3 1 Current Sum of LCY balance of the Balance Balance GLs must be Account GLs gets updated maintained as data element Non withdrawal portion on account of stipulations of minimum balances may be shown under Over 1 3 years bucket and the remaining balances may be shown under Day 1 bucket 3 2 Money at Call Sum of LCY balance of the Nostro Nostro GLs must be and Short Notice GLs gets updated maintained as data
84. g for Advances to Agriculture Part B are DISTRICT ACTIVITY _OCCUPATION and LAND HOLDINGS 4 26 1 System Data Mapping for Advances to Agriculture Part A The pre requisites for data population in Advances to Agriculture Part A are as follows e The accounts must be open and must have a balance greater than zero The accounts should be active i e all active loans are considered e The data should be populated state wise which is derived from the data store using the UDF DISTRICT e The UDF LAND HOLDINGS is maintained where you can specify the acres and the mapping using the data element maintenance Also the holding ranges are maintained as data elements in the system The following table gives the system data mapping for Advances to Agriculture Part A Columns Description Condition Name of the Bank AD Bank Name Name of the State Union District is maintained as State will be derived from the territory UDF Data store Up to 2 5 acres Label Disbursements during the The number of accounts UDF year and the amount disbursed ACTIVITY_OCCUPATION during the year for area up values 01121 01129 01101 to 2 5 acres is displayed 01121 Balance Outstanding The number of accounts UDF which have a balance ACTIVITY OCCUPATION 4 99 ORACLE Columns Description Condition outstanding as on 31 March and the outstanding for those accounts provided
85. gure Or 2 only if 1 5 is a minus figure Part B For non scheduled Banks only Label 4 38 ORACLE S No Columns Description Conditions Minimum amount of cash reserve required to be maintained under Section 18 of the Banking regulation act 1949 3 of 7 as on the last Friday of the preceding fortnight 3 of 7 as on the last Friday of the preceding fortnight Derived value Cash reserve actually maintained 3 4 6 3 4 6 Derived value Excess of 9 over 8 Excess of 9 over 8 Derived value 9 8 Part C Label Minimum amount of assets required to be maintained under section 18 and 24 of regulation act 1949 25 percent or such other specified percentage of 7 as on the last Friday of the second preceding fortnight 25 percent or such other specified percentage of 7 as on the last Friday of the second preceding fortnight Derived value 12 a Balance required to be maintained under the section 42 of the RBI Act 1934 LCY Balance for the GLs maintained under SEC_42 GL 12b Balance maintained by Scheduled banks with RBI LCY Balance for the GLs maintained under SCHEDULED_BANK_GL 12 c Excess of 12 b over 12 a Excess of 12 b over 12 a Derived value Assets actually maintained Label 4 39 ORACLE S No Columns Description Conditions
86. hased For accounts with credit limit of Rs 25 thousand and less For current account in case of overdraft account For Retail Loans in case of Loan account No of accounts Number of accounts Credit Limit The credit limit sanctioned Amount outstanding Additional value populated other than all occupations Sum of LCY balance of advance GL s Festival Advance Interest Free Rent Advance Manual Cheques Purchased For accounts with credit limit of over Rs 25 thousand and up to Rs 2 Lakh For current account in case of overdraft account For Retail Loans in case of Loan account 4 12 ORACLE 4 6 3 System Data Mapping for BSR 1 Summary 4 7 Following are the details displayed for BSR 1 summary reports Item Summary Items No of Credit Amount Conditions code Accounts Eam Outstandi Rs ng a Rs thousand 991 Total of BSR 1A Total numberof The The Refer accounts In total amount BSR1A BSR1A the Max credit outstanding S No limit 992 Total of BSR 1B Total number of The The Value in accounts total amount 950 refer credit outstanding BSR1 B limit 990 Grand Total 991 992 Total number of The The accounts total amount credit outstanding limit 999 Total credit as per Total number of The The Bank credit Section 42 2 accounts total amount in India credit outstanding excluding limit inter bank advances as reported under
87. he Data Element maintenance b 4 Inter bank Lendings Balance of Money Market Contracts with Currency in FCY b 5 Others Based on the ASSETS _OTHERS_GL GL maintenance in the 4 28 ORACLE Data Element maintenance Total Assets To be indicated Total Assets indicated with a plus sign with plus sign Balance Sheet GAP a b Balance Sheet GAP Total Liabilities indicated with minus sign Total Assets indicated with plus sign RESIDUAL GAP B D Difference between Off Balance Sheet GAP and Balance Sheet GAP MAP is a currency wise report 4 10 Interest Rate Sensitivity SIR Reports The SIR statements which are branch wise reports are forwarded by authorized dealers to RBI on a monthly basis All the data with respect to the account balances from FX TD MM BC and CL modules are extracted and maintained in the system You can generate the SIR report using MIS Date and Branch as the search criteria The gap is calculated as the difference between total assets and the total liabilities For some products the interest rate sensitivity is calculated individually The Net Gap is calculated as the difference between the Gap that is calculated and the other products total 4 10 1 System Data Mapping for SIR The following table gives the system data mapping for SIR reports SI Name Head of FCUBS Data Conditions No Accounts A L
88. he currency should not be INR e The report should take the NOSTRO accounts The following table gives the system data mapping for BAL reports 4 87 ORACLE SI Columns FCUBS data Conditions No Country Country code of the below Foreign Currency is displayed Currency All Foreign Currencies are displayed Foreign currency Label balances in Current account The Sum of Closing book Closing balance date lt MIS balance of external accounts date in the foreign currency is displayed 1 Credit Above Current Account Sum is displayed in credit if it is positive 2 Debit Above Current Account Sum is displayed in debit if it is negative 3 Fixed Deposit The Outstanding balance of all TDs in FCY 4 Treasury Bills Not filled 5 Securities Not filled 6 Loans The sum of Outstanding Account status must be Active balance of MM and or Hold Outstanding balance of Loans in the currency of the country is displayed 7 Total Displays the sum of balances of all the accounts currency wise Balances held by Label overseas branches and correspondents in non resident rupee A Cs with A D in Indian Rupees 8 Credit Not Filled 9 Debit Not Filled 4 88 ORACLE 4 22 Special Return1 Disbursal of Credit to Agriculture The Special Return 1 statement which is a branch wise report is forwarded by the banks to RBI ona yearly basis The data from CL and BC modules a
89. his is considered only for unclaimed Less Incidental charges levied to Number of accounts is displayed The outstanding amount is displayed If Sum of previous year s 4 86 ORACLE Particulars No of Accounts Outstanding Description Balance the accounts during savings account and the year deposits balance is greater than Sum of Savings account balance for the current year then Charge Sum of previous year s savings account balance Sum of Savings account balance for the current year Else Charge is Null This is considered only for unclaimed Total Number of accounts The outstanding Total balance as at is displayed amount is displayed MIS date Add Interest credited to the accounts during the year Less Incidental charges levied to the accounts during the year 4 21 Balance Held Abroad BAL Statements The BAL statement which is a bank wise report is forwarded by the authorized dealers to RBI on a fortnightly basis The data from CASA CL MM and CORE modules are maintained in the system You can generate the report using MIS Date and bank code as the search criteria The following details are displayed in the report e Name and address of Authorized Dealer e A D Code No 4 21 1 System Data Mapping for BAL The pre requisites for data population in BAL reports are as follows e The country should not be India and t
90. iabilities It s a Label in the report 1 FCNR B For FCNR TD products with Account not Closed Currency is FCY like USD Data element FCNR can be Sum of TD Principal defined to restrict the TD Amounts till MIS Date Products 2 EEFC Maintained as Account Class This shows Sum in Account Currency Always in first Time bucket 3 RFC Sum of Balance of TD 4 29 ORACLE SI Name Head of FCUBS Data Conditions No Accounts and SA accounts The values will be available only the first bucket for Savings Account else distributed across buckets Account Class level data element is maintenance 4 Overdrafts in This shows Sum of All gl s of GL type Nostro 1 Nostro A c positive value of bucket Account Currency Balance only when the Balance goes negative for all Nostro GL s 5 Interbank Sum of FCY balance Product is maintained as Inter borrowings from the MM contracts bank borrowings based on the Product code 6 LOC BAF None 7 Others Specify Based on the Others GL maintenance in the Data Element maintenance Total Liabilities Summation of total liabilities B Assets It s a Label in the report 1 Nostro Balances S mort balanceo all Nostro GL s should be Nostro GL s for which maintained as a Data Element Balance is positive Always in first Time bucket 2 Short term Balance from the MM investments placement products 3 Loans None Label
91. ildren in Urban Areas DWCUA programme envisages special incentive to urban poor women who decide to set up self employment ventures in a group The report contains the following data e Name of the Bank e Report showing the cumulative position for the quarter ended under the DWCUA component of SUSRY The pre requisites for data population in DWCUA reports are as follows e Account must be open and must have an outstanding balance e Account status is not closed liquidated reversed or on hold for loans e The UDF SCHEME_TYPE has the value Development of Women and Children in Urban Areas The following table contains the details on the data which needs to be captured on quarterly basis for States and Union territories for DWCUA reports S No Columns Description 1 Name of the State District is maintained as UDF State will be Union Territory derived from the Data store 2 No of applications No values currently filled Received 3 DWCUA sanctioned Label 3 1 No of groups This is the number of accounts 3 2 Total members This is from the UDF TOTAL_MEMBERS 3 3 Amount Sanctioned The sanctioned amount of loans gets displayed 4 DWCUA disbursed Label 4 74 ORACLE S No Columns Description 4 1 No of groups The no of groups for which amount is disbursed gets displayed 4 2 Total members This is from the UDF TOTAL_MEMBERS 4 3 Loan amount disbursed
92. ined in the system You can select the appropriate one Event Code Specify the event code The adjoining option list displys a list of all the event codes maintained in the system You can select the appropriate one Amount Tag Specify the amount tag The adjoining option list displys a list of all the amount tags maintained in the system You can select the appropriate one Purpose Code Select the purpose code from the adjoining option list Once you save you can modify the value of Purpose Code only You can click on the or button to add or remove rows 4 12 2 1 Operations you can Perform on R Record Details On the r record details maintenance you can perform the following operations e Add a record e Modify a record e Delete a record 4 44 ORACLE 4 12 3 Viewing R Return Details You can view the r returned details maintained for report generation and submission using the R Return Maintenance summary screen You can invoke this screen by typing MDSRRETM in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button R Return Maintenance Web Page Dialog Authorization Status Record Status Branch Q Search Advanced Search wv Lock 1 j 3 Records per page 15 3 Authorization Status Record Status Branch Branch Description In the above screen you can base your queries on any or all of the following parameters and
93. ing RPDPARAM in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button 4 Reporting System Parameters Web Page Dialog p 21x Branch CHO Spool Path D spool Spool History Path exportshomestest Time Out 60 Server Report Path export homestest Input By AMITS Date Tim 2 Modification Number 6 Iv Open Exit Authorized By AMITS Date Time 7 3 2000 12 41 40 iv Authorized Here you need to specify the following details Branch The system displays the branch for which you are maintaining the spool path However you cannot modify it Spool Path Specify the location to which the reports should be spooled The system stores the generated reports into this location if you have selected Spool in the Printing Preferences screen Spool History Path Specify the spool history path This is the generation where the system saves the generated report It is usually the same as the spool path Time Out Specify the time span within which you wish to complete the process The system reports if it takes longer time to generate it Server Report Path This is the location where the system stores the report if you have selected the option View in the Printing Preferences screen 2 3 Viewing Messages for Unauthorized Contracts You can view all messages to be generated for unauthorized contracts You can invoke this screen by typing MSDM
94. into term loans In case of over dues the overdue amount is considered as a new loan and the existing loan is closed This is maintained in the system using the UDF CROPTTOTERM The UDF LAND HOLDINGS is maintained in the system where in you can specify the acres and the mappings using the data element maintenance The following table gives the details for Special Return 1 Section 1 reports Columns Description 4 89 ORACLE Columns Description Name of the Bank AD Bank Name Name of the State Union territory District is maintained as UDF Up to 2 5 acres Disbursements during the year The number of accounts and the amount disbursed during the year for area up to 2 5 acres is displayed Balance Outstanding The number of accounts which have a balance outstanding as on 31 March and the outstanding for those accounts provided the area is up to 2 5 acres is displayed gt 2 5 acres and up to 5 acres Disbursements during the year The number of accounts and the amount disbursed during the year for area of gt 2 5 acres to 5 acres is displayed Balance Outstanding The number of accounts which have a balance outstanding as on 31 March and the outstanding for those accounts provided the area of gt 2 5 acres to 5 acres is displayed above 5 acres Disbursements during the year The number of accounts and the amount disbursed during the year for
95. iption Conditions 9 No of accounts The number of accounts sanctioned to SC out of the total sanctioned 10 Amount The amount sanctioned to SC out of the total amount sanctioned 11 of 9 4 Derived value Loans sanctioned to UDF SECTOR value SC out of total 100000029 disbursed 12 No of accounts The number of accounts disbursed to SC out of the total disbursed 13 Amount The amount disbursed to SC out of the total amount disbursed 14 of 12 6 Derived value Loans sanctioned to UDF SECTOR value ST out of total 100000030 sanction 15 No of accounts The number of accounts sanctioned to ST out of the total sanctioned 16 Amount The amount sanctioned to ST out of the total amount sanctioned 17 of 15 4 Derived value Loans sanctioned to UDF SECTOR value ST out of total 100000030 disbursed 18 No of accounts The number of accounts disbursed to ST out of the total disbursed 19 Amount The amount disbursed to ST out of the total amount disbursed 20 of 18 6 Derived value Loans sanctioned to UDF SECTOR value OBC out of total sanction 100000039 OBC 4 96 ORACLE S No Columns Description Conditions 21 No of accounts The number of accounts sanctioned to OBC out of the total sanctioned 22 Amount The amount sanctioned to OBC out of the total amount sanctioned 23 of 21 4 Derived value Loans sanctioned to OBC out of total disbursed 24
96. itions Total of 1 Total of 1 2 Liabilities in India Other Demand and Time PRODUCT_ELEMENT will be to Others Liabilities ODTL include provided to include and excluding interest accrued on exlude the Products from borrowings from the Reserve Bank EXIM Bank NABARD Demand Liabilities Time Liabilities deposits bills payable unpaid dividends suspense account balances representing amounts due to other banks or public net credit balances in branch adjustment account any amounts due to the Banking System which are not in the nature of deposits or borrowing Such liabilities may arise due to items like i collection of bills on behalf of other banks ii interest due to other banks and so on Participation Certificates issued to other banks the balances outstanding in the blocked account pertaining to segregated outstanding credit entries for more than 5 years in inter branch adjustment account the margin money on bills purchased discounted and gold borrowed by banks from abroad Bills Loans LC LCY Balance for the GLs maintained under ODTLIAB_ DEP_GL LCY Balance for the GLs maintained under ODTLIAB _ BILLS PAY_GL LCY Balance for the GLs maintained under ODTLIAB _ UNPAID _DIVDND_GL LCY Balance for the GLs maintained under ODTLIAB _ SUSPENSE_GL LCY Credit Balance for the GLs maintained under ODTLIAB_ BRN_ADJ_GL LCY Balance for the GLs
97. ity sector advance Ss sanction ed to member s of specified minority communi ties vis a vis overall priority sector Bills CL OD PSA MIN Summary MINOR ITY DISTRI CT PRODUCT_ELEMENT_MINR Non mandator y Foreign Exchang e Manage ment Act 1999 Guidelin es for Compilat ion of R Returns Nostro Bills FT RRE TNN Summary NA CASH_BAL_GL DEP_OAD_GL DEP_RBI_GL FCY_LOAN_GL FIXED_DEP_GL PUR_AGGR_BRN SALES_AGGR_BRN SECURITY_SHARES_GL SUSP_BAL_GL TREASURY_GL Mandator y FETERS R return Bills FT NA NA NA NA NA 5 16 ORACLE RBI Mod Repo Detailed UDF M Data Element Whether Return ules rtld Summary IS Data Name Element isManda tory Non Mandato ry Stateme Bills STA Summary DISTRI Non nt of CL GRI CT AGRI_PARTA mandator Advance LAND_ AGRI_PARTB y s to HOLDI AGRI _RECOVERY Agricultu NGS ACRES_RANGE_1 re ACTIVI ACRES RANGE _2 TY_OC CUPAT ION Return CL SUIT Detail SUIT_ ASSETCLASS Mandator 20 Suit FQ FILED SUITACCBALANCE y Filed and SUIT Decreed FA PMRY CL PMR Summary SCHE QUARTERLY_PROGRESS Non YQ ME_TY MONTHLY_PROGRESS mandator PMR PE HALFYEAR_RECOVERY y YM SECT PMR OR YH DISTRI CT PHYSI CAL C HALLE NG ACTIVI TY_OC CUPAT ION LAND_ HOLDI NGS 5 17 ORACLE ORACLE Reports October 2015 Version 11 6 0 0 0
98. lakh Code No 602 No of Accounts Count of the term deposits with the deposit in the range of Rs 1 lakh amp above but less than Rs 15 lakh Code No 603 Amount Outstanding Outstanding of the term deposits with the deposit in the range of Rs 1 lakh amp above but less than Rs 15 lakh Code No 603 No of Accounts Count of the term deposits with the deposit in the range of Rs 15 lakh amp above but less than Rs 1 crore Code No 604 Amount Outstanding Outstanding of the term deposits with the deposit in the range of Rs 15 lakh amp above but less than Rs 1 crore Code No 604 No of Accounts Count of the term deposits with the deposit in the range of Rs 1 crore amp above Code No 605 Amount Outstanding Outstanding of the term deposits with the deposit in the range of Rs 1 crore amp above Code No 605 No of Accounts Total Count of the term deposits from 601 605 Code No 600 Amount Outstanding Total Outstanding of the term deposits from 601 605 Code No 600 4 20 ORACLE 4 7 5 System Data Mapping for BSR 2 Part V The BSR 2 Part V reports are used to obtain information on outstanding amount of term deposits as on the reference days of the return classified according to the residual period of maturity This information is submitted by the computerized branches of the scheduled commercial banks The range of residual maturity days is maintained as
99. lowing table contains the details for SGSY Cumulative Position reports S No Columns Description 1 Name of State Union territory District is maintained as UDF State will be derived from the Data store 2 Annual financial target No values currently filled 3 Applications received up to the No values currently filled previous month 4 76 ORACLE S No Columns Description Applications Received during the month No values currently filled Total applications received from April up to the current month No values currently filled Applications loans sanctioned from April current year up to the month The no of account sanctioned and the sanctioned amount of loans whose sanctioned date is between 1 April of the current year and the current day The Number of accounts and the disbursed amount is classified into 2 groups Individuals SHGs Applications loans disbursed from April current year up to the month The no of account disbursed and the disbursed amount of loans whose disbursed date is between 1 April of the current year and the current day The Number of accounts and the disbursed amount is classified into 2 groups Individuals SHGs No of Applications returned rejected No values currently filled No of Applications pending for decision No values currently filled No of Applications sanctioned but not disbursed No
100. ndator y Stateme nt of priority sector advance S Bills OD CL PSA _WK Summary SECT ACTIVI TY_OC CUPAT ION PRODUCT_ELEMENT_PSA Non Mandator y 5 9 ORACLE RBI Return Name Mod ules Repo rt Id Detailed Summary UDF M IS Data Element Whether Data Element isManda tory Non Mandato ry Structura Liquidity str_lq Summary NA CAPITAL_GL RESERVE_SURPLUS_GL CURR_DEP_AC_COL1 CURR_DEP_AC_COL2 CURR_DEP_AC_COL3 CURRENT_DEPOSIT_ACCLAS S CURR_DEP_GL_COL1 CURR_DEP_GL_COL2 CURR_DEP_GL_COL8 CURRENT_DEPOSIT_GL SAV_DEP_AC_COL1 SAV_DEP_AC_COL2 SAV_DEP_AC_COL8 SAVINGS_DEPOSIT_ACCLASS SAV_DEP_GL_COL1 SAV_DEP_GL_COL2 SAV_DEP_GL_COL8 SAVINGS_DEPOSIT_GL OUTFLOW_TD_PRODUCTS TERM_DEPOSIT_GL CERT_OF_DEPOSIT_GL CALL_SHORT_NOTICE_COL1 CALL_SHORT_NOTICE_COL2 CALL_SHORT_NOTICE_COL3 CALL_SHORT_NOTICE_COL4 CALL_SHORT_NOTICE_COL5 CALL_SHORT_NOTICE_COL6 CALL_SHORT_NOTICE_COL7 CALL_SHORT_NOTICE_COL8 CALL_SHORT_NOTICE_COL9 CALL_SHORT_NOTICE_COL10 CALL_SHORT_NOTICE_GL INTER_BANK_TERM_PRODUC TS REFINANCE_GL BORROWINGS_OTHERS_GL BILLS_PAY_COL1 BILLS_PAY_COL6 BILLS_PAYABLE_GL PROVISIONS_GL OTHR_LIAB_OTHERS_GL LOC_INSTITUTION_PRODUCT S LOC_CUSTOMER_PRODUCTS UNAVAILED_PRODUCTS LC_GTY_PRODUCTS Mandator y 5 10 ORACLE RBI Return Name Mod ules Repo rt Id Detailed Summary UDF M I
101. ndicated with a minus sign Sum of all off balance Sheet Items indicated with a minus sign b Items in the nature of Assets Label b 1 Merchant Purchases Sum of Foreign Currency balance for FX Contracts FX Product with Buy Deal Bought leg is a FCY Auto Liquidation Set to No Forward FX Product b 2 Inter bank purchases If Buy Sell flag is Buy then sum of Foreign Currency balance of contract else sum of Sold Amount for FX Contracts FX Product with Either Buy Sell Deal Bought leg is a FCY like USD Auto Liquidation Set to Yes 4 25 ORACLE b 3 Overseas Purchases None b 4 Purchases from RBI Sum of Foreign Currency balance for FX FX Product with Buy Deal Contracts Bought leg is a FCY like USD Sell leg is a LCY like INR b 5 Currency Swaps Label b 5 1 Purchases against INR If Buy Sell flag is Sell then sum of Foreign Currency balance of contract else sum of Bought Amount for FX Contracts FX Product with Either Buy Sell Deal Bought leg is a FCY like USD Sell leg is a LCY like INR b 5 2 Cross Currency If Buy Sell flag is Sell then sum of Foreign Currency balance of contract else sum of Bought Amount for FX Contracts FX Product with Either Buy Sell Deal Bought leg is a FCY like USD Sell leg is not LCY Contract Status is Active b 6 Others Based on the OTHR_ASSET_PRODUCTS m
102. nes 4 66 4 15 1 System Data Mapping XOS Reports Part l wi eccecccesccesccesceseceseesseeeeeeeeseeeseeeeecusecsaecaecaecaeeaeeeneees 4 66 4 16 RETURN 25 EXPORT CREDIT DISBURSEMENTS AND BALANCE OUTSTANDING cccceccesssesseeetseseeeeneenees 4 68 4 16 1 System Data Mapping for Return 25 All EXPoOrts c cccccesccescsseesseesseeeeeecesecesecesecesecaecaecaseeseeeneees 4 68 4 16 2 System Data Mapping for Return 25 Gold Card Holders cc sccesccesceesseesceescesecesecese cuss cueeeeeensees 4 70 4 17 SJSRY AND SGSY REPORTS wii sects E age NA ae eee aoe ea ae eS 4 72 4 17 1 Swarna Jayanti Shahari Rozgar Yojana STSRY Reports sccsccssssssesseeseceeecesecesecnsecnseceeeeeeneees 4 72 4 17 2 Swarnajayanti Gram Swarozgar Yojana SGSY Reports sccscesseeseesceeeceeecesecesecaecnseceeeseeeneees 4 76 4 18 ADVANCES AND DIFFERENTIAL RATES OF INTEREST DRI TO SC ST ou eeccscceeseceeeesneceessseeeeeseeeeeees 4 80 4 18 1 System Data Mapping for Advances to SC ST ccccccsccesccescesecsseeseeeseeeseeeneeseeeecnseceaecaecsaessaeeaeeeneees 4 80 4 18 2 System Data Mapping for Statement by Public S Ctors 1 ccccsccessesseesseeeeeeeeeeceeecesecesecneceeeaeeeseees 4 80 4 18 3 System Data Mapping for DRI for SC ST ccccccesccesscessceseceecneeeseeeseeeeeeseeeeeeeecsecaecaecaaecsaeeseeeaeees 4 81 4 19 ADVANCES TO MINORITY COMMUNITY cccccsssssessseseeecsseseeecseeseeecsseseeecsseseeecnseseeesnseseeesneeseeesnseneeneneenees 4 81
103. ng to Original Maturity 2LESSER1825 Part2 Classification of Term Deposits according to Original Maturity 2GREATEREQUAL1825 Part2 Classification of Term Deposits according to Original Maturity 6GREATEREQUAL29 Part5 Classification of Term Deposits according to Residual Maturity 6LESSER46 Part5 Classification of Term Deposits according to Residual Maturity INTER_BANK_PROD Part 1 Classification of Deposits according to Type Basic Bills BSR Summary ORGS PRODUCT_ELEMENT_BSR1B Statistica CL 1B UBTYP TOTAL_ADVANCES TOTAL_ Return OD E ADVANC 1B BORR ES is OWAL Mandator TYPE_ y OF_AC COUN T ACTIVI TY_OC CUPAT 5 6 ORACLE RBI Return Name Mod ules Repo rt Id Detailed Summary UDF M IS Data Element Whether Data Element isManda tory Non Mandato ry ION DSB return no X report on maturity and position forex FX TD Bills CL MAP Summary EEFC_GL CROSS_CCY_BUY PCFC_PRODUCTS OVERDRAFTS_NOSTRO_GL TD_RFC_PRODUCTS NOSTRO_BALANCE_GL INTER_BANK_BORROW_GL INTER_BANK_PURCHASES PURCHASE_FROM_RBI BUY_SALES_AGAINST_LCY MERCHANT_PURCHASES MERCHANT_SALES INTER_BANK_SALES CROSS_CCY_SELL DISC_BILLS_PRODUCT BORROWING_OTHERS OTHR_LOAN_ASSET_PRODUC TS MAPCCY OTHR_ASSET_PRODUCTS INTER_BANK_BORROW_PROD UCTS FCNR_PRODUCTS INTER_BANK_LENDING_PROD UCTS TD_FCNR_PRODUCTS SELL_SALES_AGAINST_LCY Mandator y 5 7 OR
104. nsactions processed in your bank 1 3 Organization This manual is organized into the following chapters Chapter 1 About this Manual gives information on the intended audience It also lists the various chapters covered in this User Manual Chapter 2 Retrieving Information in Oracle FLEXCUBE explains how reports can be generated for different modules Chapter 3 Reports Batch explains the maintenance of reports pertaining to a particular branch Chapter 4 RBI Regulatory Reports gives details of the submission of returns by commercial banks to the Reserve Bank Chapter 5 Annexure A User Defined Fields and Data Elements gives the details of the UDF values for pertaining to RBI Regulatory Reports 1 4 Conventions Used in this Manual Important information is preceded with the symbol 1 5 Glossary of Icons This User Manual may refer to all or some of the following icons Icons Function Exit Add row Delete row 1 1 ORACLE Icons Function ass Option List ORACLE 2 Retrieving Information in Oracle FLEXCUBE 2 1 Introduction During the day or at the end of the day you may want to retrieve information on any of the several operations that were performed during the day in your bank You can generate this information in the form of reports in Oracle FLEXCUBE For every module you can generate reports which give you data
105. nt isManda tory Non Mandato ry Basic Bills BSR Summary ACTIVI PRODUCT _ELEMENT_BSR3 Non Statistica CL 3 TY_OC Mandator l OD CUPAT y Returns ION 3 BORR OWAL BEF Bills BEF Detail IECOD Mandator statemen E BEF_PRODUCTS y t BEF_CCY BEF_AMOUNT BEF _ PERIOD Basic Bills BSR Detail UTILIZ PRODUCT ELEMENT BSR1A Non Statistica CL 1A ED DI Mandator Return OD STRIC y I 1A T POPC ODE TYPE_ OF_AC COUN T ORGS UBTYP E BORR OWAL ACTIVI TY_OC CUPAT ION 5 1 ORACLE RBI Return Name Mod ules Repo rt Id Detailed Summary UDF M IS Data Element Whether Data Element isManda tory Non Mandato ry Basic Statistica Return II CAS A TD BSR Summary NA MAT_ACCLASS Part2 Classification of Term Deposits according to Original Maturity INT_ACCLASS Part3 Classification of Term Deposits according to Interest Rate Range DEP_ACCLASS Part4 Classification of Term Deposits according to Size RES_ACCLASS Part5 Classification of Term Deposits according to Residual Maturity TYP_ACCLASS Part 1 Classification of Deposits according to Type LESSER5 Part3 Classification of Term Deposits according to Interest Rate Range GREATEREQUALS5 Part3 Classification of Term Deposits according to Interest Rate Range LESSERG6 Part3 Classification of Term Deposits according to Interest Rate Range GREATEREQUALE6 Part3 Classification of Term Deposi
106. nt created with Export Bill products and Export Bill Rupee Advance products that are linked to a Loan Product All Active Loans linked to Bills and Bills have LCY Advancing set to Yes And Loan in LCY EBR Rediscounting of Export Bills Abroad Scheme Disbursed amount in case of bills with purchase discount date between maximum and minimum date LCY balance outstanding is Outstanding balance of loan EBR Data Element created with Post shipment Export Bill Rediscounted products both Sight amp Usance with operation in Purchase and Discount All Active bills that have Rediscount Date greater than Bill Shipment Date 4 69 ORACLE Columns Disbursement Balance Conditions Outstanding The amount of bills discounted rediscounted under EBR Scheme on without recourse basis should be excluded from the balance outstanding Deferred Payments None None Deferred Data Element created with Deferred Products Note Currently these values are empty Other Govt None None Payments Other Product Data Element created with Other Products Note Currently these values are empty 4 16 2 System Data Mapping for Return 25 Gold Card Holders The UDF GOLD_CARD_HOLDER is used to identify the gold card holders The following table contains the data of the gold card holders Columns Disbursement Balance Outstanding
107. oating or Fixed rate indicator Interest Flag Indicator Rate of Interest Interest rate of the Bills Loans account is displayed Credit limit in thousands of rupees Credit limit is the limit amount for Bill accounts and the Sanctioned amount for the loans Amount outstanding in thousands Amount Outstanding is taken for Loans Bills Remarks Branch Code The user can also enter manually 4 9 ORACLE Following are the codes for the different types of accounts S Type of Account Code Conditions No 1 Cash Credit 10 Pledge Hypothecation type of accounts Cash Credit Data element will be defined 2 Overdraft 20 OD Current Savings Account All OD Current Savings Account are considered OD Data element can be defined to restrict a set of OD s 3 Demand Loan 30 Bill Data Element with Sight Usance Bills Products as below Import Bill with Operation as Acceptance Outward Export Bill with Operation as Collection Loan Data Element with below Loan Products Foreign Currency Denominated Loan Export Bill Crystallization Loan Inland LC Devolvement Loan 4 Loan extended through Credit 31 None Cards 5 Term Loan including interim cash credit pending sanction of term loans and installment credit 5 1 Medium Term Loans i e loans 41 Months between the maturity date and and advances granted for a period value date of the account is
108. of Entry e The Date of Remittance Advance 90 days is within the half year period The 90 days is maintained in the data element maintenance as the data element BEF_PERIOD e The Bill amount be it advanced or delayed payment exceeds 100000 USD This is maintained as a Data Element BEF_CCY BEF_AMOUNT e The Bill is listed if the Remitted amount is not equal to the total of the Bill of Entries e Once a record is reflected in BOE Part it is not repeated again in Part The UDF ORGSUBTYPE is used to identify the importer The following table reflects whether the importer is a government body or not Field System Field Conditions Name and address of This is the name and Address of The AD Code is maintained as AD branch the Head Office or the Branch Branch level UDF reporting the Data Name of Controlling This is the Regional Office Head Report Header Office of AD branch Office 4 5 ORACLE Field System Field Conditions Statement for the half year ended Month range Report Header S No This is the serial number for the records listed Importer Exporter Code No An I E Code at customer level Name and address of importer Drawee name and Address in Contract Main tab Parties Tab in BC contract screen No and date of import licenses if any License number and Issue date in the License subsystem LIC subsystem Brief description of goo
109. one based on the UDF maintained System Data Mapping for BSR 3 The pre requisites for BSR 3 reports are as follows e The account should be open and must have a balance greater than zero e Active bills both Import Export that are Purchased Discounted Advanced are considered The following table gives the system data mapping for BSR 3 reports Security ACTIVITY_OCCUPATION BORROWAL UDF UDF Mills Factories Industrial Others 4 22 ORACLE 4 9 Users Food grains Cereals 01101 01 29 49 41 45 31 39 Food grains Pulses 01102 01 29 49 41 45 31 39 Selected major oil seeds indigenously grown viz groundnut rapeseed mustard cottonseed linseed and castor seed oils thereof vanaspati and all imported oils and vegetable oils 11031 15104 01 29 49 41 45 31 39 raw cotton and kapas 01105 01 29 49 41 45 31 39 sugar gur Khandsari 01104 15402 01 29 49 41 45 31 39 cotton textiles which include cotton yarn man made fibres and yarn and fabrics made out of man made fibres and partly out of cotton yarn and partly out of man made fibres 17101 to 17105 18101 18102 01 29 49 41 45 31 39 STOP on a monthly basis The entire off balance sheet items in the nature of assets and liabilities and balance sheet items All amounts are in thousands Amount divided by 1000
110. port No and Generation Date Bill Evidence Failure BEF Report The BEF report which is a branch wise report is forwarded by authorized dealers to the RBI ona half yearly basis at the end of June amp December of every year All the FCY import transactions that occur in the BC module are maintained in the system The imports that do not accompany documents like Bill of Entry Customs Assessment Certificate Postal Appraisal Form are extracted by the system You can then generate the BEF report using MIS Date and Branch as the search criteria in case of convertible INR you have to maintain the products in the Data Element Maintenance screen Following are the two parts of a BEF report e PartI contains iinformation regarding importers who have failed to submit the documentary evidence of import e Part Il contains information regarding subsequent receipt of Exchange Control copy of Bills of Entry for Home Consumption Postal Courier Wrappers from importers whose names were reported in Part of earlier BEF statement s as defaulters 4 5 1 System Data Mapping for BEF Part The pre requisites for data population in Part of BEF reports are as follows e All foreign currency import bills are liquidated of the bill amount advanced EVENT_CODE LIQD or BADV and the products are maintained with the data element BEF_AMOUNT e All Foreign Currency Import Bills do not accompany documents like Bill
111. re extracted and maintained in the system You can generate the report using MIS Date and Bank as the search criteria The ALM report contains the following details e Name of the bank e Statement as on the Date You can adopt a granular approach for measurement of liquidity by having 10 time buckets as follows e Dayi e 2 7 days e 15 28 days e 29 days up to 3 month e Over 3 months and up to 6 months e Over 6 months and up to 3 years e Over 3 years and up to 3 years e Over 5 years e Total 4 58 ORACLE 4 14 1 System Data Mapping for ALM Reports For both the inflows and outflows the respective maturity buckets should be updated based on the data obtained on the fortnight The following table gives the outflow details for all the active accounts that have balance S Name Head of FCUBS Data Conditions No Accounts 1 Capital The sum of balance outstanding of Only the 5 year bucket Capital GLs like will be filled in the report i paid up capital GL and ii Forfeited shares GL are displayed 2 Reserves amp Surplus Itis the Sum of 1 and 2 Reserve GLs must be Sum of LCY balance of the maimamed asa data element reserves surplus GLs Only above 5 years time Net balance of the branch Income l GL s balance Expense GL s plore aets tied balance in the given date 3 Deposits Label 3 1 Current Deposit It is the sum of 1 and 2 1 Sum of Outstanding amount of CASA Account
112. re extracted and maintained in the system You can generate the report using MIS date and the branch as the search criteria The report displays the disbursements in a year and the amount outstanding for each type of loan across different Land Holdings Category and Loan Type short term or long term For Special Return 1 reports the account status for bills loans accounts should not be closed liquidated reversed or on hold The 2 parts of Return 1 reports are as follows e Part 1 this part displays the number of accounts disbursed amount and the balance outstanding for both short and long term loans for various land holdings as give below gt Upto 2 5 acres gt 2 5to5 acres gt Above 5 acres gt Total e Part2 this part contains the total direct finance to agriculture and allied activities disbursements during the year and the balance outstanding The land ranges are maintained as data elements in the system The minimum and maximum date for the MIS Date is obtained as follows Minimum For MIS month in JAN MAR the 1 April of previous year is taken as min Date date 1 April of current year is taken as the min date for others Maximum MIS date Date 4 22 1 System Data Mapping for Special Return 1 Section 1 The Special Return 1 Section 1 report contains the following details e Short term loans e Term loans e The crop loan dues in the notified affected areas converted
113. ription Conditions No 1 Name of District is maintained as UDF State will be Zone derived from the Data store 2 Recovery General 2 1 Demand This is the Principal due from the customers under the General category 2 2 Recovery Recovery amount of the loans is displayed 2 3 Overdues The amount outstanding post the due date in Loans 2 4 Recovery amount Demand amount 100 4 79 ORACLE 4 18 Advances and Differential Rates of Interest DRI to SC ST The Advances to SC ST statement which is a bank wise report is forwarded by the banks to RBI within two months from the end of the relevant half year year The data from the CL CASA and BC modules is extracted and maintained in the system You can generate the report using MIS Date and Bank as the search criteria Following are the 3 parts of the Advances to SC ST report Statement showing Advances granted to Scheduled Castes Scheduled Tribes Statement to be submitted by the public sector banks Advances under Differential Rate of Interest Scheme The pre requisites for data population in the Advances to SC ST reports are as follows For ST applicants the UDF SECTOR has the value IN 100000030 and for SC applicants the UDF SECTOR has the value IN 100000029 The account should not be closed and must have a balance The LC accounts should not be considered 4 18 1 System Data Mapping for Advances
114. rs as defined in the following table Amount Advanced The amount disbursed out of the credit limit Disbursed amount is purchased discounted ad vanced amount Disbursed Loan Amount The field data is captured for the Priority sectors as defined in the following table Balance Outstanding Outstanding amount of all the current accounts Outstanding balance in local currency of the loan contract Purchase advanced amount 4 56 ORACLE Field FCUBS Data Conditions The field data is captured for the Priority sectors as defined in the following table The amount outstanding post the due date in Loans The amount outstanding The amount outstanding post the post the maturity date in due date Bills Amount Overdue under Balance outstanding The field data is captured for the Priority sectors as defined in the following table 4 13 2 System Data Mapping for PSA Report Part PSA report Part 1 records the date based on the following classification e Scheduled Castes e Scheduled tribes e Women e Other categories using the weaker sections on the basis of amount of advance e Net position to be reported in Part of the PSA report System identifies the above mentioned classification based on the following e UDF SECTOR at the customer level to identify Scheduled Casts and Scheduled Tribes e Gender of the Customer as Female identifies
115. rting The R Return report which is a bank wise report is forwarded by the banks to RBI ona fortnightly basis The foreign currency inflow outflow transactions that occurred in BC CL Teller FX and FT modules are extracted from the system at the end of every fortnight The data extraction is based on the purpose codes defined by BRI Following are the instances for which the purpose codes are defined e Reporting Forex transaction Receipts e Reporting Forex Transaction Payments e Purpose codes for Cover page The data extraction is based on purpose code selection for BC RT and FT The R Return batch MDFRSRRN which is an intra day batch is maintained in the system This batch is run at the head office level which is required for R Return Nostro pages Note the following In FT contracts Purpose Code is mandatory only if the settlement account is Nostro which is validated by the system In case of FX transactions the data extracted is available n in the Nostro Cover page and the Q E File The extraction for the Cover page items is based on the following conditions Cover page Item Conditions 1 D Sales to other Authorised Dealers Credit Nostro in India Customer type is Bank Residence India 4 41 ORACLE Cover page Item Conditions 1 E Sales to Reserve Bank of India Credit Nostro Customer Type is Bank MDTM_REPORT_PARAM table name RBlL_CUSTOMER Customer CIF Residence
116. s Branch Code and Description Specify the code that identifies the branch The option list displays all valid branch codes maintained in the system Based on the branch code selected the system displays the description 3 2 1 Viewing Reports On this screen you can view the reports function IDs and description maintained for the selected branch Once you have specified the branch code click View button The system displays a list of reports maintained for the branch 3 Report Batch Execution Web Page Dialog i B 2 x Branch Code CHO AB Description BANK OF INDIA Report Function ID F Format O Function ID Function Description POF z Vv BCROBEFR List of Bills Eligible for Rediscourting Output R ACRUNCOL Uncollected Funds Print Output Print M BCROBUDS Report Bills in User Defined Statuses Spool M BCRODAPP Under Reserve Report Printer R CARPCKDT CASA Cheque Details Report Options Printer 7 Report Function ID This is the list of report function IDs that you have maintained in the Report Batch Maintenance screen Use the checkbox adjacent to each function ID to select the same for execution 3 2 2 Printing Spooling the Reports In the list of report function IDs use the checkbox adjacent to each ID to select the reports that you want to print or spool Before you print set the following preferences Format Select the format of the output The system allow
117. s Report1 Part A System identifies the above Advances to Minority Communities classification based on the following e UDF MINORITY at the customer level to identity Christians Muslims Buddhists Sikhs Zoroastrian e UDF DISTRICT at the branch level to identify the district of the minority community e UDF ACTIVITY _OCCUPATION at the transaction level to identify the Priority Sector The report contains the following data e Bank Name e Bank Code The following table contains the details for Advances to Minority Communities Report1 Part A No of Total vr Report iien Accounts outstanding Conditions Christians Number of The UDF MINORITY 1 accounts outstanding Muslims amount UDF MINORITY 2 Buddhists UDF MINORITY 3 Sikhs UDF MINORITY 4 Zoroastrian UDF MINORITY 5 Total A Summation of UDF MINORITY 1 to 5 Others B All Advances not belonging Minority Community for the District Total P S Advances in Identified Sum of A and B Districts C 4 19 2 System Data Mapping for Advances to Minority Communities Report1 Part B System identifies the above Advances to Minority Communities classification based on the following e UDF MINORITY at the customer level to identity Christians Muslims Buddhists Sikhs Zoroastrian e UDF DISTRICT at the branch level to identify
118. s which is a bank wise report are forwarded by the banks to RBI All the data with respect to the number of disbursed advanced and the outstanding amount in the CL module are extracted and maintained in the system You can generate the report using MIS Date and Bank as the search criteria Following are the 3 parts of a SGSY report e Cumulative Position Monthly Quarterly e Cumulative Progress Monthly Quarterly e Recovery half yearly The UDFs used for system data mapping for SGSY Cumulative Position reports are DISTRICT SCHEME_TYPE and SECTOR The UDFs used for system data mapping for SGSY Cumulative Progress reports are DISTRICT SCHEME_TYPE and SELF HELP GROUP The UDFs used for system data mapping for SGSY Recovery Statement reports are DISTRICT SCHEME_TYPE SECTOR PHYSICAL_CHALLENG and SELF HELP GROUP 4 17 2 1 System Data Mapping for SGSY Cumulative Position The SGSY Cumulative Position report which has to be submitted on a monthly quarterly basis contains the details of the loans sanctioned and loans disbursed during the month Individuals and Self Help Groups SGH The report also lists the applications pending and rejected for the month The report contains the following data e Name of the bank e Report showing the cumulative position for the month ended e Details on the all the loans to the SGSY scheme The fol
119. s you to print the reports in any of the following formats e HTML e RTF e PDF Output Indicate whether you need to print or spool the reports Use the radio button adjacent to each option to indicate your preference Printer Select the printer using which you need to print the reports Select the appropriate printer form the option list Once you have set your preferences click Ok button The system prints the reports as per the preferences you have set 4 1 4 2 4 RBI Regulatory Reports Introduction The Reserve Bank of India RBI requires the submission of returns by commercial banks to the Reserve Bank As part of the online submission of returns the Reserve Bank has adopted international standards for reporting among business entities RBI has also taken measures for the rationalization of returns The RBI has also adopted advanced methods for a better and healthier way of reporting of Banks Regulatory reporting is mainly through collection and process of manually prepared returns from branches of various banks Maintaining Data Element Details In Oracle FLEXCUBE you can maintain the select criteria and variables for data population in all the reports You can maintain the data element values for each report in the Data Element Maintenance screen You can invoke this screen by typing MDDDEMNT in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow
120. sored Corporations of Scheduled Castes UDF ACTIVITY_OCCUPATION Scheduled Tribes 65904 65905 2 3 Co operatives LAMPS identified in specific tribal areas UDF ACTIVITY_OCCUPATION by Government 65902 4 19 Advances to Minority Community The Advances to Minority Community which is a bank wise report is forwarded by the banks to RBI on a half yearly basis The data from CL CASA and BC modules is extracted and maintained in the system You can generate the report using MIS Date and Bank as the search criteria The 2 reports under Advances to Minorities are Report 1 and Report 2 Following are the 2 parts of Report 1 of Advances to Minorities e Part A Priority Sector Advances granted to Minority Community for Identified Districts e Part B Priority Sector Advances granted to Minority Community for all Districts in the Country i e State wise Report 2 of Advances to Minorities consists of the Priority Sector Advances granted to Minority Community The pre requisites for data population in the Advances to Minority Community reports are as follows e The account must be open and must have a balance greater than zero The account should be active i e all active loans are considered Active bills both Import Export that are Purchased Discounted Advanced are considered e The priority sectors should be taken from the PSA report 4 81 ORACLE 4 19 1 System Data Mapping for Advances to Minority Communitie
121. t Rate Range LESSER15 Part3 Classification of Term Deposits according to Interest Rate Range GREATEREQUAL15 Part3 Classification of Term Deposits according to Interest Rate Range 5LESSER25000 Part4 Classification of Term Deposits according to Size 5GREATEREQUAL25000 Part4 Classification of Term Deposits according to Size 5LESSER100000 Part4 Classification of Term Deposits according to Size 5GREATEREQUAL100000 Part4 Classification of Term Deposits according to Size 5LESSER1500000 Part4 Classification of Term Deposits according to Size 5GREATEREQUAL1500000 Part4 Classification of Term Deposits according to Size 5LESSER10000000 Part4 Classification of Term Deposits 5 3 ORACLE RBI Return Name Mod ules Repo rt Id Detailed Summary UDF M IS Data Element Whether Data Element isManda tory Non Mandato ry according to Size 5GREATER10000000 Part4 Classification of Term Deposits according to Size 6GREATEREQUALE6 Part5 Classification of Term Deposits according to Residual Maturity 6GREATEREQUAL7 Part5 Classification of Term Deposits according to Residual Maturity 6LESSER15 Part5 Classification of Term Deposits according to Residual Maturity 6GREATEREQUAL15 Part5 Classification of Term Deposits according to Residual Maturity 6LESSER29 Part5 Classification of Term Deposits according to Residual Maturity 6GREATEREQUAL46 Part5 Classifica
122. tanding Outstanding of the term deposits with the maturity period as 1 year amp above but less than 2 years Code No 407 No of Accounts Count of the term deposits with the maturity period as 2 years amp above Code No 408 4 16 ORACLE Field FCUBS Data Conditions but less than 3 years Amount Outstanding Outstanding of the term deposits with the maturity period as 2 years Code No 408 amp above but less than 3 years Count of the term deposits with the No of Accounts maturity period as 3 years amp above Code No 409 but less than 5 years Amount Outstanding Outstanding of the term deposits with the maturity period as 3 years Code No 409 amp above but less than 5 years No of Accounts Count of the term deposits with the Code No 410 maturity period as 5 years amp above Amount Outstanding Outstanding of the term deposits with the maturity period as 5 years Code No 410 amp above No of Accounts Sum of the accounts referring to code nos 401 410 CORE Hoan Amount Outstanding Outstanding of the accounts Code No 400 referring to code nos 401 410 4 7 3 System Data Mapping for BSR 2 Part Ill The BSR 2 Part III reports are used to obtain information on the distribution of term deposits according to the broad interest rate ranges The interest rate range is maintained as a data element The UDE is used to select the interest rate The data is classified as
123. th Either Buy Sell Deal Bought leg is a If Buy Sell flag is Sell then sum of a ie ep Foreign Currency balance of contract else sum of Bought Sell leg is a LCY b 5 1 Purchases against INR Amount for FX Contracts like INR FX Product with Either Buy Sell Deal Bought leg is a FCY like USD If Buy Sell flag is Sell then sum of Sell leg is not LCY Foreign Currency balance of contract else sum of Bought Contract Status b 5 2 Cross Currency Amount for FX Contracts is Active 4 11 Return 13 Form VIII The Form VIII which is a branch wise report is forwarded by the banks to RBI on a monthly basis The asset and liability details are derived from GLs You can generate the report using MIS Date and Branch as the search criteria 4 11 1 System Data Mapping for Return 13 Form The pre requisites for BSR 3 reports are as follows e The account must be open and must have a balance that is greater than zero e Active bills both Import Export that are Purchased Discounted Advanced are considered e Account_Class_Data_Element and Gl_Data_Element is provided to include and exclude the Account Classes and GL s respectively PRODUCT_ELEMENT is provided to include and exclude the Products from Bills Loans LC The report data is classified as follows e First Alternate Friday e Second Alternate Friday e Third Alternate Friday The following table gives the system data mapping for Form VIII
124. than INR 1 crore 4 92 ORACLE SUIT_FILED is a UDF maintained at the customer level 4 24 1 System Data Mapping for Suit Filed and Decreed The data for individual accounts as well as the aggregate for each customer is displayed here The following table gives the system data mapping for DRT Statements Columns Description Borrower s name and Address Customer Number Name Customer Account Number and Address of the Customer of the account Name of Director Name from Customer Corporate Directors Partners Proprietor Details Balance Outstanding Sum of Outstanding balance of Loans in crores Asset Classification Asset Classification data element is to be defined Date of Classification Date of the latest status change of the account Branch Details Name of the branch is displayed 4 25 PMRY Reports The PMRY report monthly quarterly progress reports and half yearly recovery statement which is a bank wise report is forwarded by the banks to RBI The disbursement details of all the active contracts in the CL module are maintained in the system You can generate the report using MIS date maximum date and the Bank Code as the search criteria Following are the 3 parts of a PMRY report e Monthly Progress Report e Quarterly Progress Report e Half yearly Recovery Report The UDFs used for system data mapping for PRMY reports monthly progress are SCHEME_TYPE and SEC
125. the area is up to 2 5 acres is displayed values 01121 01129 01101 01121 gt 2 5 acres and up to 5 acres Label Disbursements during the year The number of accounts and the amount disbursed during the year for area of gt 2 5 acres to 5 acres is displayed UDF ACTIVITY_OCCUPATION values 01121 01129 01101 01121 Balance Outstanding The number of accounts which have a balance outstanding as on 31 March and the outstanding for those accounts provided the area of gt 2 5 acres to 5 acres is displayed UDF ACTIVITY_OCCUPATION values 01121 01129 01101 01121 above 5 acres Label Disbursements during the year The number of accounts and the amount disbursed during the year for area of greater than 5 acres is displayed UDF ACTIVITY_OCCUPATION values 01121 01129 01101 01121 Balance Outstanding The number of accounts which have a balance outstanding as on 31 March and the outstanding for those accounts provided the area greater than 5 acres is displayed UDF ACTIVITY_OCCUPATION values 01121 01129 01101 01121 4 26 2 System Data Mapping for Advances to Agriculture Part B The pre requisites for data population in Advances to Agriculture Part A are as follows e The accounts must be open and must have a balance greater than zero The accounts should be active i e all active loans are considered e The data should be populated region wis
126. the following details as the search criteria Bank Reference Number Customer Number Currency Purpose Code Authorisation Status Record Status Transaction Date You can view the data captured for a record in the R Return Extracted Data Details screen This screen displays the data of the individual transactions 4 46 ORACLE To invoke the R Return Extracted data Details screen click on a record in the R Return Extracted Data summary screen Z R Return Extracted Data Webpage Dialog Transaction Date Bank Reference Number Currency Nostro Vostro Indicator Vostro Country Code Purpose Code Transaction Amount Indicator Amount In Foreign Currency Amounticy Invoice Gr Amount Gr Prefix Form Number Remarks Ref No URS Maker SYSTEM Checker SYSTEM Serial Number Bill Prefix Bill Number To Date Import Export Code Date Of Shipment Shipping Bill Number Customer Country Code Customer Number Under LC URS Beneficiary Name Remitter Name Date Time 9 30 2008 Mod No E Authorized Date Time 9 30 2008 E Open Specify the following details here Purpose Code Specify the purpose code from the adjoining option list Remark Ref No URS Specify your remarks on unclassified receipts survey here System displays the following details here Transaction Date System displays the date on which the transaction has occurred Serial Number System displays the sequence number appended to
127. the transactions The Serial Number ranges from 1 to 9999 Bank Reference System displays the Central Bank reference number for the transaction 4 47 ORACLE Currency System displays the bill currency for the transaction Nostro Vostro Indicator System displays V when currency is INR and N for all the other currencies Vostro Country Code System displays the code of the Vostro account holder s country Transaction Amount Indicator System displays the realization type in GR form System displays one of the following values e 0 Indicates otherwise e 1 Indicates full invoice e 2 lIndicates part invoice value e 4 Indicates Amount Zero e 5 Indicates combined GR forms Amount in Foreign Currency Unit System displays the credit amount without any decimal value and point in case of outward remittance and the debit amount in case of inward remittance Amount in Rupees System displays the local equivalent of the debit amount without any decimal value and point in case of outward remittance or credit in case of inward remittance to the customer account Invoice GR Amount System displays either the invoice amount or the GR amount in the GR forms whichever is applicable Gr Prefix System displays the GR prefix for the transaction Form Number System displays the form number for the transaction This field is blank for new export procedures Bill Prefix System displays
128. tion of Term Deposits according to Residual Maturity 6LESSER91 Part5 Classification of Term Deposits according to Residual Maturity 6GREATEREQUAL91 Part5 Classification of Term Deposits according to Residual Maturity 6LESSER183 Part5 Classification of Term Deposits according to Residual Maturity 6GREATEREQUAL183 Part5 Classification of Term Deposits according to Residual Maturity 6LESSER366 Part5 Classification of Term Deposits according to Residual Maturity 6GREATEREQUAL366 Part5 Classification of Term Deposits according to Residual Maturity 6LESSER730 Part5 Classification of Term Deposits according to Residual Maturity 6GREATEREQUAL730 Part5 Classification of Term Deposits according to Residual Maturity 6LESSER1096 Part5 Classification of Term Deposits 5 4 ORACLE RBI Return Name Mod ules Repo rt Id Detailed Summary UDF M IS Data Element Whether Data Element isManda tory Non Mandato ry according to Residual Maturity 6GREATEREQUAL1096 Part5 Classification of Term Deposits according to Residual Maturity 6LESSER1825 Part5 Classification of Term Deposits according to Residual Maturity 6GREATEREQUAL1825 Part5 Classification of Term Deposits according to Residual Maturity 2GREATEREQUAL7 Part2 Classification of Term Deposits according to Original Maturity 2LESSER 15 Part2 Classification of Term Deposits according to Original Maturity 2
129. tions transactions crediting transactions crediting the the account Credit to account Credit to Vostro Vostro in FX in FX Total Credits Sum of 3 4 5 Sum of 3 4 5 7 Exports Sum of all bill Sum of all bill transactions transactions are are displayed Debit from displayed Debit from Vostro in BC Vostro in BC 8A Transaction with Sum of all Payments Sum of all Payments Public Payments 5 equal to or above equal to or above 5lakhs lakhs and above 5lakhs Debit from Vostro Debit from Vostro in FT in FT and Other Modules and Other Modules 8B Transaction with Sum of all Payments Sum of all Payments Public Payments below 5 lakhs Debit from below 5 lakhs Debit from Below 5 lakhs Vostro in FT and Other Vostro in FT and Other Modules Modules 9 Withdrawal Sum of withdrawal Sum of withdrawal transactions transactions debiting the transactions debiting the account Debit from account Debit from Vostro in FX Vostro in FX Total Debits Sum of 7 8 9 Sum of 7 8 9 4 50 ORACLE on Vostro Column Bank Operati Private Exchange House Closing Balance Credits Debits Credits Debits During extraction any credit to the account is defaulted to purpose codes 4a or 4b and debit is defaulted to purpose codes 8a or 8b 4 12 6 Viewing R Return Vostro Cover Page Data You can view the extracted data for Vostro cover page using the R Return Extracted Data summary screen You
130. to SC ST The number of accounts and the outstanding is displayed for the Priority Sectors 4 18 2 System Data Mapping for Statement by Public Sectors The Statement by Public Sectors is applicable only for public sector banks where the loans are disbursed to the SGHs under the National Scheduled Tribes Finance Development Corporation NSTFDC Micro credit Scheme The pre requisites for data population in the statement by Public Sectors are as follows The UDF SCHEME_TYPE has the value NSTFDC The UDF ORGSUBTYPE will have the value from 11 to 16 The UDF SECTOR has the value 100000030 The following table contains the details for Statement by Public Sectors S No Column Conditions The Number of accounts and the outstanding amount disbursed for STs Loans disbursed to SHGs belonging to ungertnecohdilans STs under the National Scheduled SCHEME_TYPE UDF NSTFDC Tribes Finance Development Corporation NSTFDC Micro credit ORGSUBTYPE value 11 to 16 Scheme Is displayed 4 80 ORACLE 4 18 3 System Data Mapping for DRI for SC ST The UDF SCHEME_TYPE contains the value DRI The following table contains the details for DRI for SC ST S No Differential Interest Rates Conditions 1 UDF SECTOR 100000030 Advances directly granted 100000029 2 Routed through None 2 1 UDF ACTIVITY_OCCUPATION Regional Rural Banks 65103 2 2 State spon
131. ts according to Interest Rate Range LESSER7 Part3 Classification of Term Deposits according to Interest Rate Range GREATEREQUAL7 Part3 Classification of Term Deposits according to Interest Rate Range LESSER8 Part3 Classification of Term Deposits according to Interest Rate Range GREATEREQUAL8 Part3 Classification of Term Deposits according to Interest Rate Range LESSER9 Part3 Classification of Term Deposits according to Interest Rate Range GREATEREQUAL9Y Part3 Classification of Term Deposits according to Interest Rate Range LESSER10 Part3 Classification of Term Deposits according to INTER_B ANK_PR OD is Mandator y 5 2 ORACLE RBI Return Name Mod ules Repo rt Id Detailed Summary UDF M IS Data Element Whether Data Element isManda tory Non Mandato ry Interest Rate Range GREATEREQUAL10 Part3 Classification of Term Deposits according to Interest Rate Range LESSER11 Part3 Classification of Term Deposits according to Interest Rate Range GREATEREQUAL11 Part3 Classification of Term Deposits according to Interest Rate Range LESSER12 Part3 Classification of Term Deposits according to Interest Rate Range GREATEREQUAL12 Part3 Classification of Term Deposits according to Interest Rate Range LESSER13 Part3 Classification of Term Deposits according to Interest Rate Range GREATEREQUAL13 Part3 Classification of Term Deposits according to Interes
132. ts with a If Report Run Date is at the end of previous outstanding balance for Bills March 2010 half year ending and Loan in the previous half Period 1 April 2009 30th Sep 2009 If Report Run Date is Sep 2010 Mar Sep year 4 83 ORACLE Report Item Description Conditions Period 1st Oct 2009 and 30th Mar 2010 Amount outstanding at the end of half year under report Same as for previous half year except it shows for different periods If Report Run Date is March 2010 Period 1st Oct 2009 and 30th Mar 2010 If Report Run Date is Sep 2010 Period 1 April 2009 and 30th Sep 2010 Fresh loans disbursed No of Borrowers The no of accounts and which are sanctioned and disbursed in the specified period is displayed in this field Amount Sanctioned The Sanctioned amount of Loans whose sanctioned date is in the period specified Amount Sanctioned The Sanctioned amount of Bills whose Purchase Advance Discount Value Date is in the period specified Amount Disbursed The amount disbursed from Loans Bills whose disbursement date is in the period specified If Report Run Date is March 2010 Period 1st Oct 2009 and 30th Mar 2010 If Report Run Date is Sep 2010 Period 1 April 2009 and 30th Sep 2010 Note same period as above 4 20 Form VIII Return 11 Unclaimed Deposits The Form VIII statement which is a bank
133. tstanding Outstanding of the term deposits with the maturity period as 7 14 days Code No 401 No of Accounts Count of the term deposits with the maturity period as 15 29 days Code No 402 Amount Outstanding Outstanding of the term deposits with the maturity period as 15 29 days Code No 402 No of Accounts Count of the term deposits with the maturity period as 30 45 days Code No 403 Amount Outstanding Outstanding of the term deposits with the maturity period as 30 45 days Code No 403 No of Accounts Count of the term deposits with the maturity period as 46 90 days Code No 404 Amount Outstanding Outstanding of the term deposits with the maturity period as 46 90 days Code No 404 No of Accounts Count of the term deposits with the maturity period as 91 days amp above but less than 6 months Code No 405 Amount Outstanding Outstanding of the term deposits with the maturity period as 91 days amp above but less than 6 months Code No 405 No of Accounts Count of the term deposits with the maturity period as 6 months amp above but less than 1 year Code No 406 Amount Outstanding Outstanding of the term deposits with the maturity period as 6 months amp above but less than 1 year Code No 406 No of Accounts Count of the term deposits with the maturity period as 1 year amp above but less than 2 years Code No 407 Amount Outs
134. underlying table for currency swaps D Assets Assets Currency Currency Swaps from Assets is Currency Swaps from Assets calculated Refer the underlying 4 31 ORACLE SI Name Head of FCUBS Data Conditions No Accounts Swaps table for currency swaps E Gap Difference Liabilities Currency between Cand Swaps from Liabilities D Assets Currency Swaps from Assets F Other products IRS None FRAS None Others None Net Difference This would be the same as E between E and F SIR is a currency wise report The following table lists the items in the nature of Liabilities selling a foreign currency a 5 Currency Swaps Label If Buy Sell flag is Buy then sum of Foreign Currency balance of contract else sum of Sold Amount FX Product for FX Contracts defined by Data Either Buy Sell Deal Element Sales Sell leg is a FCY Bought Leg in against INR a 5 1 Sales against INR INR If Buy Sell flag is Buy then sum of Foreign Currency balance of contract else sum of Sold Amount for FX Contracts FX Product defined by Data Either Buy Sell Deal i Element Cross Sell leg is a FCY like USD Currency a 5 2 Cross Currency Bought Leg is not LCY 4 32 ORACLE The following table lists the items in the nature of Assets buying a foreign currency b 5 Currency Swaps Label FX Product wi
135. unt of the Current No of Accounts savings and term deposit Code No 200 Code No 300 current account held by Females Total Inter Bank Deposits Aggregate of Inter Bank deposits Code No 800 This is not applicable for Individuals and Others Grand Total Total outstanding of all the term deposits accounts total Inter Bank deposits Code No 900 This is not applicable for Individuals and Others Aggregate Deposit Aggregate deposits other than from banks in India Code No 999 This is applicable for total outstanding amount column alone 4 7 2 System Data Mapping for BSR 2 Part Il The BSR 2 Part Il reports are used to obtain information on the outstanding amount of term deposits as on the reference date classified according to the original period of maturity for which deposits have been placed with the branch by depositors The range of the original maturity days is maintained as a data element The data is classified as follows e Individual e Corporate e Total of individuals and corporate excluding deposits from banks Following are the details which include all types of non resident rupee and foreign currency deposits displayed for BSR 2 Part II reports Field FCUBS Data Conditions Count of the term deposits with the Code No 401 No of Accounts maturity period as 7 14 days 4 15 ORACLE Field FCUBS Data Conditions Amount Ou
136. value 4 25 3 System Data Mapping for PMRY Reports Half yearly Recovery The following table gives the system data mapping for PMRY reports quarterly progress Columns Description Conditions State District is maintained as UDF State will be derived from the Data store Demand This is the Principal due from the customers Recovery Recovery amount of the loans is displayed Overdue The amount outstanding post the due date in Loans Recovery Recovery amount Demand amount 100 4 98 ORACLE 4 26 Statement of Advances to Agriculture Statement of advances to agriculture which is a bank wise report is forwarded by the banks to RBI on an annual basis The disbursement details of all the active contracts in the CL and BC modules are maintained in the system You can generate the report using MIS date maximum date and the Bank Code as the search criteria This report is only for short term loans and is determined by the loan tenure which should be less than one year Following are the 2 parts of Advances to Agriculture report e Part A Loans amp Advances to Agriculture and Allied Activities Direct Finance e Part B Recovery of Agricultural Advances Direct Finance as on 31st March of every year The UDFs used for system data mapping for Advances to Agriculture Part A are DISTRICT and ACTIVITY _OCCUPATION The UDFs used for system data mappin

Reports Batch User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents