User Defined Events User Manual
Contents
1. Enter a brief description about amount rule error that should be displayed in case the derivation fails 2 12 ORACLE Currency Rule Derivation The currency can either be derived from the existing account currency or can be maintained as a UDF field in the account or it can be hard coded in the Currency Rule Definition screen Currency Rule Type Check this box if the currency for a particular amount tag has to be derived based on the derivation rule Derivation Currency Rule Specify the rule based on which the system should derive the currency for the amount tag Note that you need to assign a value to L_CCY For instance the rule may be given as under BEGIN SELECT currency INTO _ccy FROM cltb account master WHERE account number p acc no AND branch code p branch END Currency Rule Error Description Enter a brief description about currency rule error that should be displayed in case the derivation fails 2 3 2 Accouting Roles Tab Click Accounting Roles tab in the Accounting Role and Head Maintenance screen 2 13 ORACLE 6 Accounting Role and Head Maintenance Module Code nil Amount Tag Accounting Roles Account Rule Details LI Role Code Description Role Type Input By Authorized By Modification Authorized exit Date Time Date Time Number Open In this screen you can enter the following details Role Code Specify the role code Description Enter a brief d2. TENOR Duration for which the loan is applied LOAN_PRINCIPAL Principal PRINGIPAL Amount disbursed PRINCIPAL OUTSTAND Principal amount outstanding OVERDUE MONTHS OverDue Months TOTAL OVERDUE AMOUNT Total Overdue amount for all components INS TENOR INSTALLMENT TENOR NO OF RPMNT SCHS Number of Non Moratorium repayment schedules 2 11 ORACLE e MORA OUTSTANDING Moratorium Outstanding Amount e COMPOUND VALUE Amount Compounded e TOTAL MORA AMOUNT Total Moratorium Amount e OVR DAYS lt Component gt overdue days e EXPECTED lt Component gt expected amount e OUTSTAND lt Component gt outstanding amount e _CCY lt Component gt currency e OVERDUE lt Component gt overdue amount e FN NO REPAY_SCH lt Component gt number of schedules for a component if periodic e NET PRINCIPAL lt Component gt amount financed e PROJECTED AMOUNT Projected Amount e UIDB_ DIFFERENTIAL UIDB Differential e BALLOON AMOUNT Balloon Amount e RESIDUAL_AMOUNT Residual Amount e CAPITAL AMOUNT Capital Amount e CLOSURE AMOUNT Closure Amount e NET MORTGAGE Net Mortgage Amount Assume that you have an account level UDF called OSCHGRATE The derivation rule using the SDEs and UDF may be given as under DECLARE osprin amt number rate number BEGIN L_osprin_amt SDE_VAL PRINCIPAL_OUTSTAND rate UDF_UD OSCHGRATE amount rate I osprin amt END Amount Rule Error Description
3. You have the following options e Yes e No Allow Transaction Tax Specify the liquidation allow transaction tax You have the following options e Yes e No 2 3 ORACLE 2 2 1 Specifying Default Details Click Default button in the User Defined Events screen to define the triggering parameters for the configured event Event Trigger Module Code Event Trigger Automatic Event Code Manual Value Date Derivation C Event Processing Execution Query Value Date Derivation Event Processing In this screen you can enter the following details below Module Code The system displays the module code here Event Code The system displays the event code here Event Trigger The event which you are defining can be triggered in either of the following ways e Automatic This means that the event should be triggered automatically during EOD e Manual This means that the event should be triggered manually from the User Defined Event triggering screen Value Date Derivation Check this box to indicate that the value date derivation is defined for a particular event ail ORACLE Event Processing Check this box to indicate the event processing is defined for a particular event Execution Query Enter the query condition to select the list of accounts for the execution of the event during EOD Input to this field will be mandatory if you choose Automatic triggering o
4. Rule Type Check this box if the amount has to be derived based on a specified condition The amount for a particular tag can be derived based on a condition Derivation Amount Rule If you have checked against the option Amount Rule Type the system will derive the amount for the amount tag that is being defined You can use the following as variables while creating the derivation rule 2 10 ORACLE Account Level UDF SDE You can use any of the following SDEs CUSTOMER CATEGORY Category of the customer of the loan CUSTOMER ID Customer ID LOAN STATUS Status ACCOUNT CCY Loan account s currency TODAY Today NEXT WORKDAY Date of next workday PAYMENT VALUE DATE Payment value date LAST PAYMENT DATE Last payment date for the customer DAYS FOR NEXT PMNT Days for next payment AMOUNT DISBURSED Current disbursement amount COMMITMENT UTILIZED Utilized part of commitment EMI AMOUNT EMI AMOUNT NET PRINCIPAL Non funded amount for which the loan is applied TOTAL DUE AMOUNT Sum of all the Outstanding Balances for the Customer LAST PAYMENT AMOUNT Last Payment Amount for the Customer CURRENT PAYMENT AMOUNT Current Amount which is Due PAID_INTEREST AMOUNT Total Interest Amount Paid INTEREST ACCRUED AMOUNT Sum of all the Accrued Amounts for Interest AMOUNT NOT DISBURSED Amount Not Disbursed COMMITMENT UNUTILIZED Unutilized part of commitment TOTAL PRINGIPAL Amount for which the loan is applied
5. intended as a guide to help you define User Defined events in FLEXCUBE Besides this User Manual you can find answers to specific features and procedures in the Online Help which can be invoked by choosing Help Contents from the Help Menu of the software You can further obtain information specific to a particular field by placing the cursor on the relevant field and striking lt F1 gt on the keyboard 1 2 Organization This manual is organized as follows Chapter 1 About this Manual gives information on the intended audience It also lists the various chapters covered in this User Manual Chapter 2 Building User Defined Events explains how to define events in Oracle FLEXCUBE either for your own convenience or to suit the requirements of your bank 1 3 Conventions Used in this Manual Important information is preceded with the symbol 1 4 Glossary of Icons This User Manual may refer to all or some of the following icons om ten a e e p o a ORACLE 1 5 Cac Roll over Hold Authorize Liquidate Exit Sign off Help Refer the Procedures User Manual for further details about the icons Related Documents For further information on procedures discussed in the manual refer to the Oracle FLEXCUBE manuals on e Core Services e Common Procedures ORACLE 2 1 2 2 2 User Defined Events Introduction A contract that you process in Oracle FLEXCUBE goes through different stage
6. User Defined Events Oracle FLEXCUBE Universal Banking Release 11 3 1 0 0LA January 2012 Oracle Part Number E51536 01 ORACLE FINANCIAL SERVICES ORACLE User Defined Events Table of Contents Ie PROUT EATS VAIN Ne 1 1 1 1 PRINS 1 1 1 2 RMN 1 1 1 3 CONVENTIONS USED IN THIS MANUAL sce ee tececcetiecvarcsinee devel backeecdesecdoiiescsaeddvendeuelbacitec ecendodbesebausSenedeveleacns 1 1 1 4 NNN NN 1 1 1 5 RELATED DOCUMENTS cece neea EEEE EEEE Eaa 1 2 2 VER DFNEDENENIN o E E 2 1 D ARGUS OSE SE EE E E 2 1 PAR INDICATING THE EVENT DETAILS 1 eresoenevnrnevnrnennenennnnennnnennnnennnnenennenennenennnnennnnennnnennnnenennenennenennenennenennnneneenene 2 1 22d Speci Mine Default DERE EE EEE 2 4 222 Value Date DeTIVAtION 20 cc ccccccccccuccucuccecuccecuccecuccccucuecucuecucuececuscecuececusceccuscusuecucuscecascecaseecusescsescucuscass 2 5 225 KD ATR POCO NS RENEE RENNENE EEE 2 6 2 2 4 Calculating the commission on the highest outstanding balance rrrnnnrrrnnnnnnnnnnnnrrnnnnnnnnnnnrrrnnnnnnnnnenr 2 7 2 3 MAINTAINING ACCOUNTING ROLES AND HEADS errenevnennvnennnnenennenennenennnnennnnennnnenennenennenennenennenennnnennnnennnnene 2 8 2 3 1 NNN 2 8 2 3 2 MN 2 13 2 4 TRIGGERING USER DEFINED EVENTS AUTOMATICALLY srenevnevnvnennnnennnnennnnenennenennenennenennnnennnnennnnennnnennenene 2 15 3 SCREEN GLOSSARY seede 3 1 3 1 PUONCTION S G EEE EN EEE SEES 3 1 ORACLE 1 About this Manual 1 1 Introduction This manual is
7. aintenance UDDEVMNT User Defined Events UDDRLTAG Accounting Role amp Head Maintenance A ORACLE ORACLE User Defined Events January 2012 Version 11 3 1 0 0LA Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores CA 94065 U S A Worldwide Inquiries Phone 1 650 506 7000 Fax 1 650 506 7200 www oracle com financial_ services Copyright 2012 Oracle Financial Services Software Limited All rights reserved No part of this work may be reproduced stored in a retrieval system adopted or transmitted in any form or by any means electronic mechanical photographic graphic optic recording or otherwise translated in any language or computer language without the prior written permission of Oracle Financial Services Software Limited Due care has been taken to make this document and accompanying software package as accurate as possible However Oracle Financial Services Software Limited makes no representation or warranties with respect to the contents hereof and shall not be responsible for any loss or damage caused to the user by the direct or indirect use of this document and the accompanying Software System Furthermore Oracle Financial Services Software Limited reserves the right to alter modify or otherwise change in any manner the content hereof without obligation of Oracle Financial Services Software Limited to notify any person of such revision or changes All company and product
8. asing batch LEDBATCH e Mortgage batch MODBATCH For further details about this screen refer the chapter Setting up Mandatory Programs for EOD in the AEOD User Manual This batch fetches the list of user defined events of the following modules for which the event triggering is set as Automatic e OL e Islamic Financing e Mortgages e Leasing It fetches valid accounts associated with the event by the executing the query defined for the event in the Event Trigger screen The settlement account and branch are defaulted from the settlement details maintained for the account If these details are not maintained they will be defaulted from the settlement details maintained for the Principal component The system triggers the derivation rule maintained for the event to arrive at the value date of the event The system then posts accounting entries to the respective GLs using the value date derived The system also derives the amount and currency for each amount tag of the accounting entries defined for the event The system allows you to link only payment advice CR_ADV DR ADV to the user defined event So if linked to an account this advice will be generated 2 16 ORACLE 3 Screen Glossary 3 1 Function ID List The following table lists the function id and the function description of the screens covered as part of this User Manual Function ID Function Description EIDMANPR Mandatory Batch Program M
9. escription about role code Role Type Select the role type from the adjoining drop down list The following values are available e Asset e Liability e Income e Expense e C Asset e C Liability e Customer a ORACLE 2 4 Triggering User Defined Events Automatically You can add the user defined event batch to the mandatory programs to be run for the module using the Mandatory Batch Program Maintenance screen You can invoke this screen by typing EIDMANPR in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Mandatory Batch Program Maintenance d Of Cycle Group Transaction input Stop Automatic End Of Day and Run Emergency Program Continue with Automatic End End Of Financial input Of Day End Of Day Beginning Of Day End Of Transaction input Daily Rule Do Not Execute yer 9 Database Appkcation Fields Input By A21898M01 Date Time Modification Number 3 Authorized Authorized By Date Time El open Module Choose the module code from the adjoining option list Function Identification Specify UDBATEVT as the batch that needs to be run You can also select this value from the adjoining option list End Of Cycle Group Select the option End Of Transaction Input Predecessors You need to add the following batches as predecessors to the UDBATEVT batch e CL batch CLBATCH e Islamic CL batch CIDBATCH a ORACLE e Le
10. event code that you want to set up for the module Event Description Give a brief description of the event that you are defining The description that you enter is for information purposes Accounting Entries Definition Specify the accounting entries definition You have the following options e Yes e No Advice Definition Specify the advice entries definition You have the following options e Yes e No UDE Advices Definition Specify the UDE advice definition You have the following options e Yes e No Association Indicate your preferences Allow Charge Specify the association allow charge You have the following options e Yes e No Allow Transaction Tax Specify the association allow transaction tax You have the following options e Yes e No 2 2 ORACLE Application Indicate your preferences Note that these fields will not be applicable if you have specified any one of the following in the Report Module field e CL e Cl e LE e MO Allow Charge Specify the application allow charge You have the following options e Yes e No Allow Transaction Tax Specify the application allow transaction tax You have the following options e Yes e No Liquidation Indicate your preferences Note that these fields will not be applicable if you have specified any one of the following in the Report Module field e CL e Cl e LE e MO Allow Charge Specify the liquidation allow charge
11. f the event 2 2 2 Value Date Derivation Click Value Date Derivation button on the Event Trigger screen and invoke the Derivation Rule screen to specify the value date derivation logic Value Date Derivation Rule Module Code Event Code Default value Date Derivation Rule Le In this screen you can enter the following details Module Code The system displays module code here Event Code The system displays event code here Value Date Derivation Rule Enter description about the value date derivation rule You need to assign a value to L_VAL_DT For instance L VAL DT global application date 2 ORACLE Error Click X button to execute the code The derivation code will be validated by the system If any checks fail you must alter the statement so that the validation can be made successfully Click E button to view the errors 2 2 3 Event Processing Click Event Processing button on the Event Trigger screen and invoke the Derivation Rule screen to assign values for processing of the event Derivation Rule Event Process Derivation Rule Module Code Event Code Errors In this screen you can enter the following details Module Code The system displays module code here Event Code The system displays event code here 26 ORACLE Errors Click button to execute the code The derivation code wil
12. l be validated by the system If any checks fail you must alter the statement so that the validation can be made successfully Click E button to view the errors 2 2 4 Calculating the commission on the highest outstanding balance System uses UDE to calculate the commission on the highest outstanding balance of the loan and the mortgage Accounts You can define a UDE Highest Debit Balance Commission Event HDBC for computation of commission with following parameters e Event Trigger can be either Auto or Manual e Apply Charge should be Yes e Execution Query should be all accounts which satisfy the following criteria gt Account Status is Active gt Outstanding Principal is greater than 0 00 e Value Date derivation rule to return the date as month end e This event is available at Loan and Mortgage product level 2 7 ORACLE 2 3 Maintaining Accounting Roles and Heads You can define the amount tags for accounting roles through the Accounting Role and Head Maintenance screen You can invoke this screen by typing UDDRLTAG in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button APCODUNbAg Role and Head Martenance hot By ADISSGAD I MoSiiceton Number Authorced By n E open You can specify the following parameters for the module e Amount Tag e Accounting Roles 2 3 1 Amount Tag Tab This tab is displayed by default when you invoke the screen Amo
13. names are trademarks of the respective companies with which they are associated
14. s during its life cycle These stages are defined as Events Every new module that you maintain has to be associated with a set of events which will be triggered at appropriate stages during the lifecycle of the contract Apart from the factory shipped events you can create your own events as per the requirements of the bank Indicating the Event Details You can define the events through the User defined Events screen You can invoke this screen by typing UDDEVMNT in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button You can define events for a new module and also for existing modules in this screen Report Module Event Code Event Description Accounting Entries Definition No Association co ae Allow Charge Advice Definition No m se T Allow Transaction Tax Application Liquidation i Allow Charge No w Allow Charge Allow Transaction Tax No Allow Transaction Tax Faas detaut Input By Authorized By Modification Authorized exi Date Time Date Time Number Open User defined events will be linked to a product and is triggered in the life cycle of a contract which is processed under that product Report Module Specify the module for which you want to set up a user defined event The adjoining option list contains all the module codes available in the system Select the appropriate one a ORACLE Event Code Specify the
15. unt Tag Specify the amount tag Description Enter the brief description for amount tag Charge Indicate whether the amount tag pertains to a charge or not by choosing one of the following options ee ORACLE e Yes e No Accounting Indicate whether accounting entries are required or not by choosing one of the following options e Yes e No Trasanction Tax Indicate whether transaction tax is applicable or not by choosing one of the following options e Yes e No Local Currency Indicate the local currency preference by choosing one of the following options e Average e Equivalent Local Currency Eq Tag Specify the amount tag for the local currency equivalent amount Click Derivation button and invoke the Derivation Rule Details screen to derive the amount and currency for the amount tag 2 9 ORACLE Derivation Rule Details Module Amount Tag Amount Rule Derivation Currency Rule Derivation Amount Rule Type C Currency Rule Type Derivation Amount Rule e Derivation Currency Rule Execute Execute Erors Amount Rule Error Currency Rule Error Description Description Here you can specify derivation logic for the following e Amount Rule e Currency Rule Module Code The system displays module code here Amount Tag The system displays the amount tag here Amount Rule Derivation You can specify the following details Amount
Download Pdf Manuals
Related Search