Who's Online
0 registered (), 8 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Recent Posts
French Localizations
by jmoyano
Today at 09:20 AM
How managers initiates SSHR request of employees
by Geoff Dixon
Today at 09:02 AM
FYI: P60s to be available in Self Service
by kp_rapolu
01/09/10 03:42 PM
SSHR Personalization requirement
by kp_rapolu
01/09/10 03:41 PM
Request for responsibility in ESS
by SBi
01/09/10 05:49 AM
Nominate for peers/subordinat for reward
by bcooper
31/08/10 07:46 PM
UK HCM Sig - 29th September
by andy.fisher
31/08/10 10:05 AM
Migration of terminated Employees
by SBi
31/08/10 10:02 AM
Worldwide Bank Details Validation
by SBi
27/08/10 02:33 PM
HTML pages popping up BEHIND Core Apps forms?
by Geoff Dixon
27/08/10 12:34 PM
Top Posters (30 Days)
SBi 28
bcooper 14
CT 12
PeterP 10
Geoff Dixon 8
Saqib Rahat 7
EBS_USER 6
kp_rapolu 5
delboy 5
MarinaH 3
(Views)Popular Topics
Family Pack K issues thread 8728
CREATE_GRADE api returns:PLS-00306: wrong number o 6046
Still trying to locate... 4588
Creating hr jobs ORA-20001: HR_289477_JOB_GROUP_ID 4356
Review of my Release 12 laptop 4212
Log-on problems for existing users 3526
Viewing Output of another user 3213
Family Pack K 3087
October UK-OUG? 3064
uploading bank branches to PAYROLL 2880
Page 1 of 2 1 2 >
Topic Options
Rate This Topic
#1310 - 11/04/05 10:09 AM uploading bank branches to PAYROLL
mgereis Offline
regular

Registered: 30/03/05
Posts: 26
Loc: Reading, UK
the requirement is for an interface to load bank sort codes (branches) into a pre-existing table within the Payroll eBusiness Suite schema (pay_bank_branches) to allow existing validation within the Payroll forms to be enabled; this does not entail any payroll forms customisations; the source of bank codes. . .can this be done? I'm not sure that there is any validation on loading bank branches/sort codes into Payroll. I didn't find any APIs to use. . .I've also looked on Metalink but found nothing useful or solid. . .help chaps!!
_________________________
Mina Gereis

Top
#1311 - 11/04/05 10:13 AM Re: uploading bank branches to PAYROLL
mgereis Offline
regular

Registered: 30/03/05
Posts: 26
Loc: Reading, UK
oh and by the way payment methods are set to use the key flexfield "bank details" .. and the valuesets for the segments are based on lookup tables (with the exception of branches)
_________________________
Mina Gereis

Top
#1312 - 11/04/05 11:21 AM Re: uploading bank branches to PAYROLL
CT Offline
veteran
***

Registered: 11/03/05
Posts: 816
Loc: Back at Fort Apache, Gosport!
There are no apis to use as yet - you might want to take a look at the package PAY_BANK_BRANCHES_PKG - specifically the procedures insert_gb_row and update_gb_row. . .NOTE this package is not in the public domain - so tread with extreme caution if you're considering using it in an interface. . .I think there is also some stuff to be done with setting system profile options - "HR:Enable Bank Branch Validation" or summat?
_________________________
L&K
CT

Top
#1313 - 11/04/05 12:42 PM Re: uploading bank branches to PAYROLL
mgereis Offline
regular

Registered: 30/03/05
Posts: 26
Loc: Reading, UK
that was really helpful. thanks CT <img src="/ubbthreads/images/graemlins/smile.gif" alt="" />
_________________________
Mina Gereis

Top
#1314 - 15/04/05 01:18 PM Re: uploading bank branches to PAYROLL
bcooper Offline
veteran
*****

Registered: 11/03/05
Posts: 944
Loc: Earth, Europe, England, here
May have some interface code for reuse. .Here at *** we have a sort code upload interface that regularly maintains a full list of bank bank branch and sort code info within the application.
_________________________
I'm blogging again - albeit sporadically
Also my random musings courtesy of Twitter

Top
#1315 - 25/04/05 02:45 PM Re: uploading bank branches to PAYROLL
mgereis Offline
regular

Registered: 30/03/05
Posts: 26
Loc: Reading, UK
yeah if you could share that it would be really helpful. sorry i've been away for a while. .cheers.
_________________________
Mina Gereis

Top
#1316 - 25/04/05 04:44 PM Re: uploading bank branches to PAYROLL
bcooper Offline
veteran
*****

Registered: 11/03/05
Posts: 944
Loc: Earth, Europe, England, here
Okay - give me a day and i'll upload something on here.
_________________________
I'm blogging again - albeit sporadically
Also my random musings courtesy of Twitter

Top
#1317 - 26/04/05 10:38 PM Re: uploading bank branches to PAYROLL
Gus Offline
hanger-on

Registered: 16/03/05
Posts: 59
Loc: Lapenne
Is that the same sort of day for the Element Types and Element Links......still waiting . .Gus

Top
#1318 - 27/04/05 08:52 AM Re: uploading bank branches to PAYROLL
mgereis Offline
regular

Registered: 30/03/05
Posts: 26
Loc: Reading, UK
no i think this is for banks/branches/sort codes .. that kind of thing.
_________________________
Mina Gereis

Top
#1319 - 27/04/05 10:40 AM Re: uploading bank branches to PAYROLL
bcooper Offline
veteran
*****

Registered: 11/03/05
Posts: 944
Loc: Earth, Europe, England, here
Hey i'm a busy man...time is money and all that.
_________________________
I'm blogging again - albeit sporadically
Also my random musings courtesy of Twitter

Top
Page 1 of 2 1 2 >


Moderator:  Administrator, Geoff Dixon 
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
492 Members
48 Forums
1207 Topics
5710 Posts

Max Online: 51 @ 12/08/10 02:30 AM
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters
bcooper 944
CT 816
Geoff Dixon 354
delboy 291
SBi 288
vkumar 223
kp_rapolu 208
cbrookes 197
Gavin Harris 111
jmoyano 96
September
Su M Tu W Th F Sa
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30