Has anyone implemented Bank Sort code validation? I just want an estimate of the effort involved to implement please.

Hi Brooksy,

I don't think there is much to it (well, not from a funky point of view). You just need a CD from BACS of the bank sort codes to load to a table and I think there is a profile option to switch it on but I might be wrong.

Cheers,

Delboy

CB

Profile option is 'HR:Enable Bank Branch Validation' - Yes/No

I seem to recall the data (and updates) was available by subscription from e.g. Reed Business Publishing for some extortionate fee.

I also seem to recall that the data can be held in the payroll table PAY_BANK_BRANCHES, however at the implementation of payroll for a well-known government organization concerned with defence, the data was actually held in the payables equivalent (AP_BANK_BRANCHES) and shared by payroll. Not 100% sure how that was achieved, whether it was standard or custom functionality.

So all you need to do is write a concurrent process which does a SQL*Ldr into temp tables and then another process which calls the appropriate API? As I assume you get the updates from BACS at intervals.
I'd rather just go with Delboys answer and just switch a Profile on!!

CB

I rather get the impression you'd need to do both - it's one thing to say 'validate sort codes' it's another entirely to populate the table that contains the correct values. I tried looking for a standard concurrent process (on my standalone R12 instance) that might do that for you, but sadly no luck. Having said that, it should be fairly straightforward to knock up a sql*loader thing to do the uploading directly to the PAY_BANK_BRANCHES and/or AP_BANK_BRANCHES.

As for the data itself, I recall RBP did quarterly updates to the sort-code listing, not sure if BACS themselves do a similar thing or any more frequently than that?

I was joking when I said I would go with Delboys simple solution, his response was the sort of thing you expect from a "funkie".
I'll quote the client 5 days and that should be enough time to knock up a Concurrent Program or two.

Ah, sense of humour, I vaguely remember having one of those!

Possibly the attached file (assuming the upload bit worked of course) will help... it's the help text from the online help on the 'setup personal pay method' screen. Interestingly it talks of using APIs to populate the tables, which I guess means they must exist now, although beggared if I could find 'em....

Edit: They do exist, the package doesn't end in _API though. Well there's consistent... (PAY_BANK_BRANCHES_PKG is yer man)

5 Days!
I'll do it for you in 3

Didn't you do it at that place in Warwick?

5 days? Like I said, there's not much to it.

Don't forget the commit!!

Delboy

I seem to recall that there is note on Metalink which describes what is required to enable the validation functionality. I can't remember the doc id but I am attaching a copy of the doc that I have its old but I doubt it has been updated.

Dil

Hi

Or you could just call a web service that will validate your bank sort codes (and account numbers)

That way you don't have the hassle of updating your sort code database (and the modulus checking rules that go with it) every month or so.

Try Unified Software. You can download a jar file from the developers area. www.unifiedsoftware.co.uk/developers/cookbook/java.html You can be up and running within a day or two.


Cheers
Phil

Hello Phil - welcome to HRMSACES

Is there any performance overhead in performing this sort of validation 'on the fly' using this service?

Regards

Barry