Bank sort code validation - HRMS Aces - The Oracle HRMS Community

You are not logged in. [Log In] HRMS Aces - The Online HRMS Community » Forums » Apps Technical » Interfaces » Bank sort code validation

Top Posters (30 Days)

SBi	31
CT	16
bcooper	15
Saqib Rahat	11
PeterP	10
EBS_USER	9
kp_rapolu	8
Geoff Dixon	8
delboy	5
MarinaH	5

(Views)Popular Topics

Family Pack K issues thread	8849
CREATE_GRADE api returns:PLS-00306: wrong number o	6175
Still trying to locate...	4660
Creating hr jobs ORA-20001: HR_289477_JOB_GROUP_ID	4444
Review of my Release 12 laptop	4226
Log-on problems for existing users	3538
Viewing Output of another user	3261
Family Pack K	3128
October UK-OUG?	3090
HR_PF.K RUP4	2908

Page 1 of 2

Topic Options

Rate This Topic

#3832 - 22/12/08 02:48 PM Bank sort code validation
cbrookes nothin' better to do Registered: 14/03/05 Posts: 197 Loc: Detained at HM pleasure	Has anyone implemented Bank Sort code validation? I just want an estimate of the effort involved to implement please.
Top

#3833 - 23/12/08 06:27 AM Re: Bank sort code validation [Re: cbrookes]
delboy claiming squatters rights Registered: 15/03/05 Posts: 291 Loc: Somewhere in Berkshire	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
Top

#3834 - 23/12/08 09:22 AM Re: Bank sort code validation [Re: delboy]
CT veteran Registered: 11/03/05 Posts: 820 Loc: Back at Fort Apache, Gosport!	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. _________________________ L&K CT
Top

#3835 - 23/12/08 12:15 PM Re: Bank sort code validation [Re: CT]
cbrookes nothin' better to do Registered: 14/03/05 Posts: 197 Loc: Detained at HM pleasure	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!!
Top

#3837 - 23/12/08 01:39 PM Re: Bank sort code validation [Re: cbrookes]
CT veteran Registered: 11/03/05 Posts: 820 Loc: Back at Fort Apache, Gosport!	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? _________________________ L&K CT
Top

#3838 - 23/12/08 02:04 PM Re: Bank sort code validation [Re: CT]
cbrookes nothin' better to do Registered: 14/03/05 Posts: 197 Loc: Detained at HM pleasure	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.
Top

#3840 - 23/12/08 02:21 PM Re: Bank sort code validation [Re: cbrookes]
CT veteran Registered: 11/03/05 Posts: 820 Loc: Back at Fort Apache, Gosport!	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) Attachments pay_bank_branches_validation.txt (176 downloads) Description: Online help for setting up bank branch validation Edited by CT (23/12/08 02:34 PM) _________________________ L&K CT
Top

#3843 - 23/12/08 02:51 PM Re: Bank sort code validation [Re: cbrookes]
bcooper veteran Registered: 11/03/05 Posts: 945 Loc: Earth, Europe, England, here	Originally Posted By: cbrookes 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. 5 Days! I'll do it for you in 3 _________________________ I'm blogging again - albeit sporadically Also my random musings courtesy of Twitter
Top

#3847 - 23/12/08 04:20 PM Re: Bank sort code validation [Re: bcooper]
cbrookes nothin' better to do Registered: 14/03/05 Posts: 197 Loc: Detained at HM pleasure	Didn't you do it at that place in Warwick?
Top

#3849 - 23/12/08 08:45 PM Re: Bank sort code validation [Re: cbrookes]
delboy claiming squatters rights Registered: 15/03/05 Posts: 291 Loc: Somewhere in Berkshire	5 days? Like I said, there's not much to it. Don't forget the commit!! Delboy
Top

Page 1 of 2

Previous Topic

Index

Next Topic

Hop to:

Moderator: bcooper, CT

Oracle R12.1.1 on your existing computer

Get up and running with Oracle on your existing computer in 5 minutes

Get up and running with Oracle on your existing computer in 5 minutes!

Alard Consulting Ltd are pleased to offer Oracle R12.1.1 on your existing computer.

Connect to Oracle R12 from your computer to do client demonstrations, your own development work, or test functional setup on a Vision environment without having to install and maintain Oracle.

Backup your work before making changes in case things go wrong. Just copy the files to a new directory before making the changes. If it doesn't work, copy the files back again, all from Windows. No other skills needed.

As everything is contained on a single external hard drive, you can take it with you to use wherever you need it.

For each sale from HCMAces a portion of the price will go to the running costs of this forum.

For more information see www.alard.net/products.html.

Forum Stats

494 Members
48 Forums
1213 Topics
5734 Posts

Max Online: 51 @ 12/08/10 02:30 AM

Today's Birthdays

No Birthdays

Recent vacancies