Relationship Pricing User Manual
Contents
1. Role Function Back office clerk Input functions for contracts Back office managers officers Authorization functions Product Managers Product definition and authorization End of day operators Processing during end of day beginning of day Financial Controller Product Generation of reports Managers Organization The manual is organized in the following manner Chapter 1 About this Manual gives a brief introduction of the module the audience it addresses and the organization of the various chapters It also includes the list of related documents to be referred if any and the conventions used in the document Chapter 2 Customer Relationship Pricing explains the maintenances required to provide services to customers based on the total business that the customer conducts or could potentially conduct Conventions Used in this Manual Important information is preceded with the symbol 1 1 ORACLE 1 4 Related Documents 1 5 e The Procedures User Manual Glossary of Icons This User Manual may refer to all or some of the following icons l E Delete row Option List ORACLE 2 1 2 Customer Relationship Pricing Introduction Relationship pricing is the pricing of services offered to a customer based on the total business that the customer conducts or could potentially conduct In this case a set of eligible customers is offered a special pricing over and above the2. Relationship Data Element v Function Reset Operators Logical Operators You can specify the conditions for deriving the variance rule in this screen Condition Specify the condition for building the variance rule Result Specify the result of the execution of the variance rule in terms of rate or amount 2 19 ORACLE Relationship Data Element Select the RDE to be used to build the variance rule expression All the RDEs selected previously for this variance rule are displayed in the option list Function Select the mathematic function to be used to build the variance rule from the drop down list provided The following options are available e Abs e Greatest e Round es Trunc e Floor e Ceil e Power e Mod Operators Select the operator to be used to build the variance rule expression The following options are available e add e Subtract e multiply e divide Logical Operators Select the logical operator to be used to build the variance rule expression The following options are available e AND e OR e lt e lt e gt e gt e lt gt You can specify any number of conditions using combinations of mathematical functions operators and logical operators 2 20 ORACLE Example The following example demonstrates the building of a variance rule A variance rule needs to be set up to derive beneficial interest rates for customers based on loan amount I
3. Specify the start date of the pricing scheme you want to search for Scheme End Date Specify the end date of the pricing scheme you want to search for Validity Type Select the validity type of the pricing scheme you want to search for from the drop down list provided Apply For Select the customers for which the pricing scheme you want to search for is applicable from the drop down list The following options are available e New customer e All customers e Existing customers Execution Type Select the type of application of the pricing scheme you want to search for from the drop down list The following options are available e Manual e Automatic Click the Search button to search for records according to the search criteria specified You can also perform an advanced search using combinations of conditions by clicking the Advanced Search button 2 17 Maintaining Customer Scheme Linkage 2 34 ORACLE You can link a customer to a pricing scheme in the Customer Scheme Manual Linkage screen The benefits of the scheme are applied to the customer for the validity period specified You can invoke this screen by typing CODCUSCM in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Benefit Plans E Module Benefit Plan Id Benefit Plan Description Priority Number II View Benefit Details You can specify the following details i
4. Current Status The current status of the scheme application to the customer is displayed here The following values are possible e Active e Expired e Expired Renewable e Waiting for Acceptance e Rejected You can change the status of the scheme linkages under the following conditions e Reject this status can be selected if the current status of scheme linkage is any of the following gt Active gt Waiting for Acceptance gt Expired Renewable On rejection the linkage status changes to Rejected e Accept this status can be selected if the current status of scheme linkage is Waiting for Acceptance On acceptance the linkage status changes to Active Status Change Reason The reason for changing the status is indicated here Last Status Change Date The date on which the customer scheme linkage status was last changed either by the system or manually is displayed here Previous Linkage Status The previous status of linkage in case the current linkage status is changed manually or by system is displayed here 2 21 Evaluating Customer Scheme Online 2 45 ORACLE You can perform an online evaluation of customer eligibility for a scheme using the Online Customer Scheme Eligibility Evaluation screen All eligibility plans associated with active schemes are evaluated and if the customer is eligible for a scheme then customer scheme linkage gets established You can invoke this scr
5. Search button 2 18 Changing Benefit Plan Priority You can modify the priority value associated with a benefit plan for a given module in the Relationship Pricing Benefit Priority Maintenance screen You can invoke this screen by typing CODBENPR in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Relationship Pricing Benefit Priority Maintenance Module Module Description ESS Benefit Details B E Benefit Plan Id Benefit Plan Description Priority Number m View Benefit Plan You need to specify the following details to change the priority of a benefit plan Module Select the module for which you want to change the benefit plan priority number All modules for which benefit plans are defined are displayed in the option list Module Description The description associated with the selected module is displayed here Benefit Plan ID Select a module and click the Query button to view the valid benefit plan IDs for that module 2 40 ORACLE Benefit Plan Description The description associated with the benefit plan ID is displayed here Priority The priority number linked to the benefit plan is displayed here You can change the priority number in such a way that it remains unique for a benefit plan within a given module 2 18 1 Viewing Benefit Plan Details Select a benefit plan ID and click the View Benefit Plan button to view
6. Description UDE Basis Ouen UDE Data Type Numeric ze aer ron SQL Statement Validate Query Error You can maintain the following details in this screen UDE Code Specify a unique alphanumeric code for the User Data Element UDE Description Specify a suitable description for the User Data Element UDE Basis Select the basis for deriving the UDE value from the drop down list provided The options available are as follows e Query the UDE value is derived using a PL SQL query on Oracle FLEXCUBE database which returns a single value e Function the UDE value is derived using pre defined database functions returning a particular value You need to provide proper inputs to the function to return the UDE value 2 3 ORACLE 2 2 1 2 2 2 UDE Datatype Select the data type of the UDE value from the drop down list provided The possible options are as follows e Numeric e String e Date Query Tab If you have selected Query as the basis for deriving UDE value you need to specify the SQL query statement to return the UDE output value You can frame the query statement using one or more database tables in Oracle FLEXCUBE You can also use aggregate functions and multiple conditions in the where clause of the SQL statement You need to provide customer number as an input to the query and the result of the query will be the UDE value You can validate the query statem
7. Details and click the View Benefit Details to view the details associated with the selected benefit plan The following screen is displayed Relationship Pricing Benefit Plan Detailed i Pricing Benefit Benefit Plan Id Benefit Plan Description Module Priority Number Pricing Benefit Details Benefit Type Type Variance Currency SI The details associated with the selected benefit plan are displayed here If the benefit selected in Benefit Details screen is related to Consumer Lending module the following screen gets displayed 2 37 ORACLE The screen appears as shown below Promotions Details ES Enter Query Promotion Code Promotion Description Module Code E Tenor Minimum Maximum Default Unit Promotion Rate Factor 10 L User Defined Element Id Promotion Start Date Promotion End Date Product Code Loan Amount Holiday Periods Minimum Loan Amount 10f1 Maximum Loan Amount F Holiday Period x UDE Value Minimum Value Maximum Value Maker Checker Date Time Mod No Record Status Date Time Authorization Status The following details related to the benefit plan selected are displayed e Benefit or promotion plan identification and description e Start date and end date of the promotion e Tenor details and the holiday period details e Related UDEs and corresponding values e
8. Schedule details of the principal and interest components 2 38 ORACLE 2 17 3 Viewing Linkage Details You can view the details of customer scheme linkages and also search for a customer in the Customer Scheme Manual Linkage Summary screen You can invoke this screen by typing COSCUSCM in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button The screen appears as shown below Summary Authorization Status e Record Status Customer Number seat Advanced searen Reset Gee e Authorization Status Record Status Customer Number Authorization Status A Authorized U Unauthorized Record Status C Closed O Open eu You can specify any of the following details to perform a search Authorization Status Select the authorization status of the record you want to search for from the drop down list provided The options possible are e Authorized e Unauthorized Record Status Select the status of the record which you want search for from the drop down list provided The options possible are e Open e Closed 2 39 ORACLE Customer Number Select the customer number whose relationship value you want to search for from the option list provided Click the Search button to search for records according to the search criteria specified You can also perform an advanced search using combinations of conditions by clicking the Advanced
9. You can view the schemes linked to a customer number in Customer Scheme Linkage Query screen You can invoke this screen by typing CODSCMQY in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button The screen appears as shown below 2 43 ORACLE Customer Scheme Linkage Query Customer Number laz Linkage Status All Ki Query Scheme Details E Scheme Id Eligibility Plan Id Benefit Start Date Benefit End Date Linkage Status lt View Benefit Plan Customer Number Select the customer whose scheme linkages you would like to change All valid customer numbers with scheme linkages are displayed in the option list Linkage Status Select the linkage status of the scheme which you want to modify The following options are available e All e Active e Waiting for Acceptance e Expired e Expired Renewable e Rejected Click the Query button to get the details of the schemes attached to the customer in Scheme Details Scheme ID All scheme IDs linked to the selected customer are displayed Eligibility Plan ID The eligibility plan ID maintained for the scheme is displayed here For manual linkages the eligibility plan ID is displayed as MANUAL 2 44 ORACLE Benefit Start Date The date when the scheme was applied to the customer is displayed Benefit End Date The end date of the benefits received by the customer is displayed here
10. are displayed in the list Price Component Type Select the type of the price component from the drop down list The following options are available e interest e Charge e Fee e Commission e Exchange Rate Price Components Select the price class components to be associated with the benefit plan The option list displays the valid price class components maintained based on the product code and price component type specified Example For an LD Product if you select the price component type as Interest the price components list will display Interest Class components mapped to the LD product If you specify price component type as Charge the price components list will display Charge Class components Benefit Type Select the type of benefit from the drop down list The following options are available e Variance a price variance is offered as benefit to the customer e Waive a price component waive off is offered as benefit to the customer Waive off benefit is applicable for price components of type charges fees and commission Variance Type Select the type of variance to be attached to the benefit plan This is applicable if you have specified Variance as the benefit type The following options are available e Fixed Rate fixed rate will be applied over the computed base rate computed 2 25 ORACLE e Variance Rate variance rate will be either added to or subtracted from the base rate computed
11. benefit plan type is waive off then the price component computation is done and the final price will be waived off e If the benefit plan is of variance type then the variance rate or amount is applied If a variance rule is attached to the price component then the variance rule is evaluated to get the variance rate or amount e After applying benefit variance the final rate or amount will be checked against the minimum and maximum limits set at module product level 2 51 ORACLE 3 1 3 Screen Glossary 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 CODBENFT Relationship Pricing Benefit Plan Maintenance CODBENPR Relationship Pricing Benefit Plan Priority Change CODCURVT Customer Relationship Value Tag Code CODCUSCH Relationship Pricing Customer Availed Scheme Benefits CODCUSCM Customer Scheme Manual Linkage CODELEBT Online Customer Scheme Eligibility Evaluation CODELPLN Relationship Pricing Eligibility Plan CODRVTMT Relationship Value Tag Code Maintenance CODSCHME Relationship Pricing Scheme Maintenance CODSCMQY Customer Scheme Linkage Query CODSCMST Customer Scheme Linkage Status Change CODUDEMT Relationship Pricing User Data Elements Maintenance CODVARRL Relationship Pricing Variance Rule Mainte
12. customers continue to be available to the customers even if they fall out of the eligibility conditions Eligibility Type Select the duration of the benefit validity from the drop down list The following options are available e Benefits Validity Period e Scheme Validity Period 2 30 ORACLE Apply For Select the customers for which the pricing scheme is applicable from the drop down list The following options are available e New customer e All customers e Existing customers customer is identified as new or existing based on their creation date and scheme start date Execution Type Select the type of application of the pricing scheme from the drop down list The following options are available e Manual e Automatic Benefit End on Scheme Expiry Select this checkbox to indicate that the customer scheme benefits expire on reaching the scheme end date in cases where the validity period exceeds the scheme end date 2 15 1 Benefit Details Tab You can select the benefit plans to be applicable for a pricing scheme in the Benefit Details tab The following details related to the benefit plan are displayed e Benefit Plan ID e Benefit Plan Description Select the checkbox against any desired benefit plan to make it a part of the pricing scheme 2 31 ORACLE 2 15 2 Eligibility Details Tab You can specify the eligibility details of the pricing scheme in the Eligibility Details tab Relationship Pri
13. 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 names are trademarks of the respective companies with which they are associated
14. provided Module Select the module for which you want to view the benefit plans from the option list provided Click the Search button to search for records according to the search criteria specified You can also perform an advanced search using combinations of conditions by clicking the Advanced Search button 2 28 ORACLE 2 15 Maintaining Pricing Scheme You can maintain the details of the pricing scheme in the Relationship Pricing Scheme Maintenance screen You can invoke this screen by typing CODSCHME in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button The screen appears as shown below Relationship Pricing Scheme Maintenance b Pricing Scheme Id Pricing Scheme Id Description Scheme Validity Details Validity Type Scheme Start Date Scheme End Date Benefit Validity Period Benefit Validity Basis Eligibility Type Apply For v Execution Type v Benefit End on Scheme Scheme Advice Description e o0 Expiry Scheme Status tive Benefit Details Eligibility Details Scheme Details HHE Ege nefit Plan Id Benefit Plan Description You can maintain the following details specific to the scheme in this screen Pricing Scheme ID Specify a unique ID for the pricing scheme Pricing Scheme ID Description Specify a suita
15. relationship value you want to search for from the option list provided Source Code Select the source code for the desired external system from the option list provided Click the Search button to search for records according to the search criteria specified You can also perform an advanced search using combinations of conditions by clicking the Advanced Search button Maintaining Eligibility Plan You need to maintain the eligibility criteria based on which a customer can avail the benefits of scheme Eligibility criteria can be defined based on various customer attributes maintained as User Data Elements UDE or pre shipped set of System Data Elements SDE and it helps to identify the target customers for a scheme The eligibility criteria can be defined using customer RVT codes also You can maintain the eligibility criteria for a scheme in Relationship Pricing Eligibility Plan screen You can invoke this screen by typing CODELPLN in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button 2 12 ORACLE Relationship C New Eligibility Plan id Eligibility Plan Description Relationship Data Element E RDE Code RDE Parameter Value Expression Builder Input By Authorized By Modification Date Time Date Time Number Authorized Open You can maintain the following details in this screen Eligibility Plan ID Specify a unique ID for the eligi
16. the details of the selected benefit plan 2 19 Changing Customer Scheme Linkage Status You can view and change the status of customer scheme linkages in the Customer Scheme Linkage Status Change screen All the schemes linked to the customer are displayed in this screen with the respective status You can invoke this screen by typing CODSCMST in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Customer Scheme Linkage Status Change Customer Number Customer Name Scheme Id Scheme Description Scheme Details E scheme Id Benefit Start Date Benefit End Date Linkage Status s lt View Benefit Plan Input By Authorized By Modification Date Time Date Time Number Authorized Open You can specify the following details in this screen Customer Name The system displays the name of the specified customer ID based on the details maintained at Customer Maintenance level 2 41 ORACLE Scheme ID Select the ID of the scheme whose status you want to change from the option list Scheme Description The description associated with the scheme gets displayed once you select the Scheme ID 2 19 1 1 Viewing Scheme Details The following details related to the scheme are displayed e Scheme ID e Eligibility plan ID e Benefit start date and end date e Linkage status and the status of previous linkage e Linkage
17. Date e Date of last status change and the reason for change Linkage Status Select the status of the scheme linkage from the drop down list provided The following options are available e Active e Waiting for Acceptance e Expired e Expired Renewable e Rejected 2 19 2 Viewing Status Change Details You can view the details of scheme linkage status and also search for a linkage in the Customer Scheme Status Change Summary screen You can invoke this screen by typing COSSCMST in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button 2 42 ORACLE Summary Authorization Status d Record Status Customer Number Scheme Id Search Advanced Search Reset page 15 MLL Os or EL fce Authorization Status Record St C ustomer Number Scheme Id Authorization Status A Authorized U Unauthorized Record Status C Closed O Open Exit You can specify any of the following details to perform a search Customer Number Select the customer number you want to search for from the option list provided Scheme ID Select the scheme ID you want to search for from the option list provided Click the Search button to search for records according to the search criteria specified You can also perform an advanced search using combinations of conditions by clicking the Advanced Search button 2 20 Viewing Customer Scheme Linkages
18. Relationship Pricing Oracle FLEXCUBE Universal Banking Release 12 0 May 2012 Oracle Part Number E51527 01 ORACLE FINANCIAL SERVICES ORACLE Relationship Pricing Table of Contents 1 ABOUT THIS MANUA Diswiscsssccsstsnsssscccsscnsssenccosasscecssscovssescssnesoscesvesnscsenssovecsvssndseduscencessesescocesasscesnessiecsvsenscene 1 1 1 1 INTRODUCTION merone eere snee EE Ore E A rA E rE AE EN 1 1 1 1 1 Va OLA NE EETA EE EE EE E E E Ee EAE EE AE l 1 1 1 2 Organizat OM es seasende ss izenssapeceescasningntdunttededsixsorsazasanceaseloepsianionbensiseeysereaneseieedoaps benieededeiaeoseapietesciaess l 1 1 1 3 Related EE 1 2 1 1 4 VE 1 2 2 CUSTOMER RELATIONSHIP PRICING u ccssscssssccssccssssccssscssscsscsssscssnessssssscnsssssssscnssssssssseessssseees 2 1 2 1 INTRODUCTION pesee iaeneoan rea aa a a aa a aaa a Eaa SaGa 2 1 22 MAINTAINING USER DATA ELEMENTS 2 2 2 2 1 Lee 2 4 2 2 2 CHE eege EE ee Ee 2 4 2 3 VIEWING DE RI NEE 2 6 2 4 SYSTEM DATA ELEMENTS vrir esie ineine cerana a a ia a a ia EEE eS AS EEL EE EREE EE SEENEN 2 7 2 5 MAINTAINING RELATIONSHIP VALUE TAG Coppi 2 8 2 6 VIEWING RVT CODE Drang 2 8 2 7 MAINTAINING VALUES FOR RELATIONSHIP Tag 2 9 2 8 VIEWING RELATIONSHIP TAG VALUE DETAILS ccccccceceesessscecececeesessececececeesesesecececeeseseseceecceesenneaeeeeees 2 11 2 9 MAINTAINING ELIGIBILITY PLAN 2 12 2 9 1 Creating Eligibility Condition seiseissesiesisseseasississesineeihenssaesdasdenasitbcipe
19. Rule ID Specify a unique ID for the variance rule Variance Rule Description Specify a suitable description for the variance rule 2 17 ORACLE Module Select the module to which you wish to associate the variance rule from the option list provided Variance Rule Basis Select the price component based on which you want to define the variance rule The following options are available e interest e Charge e Commission e Fees e Exchange Rate Variance Rule Type Select the type of the value being returned by the variance rule from the option list provided The following options are available for selection e Fixed Rate applicable if you have selected Interest as Variance Rule Basis Variance rule returns a fixed rate in this case which can be used for pricing computation e Fixed Amount variance rule returns a fixed amount which can be used for pricing computation e Variance Rate applicable if you have selected Interest as Variance Rule Basis Variance rule returns the variance rate over the base rate computed which is added to or subtracted from the base rate e Variance Amount returns the variance amount to be added to or subtracted from the base rate e Percentage returns a percentage to be applied to the base amount or base rate computed to arrive at the final value The options Fixed Amount and Variance Amount are not applicable if you have specified Interest as Varian
20. ance Value e Variance Currency e Original Computed Price e Final Price e Price Currency 2 23 Processing Relationship Pricing Batch Relationship pricing batch evaluates the eligibility criteria for customers who have opted for relationship pricing and links the schemes applicable to the customers The customer linkage status also gets changed during the batch This batch is run at the head office level during EOD after marking End of Financial Input EOF1 The batch process involves the following main activities e Changing scheme status e Evaluating scheme eligibility e Applying scheme benefits The linkage status of customers whose benefits have expired will change to Expired during EOD as part of the batch 2 23 1 Changing Scheme Status 2 49 ORACLE The status change of the scheme happens before the evaluation of the scheme eligibility On the end date of the scheme the status of the scheme changes to Expired If the scheme has the Benefits End on Scheme Expiry option enabled then all the related customer scheme linkages will be marked as Expired 2 23 2 Evaluating Scheme Eligibility All the active schemes with first revision date or next revision date less than or equal to application date are considered for eligibility evaluation Following validations are carried out for schemes with different validity types e Perpetual validity customers created within the benefit period are not conside
21. aximum interest rate maintained at the RP level If the value of the interest rate is greater than the maximum value then the system will use the maximum value for computation If the value of the interest rate is lesser than the minimum value then the system will compute the minimum value computation Viewing Benefit Plan Details You can view the details of the benefit plan and also search for a benefit plan for a specific module in the Relationship Pricing Benefit Plan Summary screen You can invoke this screen by typing COSBENFT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button 2 27 ORACLE Summary Authorization Status v Record Status Benefit Plan Id Module mer 1E ie ed Status RE 1 Status Benefit Plan mE fit Pla scription Module Priority Number Authorization Status A Authorized U Unauthorized Record Status C Closed O Open Exit You can search for a benefit plan by specifying the following fields Authorization Status Select the authorization status of the record you want to search for from the drop down list provided The options possible are e Authorized e Unauthorized Record Status Select the status of the record which you want search for from the drop down list provided The options possible are e Open e Closed Benefit Plan ID Select the benefit plan you want to search for from the option list
22. bility plan Eligibility Plan Description Specify a unique description for the eligibility plan RDE Code Select the relationship data element to be used to build the eligibility criteria expression All system data elements user data elements and customer RVT codes are available for selection in the option list provided RDE Parameter Value Specify a value for the relationship data element selected 2 9 1 Creating Eligibility Condition You can build the condition to be evaluated to verify the eligibility of a customer by clicking the Expression Builder button The Expression Builder screen is displayed 2 13 ORACLE Expression Builder Expression Builder Condition Relationship Data Element Functions Reset Operations v Logical Operations v You can specify the following details to build the eligibility criteria expression Condition Specify the eligibility evaluation condition using the relationship data elements functions operations and logical operations provided Relationship Data Element Select the relationship data element to be used to build the eligibility condition The RDE codes specified in Relationship Pricing Eligibility Plan screen are displayed in the drop down list provided Functions Select the mathematical function to be used to build the eligibility condition The following options are available e Abs e Greatest e Round e Trunc e Floor e Ceil e Power
23. ble description for the pricing scheme Scheme Start Date Specify the effective start date of the pricing scheme Select the start date by clicking the adjoining calendar icon 2 29 ORACLE Scheme End Date Specify the end date of the scheme Select the end date by clicking the adjoining calendar icon Benefit Validity Period Specify the period through which the benefits will be made available to the customer in terms of days months or years This date is applicable under the following conditions e Scheme ceases to exist but benefits are given to the customers for a period of time e Scheme is active but the benefits are given to the customers for a short period of time Benefit Validity Basis Select the basis of specifying the validity period from the drop down list provided The following options are available e Days e Months e Years Scheme Advice Description Specify a suitable description for the scheme advice Scheme Status Status of the scheme is displayed as Active by default The status of the scheme changes to Expired on the end date specified for the schema Validity Type Select the way of applying the scheme benefits from the drop down list The following options are available e One Time benefits are made available to eligible customers only once e Renewable scheme benefits are made available to the customers till the expiry of the scheme e Perpetual benefits offered to eligible
24. ce Rule Basis Variance Rule Currency 1 Select the currency associated with the variance rule from the option list provided You need to specify this if you have selected Fixed Amount or Variance Amount as Variance Rule Type If you have selected the Variance Rule Basis as Exchange Rate you need to select the first currency of the currency pair from the option list provided Variance Rule Currency 2 Select the second currency of the currency pair from the option list provided if you have selected the Variance Rule Basis as Exchange Rate 2 18 ORACLE 2 11 1 Specifying Relationship Data Elements Relationship Data Element is a collection of UDE SDE module specific and customer specific and Customer RVT codes which is used to build the variance rule You can maintain the following details to build the variance rule Relationship Data Element Select the relationship data element to be used to build the variance rule The option list contains all SDEs UDEs and customer RVT codes available for selection RDE parameter value Specify a value for the RDE parameter selected 2 11 2 Specifying Conditions for Variance Rule You can build the expressions and specify conditions to derive the variance rule using the Expression Builder screen Click the Expression Builder button to invoke the Expression Builder screen Expression Builder Expression Builder E Condition Result
25. cing Scheme Maintenance b Pricing Scheme Id Pricing Scheme Id Description Scheme Validity Details Validity Type Scheme Start Date Scheme End Date Apply For Benefit Validity Period Execution Type o xecuti H Benefit Validity Basis S Eligibility Type zi C Benefit End on Scheme a Expiry Scheme Advice Description Scheme Status Active Benefit Details Eligibility Details Eligibility Plan Id First Revision Date E Eligibility Revision Frequency Daily EI Last Revision Date Next Revision Date E You can specify the following details related to eligibility Eligibility Plan ID Select the eligibility criteria for a customer to avail the benefits of a scheme from the option list provided All valid eligibility plans are displayed in the list Eligibility Revision Frequency Select the frequency at which the eligibility plan gets revised from the drop down list The following options are possible e Daily e Weekly e Fortnightly e Monthly e Quarterly e Half Yearly e Yearly 2 32 ORACLE First Revision Date The date on which the first execution of the eligibility plan happened is displayed here Last Revision Date The last revision date of the scheme eligibility is displayed here Next Revision Date The date on which next revision of the eligibility plan should happen i
26. e At the end of the batch process the next revision frequency for the scheme eligibility gets updated based on revision frequency Note the following 2 50 ORACLE e Eligibility evaluation will not happen for customers who already have the schemes linked to them after the benefit validity period if the scheme eligibility type is Benefit Validity period e Eligibility evaluation will happen for customers who already have the schemes linked to them after the benefit validity period if the scheme eligibility type is Scheme period e Eligibility evaluation will not happen till the end of the benefit period for customers whose schemes have been manually linked 2 23 3 Applying Scheme Benefits The benefits of the scheme are applied to customers only after the eligibility evaluation of the scheme during EOD The eligible customers can avail the benefits of the scheme only from next branch working day The following activities are involved in the application of scheme benefits for eligible customers e The system checks if the customer is eligible for any scheme benefits for the product and price component associated with the transactions or contracts involved and for eligible customers the pricing process is changed based on the benefit type e f the customer has more than one benefit plan for the same product and price component combination then benefit plan with the least priority number is taken up for processing e If the
27. e Fixed Amount fixed amount will be applied over the computed price amount e Variance Amount variance amount will be added to or subtracted from the base amount computed e Percentage percentage of base rate or amount computed will be increased or decreased from the base rate or amount e Free Txn indicates the number of free transactions available for the combination of a given Module id Product Price component type and Price Component for a calendar month To avail this feature you must setup the charge through the IC module and select ITEM COUNT as charge basis For a product the system overrides the free transaction count maintained at account class level with the free transaction count maintained at the RP benefit plan level If you have selected the price component type as Exchange Rate you need to select Variance Rate as the variance type Variance Currency 1 Select the currency associated with fixed amount or variance amount from the option list provided If you have selected the price component type as Exchange Rate you need to select the buy currency of the customer from the option list provided Variance Currency 2 Specify the sale currency associated with the benefit plan from the option list provided This is applicable only if you have selected the price component type as Exchange Rate Variance Value Specify the value related to variance This is applicable if you ha
28. e Mod Operations Select the operator to be used to build the eligibility criteria expression The following options are possible 2 14 ORACLE e Addition e Subtraction e Multiplication e Division Logical Operations Select the logical operator to be used to build the eligibility criteria expression The following options are possible e AND e OR e lt e lt e gt e gt e lt gt 2 15 ORACLE 2 10 Viewing Eligibility Plan Details You can view the details of the eligibility plans and also search for a desired plan in the Relationship Pricing Eligibility Plan Summary screen You can invoke this screen by typing COSELPLN in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button The screen appears as shown below Summary Authorization Status d Record Status Eligibility Plan Id searan Adena Searon J Reset Le sl beet OG Tt Authorization Status Record Status Eligibility Plan Id Ehaibility Plan Description Condition Authorization Status A Authorized U Unauthorized Record Status C Closed O Open eu You can specify any of the following details to perform a search Authorization Status Select the authorization status of the record you want to search for from the drop down list provided The options possible are e Authorized e Unauthorized Record Status Select the status of the record w
29. een by typing CODELEBT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Online Customer Scheme Eligibility Evaluation C New l Customer Number Customer Name Scheme Id You need to specify the following details to evaluate the customer eligibility for a scheme Customer Number Select the customer number for which you would like to evaluate scheme eligibility from the option list provided Customer Name The name of the selected customer is displayed here Scheme ID Select the scheme ID for which you want to perform eligibility evaluation from the option list provided Scheme Description The description associated with the selected scheme is displayed here Click the Ok button to submit the batch for processing After submitting the batch click Batch Monitor button to view the status of the batch The status of the process is displayed in the Journal Batch Log screen 2 46 ORACLE The screen appears as shown below Journal Batch Log Intraday Sequence Z Function User Id Advanced Search Records per page RI Intraday Sequence Function User Id Status Start Time End time Branch Code Status W ProcessinProgress U Unprocessed P Process Completed The status of the process can be any of the following e W Process in Progress e U Unprocessed e P Process Completed 2 47 ORACLE 2 22 Viewing Customer Availed Sch
30. eferential exchange rates 2 23 ORACLE You can define benefits at module level for more than one product and price component combination You can invoke this screen by typing CODBENFT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button The screen appears as shown below Relationship Pricing Benefit Plan Detailed k Pricing Benefit Benefit Plan Id Benefit Plan Description Module Priority Number Pricing Benefit Details Price Components Benefit Type Variance Type Variance Currency nput E You can specify the following details in this screen Benefit Plan ID Specify a unique identification for the pricing benefit plan Benefit Plan Description Specify a suitable description for the benefit plan Module Select the module for which you want to maintain the benefit plan from the option list provided Priority Number Specify the priority number to be associated with the benefit plan for the selected module The priority number specified should be unique across all benefit plans for a given module 2 24 ORACLE 2 13 1 1 Specifying Pricing Benefit Details You can specify the following pricing preferences for the benefit plan Product Select the product to which you want to associate the benefit plan from the option list provided All the valid product codes for the selected module
31. eme Benefits You can view the details of the benefits availed by the customers in the Customer Availed Scheme Benefit Details screen You can invoke this screen by typing CODCUSCH in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button The screen appears as shown below Customer Number Taz Scheme dal Customer Name Scheme Description From Date E To Date E RP Reference Customer Number Customer Account Number Scheme Id L You need to specify the following to view the benefit details availed by the customer Customer Number Select the customer number for which you would like to view the benefit details Customer Name The name of the selected customer is displayed here Scheme ID Select the scheme availed by the customer whose details you want to view Scheme Description The description associated with the selected scheme is displayed here From Date Specify the date from which the scheme is applicable for the customer 2 48 ORACLE To Date Specify the date up to which the scheme is applicable to the customer Click the QUERY button to view the following details related to the benefits availed by the customer e Customer Number e Customer Account Number e Transaction Reference Number e Benefit Processing Date e Scheme ID e Benefit Plan ID e Eligibility Plan ID e Price Component e Benefit Type e Variance Type e Vari
32. ent by clicking the Validate Query button Any errors in the query statement will get displayed in the Error field Example UDE to get the number of accounts opened for a customer in the logged in Branch can be defined as follows Select count 1 from STTM_CUST_ACCOUNT Where Cust_No CUSTOMER_NO And branch_code global current_branch Function Tab If you have selected Function as the basis for deriving UDE value you need to specify the parameters related to the function in the Function tab 2 4 ORACLE Relationship Pricing User Data Elements Maintenance KR User Data Element UDE UDE Code UDE Description UDE Basis Query x UDE Data Type Numeric se Functioname a Get Parameters Function Description E Parameter Name UL Constant You can specify the following details here Function Name Select the database function you wish to use from the pre defined set of functions available in the option list Click the Get Parameter button to get the parameters linked to the function name selected Parameter Name All function parameters which can be mapped to an existing UDE or a constant value to arrive at the required output get displayed here You can specify either a UDE code or a constant value as input for the function parameter UDE Specify the UDE code to be used as a value for the function parameter You can spec
33. eressseserereessssoreeeerssserrnees 2 41 2192 Viewing Status Change Details soccer isessecties ves ibeesivts d e Eed ts svestestevbildeapescaiasviadissastotietevts ieren 2 42 2 20 VIEWING CUSTOMER BCHEMELDNKAOES 2 43 2 21 EVALUATING CUSTOMER SCHEME ONLINE 2 45 2 22 VIEWING CUSTOMER AVAILED SCHEME BENEFITS sssossenssssesereeeeseesererntrrnserrenrressesererenssenrrernesreserreeen 2 48 2 23 PROCESSING RELATIONSHIP PRICING BATCH ssssenensonseoserressesererresessrrerntsrnserreeeressesererenssesrernesneserreeen 2 49 2 23 E 2 49 2 232 Evaluating Scheme Eligibility suissa n ea a cedae vied Det AT dee 2 50 2 23 33 Applying Scheme Benefits trsc seecssessiberssiseetaetsoel iheesves dasasvesdissovesdeeteves E E E E E EAER 2 51 3 SCREEN GLOSSARY scsscscsssisecosscessencssanscossssvenseoatssenetsnaseseccssanscbeneceoasesesssscvassecsssnesoseess senscsenssovecsvecndcoaveseouess 3 1 3 1 FUNCTION TID ICIS VE 3 1 1 1 ORACLE 1 1 1 2 1 3 1 About this Manual Introduction This manual is designed to help you quickly get acquainted with the Relationship Pricing module of Oracle FLEXCUBE It provides an overview to the module and provides information on using this module of Oracle FLEXCUBE 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 Audience This manual is intended for the following User User Roles
34. f the loan amount is greater than 250 000 then interest rate needs to be decreased by 1 and if the loan amount is greater than 500 000 then the decrease should be 1 5 For the above rule the setup can be as follows Setup Values Module LD RDE TXN_AMOUNT Variance Rule basis Interest rate Return type Percentage Condition1 TXN_AMOUNT gt 250000 AND TXN_AMOUNT lt 500000 Result 1 1 Condition2 TXN_AMOUNT gt 500000 Result 2 1 5 2 12 Viewing Variance Rule Details You can view the details of the variance rule and also search for a rule for a specific module or type in the Relationship Pricing Variance Rule Maintenance Summary screen You can invoke this screen by typing COSVARRL in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button The screen appears as shown below 2 21 ORACLE Summary Authorization Status Record Status Variance Rule Id Variance Rule Basis Variance Rule Type v Module e sl Authorization Status Record Status V Authorization Status A Authorized U Unauthorized Record Status C Closed O Open Cat You can specify the following details to search for a variance rule Authorization Status Select the authorization status of the record you want to search for from the drop down list provided The options possible are e Aut
35. hich you want search for from the drop down list provided The options possible are e Open e Closed 2 16 ORACLE Eligibility Plan ID Select the eligibility plan you want to search for from the option list provided Click the Search button to search for records according to the search criteria specified You can also perform an advanced search using combinations of conditions by clicking the Advanced Search button 2 11 Maintaining Pricing Variance Rule You can maintain the price or rate variance rules at module level where you can specify the rule conditions based on the module specific attributes available You can specify multiple conditions based on which the preferential variance for eligible customers can be derived You can define the variance rule in Relationship Pricing Variance Rule Maintenance screen You can invoke this screen by typing CODVARRL in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button In New ariance Rule Id Variance Rule Basis Variance Rule Description H Variance Rule Type CH Module lla Variance Rule Currency 1 Variance Rule Currency 2 Relationship Data Element a Relationship Data Element RDE Parameter Value Expression Builder Input By Authorized By Modification Date Time Date Time Number Authorized Open You need to specify the following details in this screen Variance
36. horized e Unauthorized Record Status Select the status of the record which you want search for from the drop down list provided The options possible are e Open e Closed Variance Rule ID Select the variance rule you want to search for from the option list provided Module Select the module for which you want view the variance rule details from the option list provided Variance Rule Basis Select the basis of the variance rule which you want to search for from the option list provided The following options are available 2 22 ORACLE 2 13 Interest Charge Commission Fees Variance Rule Type Select the type of the variance rule you want to search for from the option list provided The following options are available for selection Fixed Rate Fixed Amount Variance Rate Variance Amount Percentage Click the Search button to search for records according to the search criteria specified You can also perform an advanced search using combinations of conditions by clicking the Advanced Search button Maintaining Benefit Plan You can define the benefits offered to eligible customers on availing a scheme in the Relationship Pricing Benefit Plan screen Benefits can be defined in terms of any of the following Preferential interest rates for loan products Beneficial charges fees for various transactions Preferential commission variance Preferential rates for periodic interest and charges Pr
37. ified You can also perform an advanced search using combinations of conditions by clicking the Advanced Search button System Data Elements For defining the eligibility criteria and the variance rule for a customer you need to use the following SDEs available in the system e CUST_AVGSAL to calculate the average salary of the customer for the last six months The system calculates the average salary based on the salary amount credited to the account using the salary or advance salary transaction codes Any reversal of salary with DR amount is not considered for calculating the average salary e CUST_EMPLOYER to determine the customer s current employer code maintained in customer maintenance screen 2 7 ORACLE 2 5 2 6 Maintaining Relationship Value Tag Codes A customer can avail the benefits of a scheme offered by your bank based on certain attributes like credit card reward points bonus points etc You can maintain these attribute tags in the Relationship Value Tag Code Maintenance screen The values for these attribute tags can be specified either manually or uploaded from an external system You can invoke this screen by typing CODRVTMT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Relationship Value Tag Code Maintenance C New Relationship Value Tag RVT RVT Code RVT Description Input By Authorized By Modificati
38. ify the CUSTOMER_NO keyword as a parameter value 2 5 ORACLE 2 3 Constant Specify a constant value of the function parameter You cannot close a UDE record if it is used in Eligibility Criteria maintenance or in Variance Rule maintenance Viewing UDE Details You can view the details of UDEs maintained and search for a UDE in the Relationship Pricing User Data Elements Summary screen You can invoke this screen by typing COSUDEMT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button The screen appears as shown below Summary Authorization Status Record Status x UDE Code Search AdvancedSearch Reset Authorization Status Authorized U Unauthorized Record Status C Closed O Open Exit You can search for a UDE value in this screen by specifying any of the following Authorization Status Select the authorization status of the record you want to search for from the drop down list provided The options possible are e Authorized e Unauthorized Record Status Select the status of the record which you want search for from the drop down list provided The options possible are 2 6 ORACLE 2 4 e Open e Closed UDE Code Select the code of the data element you want to search for from the option list provided Click the Search button to search for records according to the search criteria spec
39. n this screen Customer Number Select the customer for whom you want to link the pricing scheme from the option list provided All customers who have opted for relation pricing are displayed in the list Customer Name Name of the customer gets displayed once you select the customer number Scheme ID Select the scheme ID to be linked to the customer number from the option list provided You can link more than one scheme to a customer number Scheme Description The description associated with the scheme gets displayed once you select the scheme ID Benefit Start Date Specify the date on which the scheme benefits starts to be applied for the customer 2 35 ORACLE Benefit End Date Specify the date on which the scheme benefits cease to exist for the customer 2 17 1 Viewing Benefit Plans Select a benefit scheme and click the View Benefit Plan button to view the benefit plans associated with the selected scheme Benefit Details Benefit Plans E Module Benefit Plan Id Benefit Plan Description Priority Number View Benefit Details The following details related to the benefit are displayed e Module module to which the benefit is related e Benefit Plan ID unique identification of the benefit plan e Benefit Plan Description description linked to the benefit plan ID e Priority Number priority number assigned to the benefit plan 2 36 ORACLE 2 17 2 Viewing Pricing Benefit Details Select a row in Benefit
40. nance COSBENFT Relationship Pricing Benefit Plan Summary COSCURVT Customer Relationship Value Tag Code Summary COSCUSCM Customer Scheme Manual Linkage Summary COSELPLN Relationship Pricing Eligibility Plan Summary COSRVTMT Relationship Value Tag Code Summary COSSCHME Relationship Pricing Scheme Summary COSSCMST Customer Scheme Linkage Status Change Summary COSUDEMT Relationship Pricing User Data Elements Summary 3 1 ORACLE Function ID Function Description COSVARRL Relationship Pricing Variance Rule Maintenance ORACLE ORACLE Relationship Pricing May 2012 Version 12 0 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
41. nien aee EEE E E 2 13 2 10 VIEWING ELIGIBILITY PLAN DETAILS ccccccccssesscececececsesseaeceeececsenseaececececeesenaeseceeeesesseaesesececeeseneaeeeeess 2 16 2 11 MAINTAINING PRICING VARIANCE RULE ensseseseneesesseeroerresseserersnssesrrernesrnserronrnessesererenssenreernesnnserrenen 2 17 2 11 1 Specifying Relationship Data Elements 2 19 2 11 2 Specifying Conditions for Variance Rule 2 19 2 12 VIEWING VARIANCE RULE DETAILS 2 21 2 13 MAINTAINING BENEFIT PLAN 2 23 2 14 VIEWING BENEFIT PLAN DETAILS 2 27 2 15 MAINTAINING PRICING RCHEME 2 29 DADA Benefit Details TAD nenep i sotavoneannpeodegs E E A EEE AE 2 31 215 2 Eligibility Details TaD ss sccisssesssecasdiccehitesswessideaathadevs E ba vetea sects saa ASE EAA 2 32 2 16 VIEWING PRICING SCHEME DETAILS 2 33 2 17 MAINTAINING CUSTOMER SCHEMELINKAOE 2 34 DATA Viewmg Benefit lenger ier egenen deeg ee deed eren 2 36 217 2 Viewing Pricing Benefit Details ssscciccessciscotsegiees sasesven saskovesdissovesahe goes ea E E 2 37 2 473 Viewing Linkage Details sicticcssccessccetetscasdataativth staesen tacts E E E E A 2 39 2 18 CHANGING BENEFIT PLAN PRIORITY cc cccccccscssssscecececeesesssaeceeececsesssaececececeeseaaececececsesesaeaeseeeceenenneaeeeeees 2 40 2ASL Viewing Benefit Plan Details si csicssiicisessestagtunds ihevsben dhdestesdtssovesdes a caiesvielissustothe ier 2 41 2 19 CHANGING CUSTOMER SCHEME LINKAGE STATUS sseseseesesseseseeeossesererstresserer
42. nship value tag you want to search for from the option list provided Click the Search button to search for records according to the search criteria specified You can also perform an advanced search using combinations of conditions by clicking the Advanced Search button Maintaining Values for Relationship Tags 2 9 ORACLE You can maintain the values for the relationship tags either manually or you can upload the same from an external system You can maintain the values manually using the Customer Relationship Value Tag Code Maintenance screen You can invoke this screen by typing CODCURVT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Customer Relationship Value Tag Code KR Customer Number Customer Name RVT Code RVT Description RVT Code Value Source Code You can specify the following details in this screen Customer Number Select the name of the customer for whom you want to specify the relationship tag value from the option list provided Customer Name Customer name gets displayed automatically once you specify the customer number RVT Code Select the relationship tag code for which you want to specify the value from the option list provided RVT Description Relationship tag description gets displayed once you specify the RVT code RVT Code Value Specify a value for the relati
43. on Date Time Date Time Number Authorized Open You can specify the following details in this screen RVT Code Specify a unique code for customer relationship value tag RVT Description Specify a suitable description for the relationship value tag You cannot close an RVT record if it has been used for any customer RVT code mapping Viewing RVT Code Details You can view the details of the RVT code and also search for a desired code in the Relationship Value Code Maintenance Summary screen You can also invoke this screen by typing COSRVTMT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button 2 8 ORACLE 2 7 The screen appears as shown below Summary Authorization Status Record Status RVT Code searan Adancea Searon J Rese svdd Authorization Status Record Status RVI Code RVI Description Authorization Status A Authorized U Unauthorized Record Status C Closed O Open Exit You can specify any of the following details to perform a search Authorization Status Select the authorization status of the record you want to search for from the drop down list provided The options possible are e Authorized e Unauthorized Record Status Select the status of the record which you want search for from the drop down list provided The options possible are e Open e Closed RVT Code Select the code of the relatio
44. onship tag selected 2 10 ORACLE 2 8 Source Code Select the source code for the desired external system from the option list provided Viewing Relationship Tag Value Details You can view the details of the relationship tag values and also search for a desired value in the Customer Relationship Value Code Maintenance Summary screen You can invoke this screen by typing COSCURVT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Summary Authorization Status e Record Status Customer Number RVT Code Source Code mi oriz oo Sta S stomer Number RVT C Authorization Status A Authorized U Unauthorized Record Status C Closed O Open Exit You can specify any of the following details to perform a search Authorization Status Select the authorization status of the record you want to search for from the drop down list provided The options possible are e Authorized e Unauthorized Record Status Select the status of the record which you want search for from the drop down list provided The options possible are e Open e Closed 2 11 ORACLE 2 9 Customer Number Select the customer number whose relationship value you want to search for from the option list provided RVT Code Select the relationship value tag code you want to search for from the option list provided RVT Code Value Select the
45. red for eligibility evaluation e One time validity customers created within the benefit period are considered for eligibility evaluation If the customer does not satisfy the eligibility conditions then the benefits will not be given to customer again The status of such customer scheme linkages will be marked as Expired e Renewable validity customers created within the benefit period are considered for evaluation If the customer does not satisfy the eligibility conditions then the benefits will not be given to customer till the customer becomes eligible again The status of such customer scheme linkages will be marked as Expired Renewable The eligibility evaluation is carried out as follows in case of new customers and existing customers 2 23 2 1 New Customers Following conditions need to be satisfied for a new customer to avail the benefits of relationship pricing schemes e Customer should have opted for relationship pricing e Customer creation date should not be less than the scheme start date e Customer should satisfy the eligibility criteria associated with scheme eligibility plan Customer scheme linkage is established with status as Active if the scheme execution type is Automatic The status will be Waiting for Acceptance if the scheme execution type is Manual 2 23 2 2 Existing Customers For existing customers the customer creation date should be less than scheme start dat
46. s displayed here This value is arrived at based on the last revision date and the revision frequency specified 2 16 Viewing Pricing Scheme Details You can view the details of the pricing scheme and also search for a scheme in the Relationship Pricing Scheme Maintenance Summary screen You can invoke this screen by typing COSSCHME in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Summary Authorization Status d Record Status Pricing Scheme Id Scheme Start Date Validity Type Scheme End Date Apply For Execution Type sear Adanowa searen Rese Ce Ekm d Status Pricing Scheme Id Pricing Scheme Id Description Scheme Start Date Scheme End Date Validity Type Authorization Status A Authorized U Unauthorized Record Status C Closed O Open exit You can search for a pricing scheme by specifying any of the following fields Authorization Status Select the authorization status of the record you want to search for from the drop down list provided The options possible are e Authorized 2 33 ORACLE e Unauthorized Record Status Select the status of the record which you want search for from the drop down list provided The options possible are e Open e Closed Pricing Scheme ID Select the pricing scheme you want to search for from the option list provided Scheme Start Date
47. scheme benefits are offered to customers 7 Scheme benefits are applied to eligible customers based on their eligibility and also based on the product bundle the customer has opted for 2 1 ORACLE 2 2 The following diagram displays the relation between various components involved in the calculation of relationship pricing Customer Pricing Scheme Linkage External system Feed Relationship Value Tag Manual Scheme System Scheme Linkage Linkage SEET Customer Scheme Linkage SS SE Benefits Plan Scheme Definition Start Date End Date User Data Elements System Data Elements User Defined Fields Eligibility Plan The various maintenances required to provide relationship pricing to customers is explained in the subsequent sections Maintaining User Data Elements You can maintain the data elements to be used to compose pricing scheme rules in Relationship Pricing User Data Elements maintenance screen You can invoke this screen by typing CODUDEMT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button The data elements could be relevant fields from tables in the database or could be complex stored procedures derived from values of other UDEs or constant values 2 2 ORACLE The screen appears as shown below Relationship Pricing User Data Hements Maintenance k User Data Element UDE UDE Code UDE
48. standard product pricing This is commonly implemented by way of discounts rebates or offsets against standard pricing A combination of products wrapped as a product bundle could also be offered to customers Pricing benefits are offered to customers based on customer relation product bundling or a combination of both For e g for keeping a minimum daily balance of 2 500 a bank may offer its customers a fee waive off on credit cards lines of credit checking and savings as well as 100 free trades and bonus interest rates on savings accounts Pricing benefits are offered to customers as a variance over the standard product pricing A pricing scheme is defined and details like eligibility criteria validity period and the benefits of the scheme are maintained The relation between different components involved in relationship pricing can be explained as follows 1 User Data Elements UDE are defined to extract data from Oracle FLEXCUBE 2 External relationship values of customers are captured using relationship value tags RVT The RVT value can also be extracted from external systems 3 System Data Elements SDE are defined to be used in the special pricing rules 4 User defined fields are maintained to be used in the pricing rules 5 Eligibility criteria to identify the set of customer to avail the benefits of the scheme are defined using the values of UDE SDE RVT and UDF 6 Pricing variance rules are defined based on which the
49. ve selected Variance as the benefit type If you have selected the price component type as Exchange Rate the system automatically calculates the variance value using the quotation method maintained for the currency pair Variance Rule Select the variance rule ID to be associated with the benefit plan from the option list provided Once you select a variance rule ID the type of the variance rule gets defaulted in the benefit plan and you cannot change this Buy Spread Specify the spread associated with the buy currency 2 26 ORACLE 2 14 Sale Spread Specify the spread associated with the sale currency Buy and Sale spreads are applicable only if you have selected the price component type as Exchange Rate You can attach the benefit plan to a scheme which in turn can be linked to a customer You can either manually link the scheme to the customer or you can use the RP batch to link the scheme based on the eligibility criteria When such a pricing scheme having the price component type as Exchange Rate is linked to a customer the system derived variance value is added to the base rate to arrive at the customer specific rate at the transaction level Maximum Value Specify the maximum value for interest rate component type Minimum Value Specify the minimum value for interest rate component type the system will validate the final interest rate after application of RP against the minimum and m
Download Pdf Manuals
Related Search