Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

R12.2 :Modulus Check Validations for Bank Accounts

Posted on July 12th, 2014 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

The existing bank account number validations for domestic banks only check the length of the bank account number. These validations are performed during the entry and update of bank accounts.With R12.2 the account number validations for United Kingdom are enhanced to include a modulus check alongside the length checks.

  • Modulus checking is the process of validating bank account numbers in conjunction with the Banks Sort Code.
  • A new concurrent program "Load UK Domestic Account Validations Data" has been provided to load modulus validation data files.

Notes The feature can be disabled by using a Cash Management System Profile (CE: Disable Bank Validations).

If you compare , you can understand this way :

Existing validations:
The sort code should have 6 numeric digits
The bank account number should have 6 numeric digits

New Validation:
The combination of Sort Code and Account Number should pass a modulus check.

Modulus check methods are prescribed by VocaLink (BACS technology partner)
Modulus checking ensures sort code and account numbers are compatible before submitting BACS payment instructions.

dgreybarrow BANK ACCOUNT VALIDATION - THE BASICS

A modulus check is an arithmetic check that establishes whether there is a valid link between a given sort code and account number range.

Modulus checking is a vital process within bank account validation for Bacs submissions, ensuring that errors arising during the capturing of data are flagged for the payer's attention to enable them to correct them before they are submitted, thus avoiding costly returned transactions.

So far, There are 3 types of modulus checks that are performed on the UK bank accounts. These are:

  • Mod 10– Standard 10 modulus check
  • Mod 11– Standard 11 modulus check
  • DblAl– Double alternate modulus check.

This feature enhances the existing UK bank account validation model by introducing modulus check validation.

A modulus check will be performed during the creation and modification of the bank accounts and will also be applied on the importing of bank accounts through public APIs.

dgreybarrow HOW THIS WORKS

When the bank accounts are entered, the system will now invoke a new modulus check in addition to the existing length check (8 digits) for validating the UK bank accounts.

The modulus algorithm applied on the bank accounts depend on the bank sort codes and is part of the sort codes published by Vocalink.

dgreybarrowIMPLEMENTATION: UK BANK ACCOUNT VALIDATION

Implemenation Process can be best understood as below:

UK Validation Bank

In order to use the new validation model, customers need to upload the latest modulus weight table file and Sorting & Substitution data file published by Vocalink.

These concurrent programs allow customers to upload the latest version of these files. Vocalink publish updates to these regularly. Customers can register via Vocalink website to be alerted when a new version has been published.

This Consist of 4 steps process

1) Download 2 files from the VocaLink site:

a) Click on Modulus weight table data (.txt valid from 18/11/13)
Save the file : valacdos.txt [ This will be one the parameter ]

b) Click on Sorting code substitution data (.txt 1Kb valid from 13/06/05)
Save the file : scsubtab.txt [ This will be one the parameter ]

2) These two files must be Upload files to server

3) Then Import : From CM super user responsblity submit a program 'Load UK Domestic Account Validations Data’

4) Make sure System Profile Set - CE: Disable Bank Validations set to YES at site level

Related Posts

Posted in Cash Management | No Comments »Email This Post Email This Post | Print This Post Print This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.