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!!

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)

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?

that was really helpful. thanks CT <img src="/ubbthreads/images/graemlins/smile.gif" alt="" />

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.

yeah if you could share that it would be really helpful. sorry i've been away for a while. .cheers.

Okay - give me a day and i'll upload something on here.

Is that the same sort of day for the Element Types and Element Links......still waiting . .Gus

no i think this is for banks/branches/sort codes .. that kind of thing.

Hey i'm a busy man...time is money and all that.