6. Oracle FLEXCUBE Universal Banking - Direct Banking Integration

Oracle FLEXCUBE Direct Banking is a multichannel e-banking platform with support for customer touch points like Internet, mobile phones and PDAs. This system is based on Java Standard Edition (Java SE) and Oracle Java Enterprise Edition (Java EE) platforms.

Oracle FLEXCUBE Universal Banking – Oracle FLEXCUBE Direct Banking integration provides for exchange of data between the two systems. This enables the users of Oracle FCDB to access the information stored in Oracle FCUBS application.

This manual explains the prerequisites required for the integration of FCUBS and FCDB. It also describes various types of information that are in the scope of integration and the channels through which such information are processed.

This chapter contains the following sections:

• Section 6.1, "Transaction Details"
• Section 6.2, "Maintenances"
• Section 6.3, "Processing Messages"
• Section 6.4, "Services and Operations associated with XSDs"

6.1 Transaction Details

This section contains the following topics:

• Section 6.1.1, "Transactions Supported by the Integration"
• Section 6.1.2, "Additional Interfaces"Section 6.1.3, "Communication Channels"
• Section 6.1.3, "Communication Channels"

6.1.1 Transactions Supported by the Integration

The transactions supported by this integration are given below.

Transaction Name	Transaction Description	Administration Transaction	Oracle FLEXCUBE UBS Module
Account Setup	This transaction allows a Cor­porate administrator to view & modify account setup for their users.	Yes
SSO for Chan­nels	Provision to allow for single login and authentication cre­dentials (user id, login pass­word and transaction password) for all channels that are part of a group	Yes
Multilingual Data Input	Business users should be able to input data in the application as per their preferred lan­guage.	Yes
Monitor Timer Services	This function allows bank administrator to monitor timer services.	Yes
View Customer Transactions	This function allows bank administrator to view the transactions done by various business users.	Yes
Customer Profile	This transaction allows a Cor­porate administrator to view & modify their own customer profile using: Modify Profile View Profile User Account Setup	Yes
Authorisation Mandates (Main­tain User List, Manage Rules)	This function allows Corpo­rate administrator to set authorisation mandates for their users.	Yes
Bulk Registration	This function allows Corpo­rate administrator to set up bulk registrations.	Yes
User BTID Map	This function allows Corpo­rate administrator to map/unmap User BTID.	Yes
View Audit Log	This function allows Corpo­rate administrator to view audit logs of their own users.	Yes
Terminate User Session
Print Welcome Letter / Pass­word
Customer Account Open­ing Management	This function allows bank administrator to view details and update KYC status of the users who have registered online and opened customer online. Applicable for Virtual Banking.	Yes
Role mainte­nance	This transaction allows a Cor­porate administrator to man­age roles for their own customer id.	Yes
User mainte­nance	This transaction allows a Cor­porate administrator to man­age users for their own customer id for the following: Create User Modify User Activate User Deactivate User Lock User Unlock User Delete User Revoke User View User Reset Password	Yes
Create Role	This transaction allows bank administrator to create a role	Yes
Modify Role	This transaction allows bank administrator to modify a role	Yes
Delete Role	This transaction allows bank administrator to delete a role	Yes
View Role	This transaction allows bank administrator to view a role	Yes
Create User	This transaction allows bank administrator to create a user.	Yes
Modify User	This transaction allows bank administrator to modify a user.	Yes
Activate User	This transaction allows bank administrator to activate a user.	Yes
Deactivate User	This transaction allows bank administrator to deactivate a user.	Yes
Lock User	This transaction allows bank administrator to Lock a user.	Yes
Unlock User	This transaction allows bank administrator to Unlock a locked user.	Yes
Delete User	This transaction allows bank administrator to Delete a user.	Yes
Revoke User	This transaction allows bank administrator to Revoke a deleted user.	Yes
View User	This transaction allows bank administrator to view user details.	Yes
Reset password	This transaction allows bank administrator to reset pass­word for a user.	Yes
Customer Pro­file - Initiate	This function allows bank administrator to create a cus­tomer profile.	Yes
Modify Cus­tomer Profile	This function allows bank administrator to modify a cus­tomer profile.	Yes
Customer Account Setup	This function allows bank administrator to map accounts to a customer.	Yes
Linked Cus­tomer Account Setup	This function allows bank administrator to link two accounts and map the accounts of the linked cus­tomer.	Yes
User Account Setup	This function allows bank administrator to map accounts to a user	Yes
View Customer Profile	This function allows bank administrator to view a cus­tomer profile.	Yes
Disable / Enable Customer Profile	This function allows bank administrator to lock / Unlock a customer profile.	Yes
Maintain User Lists	This function allows bank administrator to maintain list of the user within a customer based on the roles and responsibilities.	Yes
Manage Rules	This function allows bank administrator to setup authori­sation mandates..	Yes
Transaction Activities	This function allows bank administrator to view and authorise the transactions done by the administrators.	Yes
Transaction Sta­tus Change	This function allows bank administrator to update the transactions which has not reached final stage of cycle.	Yes
Request Pro­cessing	Bank administrator shall able to process this service request and Release Transactions for which release is configured. This will be controlled through he Business Process Flow Engine (BPFE)	Yes
Manage Policies	This transaction allows bank administrator to maintain poli­cies for User ID and Pass­words	Yes
View Audit Log	This function allows bank administrator to view audit logs of different users.	Yes
Transaction Cut Off	This function allows the bank administrator to maintain working window for different transactions	Yes
Deal Timer and Cut Off	This transaction allows bank administrator to set deal tim­ers for currency pairs	Yes
Transaction Black Out	This function allows the bank administrator to maintain blackouts for different transac­tions	Yes
Global Limits Package	This function allows the bank administrator to maintain limit packages	Yes
Transaction Password Con­figuration	This transaction allows the bank administrator to config­ure the transactions which shall require transaction pass­word	Yes
Role Subject mapping	This transaction allows the bank administrator to map the subject defined for the pur­pose of mail messaging with the roles. Only those adminis­trators get the mail who are having access to the relevant role	Yes
Calendar Main­tenance	This transaction allows the bank administrator to setup calendar i.e. marking weekly holiday and other holidays. This transaction is also used for set up of Currency holi­days. This is applicable for third party implementations where host does not provide the working business days.	Yes
Mail Box	This function allows bank administrator to view and reply for various communication done by business user using FCDB internal messaging facility	Yes
Preferences	This function allows user to set different preferences for accessing FCDB application	Yes
Change Pass­word	This transaction allows bank administrator to change their own password.	Yes
Session Sum­mary	This function displays activity details of the user done in last ‘N’ Sessions.	Yes
Site Map	This function displays all the transactions available to the user and allows the user to understand the sitemap	Yes
Maintain Bulle­tins	This function allows the bank administrator to add and view bulletins	Yes
Alerts Registra­tion	This function allows the bank administrator to register a user for various alerts. Alerts are generated and based on spe­cific event and send to the user. User shall be able to register for both FCDB and Host spe­cific alerts. Registration data is main­tained in FCDB	Yes
Register Reports	This transaction allows the bank administrator to register the reports for both bank administrators as well as busi­ness users for download / view at a later stage.	Yes
Map Reports To User	This transaction allows the bank administrator to assign reports to business user
User Manual Downloads	This function allows the bank administrator to manage forms and user manuals for down­loads	Yes
View Reports	This transaction allows the bank administrator to register the reports for both bank administrators as well as busi­ness users for download / view at a later stage.	Yes
Manage Timer Services	This function allows bank administrator to set/change timer services. This is system maintenance transaction and any unexpected change may impact processing of FCDB Application partially/com­pletely.	Yes
Manage Applica­tion Messages	This function allows bank administrator to change appli­cation messages.	Yes
Configuration Properties	This function allows bank administrator to set/change configuration properties. This is system maintenance trans­action and any unexpected change may impact process­ing of FCDB Application par­tially/completely.	Yes
View System Log	This function allows bank administrator to view system logs.	Yes
Host Interface Log	This function allows bank administrator to view host interface logs	Yes
Entity Manage­ment	This transaction allows a bank administrator to configure a new entity	Yes
Advance Search	This transaction allows a Help­Desk user to search the busi­ness user. The click on the user starts the session for selected user and helpdesk user is able to view transac­tions of the business user.	Yes
Session Man­agement - Wrap session, Create Session	This transaction allows a Help­Desk user to end session of a selected user. The click on the wrap up ends the session of existing business user and helpdesk user can start a new session for any other business user.	Yes
Reminders	Transaction allows Business user to register for personal reminders. These reminders shall be saved / registered at central repository at the Host/third party provider	No	Interactions
Mailbox - Con­versations	Transaction allows all interac­tion to be maintained in a cen­tral repository. Interaction includes all communication between the business user and bank users like customer services, additional services, grievances etc	No	Interactions
Mailbox - Alerts	Transaction allows all interac­tion to be maintained in a cen­tral repository. Interaction includes all communication between the business user and bank users like customer services, additional services, grievances etc	No	Interactions
Mailbox - Tasks	Transaction allows all interac­tion to be maintained in a cen­tral repository. Interaction includes all communication between the business user and bank users like customer services, additional services, grievances etc	No	Interactions
Mailbox - Attach­ment	Facility to enable users to attach files to the mail being sent. This enhancement is available across the Internet, Mobile and Tablet banking channels	No	Interactions
Account Details	This function displays the account details like Account Holder details, Product details, Account Parameters, Account Balances, details of unclear funds of selected CASA account.	No	CASA, Islamic CASA
Dashboard Widget Manage­ment	Business users will be pro­vided with a new transaction through which, the business user shall be able to enable or disable widgets to be dis­played on their dashboard screens of each channel to which they have access, sepa­rately	No
Account Sum­mary	This function displays the summarized view of the accounts held by the cus­tomer.	No	CASA, Islamic CASA, Retail Term Deposit, Islamic Term Deposits, Con­sumer Lending, Loans, Islamic finance & Depos­its Module.
Account Details	This function displays the account details like Account Holder details, Product details, Account Parameters, Account Balances, details of unclear funds of selected CASA account.	No	CASA, Islamic CASA
Account Activity	This function displays the account activity for specified search criteria for selected CASA Account. The account activity can be downloaded in MT940, PDF, CSV, OFX and QIF format.	No	CASA, Islamic CASA
Account State­ment Inquiry	This function displays the gen­erated account statement for the selected account. Account statement is to be generated by Oracle FLEXCUBE Univer­sal Banking as per the account statement scheduling parame­ter.	No	CASA, Islamic CASA, Loans, Islamic finance
Account Over­view	This function displays the summarized Asset, Liability view of the balances, grouped under different Currencies of the accounts held by the cus­tomer.	No	CASA, Islamic CASA, Retail Term Deposit, Islamic Term Deposits, Con­sumer Lending, Loans, Islamic finance & Corpo­rate Deposit Modules
Consolidated Position	This function displays the summarized Asset, Liability of different type of relationships like CASA, TD, Loans, Securi­ties, Shares, Options and trade instruments of the mapped customers. The func­tion also provide graphical representation of asset and liabilities.	No	CASA, Islamic CASA, Retail Term Deposit, Islamic Term Deposits, Con­sumer Lending, Loans, Islamic finance & Corpo­rate Deposits Module. Trade Finance
CASA Interest Rate Inquiry	This function displays the interest rate for Savings prod­ucts.	No
Register Biller	This function allows user to register the Billers maintained in Oracle FLEXCUBE Univer­sal Banking Module	No	Qualification not required - FCDB transaction
Delete Biller	This function allows user to delete the biller registered ear­lier Biller details are maintained in FCDB and deletion of a biller is also within FCDB	No
Pay Bills	This function allows user to pay the bills to registered bill­ers.	No	Utility Payments (UP)
Bulk Data Dic­tionary	This function allows bank administrator to create compo­nents of bulk file template.	Yes
Bulk Enrichment Definition	This function allows bank administrator to create compo­nents of bulk file template.	Yes
Bulk Template Definition	This function allows bank administrator to create bulk template. Definition	Yes
Bulk File Tem­plate Definition	This function allows bank administrator to create bulk file template.	Yes
File Control Defi­nition	This function allows bank administrator to create compo­nents of bulk file template.	Yes
Bulk Registration	This function allows bank administrator to register BTID	Yes
User BTID Map	This function allows bank administrator to map /unmap a BTID to a user	Yes
Update File Sta­tus	This function allows bank administrator to update status of a bulk file which is to be pro­cessed by a third party appli­cation.	Yes
Ad-hoc State­ment Request - Loans	This function generates account statement request for Loans and Islamic Finance account for a specified period.	No	Loans and Islamic Loans
Transaction Activities	This function allows user to: View Initiated Transactions View Authorized Transactions View / Use Drafts & Templates	No
Register for MT940 Account Statements	This function allows the user to register for the accounts for which they wish to view MT 940 account statement. The account is registered in FCDB only. The same account need to be registered in Host for getting MT940 statement.	No
View MT940 Statements	This function allows user to view the MT 940 statement received by him. The registra­tions for viewing statement shall be done in the FCDB.	No	SWIFT
Exchange Rate Inquiry	This function displays exchange rate between cur­rency pairs.	No	FOREX
Alerts Registra­tion	This function allows the users to register for various alerts. Alerts are generated and based on specific event and send to the user. User shall be able to register for both FCDB and Host spe­cific alerts. Registration data is main­tained in FCDB	No
E-Statement Subscription	This function allows user to subscribe/unsubscribe for e-statement The registrations details are maintained at FCUBS and the statement. FCUBS generates and sends the statement as per registra­tion details.	No	CASA, Islamic CASA, Term Deposits, Islamic Deposits, Loans, Islamic Loans
Subscribe for other channels	This function allows user to Subscribe for other available channel from Internet banking login. Registration details are main­tained in FCDB	No
Deactivate Channel User	This function allows user to deactivate a channel tempo­rarily for a predefined time period Details are maintained in FCDB	No
Lock Transac­tion Password	This function allows user to lock their own transaction password. Allows the user to lock the transaction pass­word, if user do not wish to authorise the transaction	No
Change Limits	This function allows user to change the existing limits allot­ted by the bank.	No
Reissue Trans­action Password	This function allows user to send a request issuing trans­action password. These transactions have to be processed offline and adminis­trator needs to update the sta­tus of the request	No
Request Pro­cessing	This function allows business users to release the transac­tion after re-verification post final authorisation. This trans­action can also be used to tank a transaction temporarily within FCDB, if required.	No
Open Additional CASA Account	This function allows user to open a new CASA account by debiting existing CASA account.	No	CASA, Islamic CASA
Register Reports	This transaction allows the user to register and schedule various reports for download / view at a later stage. Registration data is main­tained in FCDB and gets inte­grated with Oracle BI Publisher	No
Account Closure	This function allows user to send a request for closing an account. These transactions have to be processed offline and adminis­trator needs to update the sta­tus of the request.	No
Download Reports	This transaction allows the user to download / view a report generated as per the registrations. Registration data is main­tained in FCDB & integration with Oracle BI Publisher	No
Preferences	This function allows user to set different preferences for accessing FCDB application User preference data is main­tained in FCDB	No
Account Prefer­ence	This function allows user to set different preferences for accessing FCDB application User preference data is main­tained in FCDB	No
Session Sum­mary	This function displays activity details of business user done in last ‘N’ Sessions.	No
Mail Box	This function allows business user interact with bank admin­istrator user using FCDB inter­nal messaging facility	No
Electronic Form	This function allows user to write a query to the bank for a particular transaction using e-mail messaging. Predefined queries are displayed to the user based on the transaction type	No
Form & User Manual Down­loads	This function allows user to download the documents like User Manuals, application forms to be downloaded from common location shared over the Bank Internet Site. The Files to be downloaded are maintained in FCDB infra­structure. NO interface with host system is expected	No
Force Change Password	This transaction forces the user to change the password as per password policy defined	No
Site Map	This function displays all the transactions available to the user and allows the user to understand the sitemap	No
Frequently Asked Questions	This function displays Fre­quently Asked Questions (FAQ) and their answers. A link to the FAQs prepared by the bank is provided	No
News	This function displays latest news and events for bank. A link to the news prepared by the bank is provided	No
ATM Locator	This function displays list of the ATMs the bank have. A link to the ATM locator pre­pared by the bank is provided	No
Branch Locator	This function displays list of the branches the bank have. A link to the Branch locator pre­pared by the bank is provided	No
Ad-hoc State­ment Request - CASA & TD	This function generates account statement request for CASA and term Deposit account for a specified period.	No	CASA, Islamic CASA, Retail Term Deposits
Stop and Unblock Cheque Request	This function allows user to block a cheque payment or revoke the stop payment instruction issued earlier.	No	CASA, Islamic CASA
Cheque Status Inquiry	This function displays the cheques status.	No	CASA, Islamic CASA
Cheque Book Request	This function allows user to request a chequebook.	No	CASA, Islamic CASA
Term Deposit Details	This function displays details of the selected Term Deposit Account. If deposit is created using a Structured deposit scheme, additional details of the scheme are displayed.	No	Retail Term Deposits, Structured Funds/Deposits
Term Deposit Activity	This function displays transac­tion happened in the Term deposit account for specified search criteria. The activity can be downloaded in PDF, CSV format.	No	Retail Term Deposits, Structured Funds/Deposits
Open Term Deposit (Con­ventional)	This function allows user to open new Term Deposit Account. The new accounts can be opened with Single or Joint ownership.	No	Retail Term Deposits
Amend Term Deposit (Con­ventional)	This function allows user to amend the maturity and inter­est instructions of existing Term deposit Account	No	Retail Term Deposits
Redeem Term Deposit (Con­ventional)	This function allows user to redeem an existing term deposit.	No	Retail Term Deposits
Structured Deposit Sub­scription	This function allows user to subscribe for Structured Term Deposit schemes opened for subscription by bank.	No	Structured Funds/Deposits
View Subscrip­tion Status	This function displays the structured Term deposit sub­scription status like whether Subscription amount is blocked, Term deposit is cre­ated etc.	No	Structured Funds/Deposits
Contract Deposit Details	This function displays the summary and details of Term deposit accounts/ contracts held by user.	No	Corporate Deposits
Open Contract Deposit	This function allows user to open new Term deposit Account/Contract.	No	Corporate Deposits
Open Term Deposit (Islamic)	This function allows user to open new Term Deposit Account. The new accounts can be opened with Single or Joint ownership.	No	Retail Term Deposits
Amend Term Deposit (Islamic)	This function allows user to amend the maturity and inter­est instructions of existing Term deposit Account	No	Retail Term Deposits
Redeem Term Deposit (Islamic)	This function allows user to redeem an existing term deposit.	No	Retail Term Deposits
Source Benefi­ciary Linkage	This transaction allows bank administrator to map a debit (beneficiary) account for a source account. This mapping is used for fixed domestic funds transfer by business user. As per this requirement a source can be mapped with only one beneficiary account.	Yes
Global Benefi­ciary Mapping	This transaction allows the bank administrator to map restricted beneficiaries to busi­ness users.	Yes
SEPA Card Pay­ments	This function allows user to payment using a credit card through SEPA network	No
Demand Draft	This function allows user to request for a domestic Draft or pay order	No	Demand Draft
View Demand Draft	This function allows viewing all the domestic and international demand drafts and paying orders issues to a customer.	No	Demand Draft
Stop Payment of Demand Draft	"This function allows a stop payment request for a domes­tic demand drafts issued ear­lier. These transactions have to be processed offline and adminis­trator needs to update the sta­tus of the request	No	Demand Draft
Internal Remit­tance	This function allows user to ini­tiate transfer between accounts of different entity	No
View Standing Instructions	This function displays Stand­ing Instructions configured in the host banking system.	No
Cancel Standing Instructions	This function allows user to cancel Standing Instructions configured in the host banking system.	No
Domestic Collec­tion Inquiry	This function displays status of the domestic cheques send for collection.	No	Collections
FCY Collection Inquiry	This function displays status of the International cheques send for collection.	No	Collections
Beneficiary Maintenance	This function allows user to register for beneficiaries for later reuse for following pay­ments transactions. Internal Transfer Domestic Demand Draft /Pay Order IMT101 Transfer request Internal Remittance For internal funds transfer - Beneficiary details are verified with the Host. The Beneficiary data is main­tained in FCDB	No
View Limits Utili­zation	This function allows user to view the limits allocated to them and their current utilisa­tion	No
Change Limits	This function allows user to change the existing limits allot­ted by the bank	No
Global Benefi­ciary Mainte­nance	This transaction allows the bank administrator to Create, modify and delete Generic and restricted beneficiaries. The transaction also allows the bank administrator to delete public and private beneficiar­ies by the business users.	Yes
Setup Account Structure	This function allows setup Notional Pooling or Sweep Instructions by creating Cash management account struc­ture.	No	Integrated Liquidity Man­agement
Modify Account Structure	This function allows to Modify Notional Pooling or Sweep Account Structure	No	Integrated Liquidity Man­agement
View Account Structures	This function allows to Delete Notional Pooling or Sweep Instructions.	No	Integrated Liquidity Man­agement
Create Parent and Group Link­age	This function allows creating a Cash Management instruction group and mapping the cash management instructions	No	Integrated Liquidity Man­agement
Unmark account as Parent	This function allows to Delete Parent account linkage from the Group.	No	Integrated Liquidity Man­agement
Assignment Enquiry	This function displays the list of Invoices which are assigned by the seller	No
Credit Limit Enquiry	This displays the details of the Credit Limits provided to differ­ent Buyers by the Seller’s Bank	No
Financing Enquiry	This displays the list of Invoices which are financed by the bank under various Factor­ing products.	No
Invoice Enquiry	This displays the list of Invoices presented to the bank by the Seller	No
Repayment Enquiry	This displays the list of Invoices which are financed by the bank under various Factor­ing products	No
Initiate Deal Booking	This function allows user to book a Spot or Forward deal for Buying or Selling Currency.	No	FOREX
View deals	This function allows user to view the deals booked earlier.	No	FOREX
Deals in Cross Currency Trans­actions	This function allows user to book a Spot or Forward deal for Buying or Selling Currency.	No	FOREX
Loan Details	This function displays the details of the selected loan account like loan product details, disbursed amount, outstanding balance details	No	Consumer Lend­ing
Loan Schedule	This function displays repay­ment schedule of selected loan account. The repayment schedule contains the instal­ment components like princi­pal, interest, charges and outstanding instalment amount.	No	Consumer Lend­ing
Loan Repayment Inquiry	This function displays various repayments received for the selected loan account.	No	Consumer Lend­ing
Loan Settlement	This function allows partial or full pre payment of the selected loan account	No	Consumer Lend­ing
Loan Account Activity	This function displays the transactions happened through selected loan account. The transaction activity can be downloaded in PDF, CSV.	No	Consumer Lend­ing
Loan Interest Rates Inquiry	This function displays interest rates for various loan prod­ucts.	No	Consumer Lend­ing
Loan Calculator	This function displays sched­ule for a loan amount for select interest	No	Consumer Lend­ing
Mortgage Calcu­lator	This function displays sched­ule for a loan under Mortgage for select interest	No	Mortgage Loans
Financing Details	This function displays the details of the selected Islamic finance account like product details, disbursed amount, outstanding balance details	No	Consumer Lend­ing – Islamic (CI)
Financing Schedule	This function displays repay­ment schedule of selected Islamic finance account. The repayment schedule contains the instalment components like principal, profit percent­age, charges and outstanding instalment amount.	No	Consumer Lend­ing – Islamic (CI)
Financing Repayment Inquiry	This function displays various repayments received for the selected Islamic finance account.	No	Consumer Lend­ing – Islamic (CI)
Financing Settle­ment	This function allows partial or full pre payment of the selected Islamic finance account	No	Consumer Lend­ing – Islamic (CI)
Financing Account Activity	This function displays the transactions happened through selected Islamic finance account. The transac­tion activity can be down­loaded in PDF, CSV.	No	Consumer Lend­ing – Islamic (CI)
Financing Profit Rates Inquiry	This function displays interest rates for various Islamic finance products.	No	Consumer Lend­ing – Islamic (CI)
Payment Notifi­cation Inquiry	This Inquiry function allows the Seller to View the “Value dated Payment” details done by the Buyer	No
Purchase Order Assignment	This Inquiry function allows the Seller to Assign the “Pur­chase Order” details uploaded by the Buyer. The Seller selects the Purchase Order to be assigned and the details are e-mailed to the pre-speci­fied e-mail ids of the Bank User/s.	No
Draw Down Inquiry	This Inquiry function allows the Seller to specify the Draw­down Amount required for Financing from the bank. The Drawdown details are e-mailed to the pre-notified e-mail ids of the Bank User/s.	No
Stock Agent Transaction Inquiry	This function allows user to view investors’ transaction over the accounts	No
Investor's Account Inquiry	This function allows user view account balance details of his investors	No
Investor's Account Open­ing Inquiry	This function allows user view account opening status of his investors.	No
Initiate Letters of Credit	This function allows user to ini­tiate issuance of Letter of Credit	No	Letter of Credit
Amend Letters of Credit	This function allows user to ini­tiate amendment to Letter Of Credit	No	Letter of Credit
View Import Let­ters of Credit	This function displays the Import Letter of Credits.	No	Letter of Credit
View Export Let­ters of Credit	This function displays export letter of credit.	No	Letter of Credit
Attach Docu­ments	This function allows user to attach the trade related docu­ments. The attached documents are maintained in the FCDB data­base and a FCDB administra­tive user can view the documents	No
View Attached Documents	This function allows user to view the attached trade related documents. The attached documents are maintained in the FCDB data­base and a business user can view the documents.	Yes
View Import Bills	This function displays Import Bills for collections.	No	Bills and Collec­tions
View Export Bills	This function displays Export Bills for collections	No	Bills and Collec­tions
Direct Collection Initiation	This function allows user to ini­tiate Direct collection of the bills.	No	Bills and Collec­tions
Export Collec­tion Initiation	This function allows user to ini­tiate Export collection of the bills.	No	Bills and Collec­tions
Export Bill Col­lection (Under LC)	This function allows user to ini­tiate Export collection of the bills under a LC.	No	Bills and Collec­tions
Initiate Bank Guarantee	This function allows user to ini­tiate the Bank Guarantee Application.	No	Letter of Credit
Outward Guar­antee Amend­ment	This function allows user to amend a existing Bank Guar­antee Application.	No	Letter of Credit
View Outward Guarantee	This function displays Bank Guarantees.	No	Letter of Credit
Customer Acceptance for Export LC amendments	This function allows user to acceptance of the amend­ments and discrepancies.	No	Letter of Credit
Customer Acceptance for Bills Discrepancy	This function allows user to acceptance of the amend­ments and discrepancies.	No
Look Up Mainte­nance	This function allows user to maintain basic look-ups related to trade. These look-ups maintained can later be used by the users while initiat­ing respective transactions The look-up data is maintained in FCDB database	No
Line Limits	This function displays the vari­ous limit lines available for customer in the user	No	Extended Limits and Collateral Management
Trade - View Documents	This function allows the bank administrator to view docu­ments attached by business users under various trade transactions	Yes
Trade - Attach Documents	This function allows the bank administrator to attach docu­ments on behalf of business users under various trade transactions	Yes
Account Sum­mary	This function displays the summarized view of the accounts held by the cus­tomer.	No	CASA, Islamic CASA, Retail Term Deposit, Islamic Term Deposits, Con­sumer Lending (CL), Islamic finance & Corpo­rate Deposits Module.
Account Activity	This function displays the account activity for specified search criteria for selected CASA Account. The account activity can be downloaded in MT940, PDF, CSV, OFX and QIF format.	No	CASA, Islamic CASA
Account State­ment Inquiry	This function displays the gen­erated account statement for the selected account. Account statement is to be generated by Oracle FLEXCUBE Univer­sal Banking as per the account statement scheduling parame­ter.	No	CASA, Islamic CASA, Con­sumer Lending (CL), Islamic finance
CASA Interest Rate Inquiry	This function displays the interest rate for Savings prod­ucts.	No
Spend Analysis	Transaction allows display in a graphical format, of the spend analysis of a customer across various accounts held with the bank for a default period. Such a default period should be configurable at a system level	No	Interactions
FCPB - SSO and Dashboard	Allows business user to view investment details from Oracle FLEXCUBE Private Wealth management and also pro­vide single sign on facility to users to access FCPB	No
Dashboard Widget Manage­ment	Business users will be pro­vided with a new transaction through which, the business user shall be able to enable or disable widgets to be dis­played on their dashboard screens of each channel to which they have access, sepa­rately	No
Register Biller	This function allows user to register the Billers maintained in Oracle FLEXCUBE Univer­sal Banking Module	No	Utility Payments (UP)
Delete Biller	This function allows user to delete the biller registered ear­lier Biller details are maintained in FCDB and deletion of a biller is also within FCDB	No
Pay Bills	This function allows user to pay the bills to registered bill­ers.	No	Utility Payments (UP)
Bulk Data Dic­tionary	This function allows bank administrator to create compo­nents of bulk file template.	Yes
Bulk Enrichment Definition	This function allows bank administrator to create compo­nents of bulk file template.	Yes
Bulk Template Definition	This function allows bank administrator to create bulk template definition.	Yes
Bulk File Tem­plate Definition	This function allows bank administrator to create bulk file template.	Yes
File Control Defi­nition	This function allows bank administrator to create compo­nents of bulk file template.	Yes
Bulk Registration	This function allows bank administrator to register BTID	Yes
User BTID Map	This function allows bank administrator to map /unmap a BTID to a user	Yes
Update File Sta­tus	This function allows bank administrator to update status of a bulk file which is to be pro­cessed by a third party appli­cation.	Yes
Change Limits	This function allows user to change the existing limits allot­ted by the bank.	No
Ad-hoc State­ment Request - Loans	This function generates account statement request for Loans and Islamic Finance account for a specified period.	No
Transaction Activities	This function allows user to: View Initiated Transactions View /Use Drafts & Templates	No
Register for MT940 Account Statements	This function allows the user to register for the accounts for which they wish to view MT 940 account statement. The account is registered in FCDB only. The same account need to be registered in Host for getting MT940 statement.	No
View MT940 Statements	This function allows user to view the MT 940 statement received by him. The registra­tions for viewing statement shall be done in the FCDB.	No	SWIFT
Exchange Rate Inquiry	This function displays exchange rate between cur­rency pairs.	No	FOREX
Alerts Registra­tion	This function allows the users to register for various alerts. Alerts are generated and based on specific event and send to the user. User shall be able to register for both FCDB and Host spe­cific alerts. Registration data is main­tained in FCDB	No
E-Statement Subscription	This function allows user to subscribe/unsubscribe for e-statement The registrations details are maintained at FCUBS and the statement. FCUBS generates and sends the statement as per registra­tion details.	No	CASA, Islamic CASA, Term Deposits, Islamic Deposits, Loans, Islamic Loans
Subscribe for other channels	This function allows user to Subscribe for other available channel from Internet banking login Registration details are main­tained in FCDB	No
Deactivate Channel User	This function allows user to deactivate a channel tempo­rarily for a predefined time period Details are maintained in FCDB	No
Lock Transac­tion Password	This function allows user to lock their own transaction password. Allows the user to lock the transaction pass­word, if user do not wish to authorise the transaction	No
Reissue Trans­action Password	This function allows user to send a request issuing trans­action password. These transactions have to be processed offline and adminis­trator needs to update the sta­tus of the request	No
Activate Debit Card	This function allows user to send a request to activate the debit card. These transactions have to be processed offline and adminis­trator needs to update the sta­tus of the request.	No
Apply for ATM / Debit Card	This function allows user to send a request for ATM/Debit Card issuance. These transactions have to be processed offline and adminis­trator needs to update the sta­tus of the request.	No
Reset ATM - Debit Card PIN	This function allows user to send a request for changing the ATM/Debit Card Pin change. These transactions have to be processed offline and adminis­trator needs to update the sta­tus of the request.	No
Hotlist Debit card	This function allows user to send a request to host-list a debit card. These transactions have to be processed offline and adminis­trator needs to update the sta­tus of the request.	No
Account Closure	This function allows user to send a request for closing an account. These transactions have to be processed offline and adminis­trator needs to update the sta­tus of the request.	No
Request Pro­cessing	This function allows business users to release the transac­tion after re-verification post final authorisation. This trans­action can also be used to tank a transaction temporarily within FCDB, if required.	No
Register Reports	This transaction allows the user to register and schedule various reports for download / view at a later stage. Registration data is main­tained in FCDB and gets inte­grated with Oracle BI Publisher	No
Download Reports	This transaction allows the user to download / view a report generated as per the registrations. Registration data is main­tained in FCDB & integration with Oracle BI Publisher	No
Preferences	This function allows user to set different preferences for accessing FCDB application User preference data is main­tained in FCDB	No
Account Prefer­ence	This function allows user to set different preferences for accessing FCDB application User preference data is main­tained in FCDB	No
Session Sum­mary	This function displays activity details of business user done in last ‘N’ Sessions.	No
Mail Box	This function allows business user interact with bank admin­istrator user using FCDB inter­nal messaging facility	No
Electronic Form	This function allows user to write a query to the bank for a particular transaction using e-mail messaging. Predefined queries are displayed to the user based on the transaction type	No
Form & User Manual Down­loads	This function allows user to download the documents like User Manuals, application forms to be downloaded from common location shared over the Bank Internet Site. The Files to be downloaded are maintained in FCDB infra­structure. NO interface with host system is expected	No
Change Pass­word	This transaction allows the user to change the password as per password policy defined	No
Force Change Password	This transaction forces the user to change the password as per password policy defined	No
Site Map	This function displays all the transactions available to the user and allows the user to understand the sitemap	No
Frequently Asked Questions	This function displays Fre­quently Asked Questions (FAQ) and their answers. A link to the FAQs prepared by the bank is provided	No
News	This function displays latest news and events for bank. A link to the news prepared by the bank is provided	No
ATM Locator	This function displays list of the ATMs the bank have. A link to the ATM locator pre­pared by the bank is provided	No
Branch Locator	This function displays list of the branches the bank have. A link to the Branch locator pre­pared by the bank is provided	No
Ad-hoc State­ment Request - CASA & TD	This function generates account statement request for CASA and term Deposit account for a specified period.	No	CASA, Islamic CASA, Retail Term Deposits
Stop and Unblock Cheque Request	This function allows user to block a cheque payment or revoke the stop payment instruction issued earlier.	No	CASA, Islamic CASA
Cheque Status Inquiry	This function displays the cheques status.	No	CASA, Islamic CASA
Cheque Book Request	This function allows user to request a chequebook.	No	CASA, Islamic CASA
Debit Card Details	This function displays debit card details	No	Generic Inter­faces
Open Additional CASA Account	This function allows user to open a new CASA account by debiting existing CASA account.	No	CASA, Islamic CASA
Online Cus­tomer and Account Open­ing	This function allows user to open an online CASA account and register for FCDB.	No	CASA, Islamic CASA
Reminders	Transaction allows Business user to register for personal reminders. These reminders shall be saved / registered at central repository at the Host/third party provider	No	Interactions
Mailbox - Con­versations	Transaction allows all interac­tion to be maintained in a cen­tral repository. Interaction includes all communication between the business user and bank users like customer services, additional services, grievances etc	No	Interactions
Mailbox - Alerts	Transaction allows all interac­tion to be maintained in a cen­tral repository. Interaction includes all communication between the business user and bank users like customer services, additional services, grievances etc	No	Interactions
Mailbox - Tasks	Transaction allows all interac­tion to be maintained in a cen­tral repository. Interaction includes all communication between the business user and bank users like customer services, additional services, grievances etc	No	Interactions
Mailbox - Attach­ment	Facility to enable users to attach files to the mail being sent. This enhancement is available across the Internet, Mobile and Tablet banking channels	No	Interactions
Term Deposit Details	This function displays details of the selected Term Deposit Account. If deposit is created using a Structured deposit scheme, additional details of the scheme are displayed.	No	Retail Term Deposits, Structured Funds/Deposits
Term Deposit Activity	This function displays transac­tion happened in the Term deposit account for specified search criteria. The activity can be downloaded in PDF, CSV format.	No	Retail Term Deposits, Structured Funds/Deposits
Open Term Deposit (Con­ventional)	This function allows user to open new Term Deposit Account. The new accounts can be opened with Single or Joint ownership.	No	Retail Term Deposits
Amend Term Deposit (Con­ventional)	This function allows user to amend the maturity and inter­est instructions of existing Term deposit Account	No	Retail Term Deposits
Redeem Term Deposit (Con­ventional)	This function allows user to redeem an existing term deposit.	No	Retail Term Deposits
Structured Deposit Sub­scription	This function allows user to subscribe for Structured Term Deposit schemes opened for subscription by bank.	No	Structured Funds/Deposits
View Subscrip­tion Status	This function displays the structured Term deposit sub­scription status like whether Subscription amount is blocked, Term deposit is cre­ated etc.	No	Structured Funds/Deposits
Contract Deposit Details	This function displays the summary and details of Term deposit accounts/ contracts held by user.	No	Corporate Deposits
Open Contract Deposit	This function allows user to open new Term deposit Account/Contract.	No	Corporate Deposits
Open Term Deposit (Islamic)	This function allows user to open new Term Deposit Account. The new accounts can be opened with Single or Joint ownership.	No	Retail Term Deposits
Amend Term Deposit (Islamic)	This function allows user to amend the maturity and inter­est instructions of existing Term deposit Account	No	Retail Term Deposits
Redeem Term Deposit (Islamic)	This function allows user to redeem an existing term deposit.	No	Retail Term Deposits
Global Benefi­ciary Mainte­nance	This transaction allows the bank administrator to Create, modify and delete Generic and restricted beneficiaries. The transaction also allows the bank administrator to delete public and private beneficiar­ies by the business users.	Yes
SEPA Card Pay­ments	This function allows user to payment using a credit card through SEPA network	No
Demand Draft	This function allows user to request for a domestic Draft or pay order	No	Demand Draft
View Demand Draft	This function allows viewing all the domestic demand drafts and paying orders issues to a customer.	No	Demand Draft
Stop Payment of Demand Draft	This function allows a stop payment request for a domes­tic demand drafts issued ear­lier. These transactions have to be processed offline and adminis­trator needs to update the sta­tus of the request	No	Demand Draft
View Standing Instructions	This function displays Stand­ing Instructions configured in the host banking system.	No
Cancel Standing Instructions	This function allows user to cancel Standing Instructions configured in the host banking system.	No
View Pending Transfers	This function allows user to view transactions which are schedule to be executed/ accounted on future date.	No
Cancel Pending Transfers	This function allows user to cancel transactions which are schedule to be executed/ accounted on future date.	No
Linked Account Setup	This function allows user to link an external account for funds Transfer using random deposit confirmation.	No	NA
Domestic Collec­tion Inquiry	This function displays status of the domestic cheques send for collection.	No	Collections
FCY Collection Inquiry	This function displays status of the International cheques send for collection.	No	Collections
Beneficiary Maintenance	"This function allows user to register for beneficiaries for later reuse for following pay­ments transactions. Internal Transfer Demand Draft SEPA Card Payments For internal funds transfer - Beneficiary details are verified with the Host. The Beneficiary data is main­tained in FCDB	No
View Limits Utili­zation	This function allows user to view the limits allocated to them and their current utilisa­tion	No
Change Limits	This function allows user to change the existing limits allot­ted by the bank	No
Global Benefi­ciary Mapping	This transaction allows the bank administrator to map restricted beneficiaries to busi­ness users.	Yes
Credit Card Summary	This function displays sum­mary of the Credit cards hold by the user	No
Credit Card Statement	This function displays the Credit Card Statement	No
Credit Card Details	This function displays details of the Credit cards hold by the user	No
Credit Card Pay­ments	This function allows the user to pay the credit card dues	No
Register Credit Card	This function allows the user to register for existing credit cards held by them for access­ing through FCDB	No
Modify Supple­mentary Card Limit	This function allows the user to modify the limit of the sup­plementary credit cards	No
Apply for Credit Card	This service request allows a user to request for a new credit card These transactions have to be processed offline and adminis­trator needs to update the sta­tus of the request	No
Credit Card Hot Listing	This service request allows a user to request for blocking a credit card. These transactions have to be processed offline and adminis­trator needs to update the sta­tus of the request	No
Change Credit Card Billing Cycle	This service request allows a user to request for change in billing cycle of credit card These transactions have to be processed offline and adminis­trator needs to update the sta­tus of the request	No
Change Credit Limit	This service request allows a user to request for change in Credit limit of a credit card. These transactions have to be processed offline and adminis­trator needs to update the sta­tus of the request	No
Register/ De reg­ister Auto Pay­ment	This service request allows a user to request for register / de-register for auto payment of a credit card. These transactions have to be processed offline and adminis­trator needs to update the sta­tus of the request	No
Credit Card ATM PIN Change	This service request allows a user to request for new ATM PIN for a credit card. These transactions have to be processed offline and adminis­trator needs to update the sta­tus of the request	No
Credit Card Replacement	This service request allows a user to request for replace­ment of a credit card. These transactions have to be processed offline and adminis­trator needs to update the sta­tus of the request	No
Deactivation of Credit Card	This service request allows a user to request for deactiva­tion of a credit card. These transactions have to be processed offline and adminis­trator needs to update the sta­tus of the request	No
Supplementary Card Request	This service request allows a user to request for a new sup­plementary credit card. These transactions have to be processed offline and adminis­trator needs to update the sta­tus of the request	No
Activate Credit Card	This service request allows a user to request for activation of a credit card. These transactions have to be processed offline and adminis­trator needs to update the sta­tus of the request	No
Merchant Main­tenance	This transaction allows bank administrator to register vari­ous merchant / vendor to whom online Funds transfer facility is to be provided Merchant information will be stored within the FCDB only & will not be sent to the host	Yes
Loan Details	This function displays the details of the selected loan account like loan product details, disbursed amount, outstanding balance details	No	Consumer Lend­ing
Loan Schedule	This function displays repay­ment schedule of selected loan account. The repayment schedule contains the instal­ment components like princi­pal, interest, charges and outstanding instalment amount.	No	Consumer Lend­ing
Loan Repayment Inquiry	This function displays various repayments received for the selected loan account.	No	Consumer Lend­ing
Loan Settlement	This function allows partial or full pre payment of the selected loan account	No	Consumer Lend­ing
Loan Account Activity	This function displays the transactions happened through selected loan account. The transaction activity can be downloaded in PDF, CSV.	No	Consumer Lend­ing
Loan Interest Rates Inquiry	This function displays interest rates for various loan prod­ucts.	No	Consumer Lend­ing
Loan Calculator	This function displays sched­ule for a loan amount for select interest	No	Consumer Lend­ing
Mortgage Calcu­lator	This function displays sched­ule for a loan under Mortgage for select interest	No	Mortgage Loans
Financing Details	This function displays the details of the selected Islamic finance account like product details, disbursed amount, outstanding balance details	No	Consumer Lend­ing – Islamic (CI)
Financing Schedule	This function displays repay­ment schedule of selected Islamic finance account. The repayment schedule contains the instalment components like principal, profit percent­age, charges and outstanding instalment amount.	No	Consumer Lend­ing – Islamic (CI)
Financing Repayment Inquiry	This function displays various repayments received for the selected Islamic finance account.	No	Consumer Lend­ing – Islamic (CI)
Financing Settle­ment	This function allows partial or full pre payment of the selected Islamic finance account	No	Consumer Lend­ing – Islamic (CI)
Financing Account Activity	This function displays the transactions happened through selected Islamic finance account. The transac­tion activity can be down­loaded in PDF, CSV.	No	Consumer Lend­ing – Islamic (CI)
Financing Profit Rates Inquiry	This function displays interest rates for various Islamic finance products.	No	Consumer Lend­ing – Islamic (CI)
Fund Statement Request	This function allows user to request statement for selected mutual funds for an adhoc period.	No
View Portfolio	This function displays Mutual fund portfolio group by the mutual fund schemes sub­scribed by user.	No
Fund Information	This function displays various mutual funds scheme details which are available for sub­scription	No
Buy Mutual Fund	This function allows user to buy the mutual fund units of a mutual fund scheme	No
Redeem Mutual Funds	This function allows user to redeem the mutual fund units of a mutual fund scheme	No
Switch Mutual Fund	This function allows user to buy the mutual fund units of a mutual fund scheme.	No
Order Status	This function displays order status for Mutual Funds trans­actions.	No
Fund Activity	This function displays transac­tion activity happened in selected fund.	No
Dividend Infor­mation	This function displays dividend information for a selected fund.	No
My Accounts	This function displays the summarized view of the accounts held by the cus­tomer.	No	CASA, Retail Term Deposit, Consumer Lend­ing, Loans & Deposits Module.
My Cheques	This function displays the cheques status.	No	CASA
Stop Cheque	This function allows user to block a cheque payment or revoke the stop payment instruction issued earlier.	No	CASA
Contract Deposit Details	This function displays the summary and details of Term deposit accounts/ contracts held by user.	No	Corporate Deposits
Loan Details	This function displays the details of the selected loan account like loan product details, disbursed amount, outstanding balance details	No	Consumer Lend­ing
Change Pass­word	This transaction allows the business user to change their password	No
Credit Card Details	This function displays details of the Credit cards hold by the user	No
Credit Card Statement	This function displays the Credit Card Statement	No
Account Details	This function displays the account details of selected CASA account.	No	CASA
Account Activity	This function displays the account activity for specified search criteria for selected CASA Account.	No	CASA
Ad-hoc State­ment Request - CASA & TD	This function generates account statement request for CASA account for a specified period.	No	CASA
Term Deposit Details	This function displays details of the selected Term Deposit Account.	No	Retail Term Deposits, Structured Funds/Deposits
Redeem Term Deposit (Con­ventional)	This function allows user to redeem an existing term deposit.	No	Retail Term Deposits
Delete Biller	This function allows user to delete the biller registered ear­lier Biller details are maintained in FCDB and deletion of a biller is also within FCDB	No
Cheque Book Request	This function allows user to request a chequebook.	No	CASA
Exchange Rate Inquiry	This function displays exchange rate between cur­rency pairs.	No	FOREX
Mail Box	This function allows business user interact with bank admin­istrator user using FCDB inter­nal messaging facility	No
Corporate Authorization	This function allows user to authorise a transaction initi­ated by another user of that customer	No
ATM / Branch Locator	This function allows user to loacte the nearest STM / Branch based on the current location of the yser..
Financing Details	This function allows user to view all the relevant details of the Islamic finance accounts.	No
Register Biller	This function allows user to register the Billers maintained in Oracle FLEXCUBE Univer­sal Banking Module	No	Utility Payments (UP)
Pay Bills	This function allows user to pay the bills to registered bill­ers.	No	Utility Payments (UP)
Buy Funds	This function allows user to buy the mutual fund units of a mutual fund scheme	No
Sell /Redeem Fund	This function allows user to redeem the mutual fund units of a mutual fund scheme	No
Switch Fund	This function allows user to buy the mutual fund units of a mutual fund scheme	No
View Fund Port­folio	This function displays Mutual fund portfolio group by the mutual fund schemes sub­scribed by user	No
Order Status	This function displays order status for Mutual Funds trans­actions.	No
Redeem Term Deposit (Islamic)	This function allows user to redeem an existing term deposit.	No	Retail Term Deposits
Prelogin Trans­actions	Provision to have non-author­ised transactions in mobile banking.	No
Mailbox - Attach­ment	Facility to enable users to attach files to the mail being sent. This enhancement is available across the Internet, Mobile and Tablet banking channels	No	Interactions
Credit Card Pay­ments	This function allows the user to pay the credit card dues	No
My Accounts	This function displays the summarized view of the accounts held by the cus­tomer.	No	CASA, Retail Term Deposit, Consumer Lend­ing, Loans & Deposits Module.
Financing Details	This function allows user to view all the relevant details of the Islamic finance accounts.	No
My Cheques	This function displays the cheques status.	No	CASA
Change Pass­word	This transaction allows the business user to change their password	No
Account Details	This function displays the account details of selected CASA account.	No	CASA
Account Activity	This function displays the account activity for specified search criteria for selected CASA Account.	No	CASA
Ad-hoc State­ment Request - CASA & TD	This function generates account statement request for CASA account for a specified period.	No	CASA
Term Deposit Details	This function displays details of the selected Term Deposit Account.	No	Retail Term Deposits, Structured Funds/Deposits
Redeem Term Deposit (Con­ventional)	This function allows user to redeem an existing term deposit.	No	Retail Term Deposits
Contract Deposit Details	This function displays the summary and details of Term deposit accounts/ contracts held by user.	No	Corporate Deposits
Loan Details	This function displays the details of the selected loan account like loan product details, disbursed amount, outstanding balance details	No	Consumer Lend­ing
Register Biller	This function allows user to register the Billers maintained in Oracle FLEXCUBE Univer­sal Banking Module	No	Utility Payments (UP)
Pay Bills	This function allows user to pay the bills to registered bill­ers.	No	Utility Payments (UP)
Delete Biller	This function allows user to delete the biller registered ear­lier Biller details are maintained in FCDB and deletion of a biller is also within FCDB	No
Cheque Book Request	This function allows user to request a chequebook.	No	CASA
Stop Cheque	This function allows user to block a cheque payment or revoke the stop payment instruction issued earlier.	No	CASA
Exchange Rate Inquiry	This function displays exchange rate between cur­rency pairs.	No	FOREX
Mail Box	This function allows business user interact with bank admin­istrator user using FCDB inter­nal messaging facility	No
Corporate Authorization	This function allows user to authorise a transaction initi­ated by another user of that customer	No
Credit Card Details	This function displays details of the Credit cards hold by the user	No
Credit Card Statement	This function displays the Credit Card Statement	No
Buy Fund	This function allows user to buy the mutual fund units of a mutual fund scheme	No
Sell /Redeem Fund	This function allows user to redeem the mutual fund units of a mutual fund scheme	No
Switch Fund	This function allows user to buy the mutual fund units of a mutual fund scheme	Yes
View Fund Port­folio	This function displays Mutual fund portfolio group by the mutual fund schemes sub­scribed by user	No
Order Status	This function displays order status for Mutual Funds trans­actions.	No
ATM / Branch Locator (iPhone Browser only)	This function allows the user of an iPhone to locate the nearest ATM/Branch based on the current location	No
Redeem Term Deposit (Islamic)	This function allows user to redeem an existing term deposit.	No	Retail Term Deposits
Prelogin Trans­actions	Provision to have non-author­ised transactions in mobile banking.	No
Mailbox -Attach­ment	Facility to enable users to attach files to the mail being sent. This enhancement is available across the Internet, Mobile and Tablet banking channels	No	Interactions
Mailbox -Attach­ment	Facility to enable users to attach files to the mail being sent. This enhancement is available across the Internet, Mobile and Tablet banking channels	No	Interactions
Credit Card Pay­ments	This function allows the user to pay the credit card dues	No
My Scheduled Transfers	With this transaction user shall be able to view both ‘Pending Transfers’ and ‘Standing Instructions’ set on the account for all transactions.	No
Credit Card Details	This function displays details of the Credit cards hold by the user	No
Credit Card Last N Trxns	This function displays the last N transactions for a Credit Card	No
Credit Card Hot listing	This function allows user to send a request for hot-listing a card and to issuance of new credit card. These transactions have to be processed offline and adminis­trator needs to update the sta­tus of the request	No
Register for SMS Banking	This transaction allows the user to register for SMS bank­ing	No
Deregister for SMS Banking	This transaction allows the user to de-register for SMS banking	No
Change default Account	This transaction allows the user to de-register for SMS banking	No
Account Sum­mary	This function displays the summarized view of the accounts held by the cus­tomer.	No	CASA, Retail Term Deposit, Consumer Lend­ing, Loans & Deposits Module.
Account Details	This function displays the account details of selected CASA account.	No	CASA
Last N Transac­tions	This function displays the Last N Transactions for a CASA account. ‘No of transactions is configured as day 0 activity.	No	CASA
Ad-hoc State­ment Request - CASA & TD	This function generates account statement request for CASA account for a specified period.	No	CASA
Term Deposit Summary	This transaction displays sum­marized view of all the term deposits available to the cus­tomer	No	Retail Term Deposits, Structured Funds/Deposits
Term Deposit Details	This function displays details of the selected Term Deposit Account.	Yes	Retail Term Deposits, Structured Funds/Deposits
Loan Details	This function displays the details of the selected loan account like loan product details, disbursed amount, outstanding balance details	No	Consumer Lend­ing
Register Biller	This function allows user to register the Billers maintained in Oracle FLEXCUBE Univer­sal Banking Module	No	Utility Payments (UP)
Pay Bills (Bill Payment)	This function allows user to pay the bills to registered bill­ers.	No	Utility Payments (UP)
Delete Biller	This function allows user to delete the biller registered ear­lier Biller details are maintained in FCDB and deletion of a biller is also within FCDB	No
Cheque Book Request	This function allows user to request a chequebook.	No	CASA
Cheque Status Inquiry	This function displays the cheques status.	No	CASA
Stop and Unblock Cheque Request	This function allows user to block a cheque payment or revoke the stop payment instruction issued earlier.	No	CASA
Exchange Rate Inquiry	This function displays exchange rate between cur­rency pairs.	No	FOREX
Change PIN	This transaction allows the business user to change their password	No
Corporate Authorization	This function allows user to authorise a transaction initi­ated by another user of that customer	No
SMS Help on Message For­mats	This function allows user to seek help for message for­mats used to send request using SMS banking SMS help is local to FCDB	No

6.1.2 Additional Interfaces

Following are the additional transactions supported by Oracle FCUBS - Oracle FCDB Integration.

Transaction Name	Interface Name	Request Id	Interface Description	Operation Name
Peer to Peer Payment	Hold or Block	RRPPP03	This interface is used to block a given amount if the beneficiary is not registered.	CreateAmtBlk
Peer to Peer Payment	Reverse Amount	Working through a timer.	While initiating the pay­ment, if the transaction amount was credited to GL and beneficiary fails to register in a given period then this interface is used to reverse the credited amount to the customer's account.
Peer to Peer Payment	Release Hold (If ben­eficiary doesn't reg­isters in given num­ber of days.)	Working through a timer.	While initiating the pay­ment, if the transaction amount was blocked and the beneficiary fails to register in a given period then this interface is used to unblock the held amount.
Peer to Peer Payment	Unsubscribe Beneficiary	RRUPB02	For unsubscribe peer beneficiary.	ClosePTPBen
Peer to Peer Payment	Modify Peer Beneficiary	P2P_MOD­IFY_BENE	Business user can mod­ify beneficiary account details. Admin can mod­ify email and mobile number.	ModifyPTP­Ben
Peer to Peer Payment	P2P Benefi­ciary details	P2P_BENE_DETAIL	Check whether given email id exists at the UBS end. If yes Fire reo­pens Bene else create Bene.
Peer to Peer Payment	P2P create Bene	P2P_CRE­ATE_BENE	Create Bene	CreatePTP­Ben
Peer to Peer Payment	P2P Reo­pen Bene	P2P_REO­PEN_BENE	Reopen Bene	ReopenPTP­Ben
Peer to Peer Payment	P2P DEBIT GL CREDIT BENE	P2P_DEB­IT_GL_­CREDIT_BENE	Debit GL & credit Bene (Receiver's Leg)	CreateAmtBlk
Account Opening	Origination (BPEL) initi­ate request	RRORG09	This helps to submit the request on BPEL Pro­cess	initiate
Account Opening	Origination (BPEL) for Query request	GETORI­GAPP	This helps to fetch whole application of BPEL	detailedquery
Account Opening	Origination (BPEL) for Final submit request	RRORG09	This helps to modify the BPEL request on par­ticular stage	complete
Account Opening	Leads Sub­mit	RRORG60, RRORG61, RRORG62, RRORG63, RRORG64, RRORG65	This helps to submit application to core bank­ing	CreateF­CDBLead
Account Opening	Leads Query	GETLEA­DAPP	This helps to fetch the whole lead application	QueryF­CDBLead
Account Opening	Leads Mod­ify(Offer Acceptance and Addi­tional Docu­ment)	RRORG122, RRORG123	This helps to modify the lead request	ModifyF­CDBLead
Account Opening	View for Existing Cus­tomer Docu­ment	RRORG32	This helps to identify the already loaded	NA
Redeem Term Deposit	TD Redemp­tion simula­tion.		Gets the redemption details for premature full redemption. It fetches penalties and charges and total redemption amount os of the date.
Open Term Deposit	Calculator for Term Deposit maturity amount.		Calculates the maturity amount for the TD.

6.1.3 Communication Channels

The communication between Oracle FCUBS and FCDB happens in two ways.

• In case of online transactions involving booking of a contract or account in Oracle FCUBS, the communication happens by way of XML interchange.
• In case of batch uploads for single debit-multiple credit, the communications happen via database views for inquiries and via database tables for batch uploads.

The XSDs provide the templates for validation of the XML files exchanged between the systems.

6.2 Maintenances

In order to enable the integration between FCUBS and FCDB, you need to do certain maintenances in FCUBS.

This section contains the following topics:

• Section 6.2.1, "Maintaining External Systems"
• Section 6.2.2, "Maintaining Queues"

6.2.1 Maintaining External Systems

You need to define FCDB as an external system in order to enable communication between FCDB and Oracle FLEXCUBE Integration Gateway. You can define external system details using the 'External System Maintenance' screen. To invoke this screen, type 'GWDEXSYS' in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

Specify the following details:

External System

Specify a name for the external system. This should be the same as the source in an incoming message. For this integration, you need to specify FCDB.

Description

Specify a brief description of the external system.

For further details on defining external system, refer to the chapter ‘External System Maintenance’ of Gateway user manual.

6.2.2 Maintaining Queues

Incoming messages are routed through a messaging queue. You need to maintain the different user queues to which incoming messages will be directed. Users with appropriate privileges are allowed to access a particular queue.

To invoke the 'Message Queue Maintenance' screen, type 'MSDQUEUE' in the field at the top right corner of the application tool bar and click the adjoining arrow button.

Specify the following details:

Queue

Specify a unique name to identify the queue uniquely throughout the system.

For Oracle FCUBS - Oracle FCDB integration, you need to maintain the following queues.

Queue Name	Purpose
MDB_QUEUE_REQUEST	Online transaction request
MDB_QUEUE_RESPONSE	Online transaction response
NOTIFY_DEST_QUEUE_FCDB	Notification from Oracle FCUBS

Description

Specify a brief description of the queue.

Collection Queue

Check this box to indicate that the queue that you are maintaining is a collection queue.

Message Code

Specify the codes of various messages that will be routed to this queue.

Once you have specified the above details, save the maintenance.

6.3 Processing Messages

Oracle FLEXCUBE Direct Banking gets the details of transactions and operations from the database views of Oracle FLEXCUBE Universal Banking.

The details of such transactions and the related database views and XSDs in Oracle FLEXCUBE Universal Banking are detailed under the following headings. The details are organized based on the Oracle FCDB modules.

For further information on each transaction and the related module in Oracle FCUBS, refer to the section ‘Introduction’ in this chapter.

This section contains the following topics:

• Section 6.3.1, "Oracle FLEXCUBE Direct Banking Base (Core)"
• Section 6.3.2, "Oracle FLEXCUBE Direct Banking Corporate (Customer Services)"
• Section 6.3.3, "FLEXCUBE Direct Banking Corporate (Transfer and Payments)"
• Section 6.3.4, "FLEXCUBE Direct Banking Corporate (Account Inquiries)"
• Section 6.3.5, "FLEXCUBE Direct Banking Corporate (Bill Payments)"
• Section 6.3.6, "FLEXCUBE Direct Banking Corporate (Bulk Payments)"
• Section 6.3.7, "FLEXCUBE Direct Banking Corporate (Term Deposits)"
• Section 6.3.8, "Oracle FLEXCUBE Direct Banking Corporate Cash Management (Cash Management)"
• Section 6.3.9, "Oracle FLEXCUBE Direct Banking Corporate Factoring (E-Factoring)"
• Section 6.3.10, "FLEXCUBE Direct Banking Corporate Foreign Exchange (Foreign Exchange)"
• Section 6.3.11, "Oracle FLEXCUBE Direct Banking Corporate Loans (Loans)"
• Section 6.3.12, "Oracle FLEXCUBE Direct Banking Corporate Supply Chain Financing (Supply Chain)"
• Section 6.3.13, "Oracle FLEXCUBE Direct Banking Corporate Trade Finance (Trade Finance)"
• Section 6.3.14, "Oracle FLEXCUBE Direct Banking Retail (Customer Services)"
• Section 6.3.15, "Oracle FLEXCUBE Direct Banking Retail (Bill Payments)"
• Section 6.3.16, "Oracle FLEXCUBE Direct Banking Retail (Bulk Payments)"
• Section 6.3.17, "Oracle FLEXCUBE Direct Banking Retail (Account Inquiries)"
• Section 6.3.18, "Oracle FLEXCUBE Direct Banking Retail (Transfer and Payments)"
• Section 6.3.19, "Oracle FLEXCUBE Direct Banking Retail Credit Cards (Credit Cards)"
• Section 6.3.20, "Oracle FLEXCUBE Direct Banking Retail External Payment Interface (External Payment Interface)"
• Section 6.3.21, "Oracle FLEXCUBE Direct Banking Retail Loans (Loans)"
• Section 6.3.22, "Oracle FLEXCUBE Direct Banking Retail Mutual Funds (Mutual Funds)"
• Section 6.3.23, "Oracle FLEXCUBE Direct Banking Originations (Originations)"
• Section 6.3.24, "Oracle FLEXCUBE Direct Banking Retail/Corporate (Term Deposits)"

6.3.1 Oracle FLEXCUBE Direct Banking Base (Core)

The transactions and the respective database view/XSD are as follows:

Transaction Group	Transaction Name	Database Views	XSD names
Core Corporate Administrator	Account Setup
User Maintenance	SSO for Channels
System Mainte­nance	Multilingual Data Input
System Mainte­nance	Monitor Timer Ser­vices
Customer Mainte­nance	View Customer Transactions
Core Corporate Administrator	Customer Profile
Core Corporate Administrator	Authorisation Man­dates ( Maintain User List, Manage Rules)
Core Corporate Administrator	Bulk Registration
Core Corporate Administrator	User BTID Map
Core Corporate Administrator	View Audit Log
User Maintenance	Terminate User Session
User Maintenance	Print Welcome Let­ter / Password
Virtual Banking	Customer Account Opening Manage­ment
Core Corporate Administrator	Role maintenance
Core Corporate Administrator	User maintenance
Role Maintenance	Create Role
Role Maintenance	Modify Role
Role Maintenance	Delete Role
Role Maintenance	View Role
User Maintenance	Create User	fcat_vw_mstcorpo­rate
User Maintenance	Modify User	fcat_vw_mstcorpo­rate
User Maintenance	Activate User
User Maintenance	Deactivate User
User Maintenance	Lock User
User Maintenance	Unlock User
User Maintenance	Delete User
User Maintenance	Revoke User
User Maintenance	View User
User Maintenance	Reset password
Customer Mainte­nance	Customer Profile - Initiate	fcat_vw_mstcorpo­rate
Customer Mainte­nance	Modify Customer Profile	fcat_vw_mstcorpo­rate
Customer Mainte­nance	Customer Account Setup	fcc_vw_mstaccount
Customer Mainte­nance	Linked Customer Account Setup	fcc_vw_mstaccount
Customer Mainte­nance	User Account Setup
Customer Mainte­nance	View Customer Pro­file
Customer Mainte­nance	Disable / Enable Customer Profile
Authorization Mandates	Maintain User Lists
Authorization Mandates	Manage Rules
Transaction Activi­ties	Transaction Activi­ties
Transaction Dash­board	Transaction Status Change
Transaction Dash­board	Request Processing
Core Mainte­nances	Manage Policies
Core Mainte­nances	View Audit Log
Core Mainte­nances	Transaction Cut Off
Core Mainte­nances	Deal Timer and Cut Off
Core Mainte­nances	Transaction Black Out
Core Mainte­nances	Global Limits Pack­age
Core Mainte­nances	Transaction Pass­word Configuration
Core Mainte­nances	Role Subject map­ping
Core Mainte­nances	Calendar Mainte­nance
Core Services	Mail Box
Core Services	Preferences
Core Services	Change Password
Core Services	Session Summary
Core Services	Site Map
Core Services	Maintain Bulletins
Core Services	Alerts Registration	fcat_vw_mstcorpo­rate, fcc_vw_mstac­count
Core Services	Register Reports
Core Services	Map Reports To User
Core Services	User Manual Down­loads
Core Services	View Reports
System Mainte­nance	Manage Timer Ser­vices
System Mainte­nance	Manage Application Messages
System Mainte­nance	Configuration Prop­erties
System Mainte­nance	View System Log
System Mainte­nance	Host Interface Log
System Mainte­nance	Entity Management
Help Desk User	Advance Search
Help Desk User	Session Manage­ment - Wrap ses­sion, Create Session

6.3.2 Oracle FLEXCUBE Direct Banking Corporate (Customer Services)

The transactions and the respective database view/XSD are as follows:

Transaction Group	Transaction Name	Database Views	XSD names
Customer Services	Reminders
Customer Services	Mailbox - Conversa­tions
Customer Services	Mailbox - Alerts
Customer Services	Mailbox- Tasks
Customer Services	Mailbox- Attachment
Customer Services - Accounts	Ad-hoc Statement Request - Loans
Customer Services	Transaction Activities
Customer Services	Register for MT940 Account Statements	fcc_vw_pctb_con­tract_master
Customer Services	View MT940 State­ments	fcat_vw_swift_bic_­directory, fcc_vw_d­ly_msgs_in_940
Customer Services	Exchange Rate Inquiry	fcc_vw_mstfxrate
Customer Services	Alerts Registration	fcat_vw_mstcorpo­rate, fcc_vw_mstac­count
Customer Services	E-Statement Sub­scription	fcc_vw_acct_estate­ment_details, fcc_vw_loanacct_estmnt_details	MS-ModifyMSAccAdd-Req-Full-MSG.xsd MS-CreateMSAccAdd-Req-Full-MSG.xsd IA-ModifyIACustAcc-Req-Full-MSG.xsd ST-ModifyCustAcc-Req-Full-MSG.xsd
Customer Services	Subscribe for other channels
Customer Services	Deactivate Channel User
Customer Services	Lock Transaction Password
Customer Services	Change Limits
Customer Services	Reissue Transaction Password
Customer Services	Request Processing
Customer Services - Accounts	Open Additional CASA Account	fcat_vw_mst­branch, fcc_vw_m­stproductclasses, fcc_sttms_accls_c­cy_balances, fcc_st­vw_aclass_currencies	ST-CreateCustAcc-Req-Full-MSG.xsd
Customer Services	Register Reports	fcat_vw_mstcorpo­rate
Customer Services	Account Closure
Customer Services	Download Reports
Customer Services	Preferences
Customer Services	Account Preference
Customer Services	Session Summary
Customer Services	Mail Box
Customer Services	Electronic Form
Customer Services	Form & User Manual Downloads
Customer Services	Force Change Pass­word
Customer Services	Site Map
Customer Services	Frequently Asked Questions
Customer Services	News
Customer Services	ATM Locator
Customer Services	Branch Locator
Customer Services - Accounts	Ad-hoc Statement Request - CASA & TD		AccStmt-Adhoc-Query-Req-MSG.xsd, TDStmt-Adhoc-Query-Req-MSG.xsd
Customer Services - Accounts	Stop and Unblock Cheque Request		CA-StopPaymentsNew-Req-Full-MSG.XSD, CA-CreateStopPay­ments-Req-Full-MSG.xsd
Customer Services - Accounts	Cheque Status Inquiry	fcc_vw_cheque_sta­tus_inquiry fcc_vw_cavw_ch­ck_details fcc_vw_cat­m_stop_payments
Customer Services - Accounts	Cheque Book Request	fcc_vw_mstcorpo­rate	CA-CreateCheckBook-Req-Full-MSG.xsd

6.3.3 FLEXCUBE Direct Banking Corporate (Transfer and Payments)

The transactions and the respective database view/XSD are as follows:

Transaction Group	Transaction Name	Database Views	XSD names
Transfer and Payments -Main­tenance	Source Beneficiary Linkage	mstsourcebene­linkage
Core Services	Global Beneficiary Mapping	Qualification not required - FCDB transaction - Admin
Transfer and Payments	Demand Draft		DDTransaction-Create-Req-Full-MSG.xsd
Transfer and Payments	View Demand Draft	fcc_vw_istm_in­str_txn fcc_vw_con­tract_master
Transfer and Payments	Stop Payment of Demand Draft	fcc_vw_istm_in­str_txn fcc_vw_con­tract_master
Transfer and Payments	Internal Remittance
Transfer and Payments	View Standing Instructions	fcc_vw_stand­ing_instr_details
Transfer and Payments	Cancel Standing Instructions	fcc_vw_stand­ing_instr_details	SIContract-Close-Req-Full-MSG.xsd
Transfer and Payments	View Pending Transfers	fcc_vw_pending­transfer
Transfer and Payments -Col­lection and Remittance	Inward Remittance Inquiry	fcc_vw_in­ward_remmitance
Transfer and Payments -Col­lection and Remittance	Outward Remit­tance Inquiry	fcc_vw_out­ward_remmitance
Transfer and Payments -Col­lection and Remittance	Domestic Collec­tion Inquiry	fcc_vw_fcy_collec­tion_inq
Transfer and Payments -Col­lection and Remittance	FCY Collection Inquiry	fcc_vw_fcy_collec­tion_inq
Transfer and Payments -Main­tenance	Beneficiary Mainte­nance	fcc_vw_mstac­count fcc_vw_sttb_ac­count
Transfer and Payments -Main­tenance	View Limits Utiliza­tion
Transfer and Payments -Main­tenance	Change Limits
Core Services	Global Beneficiary Maintenance

6.3.4 FLEXCUBE Direct Banking Corporate (Account Inquiries)

The transactions and the respective database view/XSD are as follows:

Transaction Group	Transaction Name	Database Views	XSD names
Accounts	Account Details	fcat_vw_accountde­tails, fcc_vw_mstac­count
Accounts	Dashboard Widget Manage­ment
Overall View	Account Sum­mary	fcat_vw_mstaccount
Accounts	Account Details	fcat_vw_accountde­tails, fcc_vw_mstac­count
Accounts	Account Activity	fcat_vw_txnaccountac­tivity, fcat_vw_accountde­tails, fcc_vw_mstaccount, fcc_vw_actb_vd_bal
Accounts	Account State­ment Inquiry	fcat_vw_acct_stmt_­summary fcat_vw_acct_stmt_de­tails fcc_vw_loan_stmt_­summary
Overall View	Account Overview	fcc_vw_stt­ms_cust_account, fcc_vw_sttms_ac­count_class, fcc_vw_cltbs_ac­count_master, fcc_vw_cltbs_ac­count_schedules, fcc_vw_clproduct, fcc_vw_txntdcontracts, fcat_vw_mstldproduct
Overall View	Consolidated Position	fcc_vw_stt­ms_cust_account, fcc_vw_claccount, fcc_vw_cloutstanding­bal, fcc_vw_longop­tions, fcc_vw_lcvw_­cont_prod_summary, fcc_vw_lcvw_avail­ments, fcc_vw_bcvw_­contract_summary, fcc_vw_shortoptions, fcc_vw_assetsportfolio
Accounts	CASA Interest Rate Inquiry

6.3.5 FLEXCUBE Direct Banking Corporate (Bill Payments)

The transactions and the respective database view/XSD are as follows:

Transaction Group	Transaction Name	Database Views	XSD names
Bill Payments	Register Biller	fcc_vw_biller_info
Bill Payments	Delete Biller
Bill Payments	Pay Bills		Utility-Payment-Create-Req-Full-MSG.xsd

6.3.6 FLEXCUBE Direct Banking Corporate (Bulk Payments)

The transactions and the respective database view/XSD are as follows:

Transaction Group	Transaction Name	Database Views	XSD names
Bulk Mainte­nance	Bulk Data Diction­ary
Bulk Mainte­nance	Bulk Enrichment Definition
Bulk Mainte­nance	Bulk Template Definition
Bulk Mainte­nance	Bulk File Template Definition
Bulk Mainte­nance	File Control Defi­nition
Bulk Mainte­nance	Bulk Registration
Bulk Mainte­nance	User BTID Map
Bulk Mainte­nance	Update File Status
Bulk Transac­tions	Bulk File View
Bulk Transac­tions	Bulk Authorisa­tions

6.3.7 FLEXCUBE Direct Banking Corporate (Term Deposits)

The transactions and the respective database view/XSD are as follows:

Transaction Group	Transaction Name	Database Views	XSD names
Term Deposits	Term Deposit Details	fcc_vw_msttddetails fcc_vw_mst_std_de­tails
Term Deposits	Term Deposit Activity	fcat_vw_txnaccoun­tactivity, fcat_vw_accountde­tails fcc_vw_mstaccount fcc_vw_actb_vd_bal
Term Deposits	Open Term Deposit (Conven­tional)	fcc_vw_mstproduct­classes	ST-CreateTDCustAcc-Req-Full-MSG.xsd
Term Deposits	Amend Term Deposit (Conven­tional)	fcc_vw_msttddetails fcc_vw_ictm_tdpay­out_details fcc_vw_ictm_tdpay­in_details fcc_vw_mst_std_de­tails	ST-ModifyTDCustAcc-Req-Full-MSG.xsd
Term Deposits	Redeem Term Deposit (Conven­tional)	fcc_vw_msttddetails fcc_vw_ictm_tdpay­out_details fcc_vw_ictm_tdpay­in_details fcc_vw_mst_std_de­tails	IC-CreateTDRedem-Req-Full-MSG.xsd
Structured Term Deposits	Structured Deposit Subscrip­tion	fcc_vw_sd_scheme_­details	SF-CreateSFSub-Req-Full-MSG.xsd
Structured Term Deposits	View Subscrip­tion Status	fcc_vw_sft­m_cust_subscription
Contract Deposit	Contract Deposit Details	fcat_vw_mstldprod­uct, fcat_vw_mstld­productdetails, fcc_vw_cytm_ccy_­defn, fcc_vw_cst­m_prod_ccy_disallow, fcat_vw_tenureinter­estdtls, fcat_vw_mst­branch, fcc_vw_cstm_product fcat_vw_mstinterest­comp, fcat_vw_maturityin­structions
Contract Deposit	Open Contract Deposit		LDContract-Master-Req-Full-MSG.xsd
Term Deposits	Open Term Deposit (Islamic)	fcc_vw_mstproduct­classes	IA-CreateIATD­CustAcc-Req-Full-MSG.xsd
Term Deposits	Amend Term Deposit (Islamic)	fcc_vw_msttddetails fcc_vw_ictm_tdpay­out_details fcc_vw_ictm_tdpay­in_details fcc_vw_mst_std_de­tails	IA-ModifyIATD­CustAcc-Req-Full-MSG.xsd
Term Deposits	Redeem Term Deposit (Islamic)	fcc_vw_msttddetails fcc_vw_ictm_tdpay­out_details fcc_vw_ictm_tdpay­in_details fcc_vw_mst_std_de­tails	IA-CreateRedemption-Req-Full-MSG.xsd

6.3.8 Oracle FLEXCUBE Direct Banking Corporate Cash Management (Cash Management)

The transactions and the respective database view/XSD are as follows:

Transaction Group	Transaction Name	Database Views	XSD names
Cash Man­agement	Setup Account Structure		IL-CreateILSweep-Req-Full-MSG.xsd
Cash Man­agement	Modify Account Struc­ture		IL-ModifyILSweep-Req-Full-MSG.xsd
Cash Man­agement	View Account Structures	cc_vw_iltm_account
Cash Man­agement	Create Parent and Group Linkage	fcc_vw_iltm_group_ac­count_link, fcc_vw_iltm_group_code,	ILGroup IL-CreateIL­Group-Req-Full-MSG.xsd
Cash Man­agement	Unmark account as Parent		IL-DeleteILGroup-Req-Full-MSG.xsd

6.3.9 Oracle FLEXCUBE Direct Banking Corporate Factoring (E-Factoring)

The transactions and the respective database view/XSD are as follows:

Transaction Group	Transaction Name	Database Views	XSD names
E-Factoring	Assignment Enquiry
E-Factoring	Credit Limit Enquiry
E-Factoring	Financing Enquiry
E-Factoring	Invoice Enquiry
E-Factoring	Repayment Enquiry

6.3.10 FLEXCUBE Direct Banking Corporate Foreign Exchange (Foreign Ex­change)

The transactions and the respective database view/XSD are as follows:

Transaction Group	Transaction Name	Database Views	XSD names
Foreign Exchange	Initiate Deal Book­ing		FXContract-Create-Req-Full-MSG.xsd
Foreign Exchange	View deals	fcc_vw_fxdeal_de­tails
Foreign Exchange	Deals in Cross Currency Transac­tions		FXContract-Create-Req-Full-MSG.xsd

6.3.11 Oracle FLEXCUBE Direct Banking Corporate Loans (Loans)

The transactions and the respective database view/XSD are as follows:

Transaction Group	Transaction Name	Database Views	XSD names
Loans	Loan Details	fcc_vw_clfrequency, cc_vw_claccount, fcc_vw_cloutstanding­bal, fcc_vw_clprinperyear, fcc_vw_clinterest, fcc_vw_clinstallment, fcc_vw_clarrearamt fcc_vw_clliq, FCC_VW_CLInstall­mentPaidUnpaid, fcc_vw_cltb_acct_ad­v_payment, fcc_vw_clt­b_amount_paid
Loans	Loan Schedule	fcc_vw_clschedule fcc_vw_claccount, FCC_vw_CLInstall­mentPaidUnpaid,
Loans	Loan Repayment Inquiry	fcc_vw_claccount, FCC_vw_clliqcomp­settled, fcc_vw_clliq, fcc_vw_cloutstanding­bal FCC_vw_CLInstall­mentPaidUnpaid
Loans	Loan Settlement	fcc_vw_clfrequency, fcc_vw_clac­count,fcc_vw_clout­standingbal, fcc_vw_clprinper­year,fcc_vw_clintper­year, fcc_vw_clinter­est,fcc_vw_clinstall­ment, fcc_vw_clarrear­amt,fcc_vw_clliq, FCC_VW_CLInstall­mentPaidUnpaid, fcc_vw_cltb_acct_ad­v_payment, fcc_vw_clt­b_amount_paid,
Loans	Loan Account Activity	fcc_vw_claccount fcc_vw_cltxnaccoun­tactivity
Loans	Loan Interest Rates Inquiry	fcc_vw_clloanrates
Loans	Loan Calculator		CL-Save-AccSim-Req-Full-Msg.xsd,
Loans	Mortgage Calcu­lator		MO-Save-AccSim-Req-Full-Msg.xsd,
Islamic Financing	Financing Details	fcc_vw_clfrequency, fcc_vw_claccount, fcc_vw_cloutstanding­bal, fcc_vw_clprinperyear, fcc_vw_clintperyear, fcc_vw_clinterest, fcc_vw_clinstallment, fcc_vw_clarrearamt, fcc_vw_clliq, FCC_VW_CLInstall­mentPaidUnpaid, fcc_vw_cltb_acct_ad­v_payment, fcc_vw_clt­b_amount_paid
Islamic Financing	Financing Sched­ule	fcc_vw_clschedule, fcc_vw_claccount, FCC_vw_CLInstall­mentPaidUnpaid
Islamic Financing	Financing Repay­ment Inquiry	fcc_vw_claccount, FCC_VW_clliqcomp­settled, fcc_vw_clliq, fcc_vw_cloutstanding­bal, FCC_vw_CLInstall­mentPaidUnpaid
Islamic Financing	Financing Settle­ment	fcc_vw_clfrequency, fcc_vw_claccount, fcc_vw_cloutstanding­bal, fcc_vw_clprinperyear, fcc_vw_clintperyear, fcc_vw_clinterest, fcc_vw_clinstallment, fcc_vw_clarrearamt, fcc_vw_clliq, FCC_VW_CLInstall­mentPaidUnpaid, fcc_vw_cltb_acct_ad­v_payment, fcc_vw_clt­b_amount_paid	CI-CreatePayment-Req-Full-MSG.xsd
Islamic Financing	Financing Account Activity	fcc_vw_cltxnaccoun­tactivity, fcc_vw_claccount
Islamic Financing	Financing Profit Rates Inquiry	fcc_vw_clloanrates

6.3.12 Oracle FLEXCUBE Direct Banking Corporate Supply Chain Financing (Supply Chain)

The transactions and the respective database view/XSD are as follows:

Transaction Group	Transaction Name	Database Views	XSD names
Supply Chain	Payment Notification Inquiry
Supply Chain	Purchase Order Assignment
Supply Chain	Draw Down Inquiry
Supply Chain	Stock Agent Transac­tion Inquiry
Supply Chain	Investor's Account Inquiry
Supply Chain	Investor's Account Opening Inquiry

6.3.13 Oracle FLEXCUBE Direct Banking Corporate Trade Finance (Trade Fi­nance)

The transactions and the respective database view/XSD are as follows:

Transaction Group	Transaction Name	Database Views	XSD names
Trade Finance	Initiate Letters of Credit	fcc_vw_L­CVWS_PRODUCT_­SUMMARY, fcc_vw_LCTBS_IN­CO_TERMS	LC-Contract-Create-Req-Full-MSG.xsd
Trade Finance	Amend Letters of Credit	fcc_vw_lcvw_­cont_prod_summary, fcc_vw_lcvw_avail­ments, fcc_lctb_amn­d_vals_master	LC-CreateAmend­Confirm-Req-Full-MSG.xsd,
Trade Finance	View Import Let­ters of Credit	fcc_vw_lcvw_­cont_prod_summary fcc_vw_lcvw_avail­ments fcc_vw_lcvw_con­tract_clauses fcc_vw_lcvw_docu­ments fcc_vw_lcvw_drafts fcc_vw_lcvw_parties fcc_vw_msvw_cust_address fcc_vw_lcvw_contract fcc_vw_bcvw_con­tract_summary fcc_lctb_amn­d_vals_master
Trade Finance	View Export Let­ters of Credit	fcc_vw_lcvw_­cont_prod_summary fcc_vw_lcvw_avail­ments fcc_vw_lcvw_con­tract_clauses fcc_vw_lcvw_docu­ments fcc_vw_lcvw_drafts fcc_vw_lcvw_parties fcc_vw_msvw_cust_address fcc_vw_lcvw_contract fcc_vw_bcvw_con­tract_summary fcc_vw_lcvw_amnd_­contract, fcc_lctb_amn­d_vals_master
Trade Finance	Attach Docu­ments
Trade Finance	View Attached Documents
Trade Finance	View Import Bills	fcc_vw_bcvw_con­tract_master fcc_vw_cfvw_charge_settlement fcc_vw_BCTBS_­CONTRACT_DISC fcc_vw_bcvw_con­tract_parties FCC_VW_BCTBS_­CONT_SHIP_INFO fcc_vw_bcvw_con­tract_docs fcc_vw_FCC_BCT­B_CON_MASTER fcc_vw_BCVW_CON­TRACT_SUMMARY, fcc_vw_lcvw_­cont_msgs
Trade Finance	View Export Bills	fcc_vw_bcvw_con­tract_master fcc_vw_cfvw_charge_settlement fcc_vw_bcvw_con­tract_parties FCC_VW_BCTBS_­CONT_SHIP_INFO fcc_vw_bcvw_con­tract_docs fcc_vw_BCTBS_­CONTRACT_DISC fcc_vw_FCC_BCT­B_CON_MASTER fcc_vw_BCVW_CON­TRACT_SUMMARY, fcc_vw_lcvw_­cont_msgs
Trade Finance -Collections	Direct Collection Initiation		BC-CreateContract-Req-Full-MSG.xsd
Trade Finance	Export Collection Initiation		BC-CreateContract-Req-Full-MSG.xsd
Trade Finance	Export Bill Collec­tion (Under LC)	fcc_vw_lcvw_­cont_prod_summary, fcc_vw_lcvw_avail­ments, fcc_lctb_amn­d_vals_master, fcc_vw_lcvw_con­tract_clauses, fcc_vw_lcvw_docu­ments, fcc_vw_lcvw_drafts, fcc_vw_lcvw_parties, fcc_vw_msvw_cust_address
fcc_vw_lcvw_con­tract,	BC-CreateCon­tract-Req-Full-MSG.xsd
Trade Finance	Initiate Bank Guarantee	fcc_vw_lctms_pro­duct_fft, fcc_vw_bctms_fft_master,	LC-Contract-Create-Req-Full-MSG.xsd
Trade Finance	Outward Guaran­tee Amendment	fcc_vw_lcvw_­cont_prod_summary, fcc_vw_lcvw_avail­ments, fcc_lctb_amn­d_vals_master, fcc_vw_lcvw_parties, fcc_vw_cfvw_charge_settlement, fcc_vw_lctbs_ffts, fcc_vw_MST­PRODUCTLCBG, fcc_vw_lctms_pro­duct_fft,fcc_vw_bctms_fft_master,	LC-CreateAmend­Confirm-Res-Full-MSG.xsd
Trade Finance	View Outward Guarantee	fcc_vw_lcvw_­cont_prod_summary fcc_vw_lcvw_avail­ments fcc_vw_lctms_pro­duct_fft fcc_vw_lcvw_parties fcc_vw_cfvw_charge_settlement fcc_vw_lctbs_ffts fcc_vw_MST­PRODUCTLCBG fcc_lctb_amn­d_vals_master
Trade Finance - Customer Accept­ance	Customer Accept­ance for Export LC amendments	fcc_vw_bcvw_con­tract_master, fcc_vw_bcvw_con­tract_parties, FCC_VW_BCTBS_­CONTRACT_DISC, fcc_vw_lcvw_amnd_­contract, fcc_vw_lcvw_­cont_prod_summary,	LC-ConfirmAmend­Confirm-Res-Full-MSG.xsd
Trade Finance - Customer Accept­ance	Customer Accept­ance for Bills Dis­crepancy
Trade Finance	Look Up Mainte­nance
Trade Finance	Line Limits	fcat_vw_mstliability fcc_vw_mstcorporate fcat_vw_mstlinelimits fcat_vw_txnlinedetail fcc_vw_getm_lia­b_cust
Core Services	Trade - View Doc­uments
Core Services	Trade - Attach Documents

6.3.14 Oracle FLEXCUBE Direct Banking Retail (Customer Services)

The transactions and the respective database view/XSD are as follows:

Transaction Group	Transaction Name	Database Views	XSD Names
Customer Ser­vices	Change Limits
Customer Ser­vices - Accounts	Ad-hoc State­ment Request - Loans
Customer Ser­vices	Transaction Activ­ities
Customer Ser­vices	Register for MT940 Account Statements
Customer Ser­vices	View MT940 Statements	fcat_vw_swift_bic_di­rectory fcc_vw_d­ly_msgs_in_940
Customer Ser­vices	Exchange Rate Inquiry	fcc_vw_mstfxrate
Customer Ser­vices	Alerts Registration	fcat_vw_mstcorpo­rate, fcc_vw_mstac­count
Customer Ser­vices	E-Statement Sub­scription	fcc_vw_acct_estate­ment_details, fcc_vw_loanacct_est­mnt_details	MS-ModifyMSAc­cAdd-Req-Full-MSG.xsd MS-CreateMSAc­cAdd-Req-Full-MSG.xsd IA-ModifyIACustAcc-Req-Full-MSG.xsd ST-ModifyCustAcc-Req-Full-MSG.xsd
Customer Ser­vices	Subscribe for other channels		MS-CreateMSAc­cAdd-Req-Full-MSG.xsd
Customer Ser­vices	Deactivate Chan­nel User		IA-ModifyIACustAcc-Req-Full-MSG.xsd
Customer Ser­vices	Lock Transaction Password		ST-ModifyCustAcc-Req-Full-MSG.xsd
Customer Ser­vices	Reissue Transac­tion Password
Customer Ser­vices	Activate Debit Card
Customer Ser­vices	Apply for ATM / Debit Card
Customer Ser­vices	Reset ATM - Debit Card PIN
Customer Ser­vices	Hotlist Debit card
Customer Ser­vices	Account Closure
Customer Ser­vices	Request Process­ing
Customer Ser­vices	Register Reports	fcat_vw_mstcorpo­rate
Customer Ser­vices	Download Reports
Customer Ser­vices	Preferences
Customer Ser­vices	Account Prefer­ence
Customer Ser­vices	Session Summary
Customer Ser­vices	Mail Box
Customer Ser­vices	Electronic Form
Customer Ser­vices	Form & User Man­ual Downloads
Customer Ser­vices	Change Pass­word
Customer Ser­vices	Force Change Password
Customer Ser­vices	Site Map
Customer Ser­vices	Frequently Asked Questions
Customer Ser­vices	News
Customer Ser­vices	ATM Locator
Customer Ser­vices	Branch Locator
Customer Ser­vices - Accounts	Ad-hoc State­ment Request - CASA & TD		AccStmt-Adhoc-Query-Req-MSG.xsd, TDStmt-Adhoc-Query-Req-MSG.xsd
Customer Ser­vices - Accounts	Stop and Unblock Cheque Request		CA-StopPayments­New-Req-Full-MSG.XSD, CA-CreateStopPay­ments-Req-Full-MSG.xsd
Customer Ser­vices - Accounts	Cheque Status Inquiry	fcc_vw_cheque_sta­tus_inquiry fcc_vw_cavw_chck_­details fcc_vw_cat­m_stop_payments
Customer Ser­vices - Accounts	Cheque Book Request	fcc_vw_mstcorporate	CA-CreateCheck­Book-Req-Full-MSG.xsd
Customer Ser­vices - Accounts	Debit Card Details	fcc_vw_mstbranch fcc_vw_sttm_debit_­card_master
Customer Ser­vices - Accounts	Open Additional CASA Account	fcat_vw_mstbranch, fcc_vw_mstproduct­classes, fcc_stt­ms_accls_ccy_balances, fcc_stvw_a­class_currencies	ST-CreateCustAcc-Req-Full-MSG.xsd
Customer Ser­vices - Virtual Banking	Online Customer and Account Opening	fcc_vw_sttms_linke­dacc_details	ST-CreateCustomer-Req-Full-MSG.xsd ST-CreateCustAcc-Req-Full-MSG.xsd ST-ModifyCustAcc-Req-Full-MSG.xsd ST-ModifyCustomer-Req-Full-MSG.xsd
Customer Ser­vices	Reminders
Customer Ser­vices	Mailbox - Conver­sations
Customer Ser­vices	Mailbox - Alerts
Customer Ser­vices	Mailbox- Tasks
Customer Ser­vices	Mailbox- Attach­ment

6.3.15 Oracle FLEXCUBE Direct Banking Retail (Bill Payments)

The transactions and the respective database view/XSD are as follows:

Transaction Group	Transaction Name	Database Views	XSD names
Bill Payments	Register Biller	fcc_vw_biller_info
Bill Payments	Delete Biller
Bill Payments	Pay Bills		Utility-Payment-Cre­ate-Req-Full-MSG.xsd

6.3.16 Oracle FLEXCUBE Direct Banking Retail (Bulk Payments)

The transactions and the respective database view/XSD are as follows:

Transaction Group	Transaction Name	Database Views	XSD names
Bulk Maintenance	Bulk Data Diction­ary
Bulk Maintenance	Bulk Enrichment Definition
Bulk Maintenance	Bulk Template Definition
Bulk Maintenance	Bulk File Template Definition
Bulk Maintenance	File Control Defi­nition
Bulk Maintenance	Bulk Registration
Bulk Maintenance	User BTID Map
Bulk Maintenance	Update File Status
Bulk Transactions	Bulk File View

6.3.17 Oracle FLEXCUBE Direct Banking Retail (Account Inquiries)

The transactions and the respective database view/XSD are as follows:

Transaction Group	Transaction Name	Database Views	XSD Names
UBS Alerts	Account Balance Noti­fication		CA-CustAcc-Bal-Notify-MSG.xsd
UBS Alerts	Account Status Change Notification		CA-CustAccStat-Notif.xsd
UBS Alerts	Clearing Reject Notifi­cation		CGReject-Notif-MSG.xsd
UBS Alerts	Stop Payment Notifica­tion		CGStoppayment-Notif-MSG.xsd
UBS Alerts	Term Deposit open		TD-NewAccount-Notify-MSG.xsd
UBS Alerts	Term Deposit Status change Notification
UBS Alerts	Utility Payment Trans­action Notification		UPTransaction-Notif-MSG.xsd
Customer Services - Accounts	Ad-hoc Statement Request - CASA & TD		AccStmt-Adhoc-Query-Req-MSG.xsd, TDStmt-Adhoc-Query-Req-MSG.xsd
Customer Services - Accounts	Stop and Unblock Cheque Request		CA-StopPaymentsNew-Req-Full-MSG.XSD, CA-CreateStopPayments-Req-Full-MSG.xsd
Customer Services	Mailbox - Attachment

6.3.18 Oracle FLEXCUBE Direct Banking Retail (Transfer and Payments)

The transactions and the respective database view/XSD are as follows:

Transaction Group	Transaction Name	Database Views	XSD names
Core Services	Global Beneficiary Maintenance	Qualification for Internal Account transfer. Other trans­action do not require the Host interface.
Transfer and Pay­ments	Own Account Transfers		SIContract-Create-Req-Full-MSG.xsd
Transfer and Pay­ments	Internal Transfers		SIContract-Create-Req-Full-MSG.xsd
Transfer and Pay­ments	Multiple Internal Transfer		SICon­tract-Create-Req-Full-MSG.xsd
Transfer and Pay­ments	Demand Draft		DDTransaction-Cre­ate-Req-Full-MSG.xsd
Transfer and Pay­ments	View Demand Draft	fcc_vw_istm_in­str_txn fcc_vw_con­tract_master
Transfer and Pay­ments	Stop Payment of Demand Draft	fcc_vw_istm_in­str_txn fcc_vw_con­tract_master
Transfer and Pay­ments	View Standing Instructions	fcc_vw_standing_in­str_details
Transfer and Pay­ments	Cancel Standing Instructions	fcc_vw_standing_in­str_details	SIContract-Close-Req-Full-MSG.xsd
Transfer and Pay­ments	View Pending Transfers	fcc_vw_pending­transfer
Virtual Banking	Linked Account Setup		ST-ModifyCustomer-Req-Full-MSG.xsd
Transfer and Pay­ments -Collection and Remittance	Inward Remittance Inquiry	fcc_vw_inward_rem­mitance
Transfer and Pay­ments -Collection and Remittance	Outward Remit­tance Inquiry	fcc_vw_out­ward_remmitance
Transfer and Pay­ments -Collection and Remittance	Domestic Collec­tion Inquiry	fcc_vw_fcy_collec­tion_inq
Transfer and Pay­ments -Collection and Remittance	FCY Collection Inquiry	fcc_vw_fcy_collec­tion_inq
Transfer and Pay­ments -Mainte­nance	Beneficiary Mainte­nance	fcc_vw_mstaccount fcc_vw_sttb_account
Transfer and Pay­ments -Mainte­nance	View Limits Utiliza­tion
Transfer and Pay­ments -Mainte­nance	Change Limits
Core Services	Global Beneficiary Mapping

6.3.18.1 Additional Transactions

The additional transactions supported by the integration under this module and the details of XSD and XSL files are given below.

Transaction - Peer to Peer Payment

Interface Name	View Names	Request XSD Name	Request Host Interface XSL	Response XSD Name	Response Host Interface XSL
Hold or Block		CA-Crea­teAmtBlk-Req-Full-MSG.xsd	con­firmP2PRequest.xsl	CA-Crea­teAmtBlk-Res-Full-MSG.xsd	con­firmP2PRe­sponse.xsl
Reverse Amount	fcc_vw_p2p_rever­seamt
Release Hold (If ben­eficiary doesn't reg­isters in given num­ber of days.)	fcc_p­cvws_p2p_amt_blk_­detail
P2P DEBIT GL CREDIT BENE	NA	CA-Crea­teAmtBlk-Req-Full-MSG.xsd	claimPay­ment­sP2PRequest.xsl	CA-Crea­teAmtBlk-Res-Full-MSG.xsd	claimPay­ment­sP2PResponse.xsl

6.3.19 Oracle FLEXCUBE Direct Banking Retail Credit Cards (Credit Cards)

The transactions and the respective database view/XSD are as follows:

Transaction Group	Transaction Name	Database Views	XSD names
Credit Cards	Credit Card Summary
Credit Cards	Credit Card Statement
Credit Cards	Credit Card Details
Credit Cards	Credit Card Payments
Credit Cards	Register Credit Card
Credit Cards	Modify Supplementary Card Limit
Credit Cards	Apply for Credit Card
Credit Cards	Credit Card Hot Listing
Credit Cards	Change Credit Card Bill­ing Cycle
Credit Cards	Change Credit Limit
Credit Cards	Register/ De register Auto Payment
Credit Cards	Credit Card ATM PIN Change
Credit Cards	Credit Card Replace­ment
Credit Cards	Deactivation of Credit Card
Credit Cards	Supplementary Card Request
Credit Cards	Activate Credit Card

6.3.20 Oracle FLEXCUBE Direct Banking Retail External Payment Interface (Ex­ternal Payment Interface)

The transactions and the respective database view/XSD are as follows:

Transaction Group	Transaction Name	Database Views	XSD names
External Payment Interface	Merchant Mainte­nance	fcc_vw_mstaccount fcc_vw_sttb_ac­count

6.3.21 Oracle FLEXCUBE Direct Banking Retail Loans (Loans)

The transactions and the respective database view/XSD are as follows:

Transaction Group	Transaction Name	Database Views	XSD names
Conventional Loans	Loan Details	fcc_vw_clfrequency, fcc_vw_claccount, fcc_vw_cloutstanding­bal, fcc_vw_clprinperyear, fcc_vw_clinterest, fcc_vw_clinstallment, fcc_vw_clarrearamt fcc_vw_clliq, FCC_VW_CLInstall­mentPaidUnpaid, fcc_vw_cltb_acct_ad­v_payment, fcc_vw_clt­b_amount_paid
Conventional Loans	Loan Schedule	fcc_vw_clschedule fcc_vw_claccount, FCC_vw_CLInstall­mentPaidUnpaid
Conventional Loans	Loan Repayment Inquiry	fcc_vw_claccount, FCC_vw_clliqcomp­settled, fcc_vw_clliq, fcc_vw_cloutstanding­bal FCC_vw_CLInstall­mentPaidUnpaid
Conventional Loans	Loan Settlement	fcc_vw_clfrequency, fcc_vw_clac­count,fcc_vw_clout­standingbal, fcc_vw_clprinper­year,fcc_vw_clintper­year, fcc_vw_clinter­est,fcc_vw_clinstall­ment, fcc_vw_clarrear­amt,fcc_vw_clliq, FCC_VW_CLInstall­mentPaidUnpaid, fcc_vw_cltb_acct_ad­v_payment, fcc_vw_clt­b_amount_paid,
Conventional Loans	Loan Account Activity	fcc_vw_claccount fcc_vw_cltxnaccoun­tactivity
Conventional Loans	Loan Interest Rates Inquiry	fcc_vw_clloanrates
Conventional Loans	Loan Calculator		CL-Save-AccSim-Req-Full-Msg.xsd,
Conventional Loans	Mortgage Calcu­lator		MO-Save-AccSim-Req-Full-Msg.xsd,
Islamic Financing	Financing Details	fcc_vw_clfrequency, fcc_vw_claccount, fcc_vw_cloutstanding­bal, fcc_vw_clprinperyear, fcc_vw_clintperyear, fcc_vw_clinterest, fcc_vw_clinstallment, fcc_vw_clarrearamt, fcc_vw_clliq, FCC_VW_CLInstall­mentPaidUnpaid, fcc_vw_cltb_acct_ad­v_payment, fcc_vw_clt­b_amount_paid
Islamic Financing	Financing Sched­ule	fcc_vw_clschedule, fcc_vw_claccount, FCC_vw_CLInstall­mentPaidUnpaid
Islamic Financing	Financing Repay­ment Inquiry	fcc_vw_claccount, FCC_VW_clliqcomp­settled, fcc_vw_clliq, fcc_vw_cloutstanding­bal, FCC_vw_CLInstall­mentPaidUnpaid
Islamic Financing	Financing Settle­ment	fcc_vw_clfrequency, fcc_vw_claccount, fcc_vw_cloutstanding­bal, fcc_vw_clprinperyear, fcc_vw_clintperyear, fcc_vw_clinterest, fcc_vw_clinstallment, fcc_vw_clarrearamt, fcc_vw_clliq, FCC_VW_CLInstall­mentPaidUnpaid, fcc_vw_cltb_acct_ad­v_payment,
fcc_vw_clt­b_amount_paid	CI-CreatePay­ment-Req-Full-MSG.xsd
Islamic Financing	Financing Account Activity	fcc_vw_cltxnaccoun­tactivity, fcc_vw_claccount
Islamic Financing	Financing Profit Rates Inquiry	fcc_vw_clloanrates

6.3.22 Oracle FLEXCUBE Direct Banking Retail Mutual Funds (Mutual Funds)

The transactions and the respective database view/XSD are as follows:

Transaction Group	Transaction Name	Database Views	XSD names
Mutual Funds	Fund Statement Request
Mutual Funds	View Portfolio
Mutual Funds	Fund Information
Mutual Funds	Buy Mutual Fund
Mutual Funds	Redeem Mutual Funds
Mutual Funds	Switch Mutual Fund
Mutual Funds	Order Status
Mutual Funds	Fund Activity
Mutual Funds	Dividend Information

6.3.23 Oracle FLEXCUBE Direct Banking Originations (Originations)

The transactions supported by the integration under this module and the details of XSD and XSL files are given below.

Transaction - Account Opening

Interface Name	View Name	Request XSD Name	Request Host Interface XSL	Response XSD Name	Response Host Interface XSL
Origination (BPEL) initi­ate request	NA	ST-CreateF­CDBSavings-Req-Full-MSG.xsd	OrigSaving­sAccountAp­plicationReq.xsl	ST-CreateF­CDBSav­ings-Res-Full-MSG.xsd	OrigSaving­sAccountAp­plicationRes.xsl
Origination (BPEL) for Query request	NA	ST-QueryF­CDBSavings-Req-IO-MSG.xsd	OrigSaving­sAccDetailed­QueryReq.xsl	ST-QueryF­CDBSav­ings-Res-IO-MSG.xsd	OrigSaving­sAccDe­tailedQueryRes.xsl
Origination (BPEL) for Final sub­mit request	NA	ST-ModifyF­CDBSavings-Req-Full-MSG.xsd	OrigSaving­sAccountAp­plicationReq.xsl	ST-ModifyF­CDBSav­ings-Res-Full-MSG.xsd	OrigSaving­sAccountAp­plicationRes.xsl
Leads Sub­mit	NA	CreateF­CDBLead_Req.xsd	CreateF­CDBLead­Req.xsl	CreateF­CDBLead_Res.xsd	CreateF­CDBLead­Res.xsl
Leads Query	NA	QueryF­CDBLead_Req.xsd	QueryF­CDBLead­Req.xsl	QueryF­CDBLead_Res.xsd	QueryF­CDBLead­Res.xsl
Leads Mod­ify(Offer Acceptance and Addi­tional Docu­ment)	NA	ModifyF­CDBLead_Req.xsd	ModifyF­CDBLead­Req.xsl	ModifyF­CDBLead­Res.xsl	ModifyF­CDBLead_Res.xsd
View for Existing Customer Document	fcc_vw_orig_exist_­docs	Tables used from UBS are as follows: 1) ORT­B_PROCESS_DOCS 2) ORTM_­CATEGORY_­MAINT

6.3.24 Oracle FLEXCUBE Direct Banking Retail/Corporate (Term Deposits)

Transaction Group	Transaction Name	Database Views	XSD names
Term Deposits	Term Deposit Details	fcc_vw_msttddetails fcc_vw_ictm_tdpay­out_details fcc_vw_ictm_tdpay­in_details fcc_vw_mst_std_de­tails
Term Deposits	Term Deposit Activ­ity	fcat_vw_txnaccoun­tactivity, fcat_vw_accountde­tails, fcc_vw_mstaccount, fcc_vw_actb_vd_bal
Term Deposits	Open Term Deposit (Conventional)	fcc_vw_mstproduct­classes	ST-CreateTD­CustAcc-Req-Full-MSG.xsd
Term Deposits	Amend Term Deposit (Conven­tional)	fcc_vw_msttddetails fcc_vw_ictm_tdpay­out_details fcc_vw_ictm_tdpay­in_details fcc_vw_mst_std_de­tails	ST-ModifyTD­CustAcc-Req-Full-MSG.xsd
Term Deposits	Redeem Term Deposit (Conven­tional)	fcc_vw_msttddetails fcc_vw_ictm_tdpay­out_details fcc_vw_ictm_tdpay­in_details fcc_vw_mst_std_de­tails	IC-CreateTDRe­dem-Req-Full-MSG.xsd
Structured Term Deposits	Structured Deposit Subscription	fcc_vw_s­d_scheme_details	SF-CreateSFSub-Req-Full-MSG.xsd
Structured Term Deposits	View Subscription Status	fcc_vw_sft­m_cust_subscription
Contract Deposit	Contract Deposit Details	fcat_vw_mstldprod­uct, fcat_vw_mstld­productdetails, fcc_vw_cytm_ccy_­defn, fcc_vw_cst­m_prod_ccy_disallow, fcat_vw_tenurein­terestdtls, fcat_vw_mstbranch, fcc_vw_cstm_prod­uct fcat_vw_mstinterest­comp, fcat_vw_maturityin­structions
Contract Deposit	Open Contract Deposit		LDContract-Mas­ter-Req-Full-MSG.xsd
Term Deposits	Open Term Deposit (Islamic)	fcc_vw_mstproduct­classes	IA-CreateIATD­CustAcc-Req-Full-MSG.xsd
Term Deposits	Amend Term Deposit (Islamic)	fcc_vw_msttddetails fcc_vw_ictm_tdpay­out_details fcc_vw_ictm_tdpay­in_details fcc_vw_mst_std_de­tails	IA-ModifyIATD­CustAcc-Req-Full-MSG.xsd
Term Deposits	Redeem Term Deposit (Islamic)	fcc_vw_msttddetails fcc_vw_ictm_tdpay­out_details fcc_vw_ictm_tdpay­in_details fcc_vw_mst_std_de­tails	IA-CreateRe­demption-Req-Full-MSG.xsd

Additional Interfaces

The transactions supported by the integration under this module and the details of XSD and XSL files are given below.

Transaction - Redeem Term Deposit

Interface Name	Request XSD Name	Request Host Interface XSL	Response XSD Name	Response Host Interface XSL
TD Redemp­tion simulation.	IC-CreateT­DRedem-Req-Full-MSG.xsd	RedeemTDMa­turityDtlReq.xsl	RedeemTDMa­turityDtlRes.xsl	IC-CreateT­DRedem-Res-Full-MSG.xsd

Transaction - Open Term Deposit

Interface Name	Request XSD Name	Request Host Interface XSL	Response XSD Name	Response Host Interface XSL
Calculator for Term Deposit maturity amount.	ST-CreateTD­CustAcc-Req-Full-MSG.xsd	CalculateTD­Maturit­yAmtReq.xsl	CalculateTD­Maturit­yAmtResp.xsl	ST-CreateTD­CustAcc-Res-Full-MSG.xsd

6.4 Services and Operations associated with XSDs

The list of XSD files and the services and operations associated with each XSD is given below.

XSD names	Services/Operations
ST-CreateCustAcc-Req-Full-MSG.xsd	FCUBSAccService/CreateCustAcc
AccStmt-Adhoc-Query-Req-MSG.xsd	FCUBSAccFinService/RequestAccStmt
TDStmt-Adhoc-Query-Req-MSG.xsd	FCUBSTDFinService/RequestTDStmt
CA-StopPaymentsNew-Req-Full-MSG.XSD, CA-CreateStopPayments-Req-Full-MSG.xsd	FCUBSAccService/CreateStopPayments
DDTransaction-Create-Req-Full-MSG.xsd	FCUBSDDService/CreateTransaction
SIContract-Create-Req-Full-MSG.xsd	FCUBSSIService/CreateSIContract
SIContract-Create-Req-Full-MSG.xsd	FCUBSSIService/CreateSIContract
SIContract-Create-Req-Full-MSG.xsd	FCUBSSIService/CreateSIContract
SIContract-Close-Req-Full-MSG.xsd	FCUBSSIService/CloseSIContract
IL-CreateILSweep-Req-Full-MSG.xsd	FCUBSILService/CreateILSweep
IL-ModifyILSweep-Req-Full-MSG.xsd	FCUBSILService/ModifyILSweep
IL-CreateILGroup-Req-Full-MSG.xsd	FCUBSILService/CreateILGroup
IL-DeleteILGroup-Req-Full-MSG.xsd	FCUBSILService/DeleteILGroup
LC-Contract-Create-Req-Full-MSG.xsd	FCUBSLCService/CreateContract
LC-CreateAmendConfirm-Req-Full-MSG.xsd,	FCUBSLCService/CreateAmendConfirm
BC-CreateContract-Req-Full-MSG.xsd	FCUBSBCService/CreateContract
BC-CreateContract-Req-Full-MSG.xsd	FCUBSBCService/CreateContract
BC-CreateContract-Req-Full-MSG.xsd	FCUBSBCService/CreateContract
LC-CreateAmendConfirm-Res-Full-MSG.xsd	FCUBSLCService/CreateAmendConfirm
LC-ConfirmAmendConfirm-Res-Full-MSG.xsd	FCUBSLCService/ConfirmAmendConfirm
CA-CustAcc-Bal-Notify-MSG.xsd	FCUBSCAService
CA-CustAccStat-Notif.xsd	FCUBSCAService
CGReject-Notif-MSG.xsd	FCUBSCGService
CGStoppayment-Notif-MSG.xsd	FCUBSCGService
TD-NewAccount-Notify-MSG.xsd	FCUBSTDService
AccStmt-Adhoc-Query-Req-MSG.xsd	FCUBSAccFinService/RequestAccStmt
TDStmt-Adhoc-Query-Req-MSG.xsd	FCUBSTDFinService/RequestTDStmt
CA-StopPaymentsNew-Req-Full-MSG.XSD, CA-CreateStopPayments-Req-Full-MSG.xsd	FCUBSAccService/CreateStopPayments
SIContract-Create-Req-Full-MSG.xsd	FCUBSSIService/CreateSIContract
SIContract-Create-Req-Full-MSG.xsd	FCUBSSIService/CreateSIContract
SIContract-Create-Req-Full-MSG.xsd	FCUBSSIService/CreateSIContract
DDTransaction-Create-Req-Full-MSG.xsd	FCUBSDDService/CreateTransaction
MO-Save-AccSim-Req-Full-Msg.xsd,	FCUBSMOService/SaveAccSim