Hi. I'm on a project which will role out across 39 countries and there's an aspiration to allow users to enter their bank account details online.
The first question is where do we get the UK file that we used to upload at my last project which would load the value sets for bank branch and sort code on a monthly basis? Have asked the payroll team at current client (who use SAP..) and they don't know.
Second question is, where do I get this for the other 38 countries? List includes US, Singapore, France, Germany, Norway, Sweden, Finland, Netherlands, (list goes on and on).
Third question - I saw a post about the actual code for this to upload the UK file but I'm assuming that this is just an upload to value sets and therefore not too difficult or am I being usually simples....
Any thoughts / advice greatly received.
Cheers
Corinne

Hello you...

I am assuming this is a payroll implementation?
Does this mean that the 39 other countries will be implementing country-specific legislation-versions of Oracle payroll too?
If yes, then presumably each country uses some form of clearing system for payments (equiv to BACS)?

My experience is that BACS are happy to "talk" to payroll departments and to provide such bank file lists, although i believe there used to be a subscription payment - as the list was updated regularly (quarterly). I would assume that there is a similar system for other countries? In which case the local payroll admin for each of the countries will need to do some work.

That said, i would hope that the hardened payroll regulars of this forum would chip-in. It would be handy if Mr Fisher were monitoring as he has dabbled in most countries

Corinne

I'm not sure where the file comes from that gets loaded here.

In terms of uploading, as you (or someone near you!) are probably aware, the upload process here populates the payables version AP_BANK_BRANCHES, which then is used by the process that sets up personal payment methods for Payroll. There is however a payroll-specific equivalent PAY_BANK_BRANCHES. In theory that could be populated from any business group - it has a legislation_code column in there.

In terms of source data for other countries, I seem to remember from a brief stint at Reed Business Publishing, they produce a periodic data-set on CD (quarterly, I think) which did contain banks/sort codes for all manner of exotic locations. I think a subscription is involved, and be aware it probably won't be Charity Week where they are concerned!

Let me know if you need to know anything else, and I will see what if anything I can uncover.

Also remember that most countries will have clearing banks for foreign payments. So you can have a local (country) bank account and sort-code that will route through to another country bank branch etc.

Of course in these enlightened days of anti-fraud and bank closures etc i would expect everyone to have to jump through hoops to get any information out of the banking system!

Hi Corrine,

If you cannot do this from within Oracle for all the countries required, then you may be able to call out to Bank Wizard...

http://www.experian.co.uk/payments/products/bank-wizard.html

I think that this may cost a pretty penny though!

Any way, I hope this helps,
Gavin

Regarding storing bank details in EBS & entering thru ESS/MSS:
1. Each country has it own banking system and Oracle EBS may/may not have the Bank structure defined in "Bank Details KeyFlexField".
I would propose to start by looking at the different bank structures available for each legislation you are implementing.
2. In my previous project as we had single BG and employees were based acorss the world so we used an SIT/EIT combination to store banking information.
This has lot advantages as it saves time in setting up the system for each country... plus adds complication with regard to patches/legsilations/hrglobal etc..
3. Oracle EBS provides a basic level of validation with regard to bank account information (i.e. it does not check if account information is correct, all it checks is if its in right format).
4. Usually in such multi-country companies the payments are processed through a single system/method/agent.. similar what Gavin has suggested.

Thanks all for help and advice. We are only implementing HR (not Payroll) but will be sending out the info to the country specific payrolls.
Have contacted Experian who look like they cover all our countries - wait for the costs to come rolling in.
Cheers all

Corinne

This company has an international bank validation web service: http://www.unifiedsoftware.co.uk

Worth adding a comment here I think. SBi's comment is worthwhile - at an Aluminium Company of America (what were they called!?) who had just HR and then interfaced to each coutnry Payroll we took a purist view on this - that we would not hold bank details in HR as we didn't need them for HR business purposes. That said, there is real validity in getting them into Self Service as a cross-country common process. One of the advantages of this purist view was that we could implement neutral legislation Business Groups (I've posted the 'How To' for that elsewhere on here, but happy to find again). And so we did not have to apply loads of country legislative patches for things that as HR only we didn't want to use. So adding them as, say, an EIT might not be such a bad idea - you would want to consider how you were going to handle multiple payrolls, priorities etc.

In a similar way, where a country legislation offered a field for something - say on the person or assignment forms - we might still opt to use a Flexfield so as to avoid having lots of non standard set up which meant that global reporting was complex.

I could go on ,,,,!

Additional advantages of EITs is we can set it to multiple/single records. You could have multiple "single record" EIT for payroll/expense payments for recording purposes.