Home

User Manual Oracle FLEXCUBE Direct Banking Retail Bulk

1. Mandatory Numeric 5 Type the sequence number of the template ID in the bulk data file Display This field displays the parent ID of the template Parent Template ID is same as Template ID Once the Base Template Id is defined Parent Id field automatically gets populated Conditional Numeric 3 Type the child count number for the section template This field is enabled if the Section option is selected from the Template Type from the drop down list Click the Next button The system displays Add Bulk Template Details Verify screen Click the Close Window button to close the transaction 35 ORACLE Bulk File Template Definition Add Bulk Template Details Add Bulk Template Details 23 08 2010 23 59 39 GMT 1000 Step1 Basic Template Details Base Template ID 1214 Number of Sub Templates 2 Mandatory Fields LES Se ALGN Step2 Sub Template Details Template ID Template Occ Field Min Max Keep Keep Seq Parent Id Child Bulk Type Occ Occ Prefix Postfix No Count Transaction Identifier M 0 M 0 7 Click the Back button to go back to the previous screen OR Click the Close Window button to close the transaction OR Click the Finish button The system displays the Add Bulk Template Details confirmation screen Add Bulk Template Details Add Bulk Template Details 24 08 2010 00 00 28 GMT 1000 Step1 Basic Template Details Base Template ID 1214 Number of Sub Templates 2 Mandatory Fields
2. Close Window Step2 Sub Template Details Template ID Template Occ Field Min Max Keep Keep Seq Parent Id Child Bulk Type Occ Occ Prefix Postfix No Count Transaction Identifier M 0 M 0 8 Click the Close Window button to close the transaction To search and modify existing bulk file template Bulk File Template Definition Bulk File Template Definition 24 08 2010 00 02 07 GMT 1000 Message Template Search By ID Request Enter values in the text boxes to search or click on any letter to view the details Create New Bulk File Ter 9 Click the alphabets for the alphabetical search Or the Search button The system displays the Bulk File Template Definition screen with the search result 36 ORACLE Bulk File Template Definition Bulk File Template Definition Bulk File Template Definition 24 08 2010 00 02 49 GMT 1000 Message Template Search By ID Request Enter values in the text boxes to search or click on any letter to view the details Create New Bulk File Ten Search ID Request a 1214 SEEE A ARAVA 4OSED ASDF BENE FILE TEMP BENE FILE TEMP RESPONSE DOMESTIC FILETEMPLATE FS INTERNAL FILETEMPLATE INTERNATIONAL FILETEMPLATE PAINSDD SLRACTMAXBRKEMT TEMPLATE SLRACTMAXBRKFEMT TEMPLATE RESPONSE 10 Click the ID request link to modify the ID details The system displays the Add Sub Template Details screen Add Sub Template Details Add Sub Template Details 24 08 2010 00
3. Type Template isFinRequest Close Window Field Properties Custom Validator This ts the Validator for template for Individual filed the custom validators are entered later Postfix If option Others is selected enter the required postfix Field Description Field Name Description Id Template Mandatory Alphanumeric 25 Type the unique bulk template id Template Mandatory Alphanumeric 50 Description Type the brief description of the bulk template Custom Validator Optional Pick list Type the Java class name that will be used as custom validator OR Select the custom validator from the pick list Name Schema For future use Separator String Optional Alohanumeric 8 Type the separator string For eg Comma space etc Reference For future use Template No of Fields Mandatory Drop Down Select the no of data elements that will be a part of the template from the drop down list Prefix Optional Alohanumeric 10 Type a prefix character that will be used to identify the start of record 20 ORACLE Bulk Template Definition Field Name Description Postfix Mandatory Drop Down Alphanumeric Type a postfix character that will be used to identify the end of record Terminator Optional Alohanumeric 25 Type a terminator character that will be used to indicate end of bulk template Adjustment Optional Numeric 15 Business Type Encoding Type Template isFinRequest Type a
4. Date Allowed Real Time l Future Dated Mandatory Fields Please select from the following to modify or delete the file conrol definition Bulk File Template ID 1214 INTERNATIONAL_FILETEMPLATE INTERNAL_FILETEMPLATE DOMESTIC_FILETEMPLATE PAINSDD SLRACTMAXBRKFMT_TEMPLATE BENE_FILE_TEMP Field Description Field Name Entities Allowed FLEXCUBE DIRECT BANKING FLEXCUBE DIRECT BANKING FLEXCUBE DIRECT BANKING FLEXCUBE DIRECT BANKING FLEXCUBE DIRECT BANKING FLEXCUBE DIRECT BANKING FLEXCUBE DIRECT BANKING Description Bulk File Template ID Entities Allowed Authentication Type Allowed Financial Transaction Type Financing Allowed Mandatory Drop Down Select the bulk file template ID from the drop down list Mandatory Check Box Select the appropriate check box for the country registered under multi entity setup Mandatory Drop Down Select the type of authorization required for the file type The options are None CA Token Optional Check Box Select the Financial check box to indicate that file template can be used as financial upload Mandatory Drop Down Select the transaction type to which the file template caters Optional Check Box Select the Financing Allowed check box to indicate that the file template supports financing at host 40 ORACLE Field Name File Control Definition Description Date Allowed Bulk File Template Id Entities A
5. The system displays Modify Data Dictionary screen Modify Data Dictionary 10 ORACLE Bulk Data Dictionary Modify Data Dictionary 24 08 2010 10 01 38 Modify Data Element Data Element 40001CONTROLTOTAMT Name of Data Element Description i A000LCONTROLTOTAMT Brief description about data element ts Field Type amount Data Type of data element Min Length fo Minimum Length of data element Max Length 2o Maximum Length of data element Field Format Format for the field Comments Any extra information about the Element Mandatory Fields Modify Data Element Close Window 7 Enter the required changes 8 Click the Modify Data Element button The system displays the Modify Data Dictionary screen Note For the field description please refer to create new data element table Modify Data Dictionary Modify Data Dictionary 24 08 2010 10 02 42 Modify Details Data Element 40001 CONTROLTOTAMT Description 40001CONTROLTOTAMT Type Amount Min Length 0 Max Length 20 Field Format Close Window 9 Click the Close Window to close the window 11 ORACLE Bulk Enrichment Definition 4 Bulk Enrichment Definition Using this option defines the bulk enrichment details to be fetched according to the field value You can define the queries to fetch additional data based on data given in this field For example user can define a query to fetch the account holder name if account number is th
6. 1000 Modify Enrichment Modify Details Name SO00LTEMPLATEBODYTY SLID 4TEEFFODATE Type J Parameter Number 1 Parameter Field S4O0017TEMPLATEBODYFORMATEFFDATE Java Class comiflex feat xjava bulk enrichment CurrentDateEnrichment Close Window 10 Click the Close Window button to close the Modify Enrichment screen 11 Click the Copy link on the bulk enrichment definition screen The system displays the Add Message Template screen Copy Enrichment 23 08 2010 22 14 24 GMT 1000 Qld SO001TEMPLATEBODYV4SLID4ATEEFFOATE Enrichment Mame Mew Enrichment Hame Close Window Field Description Field Name Description Old Enrichment Display Name This field displays the existing name of the Enrichment New Enrichment Optional Alphanumeric Name Select the type of the enrichment from the dropdown list 12 Enter the new Enrichment name to copy the exiting enrichment 13 Click the Ok The system displays the Confirmation screen OR Click the Close Window button to cancel the transaction and close the window 17 ORACLE Bulk Enrichment Definition Copy Enrichment Confirm Copy Enrichment 24 08 2010 13 46 11 Inserted sucessfully 14 Click the Ok button to close the copy enrichment screen 18 ORACLE Bulk Template Definition 5 Bulk Template Definition The Bulk Template definition is built using the data dictionary elements defined in the data dictionary maintenance Template repres
7. BTID DOMBTID DOMESTIC TRANSFER BTID DOMTFR DOMESTIC TRANSFER FILE LEVEL AUTH 21 DOMTFR DOMESTIC TRANSFER FILE LEVEL AUTH 21 Display Hyperlink This column displays the File Reference Number Display Hyperlink This column displays the Name of the uploaded file Click on the hyperlink to view the file details Display This column displays the User ID of user who has uploaded the file Display This column displays the total amount of transaction Amount uploaded in the file Display This column displays the total number of transactions Display This column displays the BTID linked to the file 63 ORACLE Bulk File View Field Name Description Bulk Description Display This column displays the Bulk Transaction Identifier BTID description Receive Date Display This column displays the Date on which the file was received Status Display This column displays the Status of the file Transaction Type Display This column displays the type of transaction contained in the file Auth Type Display This column displays the type of authorizer used to authorize the file Auth Number Display This column displays the number of users have authorized the file 6 Click the links available on each of the column headings to set them in the ascending or descending order 7 Click the 5 icon The system displays the User Preferences screen User Preferences E lick on check
8. Down Select the bulk file template from the drop down list 46 ORACLE Bulk Registration Field Name Description Decrypt Processor Optional Dropdown Select the type of Encryption from the dropdown The Options are e Both checksum and Encryption e Checksum encryption e Encryption only e Both checksum and Encryption e No checksum and No Encryption e Password Based Encryption Step information Details Description Optional Check box Select the Description check box to select the description Mobile Number Optional Numeric 12 Type the Mobile Number Email Optional Alphanumeric 100 Type the Email Id of the Customer 4 Click the Next button The system displays the Bulk Registration Verify screen OR Click the Cancel button to navigate to the previous screen 47 ORACLE Bulk Registration Bulk Registration Verify Bulk Registration Verify 24 08 2010 00 12 03 GMT 1000 FLEXCUBE DIRECT BANKING Customer Id 333000028 Customer Description 4CC LTD E General Bulk Identifier abed Bulk Description ab Payment Type None Transaction Type Beneficiary Upload E Authorization Limit And Authorization Authorization File El Bulk Tech Info Processor Default Processor PreProcessor Default PreProcessor Bulk File Template 1214 Decrypt Processor No Encryption No CheckSum E Step Information Details Description Mobile No Received Pre Process Validate and Enrich Authorization Processi
9. GMT 1000 Entity FLEXCUBE DIRECT BANKING Customer Id 333000028 Customer Description 4CC LTD E General Bulk Identifier ABCD Bulk Description AB Payment Type Transaction Type Beneficiary Upload E Authorization Limit And Authorization Authorization File E Bulk Tech Info Processor Default Processor PreProcessor Default PreProcessor Bulk File Template 1214 Decrypt Processor No Encryption No CheckSum E Step Information Details Description Mobile No Received Pre Process Validate and Enrich Authorization Processing Transaction Processing Completed eoma ean 10 Click the Confirm button to confirm the transaction OR Click the Cancel button to cancel the editing 51 ORACLE Bulk Registration Edit Bulk Registration Confirm Transaction submitted for Bulk Registration having reference 145188764179867 has been Auto Authorized Edit Bulk Registration Confirm 24 08 2010 00 15 23 GMT 1000 Entity FLEXCUBE DIRECT BANKING Customer Id 333000028 Customer Description ACC LTD E General Bulk Identifier ABCD Bulk Description 4B Payment Type Transaction Type Beneficiary Upload E Authorization Limit And Authorization Authorization File amp Bulk Tech Info Processor Default Processor PreProcessor Default PreProcessor Bulk File Template 1214 Decrypt Processor No Encryption No CheckSum E Step Information Details Description Mobile No Received Pre Process Validate an
10. GMT 1000 Message Template Search By Message Type Transaction Template l ID Template Description Enter values in the text boxes to search or click on any letter to view the details Create New Message G Search ID Request Description Total Fields Template Type aira le 1213 Flat File 1214 1214Desc Flat File 213 Flat File 213 Flat File oo byes AL Flat File a Lap Flat File 12143 Flat File 414124 Flat File 213 Flat File zia Flat File 231 Flat File 5645656787889 Gh aes Al Flat File A4A0001CONSOL 40001 CONSOL Flat File 40001 TEMPLATEBODY 40001 TEMPLATE BODY Flat File 40001 TEMPLATEBODY RESPONSE 40001 TEMPLATEBODY_RESPONSE Flat File AO001TEMPLATECONSOL 40001 TEMPLATECONSOL fy Enriched AOOOLTTEMPLATECONTROL 40001 TEMPLATECONTROL 2 Enriched Delete Template a kz lt j m 3 E ot BerPerPrRPRPRYP RPP YP HP HP HP 2 Click Copy to copy the bulk template Enter the New Template Name and click Ok 3 The new copied template is also seen in the list of Bulk Template Definition screen 4 Click Delete to delete the bulk template 32 ORACLE Bulk File Template Definition 6 Bulk File Template Definition Using this transaction you can create or modify the bulk template This option allows you to search the bulk template alphabetically or by specifying the field value Alphabetical search will view all the template file initiating with that alphabet To create new bulk file template 1 Log on to the Int
11. User BTID Map Confirm BTID has been successfully mapped to the user Your request for User BTID Map having reference 132842212128755 has been 4uto Authorized User BTID Map Confirm 24 08 2010 00 49 39 GMT 1000 Entity FLEXCUBE DIRECT BANKING User Type CORPORATE USER User Details UserId PARULCORPL Name Miss PARUL CORP1 Email BTID s to be mapped Bulk Identifier Bulk Description Sensitive Data Check BENEBULK BENEFICIARY FILE UPLOAD INTBULK INTERNAL ACCOUNT TRANSFER 58 ORACLE 10 Click the OK button The system displays the User BTID Map screen 59 ORACLE Bulk File View 10 Bulk File View Using this option you are allowed to view the bulk files uploaded by the customer This function should provide customer to view result of bulk files uploaded The search can be filtered on various parameters like status transaction identifier You can trace the status of the file and if there is an error in the file you can also download the error file to arrive at the exact reason for error You can also trace the history of the file Individual record details can also be checked To view bulk files 1 Logon to the Internet Banking application 2 Navigate through the menus to Bulk Management gt Bulk File View The system displays the Bulk File View screen Bulk File View Bulk File View 24 08 2010 00 51 08 GMT 1000 Entity FLEXCUBE DIRECT BANKING Field Description Field Name Description E
12. button after verifying the details The system displays the Add Bulk Template Details confirmation screen Add Bulk Template Details Add Bulk Template Details 24 08 2010 00 05 09 GMT 1000 Step1 Basic Template Details Base Template ID 1214 Number of Sub Templates 2 Mandatory Fields Step2 Sub Template Details Template ID Template Occ Field Min Occ Max Occ Keep Keep Seq No Parent Id Bulk Type Prefix Postfix Transaction Identifier alea les M 1214 1213 M 1214 15 Click the Close window to close the transaction 38 ORACLE File Control Definition 7 File Control Definition Using File Control Definition option an administrator can assign country specific mappings for bulk file template definition It also allows specifying additional constraints to the file template definition To create the file control definition 1 Log on to the Internet Banking application 2 Navigate through the menus to Bulk Management gt File Control Definition The system displays the File Control Definition screen 3 Select the Bulk File Template ID 39 ORACLE File Control Definition File Control Definition File Control Definition 24 08 2010 00 06 03 GMT 1000 Bulk File Template ID 323232 Entities Allowed ee FLEXCUBE DIRECT BANKING BO02 FLEXCUBE DIRECT sain 4uthentication Type Allowed None Financial _ Transaction Type Bulk International Transfer l Financing Allowed _
13. harm your computer If you do not trust the source do not open or save this file What s the risk 12 Click the Save button to save the file on your file system OR Click the Open button if you want to open the file 13 Navigate to the desired location where you want to save the file and click the Save button Once the download is complete the system displays the Download complete message 14 Click the icon to print the search results P 16 Click the file reference number hyperlink in the main screen of Bulk file view to view the Bulk file record details 15 Click the icon to optimize the data in the search results column Bulk file Record details Bulk File Record Details 24 08 2010 01 15 51 GMT 1000 Country Code FLEXCUBE DIRECT BANKING Customer ID Details Customer Id Description INB002321 Chews Filter Criteria Value Start Date Value End Date Record Status g E any Column Name Operator Data Credit Account No EQUAL Field description Field Name Description 66 ORACLE Bulk File View Field Name Description Customer id details Customer id Display This field displays the Customer id of the customer Description Display This field displays the description of the customer Customer id details Value start date Optional Pick list Select the value start date for the search criteria Value end date Optional Pick list Select the value end date for the se
14. 001TEMPLATEBODYFORMATEFFDATE Details SubTemplate Name Reference Field Field Description Field Format Request Validate Mandatory Enumeration Default Value Custom Validator Reference Field aaaa This is the name of Field Reference field for the used field Brief Description of Field Format for the field Is the field request necessary Is validation required on field Is Field mandatory Enumeration Value for the Field Default value of the Field Name of the Custom Validator Bulk Template Definition 24 08 2010 15 18 42 Description for the Transaction Name of the Custom Validator The Schema Name for the template Type of request for the Template Reference request for the Template Required only for Complex request type Extra Comments to be entered for the template No of fields for the Template Not mandatory when request type is complex Data Type Details Date More Create Another Close Window 11 Click the Create Another button to return to the Add Template definition screen OR Click the Close Window button to close the transaction To modify existing template definition 1 Click on the alphabet to view the bulk template definition starting with the clicked alphabet on the Template Definition page 26 ORACLE Bulk Template Definition Bulk Template Definition Message Template Search By Message Type Transaction Template ID Template Enter values in t
15. 02 53 GMT 1000 Step1 Basic Template Details Base Template ID 1214 Number of Sub Templates 2 Mandatory Fields Step2 Sub Template Details Template ID Template Occ Field Min Max Keep Keep Seq Parent Id Child Bulk Transaction Type Occ Occ Prefix Postfix No Count Identifier mm 1 mF Fk 11 Click the Edit link to modify a particular template ID Add Sub Template Details Add Sub Template Details 24 08 2010 00 02 53 GMT 1000 Step1 Basic Template Details Base Template ID 1214 Number of Sub Templates 2 Mandatory Fields Step2 Sub Template Details Template ID Template Occ Field Min Max Keep Keep Seq Parent Id Child Bulk Transaction Occ Occ Prefix Postfix No Count Identifier _ a m A mm m O Ee 12 Enter the required change 37 ORACLE Bulk File Template Definition 13 Click the Next button The system displays the Add Sub Template Details verification screen Add Sub Template Details Add Bulk Template Details 24 03 2010 00 04 40 GMT 1000 Step1 Basic Template Details Base Template ID 1214 Number of Sub Templates 2 Mandatory Fields Step2 Sub Template Details Template ID Template Occ Field Min Occ Max Occ Keep Keep Seq No Parent Id Child Bulk Type Prefix Postfix Count Transaction 1213 M 1214 0 1213 M 1214 0 Identifier 14 Click the Back button to go to the previous screen OR Click the Close Window to close the transaction OR Click the Finish
16. 11 2010 07 28 Accepted Field description Field Name Description Name Display This column displays the Name of the Record Record reference Display Number This column displays the Record Reference number Amount Display This column displays the Amount in each record Recipient IBAN Display This column displays the IBAN of the Recipient Value Date Display This column displays the value date of the record Status Display This column displays the status of the record Note Display This column displays the details in the record 19 Click on the Record reference number hyperlink to get the Bulk file Record details for each record Bulk file Record details 68 ORACLE Bulk File View 24 08 2010 01 17 30 GMT 1000 Bulk File Record Details Country Code FLEXCUBE DIRECT BANKING Field Name Account number 0001111 Beneficiary name English Chinese TEST3 TGG20479 Validation type 2 vendor code Beneficiary ID Transaction type 2 Mail address parul k oracle com Bank name CTHCUS66 Audit Details Yalue Date Note 2010 07 28 7000002 Transaction under process 7000002 Transaction under process 7000002 Transaction under process 7000002 Transaction under process 7000002 Transaction under process Reference Number Transaction 180207985055464 Updated By Beneficiary Upload PARULCORPL Updated On Status Yersion 28 07 2010 11 53 34 Accepted al 180207985055464 Beneficiary Upload PA
17. 1TEMPLATEBODYTOTRECORDS 40001TEMPLATEBODYTOTRECORDS Numeric 40001TEMPLATEBODYTXNSTATUS A0001 Body Response Txn Status Alphabets 40001 TEMPLATEBODYTXNTYPE A0001 Body Transaction Type Alphabets 40001TEMPLATEBODYYVALIDATEEFFDATE AGOOLTEMPLATEBODYVALIDATEEFFDATE Alphabets 40001 TEMPLATEBODYVALSCREEN AGOOLTEMPLATE body Validate Screen Numeric x List of Field types from which Field Name DataType Min Length MaxLength will be entered in the first empty space in the form below ID Template 1214 SubTemplate Name Reference Field Data Type Min Max Format Allowed Request alidate Mandatory Divider He Length Length Characters 1 40001 TEMPLATEBOI a fo fio v a O Mandatory Fields Field Properties SubTemplate Name Names of Field included in template Reference Field Reference field for the used field Data Type This is Data Type of the Field 5 Make the necessary modifications and click the Next For the description of the fields please refer to create Bulk Template Definition OR Click the Back button to return to the previous screen OR Click the Close button to close the screen 29 ORACLE Modify Template Modify Template Bulk Template Definition Step3 More SubTemplate Details ID Template 1214 S SubTemplate Name Custom alidator Error Code Fixlengthflag Cash Type No 1 AO001TEMPLATEBODYDRBRANCH Validators Fixed l Field Properties field name Names of Field included in template Enum
18. 9 21 Delimiter Is Is placeholder Aggregate N N Close Window hack ORACLE Template Details Template Details Modify Details ID Template 1214 Transaction Description 1214Desc Custom Validator Name Schema Business Type No Of SubTemplates Bulk Template Definition 24 08 2010 17 10 18 Description for the Transaction Name of the Custom Validator The Schema Name for the template The Business Type of the template No of fields for the Template Not mandatory when request type is complex Fixlengthflag Max Custom Justification Error Enrichment Fin Fill Delimiter Is Is Length alidator Code Field Char placeholder Aggregate 1 40001 TEMPLATEBODYDRBRANCH F 10 L EMPTY N N SubTemplate Name Details SubTemplate Name This is the name of Field Reference Field Reference field for the used field Field Description Brief Description of Field Field Format Format for the field Request Is the field request necessary Validate Is validation required on field Mandatory Is Field mandatory Custom Validator Name of the Custom Validator 8 Click the Close Window button to close the screen To copy Bulk Template Typically this is done to introduce a template or use an existing template with minor modifications 1 To copy a particular Bulk Template click on the alphabet with which it starts 31 ORACLE Bulk Template Definition Bulk Template Definition Bulk Template Definition 23 08 2010 23 56 43
19. Bulk Data Dictionary Description Enter values in the text boxes to search or click on any letter to view the details Create New Data Elemer To create a new data element 3 Click Create New Data Element to create a new data element The system displays Add Data Dictionary screen 8 ORACLE Bulk Data Dictionary Add Data Dictionary Add Data Dictionary 24 08 2010 09 46 Add New Data Element Data Element Description Field Type Amtvaidator o Min Length Max Length Field Format pooo Comments Field Description Create Data Element Reset Data Element Close Window Field Name Description Data Element Mandatory Alphanumeric 20 Type the data element name Description Mandatory Alphanumeric 35 Type the brief description of the data element Field Type Mandatory Drop down Type the data type of data element Min Length Mandatory Numeric 2 Type the minimum length of value that data element should hold Max Length Mandatory Numeric 3 Type the maximum length of value that data element should hold Field Format Optional Alphanumeric 15 Type the value format that data element should hold e g MM DD YYYY Comments Optional Alphanumeric 30 Type the extra information about the data the element 4 Click the Create Data Element button the system displays the add data dictionary confirm screen 9 ORACLE Add Data Dictionary Add Data Diction
20. CLE Bulk Enrichment Definition Modify Enrichment Modify Enrichment 24 08 2010 13 42 36 Modify Details Name 4000LTEMPLATEBODTVALIDATEEFFOATE Type Java Based 7 Parameter Number p Parameter Field 40001 TEMPLATEBODYFORMATEFFDATE Search Java Class tom iflex feat xjava bu Java Class Mandatory Fields a Modify Enrichment Field Description Field Name Description Name Display This field displays the name of the enrichment Type Mandatory Dropdown Select the type of the enrichment from the dropdown list Parameter Number Mandatory Drop Down Select the enrichment type from the drop down list The options are e Query Based e Java Based Parameter Field Mandatory Numeric 8 Type the parameter number Java Class Conditional Pick List Select the java class from the pick list lt is the name of the java class containing the enrichment code No special characters other then period and underscore _ Is allowed This field is enabled if Java Based enrichment is selected for modify Query Conditional Pick List select the query class from the pick list It is the name of the query class containing the enrichment code bt is enabled if Query Based enrichment is selected for modify 9 Click the Modify Enrichment button The system displays the Modify Enrichment Confirm Screen 16 ORACLE Bulk Enrichment Definition Modify Enrichment 23 08 2010 22 13 24 GMT
21. L2 ghIIIMINMNNI Alphabets 123 sad Alphabets 12312 23123 Comma Seperated phone numbers 123456 vbxv Amount 313 3123 Amount 400014MOUNT The amount to be credited Amount 40001BULKCONTROLDATEVALIDATOR BULK FILE CONTROL VALIDATOR Date 40001CHECKSUMFUNCTION The value can be Y or blank Alphabets A0001LCONTROLTOTALRECORD AD001LCONTROLTOTALRECORD Numeric A0ODLCONTROLTOTAMT ADOOLCONTROLTOTAMT Amount 40001CRACCOUNT The credit account number to which the amount is to be credited Pattern 40001CREDITTYPECODE This code spcefifes the type of transaction Pattern 40001 TEMPLATEBODYDATEFORMAT LAODOOLTEMPLATEBODYDATEFORMAT Date 40001 TEMPLATEBODYDEBITACCOUNT LENRICHED DEBITACCOUNT Pattern 40001 TEMPLATEBODYDELCORPID A0001TEMPLATEBODYDELCORPID Pattern 40001 TEMPLATEBODYDRACCOUNT AOQOO1TEMPLATE Body Debit Account Pattern 40001 TEMPLATEBODYDRBRANCH A0001TEMPLATE Body Debit Branch Alphabets 40001 TEMPLATEBODYFORMATEFFDATE 40001 TEMPLATEBODYFORMATEFFDATE Date 40001TEMPLATEBODYMAXINSTRUMENTAMT AOGOOLTEMPLATEBODYMAXINSTRUMENTAMT Amount 40001 TEMPLATEBODYMAXTRANDATE 40001 TEMPLATEBODYMAXTRANDATE Date 40001 TEMPLATEBODYMININSTRUMENTAMT Virtual field AQOO1 TEMPLATE Body Min Amount Amount 40001 TEMPLATEBODYREFNO A0001TEMPLATE Body Ref no Numeric 40001 TEMPLATEBODYREJECTREASON A0001 Body Reject Reason Free Text 40001 TEMPLATEBODYTOTINSTRUMENTAMT 40001 TEMPLATEBODYTOTINSTRUMENTAMT Amount A4000
22. NKING User Type CORPORATE USER User Details User Id P4RULCORPL Name Miss PARUL CORP1 Email Do you want to Q Map BTID C Unmap BTID BTID s to be mapped Bulk Identifier Bulk Description Sensitive Data Check BENEBULK BENEFICIARY FILE UPLOAD DOMBULK DOMESTIC ACCOUNT TRANSFER FILE UPLOAD INTBULK INTERNAL ACCOUNT TRANSFER INTNTLBULK INTERNATIONAL ACCOUNT TRANSFER Submit Field Description 57 ORACLE User BTID Map Field Name Description BTIDs to be mapped Bulk Identifier Mandatory Check Box select the check box adjacent to the Bulk Identifier column to map un map a BTID Bulk Description Display This column displays the description of the bulk identifier Sensitive Data Check Optional Checkbox This column displays the description of the bulk identifier 8 Select the checkbox and click the Submit button The system displays the User BTID Map Verify screen User BTID Map Verify User BTID Map Verify 24 08 2010 00 49 39 GMT 1000 Entity FLEXCUBE DIRECT BANKING User Type CORPORATE USER User Details UserId PARULCORP1 Name Miss PARUL CORPI Email BTID s to be mapped Bulk Identifier Bulk Description Sensitive Data Check BENEBULK BENEFICIARY FILE UPLOAD INTBULK INTERNAL ACCOUNT TRANSFER Cancel Confirm 9 Click the Confirm button The system displays the User BTID Map Confirm screen with the status message OR Click the Cancel Button to cancel the BTIP Map transaction
23. Oracle FLEXCUBE Direct Banking Release 12 0 0 Retail Bulk Payments Administration and Maintenance User Manual ORACLE FINANCIAL SERVICES Part No E52305 01 Corporate Bulk Payment Administration and Maintenance User manual Table of Contents Transaciion MOST Mntegralion Malik sciscsisianacseinisanninndsaniventiocnianacaumrenieacninieereindionhinisauanandienniniiiaendiad 6 BN PN acces sates acannon cs a cena occa T 7 gc MO Me Pa N E a E EEA EE E AA T EAE 8 BUK TE TATE DONMA RAN 12 BURK TEMRE Donroe a aa aa a Raa aaa 19 BUR FES FSIS DENTO T aiaia E aaa a 33 Ma aeae We a E EANA aac sep ea nade ae enn A E A E AES 39 EARR FR cin strate A E R EEEN E O EEE 42 io E E e A A A A E AN A A A A AN AA A A N 53 T Pok FIO VOW ainai a aaa A 60 Transaction Host Integration Matrix 1 Transaction Host Integration Matrix Legends mt NovowtieteReaues Transaction Name Third Party Host System Bulk Data Dictionary NH Bulk Enrichment Definition NH Bulk Template Definition NH Bulk File Template Definition NH File Control Definition NH Bulk Registration Buk File View Bulk File Upload 6 ORACLE Introduction 2 Introduction Bulk Management allows you to upload files which contain multiple transactions Bulk module facilitates processing of multiple transactions through a single bulk file such as Fund Transfer etc lt is a faster way of processing transactions than entering single screen transactions Bulk module can be use
24. RULCORPL 28 07 2010 11 53 34 Accepted 2010 07 28 180207985055464 Beneficiary Upload PARULCORP1L 28 07 2010 11 53 33 Accepted 2010 07 28 180207985055464 Beneficiary Upload PARULCORP1 28 07 2010 11 53 33 Accepted 2010 07 28 180207985055464 Beneficiary Upload PARULCORP1 28 07 2010 11 53 33 Accepted 2010 07 28 20 Click the Back Button to return to the previous screen 21 Click the File Name link on the bulk file view screen to view the History of the File History Of File 24 08 2010 01 22 29 GMT 1000 Country Code FLEXCUBE DIRECT BANKING Customer ID Details Customer Id Description INBOO2321 CLCUST File Details Bulk Transaction Identifier Description BENEFICIARY FILE UPLOAD Bulk Transaction Identifier BENEBULK File Reference No File Name 0000015 IRB txt History Of File File Status Received PreProcessed Authorized Processed Completion File Status Description Updated Date 28 07 2010 11 52 43 28 07 2010 11 52 43 28 07 2010 11 53 24 28 07 2010 11 53 29 File Download File Download Current Step Under Execution Download Response Received File Received by Bank Error File Validation Failed PreProcessing File is under Verification PreProcessed File Verified and Pending for 4uthorization Authorization File is under Authorization Authorized File is Fully 4uthorized Process File is under Processing at Bank Response Generation Reverse File Txn Status File generation Comp
25. arch criteria Record status Optional Drop Down Select the status of the file record from the dropdown Column name Optional Drop Down Select the name of the column for the search criteria The options available are Column name Amount Name Operator Optional Drop Down Select the operator as a search criteria from the dropdown The options available are Greater Equal Less Data Optional Alphanumeric 20 Type the value to be searched 17 To filter the records from the list type the details in the search criteria 18 Click the Clear button to clear the details entered in search criteria OR Click the Cancel button to cancel and return to the previous screen OR Click the Filter button to get the details of the record entered Bulk file Record details 67 ORACLE Bulk File View Bulk File Record Details 24 08 2010 01 15 51 GMT 1000 Country Code FLEXCUBE DIRECT BANKING Customer ID Details Customer Id Description INBOO2Z321 SLES Filter Criteria Value Start Date Value End Date Record Status E E Any Column Name Operator Data Credit Account No x EQUAL zl ie a ae 2BD Records 11o of s MIRREN RRB rove of ES E Name Record reference number Amount Receipent IBAN alue Date Status Note 0000015000002 0 0 0001111 2010 07 28 Accepted 0000015000003 0 0 0001111 2010 07 28 Accepted 0000015000004 0 0 0001111 2010 07 28 Accepted 0000015000005 0 0 0001111 2010 07 28 Accepted 0000015000001 0 0 00011
26. ary Add Details Data Element DATA Description description Type Amt Validator Min Length 1 Max Length 300 Field Format To modify the existing data element Bulk Data Dictionary 24 08 2010 09 52 55 Create Another Element Close Window 5 Click on the alphabet to view the data elements starting with the clicked alphabet on the Data Dictionary screen OR Click the Search button on the Bulk data dictionary screen The system displays all the data elements Bulk Data Dictionary Bulk Data Dictionary Enter values in the text boxes to search or click on any letter to view the details To view all templates click Search with empty textboxes Name a TA 123 123456 313 A0001AMOUNT A0001BULKCONTROLDATEVALIDATOR A0001CHECKSUMFUNCTION A0001CONTROLTOTALRECORD A0001CONTROLTOTAMT A0001CRACCOUNT AQOO1LCREDITTYPECODE AQOOLTEMPLATEBODYDATEFORMAT Description ghill sad 23123 vbxv 3123 The amount to be credited BULK FILE CONTROL VALIDATOR The value can be Y or blank AQ001CONTROLTOTALRECORD AQ001CONTROLTOTAMT The credit account number to which the amount is to be credited This code spcefifes the type of transaction AOQOO1LTEMPLATEBODYDATEFORMAT 24 08 2010 09 54 56 Type Length Alphabets Alphabets Comma Seperated phone numbers Amount Amount Amount Date Alphabets Numeric Amount Pattern Pattern Date 6 Click on the name of the data element that you wish to modify
27. box to show hide columns Select All File Reference Number File Name User Id Armoaunt Mo of Transactions Bulk Identifier Bulk Description Receive Date status Transaction Type Auth Type Guth Mumber T M M m M M m m m m m m m Move Up Move Down 8 Click the checkbox corresponding to the field which is to be displayed 9 Click the E icon to set the downloading preferences The system displays the Bulk file View downloading screen 64 ORACLE Bulk File View Bulk File View Download Bulk File View 74 08 2010 16 43 54 Download Type Page Layout File Format POF ee File Reference Number File Name User Id Amount E Mo of Transactions Bulk Identifier Bulk Description Download Field Description Field Name Description Download Type Mandatory Drop Down The options are e Pre Defined e Page Layout File Format Optional Drop Down Select the appropriate download type from the drop down list The options are e PDF e XLS e HTML e RTF 10 Select the fields to appear on output using gt gt and lt lt buttons 11 Click the Download button The system displays the File Download screen 65 ORACLE Bulk File View File Download File Download Do you want to open or save this file Name 162_SRReport_1259837008421 pdf Type Adobe Acrobat Document From 10 180 81 207 While files from the Internet can be useful some files can potentially
28. can access the Bulk file templates to view and assign You can also view the list of bulk registration created on earlier occasions To create a bulk registration 1 Logon to the Internet Banking application 2 Navigate through the menus to Bulk Management gt Bulk Registration The system displays the Bulk Registration screen Bulk Registration Bulk Registration 24 08 2010 00 08 00 GMT 1000 Entity FLEXCUBE DIRECT BANKING Customer Id Field Description Field Name Description Entity Mandatory Drop Down Select the entity from the drop down list 42 ORACLE Bulk Registration Field Name Description Customer Id Mandatory Alphanumeric 20 Type the customer ID 3 Click the Search button The system displays the Bulk Registration screen with the search criteria Bulk Registration 24 03 2010 00 08 49 GMT 1000 Bulk Registration Entity FLEXCUBE DIRECT BANKING Customer Id 333000028 Customer Id Customer Description G 333000028 4CC LTD Field Description Column Name Description Customer Id Display This column displays the customer ID Customer Display Description This column displays the customer name 4 Click the radio button adjacent to the customer ID column to view the registration details 5 Click the Next button The system displays the Bulk Registration screen with the details Bulk Registration 24 08 2010 00 09 23 GMT 1000 Bulk Registration Ent
29. cessor Default PreProcessor Decrypt Processor No Encryption No CheckSum Field Name Description Selected Customer Entity Display Customer Id Customer Description General Bulk Identifier This field displays the name of the Entity Display This field displays the customer ID Display This field displays the description of the Customer Mandatory Alphanumeric 10 Type the bulk type code for the selected customer ID 45 ORACLE Field Name Bulk Description Payment Type Transaction Type Bulk Registration Description Mandatory Alphanumeric 50 Type the bulk type description for the selected customer ID Optional Drop Down Select the payment type from the drop down list The options are e Single Debit Single Credit e Single Debit Multiple Credit e Multiple Debit Single Credit lt is an accounting entry type at the host system Optional Drop Down Select the transaction type from the drop down list Authorization Limit and Authorization Authorization Bulk Tech Info Processor Preprocessor Bulk File Template Optional Drop Down Select the authorization criteria from the drop down list The options are e File Record Optional Drop Down Select the processor from the drop down list The options are e Beneficiary Processor e Default Processor Optional Drop Down Select the preprocessor from the drop down list Optional Drop
30. d Enrich Authorization Processing Transaction Processing Completed 11 Click the OK button to return to the Bulk Registration screen 52 ORACLE User BTID Map 9 User BTID Map Using this option you are allowed to assign the bulk file template In addition it allows setting up of the sensitive data check Mapping of BTID is a mandatory step for you to enable the step of uploading the file You can map only bulk file templates which are mapped to the primary customer ID Note If the User BTID Mapping required check box in User Profile is not selected you would not be available in this transaction All the Bulk Types mapped to the customer in Bulk Registration would be available by default This option allows you to map un map the bulk transaction ID s To map user BTID 1 Log on to the Internet Banking application 2 Navigate through the menus to Bulk Management gt User BTID Map The system displays the User BTID map screen User BTID Map User BTID Map 24 08 2010 00 16 38 GMT 1000 User Type CORPORATE ADMINISTRATOR FC UBS First Name Starts with Last Name Starts with User Id Starts with x Email Starts with x Customer Id Starts With DOSS Y From Date ER To Date ER 53 ORACLE Field Description Field Name User BTID Map Description User Type First Name Last Name Mandatory Drop Down Select the user type from the drop down list Optiona
31. d to process financial and non financial transactions Following are the examples of financial transaction that can be covered through bulk management e Fund Transfers e Vendor Payments The Transactions in the form of files will be uploaded through the internet banking The different types of transactions will be uploaded in a file but it should be either financial or non financial transactions You will define the file structure using the various menus like bulk template definition bulk file template definition bulk enrichment definition You can restrict access to a file type to specific customers and within a customer to specific users A file type is defined as a file template in the system File template comprises of different bulk templates Record Templates The bulk template will be constructed using data elements amp data enrichment definitions 7 ORACLE Bulk Data Dictionary 3 Bulk Data Dictionary Bulk Data dictionary transaction defines the smallest element in the uploaded file This element can be account number branch code bank code or some other information which you want to be part of the uploaded file Using this option existing data dictionary element can also be viewed and or modified To create bulk data dictionary 1 Log on to the Internet Banking application 2 Navigate through the menus to Bulk Management gt Bulk Data Dictionary The system displays Bulk Data Dictionary screen Bulk Data Dictionary
32. e field Data enrichments will be used at the time of creating templates to fetch additional information on the data field supplied in the file Enrichment helps application to get derived values or do the enrichment validation To create bulk enrichment definition 1 Logon to the Internet Banking application 2 Navigate through the menus to Bulk Management gt Bulk Enrichment Definition The system displays the Bulk Enrichment Definition screen Bulk Enrichment Definition Bulk Enrichment Definition 23 08 2010 18 33 40 GMT 1000 Enter values in the text boxes to search or click on any letter to view the details Create Enrichment 12 ORACLE Bulk Enrichment Definition Field Description Field Name Description Name Optional Alohanumeric 25 Type the full partial name of the bulk enrichment 3 Click the Create Enrichment button The system displays the Add Enrichment screen Add Enrichment Add Enrichment 23 08 2010 18 34 35 GMT 1000 Add Details Type Java Based Parameter Number Parameter Field Search Java Class Java Class Mandatory Fields Create Enrichment Reset Enrichment Field Description Field Name Description Add Details Name Mandatory Alphanumeric 50 Type the name of the enrichment Type Mandatory Drop Down Select the enrichment type from the drop down list The options are e Query Based e Java Based Parameter Number Mandatory Numer
33. ength lll i is OO O OO ____ M Mandatory Fields Field Properties field name Names of Field included in template Reference Field Reference field for the used field Data Type This is Data Type of the Field Min Length Minimum Length of the Field Max Length Maximum Length of the Field Format Format for the field Request Is the field request necessary validate Is validation required on field Mandatory Is Field mandatory Clear Clears the value in the row Field Description Field Name Description Sub Template Display Name This field displays the sub template name Reference Field For Future Use Data Type Display This field displays the data type of the field Min Length Display This field displays the minimum length of the field 22 ORACLE Bulk Template Definition Field Name Description Max Length Display This field displays the minimum length of the field Format Display This field displays the value format that field e g MM DD YYYY Allowed Display Characters This field displays the character that is allowed and should be present in the uploaded file Request Optional Check box Select the Request Check box if the field request is necessary Validate Optional Check box select the validate Check the box if the field validation is required Mandatory Optional Check box Select the Mandatory Check the box if the field is mandatory Divider For F
34. ents a single transaction record in the uploaded file which could be repeated finite amount of time in the uploaded file Using this option you can search the existing bulk templates by specifying a field value or by clicking the corresponding letter link on the screen you can also create the basic file template which defines the structure of any bulk upload and attach Sub Templates created in Bulk Template transaction to the Bulk File Template The modify or copy of the template is also possible using this option The screen accepts information like number of fields in the template the prefix and the postfix information which is used to parse the uploaded file To create a New Bulk Template 1 Logon to the Internet Banking application 2 Navigate through the menus to Bulk Management gt Bulk Template Definition The system displays the Bulk Template Definition screen Bulk Template Definition 3 Click on any of the alphabets displayed as hyperlink or click on the search button to view the already existing template definitions 4 Click the Create New Message Template button The system displays Add Message Template screen Add Message Template 19 ORACLE Bulk Template Definition Add Message Template 12 10 2012 00 19 39 Stepi Basic Template Details ID Template O Template Description Custom Validator 0 B Name Schema i Separator String ooo o Reference Template O No of Fields Terminator Adjustment j
35. eration Enumeration Value for the Field Default Value Default value of the Field Custom Validator Name of the Custom Validator 24 08 2010 17 17 25 EMPTY Map CashType Close Window 6 Make the necessary modifications and click Next For the description of the fields please refer to create Bulk Template Definition Verify Template Template Verify Step4 erify Details ID Template 1214 Transaction Description 1214Desc Custom Validator Name Schema Business Type No Of SubTemplates SubTemplate Name Fixlengthflag Max Description for the Transaction Name of the Custom Validator The Schema Name for the template The Business Type of the template No of fields for the Template Not mandatory when request type is complex Custom Justification Error Enrichment Fin Fill Length Yalidator Code Field Char 1 40001 TEMPLATEBODYDRBRANCH F 10 Details E EMPTY SubTemplate Name This is the name of Field Reference Field Reference field for the used field Field Description Brief Description of Field Field Format Format for the field Request Is the field request necessary Validate Is validation required on field Mandatory Is Field mandatory Custom Validator Name of the Custom Validator 7 Verify the details and click Finish button OR Click the Back button to return to the previous screen OR Click the Close Window button to close the screen 30 24 08 2010 17 0
36. ernet Banking application 2 Navigate through the menus to Bulk Management gt Bulk File template Definition The system displays the Bulk File Template Definition screen Bulk File Template Definition Bulk File Template Definition 23 08 2010 23 57 27 GMT 1000 Message Template Search By ID Request Enter values in the text boxes to search or click on any letter to view the details Create New Bulk File Ter 3 Click the Create New Bulk File Template button to create a new bulk file template The system displays the Add Bulk Base Template screen 33 ORACLE Bulk File Template Definition Add Bulk Base Template Add Bulk Base Template 23 08 2010 23 58 06 GMT 1000 Step1 Basic Template Details Base Template ID Number of Sub Templates Mandatory Fields Field Description Field Name Description Base Template ID Mandatory Alphnumeric 40 Type the base template id Number of Sub Mandatory Numeric 2 Templates Type the number of sub template 4 Enter the Base Template Id and the Number of Sub Templates 5 Click the Next Button The system displays the Add Sub Template Details screen OR Click the Close Window buiton to close the transaction Add Sub Template Details Add Sub Template Details 23 08 2010 23 58 51 GMT 1000 Step1 Basic Template Details Base Template ID 1214 Number of Sub Templates 2 Mandatory Fields Step2 Sub Template Details Template ID Templa
37. he adjacent field For Example If you select the search criteria as Starts With and enter L in the adjacent field then the system displays all the email ID s starting with L Optional Drop Down Alphanumeric 20 Select the search criteria for the customer ID from the drop down list The options are e Starts With e Ends With e Equals e Contains Type the search string in the adjacent field For Example If you select the search criteria as Starts With and enter L in the adjacent field then the system displays all the customer ID s starting with L 55 ORACLE User BTID Map Field Name Description From Date Optional Date Picker Select the from date for date range for the search criteria To Date Optional Date Picker Select the to date for date range for the search criteria 3 Enter the relevant information for the search criteria 4 Click the Search button The system displays the User BTID Map screen with the search result User BTID Map Search Results User BTID Map 24 08 2010 00 17 42 GMT 1000 User Type CORPORATE USER zl First Name Starts with x 0 Last Name Starts with User Id Starts with tst S Email Starts with gt Customer Id Starts with z From Date ER To Date ER Search Condition CORPORATE USER Entity FLEXCUBE DIRECT BANKING User Type CORPORATE USER User Id johni4 TINS CORP2 TINS CORPS TINACORP4 Field Description User Descript
38. he fill character used to fill up the blank spaces if needed Optional Alohanumeric 50 Enter the character used for delimiting the field value This is applicable only when the file is of variable type Optional Check box Select the parameter field check box if it is used as a parameter field Optional Check box Select the Is placeholder check box if it is got from the enrichment Optional Dropdown lt is application to get derived values or do the enrichment validation while parsing data Select any of the enrichment Optional Check box Select the Is aggregate check box if the data element value is to be aggregated 24 ORACLE Field Name Bulk Template Definition Description Fin Field Optional Check box Select the Map Fin Field check box you will get the list of Financial Fields Select any of the Fin field to map the data element to it lf Advices are to be prepared for this template please map ADVICETOKEN1 to ADVICETOKEN100 If there is no Annexure template example RBI and data needs to be taken from Transaction Mixed Template then the FinField NOANNEXUREDATA should be mapped to any subTemplateName Data present under that subTemplateName is not considered for this finfield Cash Type Optional Check box Select the Cash Type to map the cash field 9 Enter the required fields and click the Next button The system displays Verify Template screen Template Verify Tem
39. he text boxes to search or click on any letter to view the details ID Request 1213 23123124124 312 5645656787689 40001 CONSOL AOOOLTTEMPLATEBODY AOOOITEMPLATEBODY RESPONSE 40001 TEMPLATECONSOL AOO001TEMPLATECONTROL 40003TEMPLATEBODY 40003TEMPLATEBODY RESPONSE Description eat 1214Desc Arg ral spil 123 12143 414124 213 21a 231 I2 40001 CONSOL 40001 TEMPLATE BODY 40001 TEMPLATEBODY_RESPONSE 40001TEMPLATECONSOL 40001 TEMPLATECONTROL 40003 TEMPLATE Body 40003TEMPLATEBODY RESPONSE Bulk Template Definition Total Fields Template Type Flat File Flat File Flat File Flat File Flat File Flat File Flat File Flat File Flat File Flat File Flat File Flat File Flat File Flat File Flat File BRePFYFP FP FP FP YP YP YP BP PP eB BN Enriched Enriched Flat File Flat File 23 08 2010 23 49 44 GMT 1000 Delete Template Delete Delete Delete 2 Click on the name of the bulk template definition that you wish to modify Template Definition Template Definition ID Template 1214 Template Description Name Schema Enrichments SubTemplate Details Sr No SubTemplate Name al 40001 TEMPLATEBODYDRBRANCH 1214Desc Custom Validator Comments Mappings Handoff Financial Reference Name Type Request Mandatory Yalidate No No 4 Data Type Type Template Min Length Max Length 0 10 24 08 2010 17 05 13 Footer Modify Template Ea Err
40. ic 8 Type the parameter number Parameter Field Mandatory Alphanumeric 250 Type the data elements containing the parameter value Multiple parameter fields can be separated by character 13 ORACLE Bulk Enrichment Definition Field Name Description Java Class Conditional Pick List Select the java class from the pick list lt is the name of the java class containing the enrichment code No special characters other then period and underscore _ Is allowed This field is enabled only if Java Based is selected in the Type drop down list Query Conditional Pick List Select the query class from the pick list It is the name of the query class containing the enrichment code This field is enabled only if Query Based is selected in the Type drop down list 4 Enter the name description and parameter related details of the enrichment 5 Click the Create Enrichment bution The system displays the Add Enrichment screen with the added enrichment OR Click the Reset Enrichment button to clear the screen Add Enrichment A dd Enrichment 23 08 2010 18 36 56 GMT 1000 Add Details Name ENRICHMENT Type J Parameter Number 1 Parameter Field IDCUSTOMER Java Class Create Another Enrichr Clo 6 Click the Create Another Enrichment button to create new enrichment OR Click the Close Window button to close the window 7 Click the search button on the bulk enrichment definition The system dis
41. ield Name Description Search Criteria Bulk Transaction identifier Transaction Type File Processing Status Upload Start Date Upload End Date Mandatory Drop Down Select the bulk transaction identifier from the drop down list Mandatory Drop down Select the transaction type associated with bulk file from the drop down list Mandatory Drop down Select the status of the bulk file Optional pick list Select the start date of uploading from the pick list Optional pick list Select the end date of uploading from the pick list 61 ORACLE Field Name File Name File Reference No Customer ID Bulk File Summary Bulk Transaction identifier Transaction Type File Status No of files displayed OR Bulk File View Description Optional Alphanumeric Type the name of the file Optional Numeric 20 Type the file reference number which was generated while uploading the file Optional Numeric 10 Type the customer id Display Hyperlink Select the BTID linked to the file to view the details Display This field displays the type of transaction contained in the file Display Hyperlink This field displays the Current Status of File Click on hyperlink to view the details of the file Display This field displays the count of files present Type the search criteria and click the Search button The Bulk File view screen is Click on Bulk transac
42. ion Email Channel Mr JOHN SMITH pradipkumar unnikrishnan oracle com Internet Miss TINA CORPORATE 2 tina harpalani oracle com Internet Miss TINA CORPORATE 3 tina harpalani oracle com Internet Miss TINA CORPORATE 4 tina harpalani oracle com Internet Field Name Description Search Condition Display This field displays the search condition Entity Display This field displays the entity User Type Display User Details User Id User Description This field displays the user type Display This field displays the user ID Display This field displays the user description 56 ORACLE User BTID Map Field Name Description Email Display This field displays the user s email address Channel Display This field displays the user channel 5 Click the link below the User Id column The system displays the User BTID Map screen User BTID Map 24 08 2010 00 18 21 GMT 1000 Entity FLEXCUBE DIRECT BANKING User Type CORPORATE USER User Details User Id johni4 Name Mr JOHN SMITH Email Do you want to G Map BTID Unmap BTID Field Name Description Do you want to Mandatory Radio Button Click the appropriate radio button to map un map the BTID 6 Click the appropriate Radio Button to select the BTID to be mapped unmapped 7 Click the Search button The system displays the User BTID Map screen User BTID Map User BTID Map 24 08 2010 00 48 35 GMT 1000 Entity FLEXCUBE DIRECT BA
43. ission Oracle is a registered trademark of Oracle Corporation and or its affiliates Other names may be trademarks of their respective owners Hardware and Software Engineered to Work Together 70 ORACLE
44. ity FLEXCUBE DIRECT BANKING Customer Id 333000028 Customer Description 4CC LTD Customer Details Bulk Identifier Bulk Description Date of Creation BLKOO2 BULKUPLOAD 23 08 2010 16 00 16 BTPOOL BULKTEST 23 08 2010 15 55 56 New Bulk Registration Cane 6 Click the New Bulk Registration button The system displays the New Bulk Registration screen OR Click the Cancel button to navigate to the previous screen OR Click the Edit link to make changes in the bulk registration 43 ORACLE Bulk Registration OR Click the Bulk Identifier Hyperlink to view the details of the Bulk registration 44 ORACLE New Bulk Registration New Bulk Registration Entity FLEXCUBE DIRECT BANKING Customer Id 333000028 Customer Description ACC LTD E General Bulk Identifier Transaction Type Beneficiary Upload E Authorization Limit And Authorization Authorization File E Bulk Tech Info Processor Default Processor l Bulk File Template 1214 E Step Information Details Description Mobile No xI Received Decrypt BO Pre Process Validate and Enrich Authorization a KI Processing Transaction Processing Post Processing Response Generation ma a Completed Note Mobile No and Email fields accpets comma as a seperator Mandatory Fields Field Description Bulk Registration 24 08 2010 00 10 46 GMT 1000 Bulk Description Payment Type None a PrePro
45. l Drop Down Alphanumeric 20 Select the search criteria for the first name from the drop down list The options are e Starts With e Ends With e Equals e Contains Type the search string in the adjacent field For Example If you select the search criteria as Starts With and enter A in the adjacent field then the system displays all the customer first names starting with A Optional Drop Down Alphanumeric 20 Select the search criteria for the last name from the drop down list The options are e Starts With e Ends With e Equals e Contains Type the search string in the adjacent field For Example If you select the search criteria as Starts With and enter E in the adjacent field then the system displays all the customer last names starting with E 54 ORACLE Field Name User Id Email Customer Id User BTID Map Description Optional Drop Down Alphanumeric 16 select the search criteria for the user ID from the drop down list The options are e Starts With e Ends With e Equals e Contains Type the search string in the adjacent field For Example If you select the search criteria as Starts With and enter 1 in the adjacent field then the system displays all the user ID s starting with 1 Optional Drop Down Alphanumeric 100 Select the search criteria for the email ID from the drop down list The options are e Starts With e Ends With e Equals e Contains Type the search string in t
46. leted Executed Rejected Rejected By Authorizer File Rejected by Authorizer 22 This screen displays the details of the history of the file 23 Click on the File Download hyperlink to view the details of the download OR Click on the Download Response button to view the down load response details OR Click on Cancel button to return to the previous screen 69 ORACLE Bulk File View ORACLE Oracle FLEXCUBE Direct Banking Retail Bulk Payments Administration and Maintenance User Manual May 2012 Version Number 12 0 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 oracle com Copyright 2012 Oracle and or its affiliates All rights reserved This document is provided for information purposes only and the contents hereof are subject to change without notice This document is not warranted to be error free nor subject to any other warranties or conditions whether expressed orally or implied in law including implied warranties and conditions of merchantability or fitness for a particular purpose We specifically disclaim any liability with respect to this document and no contractual obligations are formed either directly or indirectly by this document This document may not be reproduced or transmitted in any form or by any means electronic or mechanical for any purpose without our prior written perm
47. llowed 4 Optional Check Box Select the check box for date allowed as Future Dated or Real Time as appropriate Display This column displays the Bulk File Template Id Click the Bulk file Template Id radio button to select a Bulk File Template Id Display This column displays the Entities Allowed Click the Submit button The system displays the File Control Definition Verify screen File Control Definition Verify File Control Definition Bulk File Template ID Entities Allowed Authentication Type Allowed Financial Transaction Type Financing Allowed Date Allowed 24 08 2010 00 06 54 GMT 1000 323232 FLEXCUBE DIRECT BANKING None No Confirm Click the Confirm button to complete the File Control Definition and go to the File Control Definition Confirm screen with the status message OR Click the Back button to go back to File Control Definition screen File Control Definition Confirm File Control Definition Confirm Bulk File Template ID Entities Allowed Authentication Type Allowed Financial Transaction Type Financing Allowed Date Allowed Click the Ok button 24 08 2010 00 07 23 GMT 1000 323232 FLEXCUBE DIRECT BANKING None No Bulk International Transfer No The system displays the File Control Definition screen 41 ORACLE Bulk Registration 8 Bulk Registration This option allows you to register for bulk file upload Using this option you
48. ng Transaction Processing Completed Confirm Cancel 5 Click the Confirm button The system displays the Bulk Registration Confirm screen with the status message OR Click the Cancel button to navigate to the previous screen 48 ORACLE Bulk Registration Bulk Registration Confirm Transaction submitted for Bulk Registration having reference 168038019179837 has been Auto Authorized Bulk Registration Confirm 24 08 2010 00 12 03 GMT 1000 Entity FLEXCUBE DIRECT BANKING Customer Id 333000028 Customer Description 4CC LTD E General Bulk Identifier abcd Bulk Description ab Payment Type None Transaction Type Beneficiary Upload E Authorization Limit And Authorization Authorization File E Bulk Tech Info Processor Default Processor PreProcessor Default PreProcessor Bulk File Template 1214 Decrypt Processor No Encryption No CheckSum E Step Information Details Description Mobile No Received Pre Process Validate and Enrich Authorization Processing Transaction Processing Completed Register a new Bulk ID 6 Click the Register a New Bulk ID button The system displays the New Bulk Registration screen OR Click the Ok button to return to the Bulk Registration Screen Bulk Registration Bulk Registration 24 08 2010 00 13 37 GMT 1000 Entity FLEXCUBE DIRECT BANKING Customer Id 333000028 Customer Description 4CC LTD Customer Details Bulk Identifier Bulk Description Date of C
49. ntity Mandatory Drop Down Select the entity from the drop down list 60 ORACLE Bulk File View 3 Select the entity from the drop down list 4 Click the Submit button The system displays bulk File View screen is displayed Bulk File View Bulk File View 24 08 2010 00 51 56 GMT 1000 Country Code FLEXCUBE DIRECT BANKING Search Criteria Bulk Transaction Identifier Transaction Type File Processing Status fall Al All Upload Start Date Upload End Date ii File Name File Reference No Customer Id Click on a Bulk Transaction Identifier BTID to view all the files uploaded under this BTID Click on any of the links in the file status column to view the details within Bulk File Summary File Status Description Bulk Transaction Identifier Transaction Type File Status No of Files BENEBULK BENEFICIARY FILE Beneficiary Upload Authorized UPLOAD Beneficiary Upload Processed Beneficiary Upload Error DOMBULK DOMESTIC ACCOUNT Bulk Domestic Authorized TRANSFER FILE UPLOAD Transfer Bulk Domestic Processed Transfer Bulk Domestic Error Transfer Received File Received by Bank and Under Verification Error File Validation Failed PreProcessed File Verified and Pending for Authorization Authorized File is Fully Authorized Response Generation Reverse File Txn Status File generation Completed Executed Rejected Rejected By Authorizer File Rejected by Authorizer Field Description F
50. number to go one position ahead or behind Optional Drop down Select the business type from drop down list The option are as follows A Advice C Control and Trailer F Consol M Mixed Z No Processing T Instruction and Response H Header For future use Optional Drop down Select one of the following from the dropdown list The options are e Normal Ordinary template e Placeholder To be used in conjunction with Bulk Enrichment Definition For future use 5 Enter the relevant details 6 Click the Next button The system displays the Add Sub Template Details screen 21 ORACLE Bulk Template Definition Add Sub Template Details Add SubTemplate Details 24 08 2010 13 50 13 Step2 SubTemplate Details DELETE DELETE DELETE L2 QhININMMINN Alphabets 123 sad Alphabets 12312 23123 Comma Seperated phone numbers 123456 vbxv Amount 313 3123 Amount 400014MOUNT The amount to be credited Amount AOOOLBULKCONTROLDATEVALIDATOR BULK FILE CONTROL VALIDATOR Date 40001CHECKSUMFUNCTION The value can be Y or blank Alphabets AOOOLCONTROLTOTALRECORD 40001CONTROLTOTALRECORD Numeric 40001 CONTROLTOTAMT ADD0LCONTROLTOTAMT Amount 40001CRACCOUNT The credit account number to which the amount is to be credited Pattern A4O001CREDITTYPECODE This code spcefifes the type of transaction Pattern 40001 TEMPLATEBODYDATEFORMAT 40001 TEMPLATEBODYDATEFORMAT Da
51. or Code 3 Click the Modify Template button the system displays the Modify template Definition screen which is same as Template definition screen 2 ORACLE Modify Message Template Modify Message Template Stepi Basic Template Details ID Template AQOO1TEMPLATEBODY_RESPONSE Custom Validator Name Schema Prefix Terminator Business Type T Instruciton And Response v Reference Template No of Fields Field Properties Bulk Template Definition 12 10 2012 02 10 13 Template Description A0001TEMPLATEBODY_RESPONSE Separator String Postfix Adjustment Encoding Type Template isFinRequest Custom Validator This is the Validator for template for Individual filed the custom validators are entered later Postfix If option Others is selected enter the required postfix No of Fields To increase or reduce no of fields select required no from the dropdown and select DELETE in case of reducing no of fields in the next screen Select v 0 0 Normal 4 Make the required changes and click the Next button for the description of the fields please refer To create Bulk Template Definition OR Click the Close Window button to close the transaction 28 ORACLE Bulk Template Definition Modify Template Modify Template 24 08 2010 17 06 43 Step2 SubTemplate Details DELETE DELETE DELETE
52. plate Verify Step4 erify Details ID Template BO01CORP Transaction Description Description for the Transaction Custom Validator Name of the Custom Validator Name Schema The Schema Name for the template Business Type The Business Type of the template No Of SubTemplates No of fields for the Template Not mandatory when request type is complex Fixlengthflag Max Custom Justification Error Enrichment Fin Fill Length Y alidator Field Char 1 40001TEMPLATEBODYFORMATEFFDATE W 10 EMPTY SubTemplate Name Details SubTemplate Name This is the name of Field Reference Field Reference field for the used field Field Description Brief Description of Field Field Format Format for the field Request Is the field request necessary Validate Is validation required on field Mandatory Is Field mandatory Custom Validator Name of the Custom Validator 24 08 2010 15 17 28 Delimiter Is Is placeholder Aggregate 4 N N Fish 10 Verify the details and click the Finish button the system displays Complete Add Template screen OR Click the Back button to return to the previous screen OR Click the Close Window button to close the transaction Add Template Complete 20 ORACLE Add Template Complete ID Template BOO1CORP Template Description Custom Validator Name Schema Type Template Reference Template Comments No Of SubTemplates SubTemplate Details SubTemplate Name 1 40
53. plays the Bulk Enrichment definition screen 14 ORACLE Bulk Enrichment Definition Bulk Enrichment Definition Bulk Enrichment Definition 23 08 2010 22 11 41 GMT 1000 Enter values in the text boxes to search or click on any letter to view the details Name eee te 123123123 Create Enrichment Type Parameter Parameter Field Copy Number a Enrichment Java Based 1 i COPY Java Based 1 ta 7 12345678912345678912345678912345678912345678912345 Java Based 1 AOO01TEMPLATEBO 12GOVIND A0001TEMPLATEBODYVALIDATEEFFDATE DYMAXTRANDATE ha Java Based 1 fsadfsadf hh Query Based PAYEESNAME th Query Based ORGRECOTRSGHHE ID Ah Java Based ass Tine DYFORMATEFFDATE 4 AQOOLTEMPLATEENBODYACCTCUSTENRICH Java Based ee EMPLATEBODYDRAC 74 AQ001TEMPLATEENBODYCUSTACCTENRICH Java Based eee ey EMPLATEBODYDRAC 4 AOO01TEMPLATEENBODYDATEFORMAT Field Description Query Based FILEREFNO Z Field Name Description Name Display This field displays the name of the enrichment Type Display This field displays the type of the enrichment Domestic Display Parameter This field displays the parameter number Parameter Field Display This field displays the data elements containing the parameter value Copy Enrichment Display This field displays the Copy link 8 Click the Copy link to copy the enrichment OR Click the Name link The system displays the Modify Enrichment screen 15 ORA
54. reation ABCD B 24 08 2010 15 39 36 BLKOO2 BULKUPLOAD 23 08 2010 16 00 18 BTPOOL BULKTEST 23 08 2010 15 55 56 New Bulk Registration Cancel 7 Click the Edit link to edit the bulk registration The system displays the Edit Bulk Registration screen 49 ORACLE Bulk Registration Edit Bulk Registration 24 08 2010 00 14 40 GMT 1000 Edit Bulk Registration Country Code FLEXCUBE DIRECT BANKING Customer Id 333000028 Customer Description 4CC LTD E General Bulk Identifier ABCD Bulk Description aB Transaction Type Beneficiary Upload E Authorization Limit And Authorization Authorization File z E Bulk Tech Info Processor Default Processor PreProcessor Default PreProcessor l Bulk File Template 1214 Decrypt Processor No Encryption No CheckSum E Step Information Details Description Mobile No Received xI Decrypt a7 Pre Process Validate and Enrich xl Authorization a Processing Transaction Processing Post Processing OO Response Generation a Completed Note Mobile No and Email fields accpets comma as a seperator Mandatory Fields 8 Enter the required changes 9 Click the Submit button The system displays the Edit Bulk Registration verify screen OR Click the Cancel button to cancel the transaction 50 ORACLE Bulk Registration Edit Bulk Registration Verify Edit Bulk Registration Verify 24 08 2010 00 15 23
55. te 40001 TEMPLATEBODYDEBITACCOUNT LENRICHED DEBITACCOUNT Pattern 40001 TEMPLATEBODYDELCORPID 40001TEMPLATEBODYDELCORPID Pattern 40001 TEMPLATEBODYDRACCOUNT AO001TEMPLATE Body Debit Account Pattern 40001 TEMPLATEBODYDRBRANCH AGOOLTEMPLATE Body Debit Branch Alphabets 40001 TEMPLATEBODYFORMATEFFDATE A0001TEMPLATEBODYFORMATEFFDATE Date 40001 TEMPLATEBODYMAXINSTRUMENTAMT A0O01TEMPLATEBODYMAXINSTRUMENTAMT Amount 40001 TEMPLATEBODYMAXTRANDATE 40001 TEMPLATEBODYMAXTRANDATE Date 40001 TEMPLATEBODYMININSTRUMENTAMT Virtual field 40001 TEMPLATE Body Min 4mount Amount 40001 TEMPLATEBODYREFNO A0001TEMPLATE Body Ref no Numeric 40001 TEMPLATEBODYREJECTREASON A40001 Body Reject Reason Free Text 40001 TEMPLATEBODYTOTINSTRUMENTAMT 40001 TEMPLATEBODYTOTINSTRUMENTAMT Amount 40001 TEMPLATEBODYTOTRECORDS A0001TEMPLATEBODYTOTRECORDS Numeric 40001 TEMPLATEBODYTXNSTATUS 40001 Body Response Txn Status Alphabets 40001 TEMPLATEBODYTXNTYPE A0001 Body Transaction Type Alphabets 40001 TEMPLATEBODYVALIDATEEFFDATE AQO01LTEMPLATEBODYVALIDATEEFFDATE Alphabets AOO01TEMPLATEBODYVALSCREEN AQO01TEMPLATE body Validate Screen Numeric gt List of Field types from which Field Name DataType Min Length MaxLength will be entered in the first empty space in the form below Insert ID Template 4110A4S SubTemplate Name Reference Field DataType Min Max Format Allowed Characters Request Yalidate Mandatory Divider x z Length L
56. te Occ Field Min Max Keep Keep Seq Parent Id Child Bulk Transaction Type Occ Occ Prefix Postfix No Count Identifier 213 sd mixed I fh faz fo p 1213 mixed EI Oe fang fo Field Description Field Name Description Template ID Mandatory Drop Down Select the template ID from the drop down list You can view the selected data in the bulk data file 34 ORACLE Bulk File Template Definition Field Name Description Template Type Mandatory Drop Down Select the template type from the drop down list The options are as follows Mixed This type of template contains more than one type of transaction such as Cheque DD etc Record This type of template contains only cheque type transaction Section This type of template contains collection of records with instructions and its corresponding details To repeat a particular pattern the section template is used Occ Field For Future use Min Occ Mandatory Numeric 3 Type the minimum occurrence of the records that should be present in the bulk data file to be uploaded Max Occ Mandatory Numeric 3 Type the maximum occurrence of the records that should be present in the bulk data file to be uploaded Keep Prefix Optional Checkbox Keep Postfix Seq No Parent ID Child Count OR Select the Keep Prefix check box to give the prefix for the bulk template Optional Checkbox Select the Keep Postfix check box to give the postfix for the bulk template
57. tion identifier link OR Click on File status link to view the Bulk File view screen 62 ORACLE Bulk File View Bulk File View Bulk File View 24 08 2010 00 52 43 GMT 1000 Country Code FLEXCUBE DIRECT BANKING Search Criteria Bulk Transaction Identifier all Upload Start Date Transaction Type all File Processing Status all l Upload End Date ii pE _ Click on a Bulk Transaction Identifier BTID to view all the files uploaded under this BTID File Name B BB File Reference Number 0000058 0000059 0000060 oo00061 0000062 0000063 0000064 0000065 0000066 ooo0067 Field Description Field Name File Reference Number File Name User ID Amount No of Transactions Bulk Identifier Domestic File Level Auth txt Domestic Bulk Auth 02 txt File Reference No File Name MTB txt User Id CUSER12 IRB txt CUSER12 ITB txt CUSER12 IFB txt CUSER12 DOMESTIC txt TINACORPS DOMESTIC txt TINACORPS DOMESTIC txt TINACORPS Domestic Record Level Suth txt TINACORPS TINSCORPS TINACORPS Description Customer Id Records 1 to 10 of 25 Bhati P lt Page 1 of 3 in gt Amount No of Transactions Bulk Identifier Bulk Description 0 0 0 RECORDIL RECORD TYPE 4UTH 0 0 0 BEN1 BENE UPLOAD 0 00 RECORD1 RECORD TYPE AUTH 0 0 0 RECORD1 RECORD TYPE 4UTH 0 00 DOMBTID DOMESTIC TRANSFER BTID 0 0 0 DOMBTID DOMESTIC TRANSFER BTID DOMBTID DOMESTIC TRANSFER
58. uture Use 7 Select the sub template and click the Insert button 8 Enter the other relevant fields and click the Next button the system displays the following screen Add Sub Template Details Add SubTemplate Details Step3 More SubTemplate Details ID Template BOO01CORP ID Template BOOLCORP S SubTemplate Name Custom alidator Error Code Fixlengthfla Cash Type No 1 AQOO1TEMPLATEBODYDRBRANCH Validators Seleta EMPTY Map CashType Field Properties field name Names of Field included in template Enumeration Enumeration Value for the Field Default Value Default value of the Field Custom Validator Name of the Custom Validator 23 ORACLE Field Description Field Name Bulk Template Definition Description Custom Validator Error Code Fix Length Flag Justification Fill Char Delimiter Param Field Is Placeholder Enrichment Is Aggregate Optional Pick list Type the Java class name to be used as custom validator Click Validators link and select one of the java classes from the list Optional Alohanumeric 20 If required provide application message ID for custom error message Mandatory Drop down Select one of the following Fixed Fixed length field Variable Variable length field Mandatory Drop down Select one of the following Left Left justified field value Right Right justified field value Optional Alphanumeric 1 Enter t

User Manual Oracle FLEXCUBE Direct Banking Retail Bulk

Contents

Download Pdf Manuals

Related Search

Related Contents