1 Overview

This topic provides the overview on inter-connecting Oracle Banking Virtual Account Management to other systems.

Oracle Banking Virtual Account Management supports the integration with Core Banking, Payment and Receivables, and Liquidity Management systems for various use cases. It also provides interfaces for self-service portals.

Figure 1-1 Oracle Banking Virtual Account Management - Overview



Core Banking

This is an outbound integration from Oracle Banking Virtual Account Management to Core Banking system.

Outbound Interface

Oracle Banking Virtual Account Management supports the following outbound interfaces:

  • Virtual Account Creation: This is used to populate a common data store to synchronize the Core Banking data store for a virtual account so that it is available in transactions.
  • External Account Check: For real account check mapped to virtual account.
  • External Credit Approval: For balance check and amount block on debit transactions.
  • Accounting Posting: Actual entries posted to Core Banking. The entries are posted if the Skip DDA option at the transaction level is set as No.

Payments and Receivables

This is an inbound/outbound integration with Payments and Receivables system.

Inbound Interface

The interface exposed by Oracle Banking Virtual Account Management that Payments and Receivables system can consume are:

  • Virtual Account Check/External Account Check: To perform account validations
  • Virtual Account Credit Approval/External Credit Approval: To perform balance check and define an amount block on the virtual account.
  • Accounting Posting on VA: To post entries on virtual accounts that in turn posts to Core Banking System.

Outbound Interface

Oracle Banking Virtual Account Management supports the following outbound interface:

  • Pending Payment Query: To check for pending payments during Virtual Account closure.

Liquidity Management

  1. Interest Re-distribution and Sweeping

    This is an inbound/outbound interface with the Liquidity Management system.

    Inbound Interface

    The interface exposed by Oracle Banking Virtual Account Management are:

    • Value Date Balance Fetch: For fetching the virtual account’s value dated balance.
    • Accounting Posting to VA: For posting entries to virtual account.
    • Sweep Eligible Balance Fetch: For fetching the virtual account’s Sweep Eligible balance and value dated balance.

    Outbound Interface

    Oracle Banking Virtual Account Management supports the following outbound interface:

    • Get LM Account: To check whether Virtual Account is participating in a LM structure during Virtual Account closure.

    Event Based:

    Vamlm Account Event
    • A Kafka event is raised on creation/modification of a Virtual Account with Liquidity Management Allowed flag as yes.
    • This event is consumed at Oracle Banking Liquidity Management which creates the customer if not already present and the virtual accounts.
  2. Interest Calculation and Liquidation on Individual Accounts

    This is an inbound/outbound interface with Interest and Charges system.

    Outbound Interface

    The outbound interfaces supported by Oracle Banking Virtual Account Management are:

    • Virtual Account Handoff: This is an online interface. The account details are handed off to the adapter when an account is authorized.
    • Accrued Interest Fetch: For fetching accrued interest for a Virtual Account.
    • Online Interest Liquidation: To initiate interest liquidation for a Virtual Account.
    • Fetch Bank Level IC Group: To fetch bank-level IC Groups.
    • Fetch product Map: To fetch product Map for a specific group.
    • Create Account Group: To create an Account Group in IC.
    • Create Account Group - Product Mapping: To create an Account Group - Product Mapping in IC.
    • vdbalMaster: For IC trigger of Value Dated Balance.

    Inbound Interface

    The interface exposed by Oracle Banking Virtual Account Management are:

    • Accounting Posting to VA: For posting interest liquidation entries to the virtual account.

Self-Service Portal

This is an inbound integration to Oracle Banking Virtual Account Management from Self-Service portal.

Inbound Interface

The interfaces available for the Self-Service portal are:

  • Virtual Entity Creation
  • Virtual Account Creation
  • Account Structure Creation
  • Virtual ID Remitter Management
  • VA to VA Internal Transfer
  • Virtual Account Balance
  • Account Structure Details
  • Virtual Account Statements
  • Virtual Account Reports
  • Virtual Account Queries
  • Internal Credit Line
  • Remittance Details
  • Charges Inquiry
  • Account Transaction Limits
  • Account Transaction Utilization
  • Virtual Identifier Transaction Enquiry

Cash Management

This is an inbound integration to Oracle Banking Virtual Account Management from Cash Management System.

The interface exposed is:

  • Get Account Details

Oracle Banking Enterprise Party Management

This is an inbound integration to Oracle Banking Virtual Account Management from Enterprise Party Management.

Inbound Interface

The interface exposed by Oracle Banking Virtual Account Management that Enterprise Party Management system can consume is:

  • Corporate 360 View of Oracle Banking Virtual Account Management’s Virtual Account, Structure, Entity and Currency Wise Balance of Real Customer.

Host To Host Integration with Oracle Banking Electronic Data Exchange

This is a host to host integration of Oracle Banking Virtual Account Management and Oracle Banking Electronic Data Exchange System.

Inbound Interface

The interface exposed by Oracle Banking Virtual Account Management that Oracle Banking Electronic Data Exchange can consume are:
  • Parse File API: To send the virtual account creation or virtual account closure file from corporate ERP system and to validate data in the file.
  • Handoff API: To perform virtual account create or close.
  • Ack File API: To get the record status, the failure reason for each record from Electronic Data Exchange system, and create consolidated ack csv file based on this data.

Outbound Interface

The outbound interfaces exposed by Oracle Banking Electronic Data Exchange and consumed by Oracle Banking Virtual Account Management are:
  • Parse Response API: To send the file data after validation to Electronic Data Exchange System.
  • Handoff Response API: To send the virtual account creation/closure status and the newly created virtual account number to Electronic Data Exchange system.
  • Outgoing Ack File API: To send the virtual account creation/closure status and the failure reason (in case, the record creation/closure is failed) in a consolidated csv file to Electronic Data Exchange system.

Refer to Host To Host Integration for the detailed explanation.

Oracle Banking Accounts

This is an outbound Integration from Oracle Banking Virtual Account Management to Oracle Banking Accounts.

Outbound Interface

Oracle Banking Virtual Account Management supports the following outbound interfaces:
  • External Account Check: For real account check mapped to virtual account.
  • External Credit Approval: For balance check and amount block on debit transactions.
  • Accounting posting: Actual entries posting to the Oracle Banking Accounts. The entries are posted if Skip DDA option at the transaction level is set as No.