Home
User Defined Fields User Manual
Contents
1. input By DOC2 Date Time W Authorized Authorized By Date Time a Open Modification Number A field that you have created will become operational in Oracle FLEXCUBE only after it is authorized A user bearing a different Login ID can authorize a field definition record that you have created eo ORACLE 2 1 1 Basic Details of User Defined Field Maintenance Screen 2 1 1 1 Field 2 2 Field name and description You can identify a field that you create with a unique identifier and a brief description Each field that you define in Oracle FLEXCUBE should be assigned a unique code You can briefly describe the field in Description field The description is for your information only It will not be printed on any customer correspondence Field type The type of field that you can create in Oracle FLEXCUBE can be of the following formats e Number Chose this option to create a Numeric field e Text Chose this option to create a Text field e Date Chose this option to create a Date field e Cube Entity Should you need to reuse any of the existing fields of Oracle FLEXCUBE to enter additional details you can indicate the Field Type as Cube Entity The Cube Entity can be any of the existing fields in Oracle FLEXCUBE like customer currency account etc Marking a field as mandatory You can make entry to a field mandatory To do so check against the Mandatory option A user of the field will be forced to make an entry to the f
2. or from the query written by the user if the cube entity type is Dynamic 2 18 ORACLE You will not be allowed to change the values of the fields for which you have not allowed amendment if the option Amendable is unchecked at the time of defining an UDF and derivation is allowed Option Derivation Allowed is checked Enter the values for the fields for which the values are not derived by the system You can change the value of a UDF after the system has derived the value from the derivation logic But it might so happen that the derivation logic of another UDF might use the value of the UDF that you have changed Consequently if you change the value of the UDF whose value is used in another UDF the value of that UDF will also change For example Let us assume that you have defined a user defined field UDF 1 to display the Euro equivalent of the contract currency The derivation logic of another user defined field UDF2 utilizes the values of UDF 1 to arrive at the value of UDF2 Assume that in the derivation logic written for UDF2 you have specified that the value of UDF2 2 UDF1 At the contract level system converts the contract currency into Euro equivalent and displays the value of UDF 1 as 220 00 According to this value of UDF2 will be 444 00 However if you change the value of UDF 1 to 250 00 it will effect on the value of UDF2 also it becomes 500 00 If the change in the UDF value has effected any o
3. Application Browser You can invoke this screen by typing STDBSUDF in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Embedded Field Maintenance UDF In Base Table Sequence Number Input By Date Time Authorized By Date Time Modification Number Authorized Open Select the function id STDCIF from the option list provided All the UDFs maintained for the selected function Id would be available in the option list for the Field Name Select the UDFs you want to include in the Customer Maintenance screen You can select a maximum of five UDFs Also specify the sequence in which you would like the UDFs to appear in the screen The selected UDFs will form a part of the Customer Maintenance screen and will be displayed in the sequence that you specify Customer Maintenance Customer No 000500048 Short Name Branch Code 000 Main Auxiliary Personal Corporate Director Address For Correspondence Name Address Swift Code Fax Credit Rating Group Code W Charge Group se Clearing Group N Tax Group N Full Name Unique Identifier Name Value Geographic Country Nationality Language Exposure Location External Reference Number Customer Category Customer Classification E Exposure on E EY Matina Cieta
4. err_code and err_param parameters can also be assigned and will be displayed if the validation fails in population of values UDF_field_name We can use another UDF that is already defined in the derivation logic of a UDF Example We have another UDF DDD FIELD_VAL UDF_DDD 2 12 ORACLE After writing the PL SQL code click X button to execute the code The derivation validation code is validated by the system If any checks fail you must alter the statement so that the validation derivation can be made successfully Click E button to view the errors You are allowed to Use any syntax in the pl sq code other than DML statements INSERT DELETE UPDATE and DBMS package You will not be allowed to USE any package function and procedures other than GLOBAL DEBUG and CSPKE_MISC 2 5 8 Cube Entity If the field that you are creating is of the type Cube Entity indicate the entity that is applicable to the field You can select a Cube Entity from the option list positioned next to this field This contains the following Cube Entities e Currency e GL e Branch e Customer e Account e Contract Ref No e User Ref No e Liability ID For instance You need to capture details of an additional customer for a transaction You can choose the Cube Entity field type and select the Customer field The list of customers maintained for your bank will be made available at the field as in any other Customer field in O
5. field 0s UNIQUE calor eterna assess gases EIE eE E E S E EEE AE EEE RE 2 8 LJ Specifying the Default VAlUe ccccsccccccccccccccssesseccceeeeeesseeeceeeeeaseeeeeeeeeeeeaaeeeeeeeeeseesaaaaeseeeeeesauaaaseeeeeeees 2 8 2 5 4 Allowing the Modification of values after POPULATION cccccccccseeeccccccecce ea eeseeccceeecaaeeseeeeeeeeaaaasseseeeeeeas 2 8 2 5 5 l actory shipped CIA S ac2scccs aesasaigcenanensgustoostanaeasisacoisonsceraniaeaaenansk N i Raai iaaiiai 2 9 2 5 6 Defining Additional Validation Rules ooe00eennnnnnnnnnnnnnneessssssssssssererrressressssssssssssssseereresessssssssssseees 2 9 237 VIGO HOW Kule cosas cuceaesaccseasisaccnsonceiaanscaens EA E EA AAE AEA 2 10 2 5 8 CL a A rer TET rer reTere Tn Pree Pree rer rnrr rer rer rr ere en errr rere ere ecrrer rere erernrrrere re 2 13 2 5 9 Enabling the Update Allowed option for a UDF u cccccccccccsssesesecccceceneeeesecceeeeeaaeeeseeceeeesaaaaseeseeeeeaas 2 15 2 6 MAKING A FIELD APPLICABLE TO A PRODUCT ssseeneccceceeeeeeeeesseeessssaaaneceeceeeeeeeeeeeeeeeesaaaaneeeeeeeeeeeees 2 15 24 LINKING THE UDF TOA FUNCTION UD prsujeseeweezersqeiesartearspareseiepeduencierdeidia i aia 2 17 2 8 POPULATING THE VALUES OF UDP c cnssonasessvonsgoncuoseyetsuonehanduonnvenbuapetions senevensuspehandtnantenbeapetenssenetensuemesentnens 2 18 2 8 1 Population of UDF values at the Contract level ccccccccccccccsssseccccccceceneeseecceeeeaaesseeceseeeaaaaeeseeseeeeeaas 2 18 2 8 2 C
6. in the Application toolbar or click new icon You will be prompted to select the account number according to the account mask If you have specified the account mask as CCCCCCCLLLLLUUU d system will allow you to select the customer account class currency Select these parameters from the adjoining option list When you select the customer system automatically picks up and displays the value of the UDF maintained for that customer Uploading User Defined Fields Your bank may use Oracle FLEXCUBE to process certain transactions say LD and FT transactions and use another application to process other transactions say MM and FX transactions At some point of time your bank may want to use the values from the external system in Oracle FLEXCUBE For this purpose Oracle FLEXCUBE stores the values of the various fields from the external system an application other than Oracle FLEXCUBE in a database table If your bank wants to use the value of the fields from the external system in Oracle FLEXCUBE the values have to be brought into Oracle FLEXCUBE database This is done through a process called Upload Contract Upload Let us assume that your bank is processing LD transactions in Oracle FLEXCUBE and MM transactions in an external system For processing certain LD transactions your bank wants to use the values from certain MM transactions Therefore you will have to put the value of the contract reference number along with the fiel
7. that you define in the User Defined Fields screen can be made applicable to the products and thereby to the contracts that you create for the front end modules of Oracle FLEXCUBE depending on your selection in the Usage Allowed field Example Suppose you have defined a user defined field DATE1 with Usage Allowed as Product the UDF will be displayed for association only in the Product Definition screen of a module 2 15 ORACLE At the time of creating a product click Fields button from the Product Definition screen From this list of all the fields that you created you can choose specific fields and make them applicable to the product Product User Defined Fields Product Code Product Description Fields 1071 SM Field Number Field Name Seed In this screen you can link the user defined fields to the product that you are defining Oracle FLEXCUBE allows you to link up to two hundred fields to a product To link a user defined field click add icon A list of all the user defined fields for which the Usage Allowed is Product will be displayed Select the fields that have to be included in the Contract Input screen for the contracts processed under the product that is being defined When a contract is processed under that product the fields associated with the product will be available in the Contract Input screen 2 16 ORACLE 2 Linking the UDF to a Function ID You can link the u
8. the tax number is 145736257 2 25 ORACLE The position wise weight and tax number and the product of weight and number is as provided below Wapa gaada inter ta mast WW lalejo lo el Sum of the product 160 Divide the value 160 by 11 to obtain the remainder Remainder 160 11 6 Therefore the 10 digit 11 Remainder 11 6 5 As per this algorithm if the remainder is 1 then the value of the UDF Tax Number should be considered as an invalid number If zero is the remainder then zero should be taken as the 10 digit of the tax number entered To do this e You need to define the UDF Tax Number e Specify Usage Allowed as Function ID e Write a rule to validate the 10 digit of the Tax Number as per the above specifications e Map the UDF Tax Number with the Function Id STDCIF function id for Customer Maintenances screen so as to make the field appear in the Customer Maintenance screen You can then enter the value for the same The procedure for mapping the UDF with the function id STDCIF is explained in the following sections 2 10 2 Making the UDF part of the Customer Maintenance screen You can make the UDFs defined for the function id STDCIF as part of the Customer Maintenance screen Oracle FLEXCUBE allows you to include a maximum of five UDFs in the screen 2 26 ORACLE The mapping is achieved through the Embedded Field Maintenance screen invoked from the
9. N where country USA RECORD_KEY RECORD_ KEY behaves differently for UDFs linked to Product and different for UDFs linked to Function ID RECORD_KEY When UDF is linked to FUNCTION_ID To use Record_key in UDFs where Usage allowed is Function_id you have to maintain Function Key Mapping which will be used to determine the record key before you define the UDF 2 10 ORACLE Specifying the UD Function Key Mapping details Through the Function Key Mapping screen you can define the Record Key items that are used for the Function ID This maintenance becomes mandatory if you have to use an UDF in all or any of the Functions You can invoke the User Defined Fields Function Key Mapping Maintenance screen by typing UDDFNMAP in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Function ld ad Function Key Mapping Ez jrone fremname lower posmo OOO O O a es a a Input By Authorized By Modification Authorized Date Time Date Time Mumber Open In this screen you must identify the function ID to which you need to link user defined fields Example The Function STDCIF is based on the STTM_CUSTOMER table The primary key maintained for this table is CUSTOMER_NO From the STDCIF FMB check the block name for the item and then enter the BLK Name block name in the Form for the Item ITM NAME Item name in the Form and the Order Numb
10. User Defined Field Oracle FLEXCUBE Universal Banking Release 11 3 0 May 2011 Oracle Part Number E51535 01 ORACLE FINANCIAL SERVICES ORACLE User Defined Field Table of Contents L OU TT MANUA Dec 1 1 1 1 Kropo TON E E A E eee l 1 1 2 ORGANA TO a a E A a E a S E l 1 1 3 CONVENTIONS USED IN THIS MANUAL sssssssseeeeeeeesssssssssssssrerreetsssssssssesestttereeesesssssssesetetereeeeesssssssssesetrretets l 1 k GLOS ARTO ICONS ren eer eo en iee u eio en ee eer ee ee 1 1 13 RELATED DOCUMENTS recrceroniipirees nye ene re kieken ere ere io eetan keidi Carena ee ee 1 2 2 CREATING CUSTOM FIELDS IN ORACLE FLEXCUBE ssscecccssssssssscccccccccccccssssssssssecccccceccccsssssssssee 2 1 2 1 EN TRO DUCTION e E E E A E E E E EE E TEE 2 1 2 1 1 Basic Details of User Defined Field Maintenance SCreen icccccccccccssesccccccccccnenescsceeceeeeaaaneseseeseseaaaaees 2 2 PAP SCOPE OPR TIEI IEE Dee O E EE E EE 2 2 2 3 U e FD A E A E A E E E E E S A E E O T E E 2 3 ABE o AT E E E oan nae E A A A A S N O E E E O P terse 2 3 2 4 1 Validation Type LOV List of Values oecccccccccsssseccccccccceecanesseccceeeeaaeeeeceeeeecaasseeeeeeeeeauaneeeeesessaeaaaes 2 5 2 4 2 D O E E E E OE EEA EEEE OEE EET TAE 2 6 2 4 3 D OT E A A E E E E NE 2 6 Lr NO TD arg geste E E E A youn T E E E A T E A EES 2 7 Dede Validations that you can specify fOr date fields cccccccccccccsssessceccccescaessssecceeeeeaaeseeeeceeeeaaaeseeeeeeeeaaaeess 2 7 ow Markin the
11. alue All entries made to the field will be validated against the format that you specify for the mask 2 4 ORACLE 2 4 1 Validation Type LOV List of Values Choose LOV to indicate that the entry to this field can be chosen from a predefined list On choosing this option you can define the items to be displayed on this list Click LOV button and define the list of values and their description The items that you define for the list are displayed whenever the field is used in Oracle FLEXCUBE List Of Values List Of Values t 15 U LOV Value Description for the LOV Values Is Default Value Field Name JT EOS m oo o i ORACLE 2 4 2 Derivation This indicates the procedure for populating the values of a field When you are processing a transaction that would use the user defined field the value of the UDF can be populated in the User Defined Field Field Name to Value Definition screen that is invoked from the Contract Input screen or the Function Id screen The value for the field can be populated based on certain conditions which can be defined as statements of code by the user Check against Derivation Allowed to specify that the value of a field has to be populated based on certain conditions Denvation Rule Derivation Rule Errors 2 4 3 Derivation Rule Check against the option Derivation Allowed if you want to the values of a UDF to be populated based on certain conditio
12. d name and value of the MM transactions which you want to use in Oracle FLEXCUBE into a database Upload table with the status marked as U indicating that it has to be taken up for processing This Upload table contains the values posted from the external system Subsequently you will have to bring the values of these fields into Oracle FLEXCUBE This is done by running the contract upload program When you run this program Oracle FLEXCUBE selects the fields for which the status is P It will upload the values from the external system into Oracle FLEXCUBE database Function Upload The values of the fields from external system used in the maintenance screens should be uploaded into Oracle FLEXCUBE database 2 23 ORACLE 2 10 Defining user defined fields for account statements The Detailed Account Statement Fields Maintenance screen in Oracle FLEXCUBE allows you to define fields that you wish to appear in the account statements for all the modules You can also define the list of values for the user defined fields that need to appear in the statements Detailed Account Statement UDF maintenance Product Code asl statement User Defined Field Number User Defined Field Name as User Defined Field Description Input By Authorized By Modification Authorized Date Time Date Time Number Open In the Detailed Account Statement Fields Maintenance screen you can specify a list of user defined fields applicab
13. d on this list Click LOV button and define the list of values and their description The items that you define for the list are displayed whenever the field is used in Oracle FLEXCUBE Text field 2 3 ORACLE To define a text field choose the text option at the Field Type field A text field can contain alphabets of the English language or a combination of alohabets and numeric values You can specify validation rules for a text field The validation types applicable to a text field include e Length e Mask e LOV e None You can indicate your preference at the Validation type field of this screen Choose None to indicate that no validation should be performed on entries made to this field Validation Type Length For a text field you can indicate that a valid entry to the field should be of a certain length You have the option to indicate e A fixed length e The maximum and minimum length for the field Depending on the option that you select indicate the fixed field length or indicate the maximum and minimum length of entries made to the field Validation Type Mask To indicate a field as a masked field choose Mask as the field type This option allows you to define a broad field structure to which all entries to the field should conform The mask structure can consist solely of a or n or a combination of these An a would indicate an alphabet of the English language and n a numeric v
14. e information related to the SSIA to the Revenue department The following UDFs need to be maintained For usage in the Bank Parameters screen Contact Person Name of the contact person in your bank for the SSIA account Contact Number Telephone number of the contact person At the time of maintaining the above UDFs in the User Defined Fields screen you need to associate them with the function id STDBANKP for allowing them to appear in the Bank Parameters screen For usage in the Customer Accounts Maintenance screen Ce e Date of account The date on which the SSIA account is opened If the account Opening is maintained in your bank it will be the account open date as specified in the Customer Account Maintenance screen For a transferred account a different date will be captured Date of account Maturity date of the SSIA account Maturity Total The total amount deposited until the transfer of the account Subscription from a different bank amount Total Tax Credit Total tax credit on the lodgment amount by the exchequer until the transfer of the account from a different bank Total Interest Total interest acquired on the account till the account is 2 28 ORACLE nee _ Amount Amount deposited into the SSIA in the transfer month till the Deposited into account Is transferred the SSIA on the transfer Month Termination The possible values are Termination and Closure The field Me
15. e value of a field after it is populated in the User Defined Field Field Name to Value Definition screen of Contract Input or Function Id screen To allow amendments to the values after they are populated check against the field Amendable at the time of defining a new field You will not be allowed to change the values of those fields for which you have disallowed the amendment option if the option Amendable is unchecked at the time of defining an UDF and derivation has been allowed Derivation Allowed option has been checked 2 8 ORACLE 2 5 5 Factory shipped fields Apart from the fields that you have created there are a set of fields that are sent by default as part of Oracle FLEXCUBE These fields are referred to as factory shipped fields You cannot define or change validations specified for factory shipped fields 2 5 6 Defining Additional Validation Rules Apart from specifying the validation type for a field you can specify additional validation rules to meet the requirements of the bank To indicate that additional validations are required for a particular user defined field check against Validation Allowed This will allow you to write a code to validate the value in the new field Click Validation button to write the validation code Validation Rule Validation Rule Errors 2 9 ORACLE 2 5 7 Validation Rule This is the PL SQL validation code based on which the system will check
16. er in this screen Order number cannot be Duplicated and Should be sequential After completing the Function Key maintenance you can continue defining the UDF for the Function ID You will be prompted to link the Function ID e g STDCIF to the Field at the Definition of the UDF RECORD_KEY will hold the value of a combination of all item name values separated by that are mapped in the UD function key mapping screen in the same order of order_no The Record key can be used only in the select statement Example Select country into FIELD_ VAL from i ORACLE STTM_ CUSTOMER WHERE RECORD_KEY and default_media MAIL RECORD_KEY When UDF is linked to PRODUCT RECORD_ KEY in product level takes the value of the Contract Reference Number transaction reference number You need not maintain the function key mapping You can use the RECORD_KEY in any statements in the Derivation rule and Validation Rule Example Select book_date into FIELD_VAL from CSTBS_CONTRACT WHERE CONTRACT_REF_NO RECORD_KEY L_prod_code substr RECORD_KEY 4 4 FIELD_VAL substr RECORD_KEY 4 4 RETURN_VAL This syntax can be used only in validation logic You can Assign TRUE or FALSE Values to this parameter Example RETURN_VAL TRUE if FIELD_VAL USD then RETURN_VAL TRUE else RETURN_VAL FALSE err_code UD UDF 01 err_param FIELD_ VAL end if The
17. ield Leave it unchecked to indicate that the field is not mandatory Scope of the field While defining a new user defined field you need to specify whether the new field has to be used at the product or maintenance level The scope or usage of the field that is being defined can be specified as Usage Allowed e If the new field that is being defined has to be used at the product level select usage as Product e If the new field is to be used in any of the maintenance screens screens related to Core Maintenance like Currency Definition screen Customer Accounts maintenance screen etc select usage as Function Id In Oracle FLEXCUBE every screen has a unique function Id However to differentiate between product and maintenance levels the scope of a user defined has been classified as Product and Function Id If the new field that is being defined is for a maintenance screen Usage Allowed is Function Id you can specify the function Id of the screen in which the new field has to be used This has to be indicated in the Function Id field Click on the option list positioned next to this field The function Ids of all the maintenance screens will be displayed Select the appropriate function Id 2 2 ORACLE 2 3 2 4 For example if you want to use the new field in the Chart Of Accounts Detailed screen select the Function ld GLDCHACT thus allowing the usage of the field in the Chart of accoun
18. le for a product that you have created Each list can be identified by an UDF name and description You can maintain as many UDF and product combination as you require In this screen you have to maintain the following details Product Code You can select the product for which the user defined field details are being maintained The user defined field details will be validated only for transactions involving the product selected in this field The description for the product code will be displayed on selection of the product code User Defined Field Name You have to select the UDF name from the option list for which the account statement maintenance has been initiated User Defined Field Name In addition to the UDF name you can give a brief description to describe each UDF 2 24 ORACLE Statement User Defined Field Number The system automatically displays the statement number sequentially for the user defined field you have selected In Oracle FLEXCUBE when ever an Account Statement is generated for any of the modules the following details is displayed in the User Defined Field Detailed section e A unique contract reference number e A user reference number e A brief description for the account number e A brief description of the offset account number e The bill number of the contract e The issue date of the contract e A brief narrative of the contract e Identification of the institution e The bill amount e The c
19. lid entry Marking the field as Unique Check against Unique if the field that is being defined has to be unique Consequently e If the usage allowed for the field is Product the new field will be unique across modules e If the usage allowed is Function Id it will be unique for the particular function id i e if you have specified a function ID the new field can be used only in the specified Function ID screen Specifying the Default Value You can specify a default value for a user defined field The option list positioned next to this field will be enabled only if the field is a cube entity Else the option list will be disabled Example Assume that your bank wants to capture an additional currency field for processing certain transactions and the default value for this additional field has to be USD Therefore your selections will be as follows e Field Type Cube Entity e Cube Entity Type Currency The option list in the Default Value field displays all the currencies maintained at your bank Select USD Consequently in the UDF screen of the Contract Input or Function Id screen USD will be displayed as the default currency If you have specified a default value for a field and also the derivation rule the value obtained from the derivation rule will take precedence over the default value at the Contract Function Id level Allowing the Modification of values after population You can modify th
20. lidated 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 Date field To define a date field choose Date as the Field Type For a date field you can indicate validations like whether back and future dates can be entered into the field and the back or future period applicable to the field Validations that you can specify for date fields 2 5 1 1 Indicating the Validation type You can specify the validation type for a date field The validation types applicable to a date field include e LOV e None If you indicate LOV then an entry to the field can be made only from the predefined list that you maintain for the field Choose None to indicate that no validation should be made for the field Back Future Date allowed For a date field you can indicate whether back or future dates can be entered Check against the relevant options to indicate your preference If you choose the back or future date options you should also indicate a future or back period permissible for the field The back or future period should be represented as a number 2 7 ORACLE 2 5 2 2 5 3 2 5 4 Example If you indicate 3 as the back date period the field will accept dates upto three days before the current system date as a valid entry If you do not choose any of these options the field will only accept the current system date as a va
21. mer NNANENNANAR It Status Type Individual Corporate Bank E Frozen E Deceased E Whereabouts Unknown E CRM Customer _ Mailers Required E CLS Participant E issuer Customer E Treasury Customer E Joint Customer mT920 E Relationship Pricing _ Staff Yet To Verify v Media SSN CIF Status Since KV C0 Deferenre Na KYC STatus MIS Standing Instructions Linked Entities CLS Restrictions J MT920 Domestic Professional Issuer Cards OFAC Check Linked Account Maker Checker Date Time Mod No Date Time 2 2 Authorization Status Record Status Cancel ORACLE The value that you enter for the UDFs will be validated as per the validation rules maintained during the definition of the UDF 2 10 3 Defining UDFs for SSIA SSIA refers to a special type of savings account used for promoting savings by customers Depending on the policies of your government you can maintain a minimum and a maximum deposit amount for an SSIA Further you can also assign a fixed allowance rate on the deposited amount if the deposit is within the specified limits On maturity you can send the details of the SSIA to the Revenue department to claim the allowance made to the customer Refer to the Products chapter of the Interest amp Charges User Manual for details on SSIA processing You can maintain UDFs to communicate th
22. n 2 20 ORACLE After creating the UDF link it to the function Id STDCIF in the User Defined Fields Function Key Mapping Summary screen E User Defined Fields Function Key Mapping Summary Web Page Dialog a Authorization Status Record Status El Function Id a Search Advanced Search Reset Records per page 15 kike of 4 KALI Go to Page 4uthorization Status Record Status Function Id CSDACSUD STDCIF ICDPRMMT CACHEOOK STDCUSAC LMDPRDOM LMIDLIMIT AMDCAOKL Cy DCDEFM DY DBRRAT GLDOCHACT ISDUTBEM LMDCOLLT LMDCOLTY LMIDLIMIT Authorization Status Record Status A Authorized Closed U Unauthorized D Open U A A A A A A A A A A A A A A Oooo oOo ooo ooo SE ORACLE 2 8 3 Indicating the Value of a user defined field for a customer At the time of creating a new customer in the Customer Information Maintenance screen click UDF button to invoke the User Defined Fields screen Enter the value for the user defined field which has to be included in the customer account since it is mandatory This value will be displayed at the time of defining a new customer account on selection of the customer User Defined Fields UDF Details 10f1 E LI 2 8 4 Using the value of the UDF for creating a Customer Account You might have linked several user defined fields to the customer Out of these you want the value of a particular UDF to be included in
23. n the manual refer to the Oracle FLEXCUBE manuals on Core Entities Core Services Common Procedures Products 1 2 ORACLE 2 1 2 Creating Custom Fields in Oracle FLEXCUBE Introduction While working with Oracle FLEXCUBE Corporate there are additional fields that you would like to use either for your convenience or to suit the requirements of your bank Adding to its flexibility Oracle FLEXCUBE now provides you the option to add fields based on your specifications to meet your needs Based on your requirement and the nature of the field you can specify default values and validations for the field Oracle FLEXCUBE will validate all entries made to the field against the validations you define for a field You can invoke the User Defined Fields Maintenance screen by typing UDDMAINT in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button a User Defined Fields Maintenance Field Name Field Description Field Type Length C Fixed Length Fixed Length Minimum Value Maximum Value Usage Allowed Function Validation Type Minimum Length Maximum Length Mask Default Value C Amendable _ Unique Field C Update Allowed C Back Dates C Mandatory Period Days E Derivation Allowed C Shipped _ Validation Allowed Future Dates Period Days Apa ive parE fi A LOV Derivation Validation Cube Enti
24. ns According to the requirements of the bank the implementer of Oracle FLEXCUBE will write a PL SQL code to populate the values of the user defined field The values of the UDF will be displayed in the User Defined Field Field Name to Value Definition screens of Contract Input or Function Id screen Click Derivation button to write the PL SQL code li ORACLE 2 5 2 5 1 After writing the PL SQL code 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 Example Grindlay s bank wants to have a new field to display the Euro equivalent of the contract amount in the User Defined Field screen of Contract Input screen To do this you need to e Define a field of type Number e Specify Usage Allowed as Product e Check against Derivation Allowed and e Write a code to display the Euro equivalent of the contract amount Subsequently you will link the UDF to a product and process transactions under it In the User Defined Field screen of Contract Online screen system will execute the derivation rule to convert the transaction amount to Euro equivalent and displays the Euro equivalent of the transaction amount After writing the PL SQL code click X button to execute the code The derivation code will be va
25. ounraqentan E E eaten 3 1 ORACLE 1 1 1 2 1 3 1 4 1 About this Manual Introduction This manual is intended as a guide to help you define User Defined Fields UDFs and associate the UDFs with products and therefore on contracts involving the products and on specific Functions in 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 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 Creating Custom Fields in Oracle FLEXCUBE explains how UDFs can be defined and used It details the procedure involved in defining UDFs and associating them with Products so that the UDF is associated with contracts associated with all contracts involving the product It also explains how to define UDFs and associating them with specific functions in Oracle FLEXCUBE Conventions Used in this Manual Important information is preceded with the symbol Glossary of Icons This User Manual may refer to all or some of the following icons i ORACLE co Delete row az Option List e9 Enter Query Fal Execute Query Refer the Procedures User Manual for further details about the icons 1 5 Related Documents For further information on procedures discussed i
26. racle FLEXCUBE 2 13 ORACLE Method for populating the Cube Entity values lf the field type is Cube Entity the values of a field can be selected from Oracle FLEXCUBE tables If you select the field type as Cube Entity the Cube Entity screen will be displayed Cube Entity Cube Entity ff Static Dynamic Static Entity Mame Dynamic Table Description Where Clause Query In the Cube Entity screen you need to specify the method by which the values have to be populated The options available are e Static If you choose this option system will retrieve the values from a Oracle FLEXCUBE table After specifying the cube entity specify the table name column name and where clause based on which the data will be retrieved from the table If you have defined a cube entity once you can reuse it The adjoining option list displays all the cube entities which you had used earlier displays Select the appropriate cube entity On selection of the reused cube entity system will automatically display the table name column name and where clause if specified for the selected cube entity You can however modify the condition in the where clause but not the table name and column name e Dynamic If you choose this option the values on the UDF will be populated based on the query written by the user ror the time of installation the implementer will write the PL SQL code for the derivation rule validation
27. reating a new user defined field AN example cccccccccccsssesseccccecccecaeeeseeeceeeeaaasesseeceeeeaaaaeseeeeeeseaaaes 2 20 2 8 3 Indicating the Value of a user defined field fOr A CUStOMEF oiccccccccccsseecccccccccneeeeseececeecaaaeeseseeeeeeseaaaes 2 22 2 8 4 Using the value of the UDF for creating a Customer ACCOUNL cccccccccccssseeescecceeceeaeeessececeeenaaseneeeees 2 22 22 WPLOADING USER DEFINED FIELDS sjcicccsosousitanssinscennbamesenseieisaea dues aca tieademanvensdeaaiedsaeadieesoeaieasernnreni tea neasieasy 2 23 2 9 1 CONT CE OD aetna ta gis vac ssataue estate S sijtas attest Goa E sesee ties aiowe 2 23 2 9 2 TIC TU OIE TOG E E te eisai dar ss nascar Renuka ecg luna E E A tension 2 23 2 10 DEFINING USER DEFINED FIELDS FOR ACCOUNT STATEMENTS ccccccececceceeeeccecccceceeccececececeseeeeeeeeeeeees 2 24 2 10 1 Defining user defined fields for CUSTOMETS cccccccccsseseeccccccecenaeessecceeeecaasesecceeeeaaaaseeeeceeeeseaaaaaeeeeess 2 25 2 10 2 Making the UDF part of the Customer Maintenance Screen cccccccccesveeeeecceeetnneneeeeceseteaaaaessseeeees 2 26 A DEEL D OV Sas dase ccs E naontecusa nach A T E A 2 28 2 10 4 Maintaining UDF for the Cheque Book Details SCr C1 ccccccccccccccscseeeeeeeeeeeeeeeeeeeeeeeeeeneea aaa eneneeennees 2 29 i mmm Od Oa 2 BG hokoy Y inener esneerereenrener ennrer ener S 3 1 3 1 FONCTION IDEN Taon ian naan nas maaan raegoen ants eseao tee peoan naa ragaynassoaqnaneaaaprease
28. rly the values of the UDF s linked to a function Id will be populated in the function Id screen 2 8 1 Population of UDF values at the Contract level The UDF s linked to a particular product will be available when a contract is processed under that product In the Contract Input screen click Fields button to invoke the User Defined Fields screen User Defined Fields Contract Reference Number Field Properties d Field Name Field Walue In this screen all the user defined fields associated with the product under which you are processing the contract will be displayed According to your specifications at the time of defining the user defined fields system may derive the values of the UDF from e Derivation Logic When you click Fields button system derives and displays the values of the fields for which derivation rules are written The value description is also displayed alongside e Static List of Values If the validation type of the UDF that is associated with the contract is List of Values LoV system will display the static values along with the value description If you have indicated a default value for the LoV the default value and its description will be displayed e Method of derivation for cube entity fields If a UDF is of type Cube Entity system populates the values in a LoV The values will be derived from the specified Oracle FLEXCUBE table if the cube entity type is Static
29. rule and also the query for fetching a cube entity according to the requirements of the bank Table Depending on your selection in the Cube Entity field system displays the table name in which the selected cube entity is located The value of the column which is specified in the previous field from this table will be picked up to populate the values of the new field 2 14 ORACLE Description After you enter the cube entity you may enter a brief description of the cube entity This description will be used for information retrieval Where Clause Enter the condition based on which the values from the specified column and table the values of the new field should be picked up Enter the condition in this field if you have indicated Static method for populating the values of the cube entity Query This is the code based on which the values of the new field will be picked up The query has to be written if the option Dynamic is selected 2 5 9 Enabling the Update Allowed option for a UDF 2 6 The Update Allowed option is used during Event Processing You can assign values to a UDF when a UDE is processed During event processing the system assigns certain UDF parameters based on the Execution Query you have maintained in the Event Processing screen You will be allowed to assign UDFs only for those UDFs for which the Update Allowed option has been enabled Making a field applicable to a product The fields
30. ser defined fields fields for which Usage Allowed is Function Id to a function Id in the User Defined Fields Function Key Mapping Summary screen You can invoke this screen by typing UDSFNMAP in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Authorization Status Record Status Function Id l Records per page 15 idla 4 of 1 oC eol Authorization Status Authorization Status A Authorized U Unauthorized Record Status Closed O Open Select the Function Id from the adjoining option list For instance if you want to include the user defined fields in the Chart Of Accounts Detailed screen select the function Id GLDCHACT After selecting the Function Id click add icon to select the fields that have to be included in the selected Function Id screen A list of all function Id s for which the Usage Allowed is specified as Function Id will be displayed Select the appropriate fields that have to be included from the list Oracle FLEXCUBE allows you to link up to two hundred fields to a Function ID After you save and authorize the record the user defined fields will be included in the specified Function Id screen oi ORACLE 2 8 Populating the values of UDF The defaulted or derived values of the UDF linked at the product level will be populated in the Contract Input screen at the time of processing contracts under a particular product Simila
31. the CASA User Manual for details on maintaining Cheque Book reordering parameters in the Cheque Book Details screen 2 29 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 STDBSUDF Embedded Field Maintenance STDCIF Customer Maintenance UDDFNMAP User Defined Fields Function Key Mapping Maintenance UDDMAINT User Defined Fields Maintenance UDSFNMAP User Defined Fields Function Key Mapping Summary 3 1 ORACLE User Defined Field May 2011 Version 11 3 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 2011 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
32. the account number Therefore your bank should inform the implementer of Oracle FLEXCUBE the UDF whose value has to be picked up and included in the customer account number The implementer will indicate the UDF whose value has to be picked up and included in the account number at the back end Consequently at the time of creating new customer accounts Oracle FLEXCUBE automatically picks up the value of that particular user defined field This will be displayed on selection of the customer Example Let us assume that your bank wants to include the value of the UDF CUST_COUNTRY_CODE created to include the country code of the customers in customer account numbers Therefore your bank has to inform the implementer that the value of the UDF CUST_COUNTRY_CODE has to be included in the account number The implementer will indicate at the back end that the value of the user defined field CUST_ COUNTRY_CODE should be included in the customer account number Let us assume that you have entered the value IND for the UDF CUST_COUNTRY_CODE for the customer Ms Tanya Agnihotri CIF Id 000000013 At the time of creating a new account for Ms Tanya Agnihotri system will automatically display the value IND on selection of CIF Id 000000013 a ORACLE 2 9 2 9 1 2 9 2 In Oracle FLEXCUBE customer accounts are defined in the Customer Accounts Maintenance screen To create a new account for a customer select New from the Actions menu
33. the value of the new field and validates at the time of transaction processing Entry to this field is mandatory if you have checked against Validation Allowed Example At the time of processing a contract for a customer Grindlay s Bank wants to add a new field to enter the first nominee that the customer has specified in his account The names of the nominees of a customer are maintained in the Customer Accounts Maintenance screen The bank wants the system to check that the name of the nominee that is entered in the new field and the name of the first nominee that is maintained in the Customer Accounts Maintenance screen are same To do this you need to e Create a new user defined field of type Text e Specify Usage Allowed as Product e Check against Validation Allowed and e Write a code to validate the value entered in the new field In the validation rule you write a code to check that the value of the first nominee specified in the Customer Accounts Maintenance screen for the customer for whom you are processing a contract and the value entered at the time of processing a contract are same Syntax to be used in Derivation and Validation Rules FIELD VAL FIELD_VAL holds the Value UDF This is s mandatory for Derivation Logic and it can be used in Validation logic to get the value of the field Example FIELD_VAL USD Select ccy_code into FIELD_VAL from CYTMS_CCY_DEF
34. ther UDF system will display an override informing you about the UDF whose value will be changed Select Ok button if you want the system to re calculate the value of the UDF based on the modified UDF value 2 19 ORACLE 2 8 2 Creating a new user defined field an example To include the value of a user defined field UDF in the customer account number you need to create a user defined field for the function Id STDCIF Function ld STDCIF indicates the Customer Information Maintenance screen Since the value of the UDF will be included in an account number it is mandatory for you enter the value of this UDF value of the UDF is entered at the time of creating a customer This is discussed in the subsequent sections of this chapter Therefore remember to check against Mandatory while defining the user defined field If you choose this option system ensures that you enter a value for the UDF LBL UDF FIELDS Field Description Function fa Field Type Validation Type C Fixed Length Minimum Length Fixed Lenath Maximum Length Mask Minimum Value Default Value sd Maximum Value Amendable Unique Field Update Allowed Field Back Dates C Mandatory Period Days C Derivation Allowed C Future Dates Shipped Period Days L_ Validation Allowed Lov J derivation Validation Cube Entity Input By Authorized By Modification Authorized Number Date Time Date Time Ope
35. thod value will be Termination when the account is terminated and Closure when the account is transferred to another bank When defining the above UDFs you have to associate them with the function id STDCUSAC for allowing their usage in the Customer Accounts Maintenance screen These fields will be used only for information purposes Oracle FLEXCUBE will validate all entries made to the field as per the validations defined if any 2 10 4 Maintaining UDF for the Cheque Book Details screen For Cheque Book reordering whether manual or automatic you have to indicate the type of cheque to be reordered For this you can define an UDF Cheque Type and associate it with the function id CACHBOOK for Cheque Book Details screen You can maintain a list of values LOV and their descriptions when defining the UDF in the User Defined Fields screen The possible values and the descriptions for this UDF are as follows J 20 page x 3 5 Personal 40 page x 3 5 Business 40 page x 3 5 Business 40 page x 3 5 2 Part 80 page x 3 5 Business At the time of defining cheque book ordering details in the Cheque Book Details screen invoke the User Defined Fields screen In this screen the UDF Cheque Type that you had linked to the function Id CACHBOOK will be displayed along with the list of values You can click on the option list provided and select the value of your choice Refer to
36. ts screen only o If you want the Field to be made available for all the Functions you will have to leave it b blank Numeric field To define a numeric field choose the number option at the Field Type field You can set up validation rules for a numeric field The validation types applicable to a numeric field are e Range e Length e LOV e None You can indicate your preference at the Validation type field of this screen Choose None to indicate that no validation should be performed on entries made to this field Validation Type Range You can specify the range validation type only for Numeric fields In this case the entry to the field should be within a permissible range On choosing this validation type you should indicate either the maximum or minimum values or both values allowed for the field Any valid entry to the field should be within the range that you specify Validation Type Length For a numeric field you can indicate that the entry should be of a certain length You have the option to indicate e afixed length e the maximum and minimum length for the field Depending on the option you select indicate the fixed field length or indicate the maximum and minimum length for valid entries to the field Validation Type LOV List of Values Choose LOV to indicate that the entry to this field can be chosen from a predefined list On choosing this option you can define the items that should be displaye
37. urrency of the bill e Description of the charge 1 e Details of the charge 1 e Description of the charge 2 e Details of the charge 2 2 10 1 Defining user defined fields for Customers On occasions to know your customer better you may need to capture additional information about the customer This is in addition to the regular information that you would capture in the Customer Information Maintenance screen You can do so by defining a set of UDFs and associating them with the function id STDCIF for Customer Information Maintenance screen On association the UDFs will be available in the screen and you can enter the values for the same The values will be verified for adherence to the validation rules maintained for the UDFs For instance you may want to capture the Personal Identification Number for all individual customers of your bank To achieve this you need to define Personal Identification Number as an UDF in the User Defined Fields screen You can also write a code to validate the entry into this field Example Friendly Neighborhood Bank wants to add a new field to capture the Tax Number of all its corporate customers The bank wants to maintain a 10 digit tax number and further wants to validate the 10 digit of this number based on the following rule Multiply the value of each position 1 to 9 with the weight for each position Your bank will provide the weight for each position For instance assume that
38. 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
Download Pdf Manuals
Related Search
Related Contents
CM362-JP 取扱説明書 前面用デュアルヒンジドア PDFファイル ASUS M51AD TH8828 User's Manual Freek Bosgraaf - ReparierMich.de Gegenees V 1.1.0 Certification. Overview of training and tests TH-32/26/20/17X1(かんたんガイド) (3.08 MB/PDF) 取扱説明書(保証書付き) MACROM M-DL40 car media receiver Copyright © All rights reserved.
Failed to retrieve file