Who's Online
1 registered (spiro), 3 Guests and 3 Spiders online.
Key: Admin, Global Mod, Mod
Recent Posts
Pension Schemes Setup
by kp_rapolu
Today at 03:09 PM
RBAC and Security Profiles
by CT
Today at 02:05 PM
Q: multiple assignments absence processing
by CT
Today at 12:34 PM
How managers initiates SSHR request of employees
by Saqib Rahat
Today at 09:00 AM
French Localizations
by bcooper
Yesterday at 07:11 AM
Setting up budgets in HRMS
by MarinaH
Yesterday at 06:06 AM
Attach documents in the SIT/EIT
by MarinaH
Yesterday at 03:09 AM
Talent management function in self service menu
by EBS_USER
06/09/10 11:23 PM
Basic Setup for CORE HR without Payroll
by EBS_USER
06/09/10 11:17 PM
FYI: P60s to be available in Self Service
by kp_rapolu
01/09/10 03:42 PM
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 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: 820
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: 945
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: 945
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: 945
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
494 Members
48 Forums
1213 Topics
5734 Posts

Max Online: 51 @ 12/08/10 02:30 AM
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters
bcooper 945
CT 820
Geoff Dixon 354
SBi 291
delboy 291
vkumar 223
kp_rapolu 211
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