Who's Online Now
0 registered members (), 7 guests, and 1 spider.
Key: Admin, Global Mod, Mod
Newest Members
hcmconfig, Christine, BBH, vjnanda, NickyB
1289 Registered Users
Recent Posts
Top Posters(30 Days)
Popular Topics(Views)
483,551 PAYE RTI
58,000 HR_PF.K RUP4
Previous Thread
Next Thread
Print Thread
Rate This Thread
Page 1 of 2 1 2
#12188 - 01/02/19 02:34 PM Update employee spinal point via API  
Joined: Feb 2019
Posts: 6
Andrew Offline
lurker
Andrew  Offline
lurker

Joined: Feb 2019
Posts: 6
Dear All

Payroll are making some changes to around 6000 employees' grades etc, and I've been asked to update employees' spinal points programatically. I thought at first that I could do this via the special_ceiling_step_id parameter when calling the HR_ASSIGNMENT_API.Update_emp_asg_criteria function, but then realised that this just sets the maximum step value.

I've also had a look at HR_GRADE_API, but there's nothing obvious there.

Any thoughts would be greatly appreciated!

Edit:
There is also an optional requirement for me to update values for AutoIncrement and Increment step for employess, and I can't see anything obvious for this either!!


Thanks

Andrew

Last edited by Andrew; 01/02/19 03:11 PM. Reason: Missed bit in original posting
#12189 - 01/02/19 02:45 PM Re: Update employee spinal point via API [Re: Andrew]  
Joined: Mar 2005
Posts: 2,103
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,103
Hi Andrew, my thoughts, like my brain, are somewhat rusty right now - but I am getting a vibe from (I think) hr_spp_api or similar? Not sure about the hr_ bit, but I am more confident about the _spp_ bit (spp = spinal point placement) smile

Cheers,

Clive


CT
#12190 - 01/02/19 02:50 PM Re: Update employee spinal point via API [Re: Andrew]  
Joined: Mar 2005
Posts: 1,291
bcooper Offline
bcooper  Offline

*****

Joined: Mar 2005
Posts: 1,291
Earth, Europe, England, here
I was sure that there as a grade_step API?

I dont have access to an EBS instance at the moment (Cloud, yes, EBS no!) so cannot check.

#12191 - 01/02/19 03:01 PM Re: Update employee spinal point via API [Re: Andrew]  
Joined: Mar 2005
Posts: 2,103
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,103
Yes that's another possibility - I will admit I was thinking in terms of changing an employee's specific placement, whereas it's equally possible that the OP would have been thinking in terms of changing the values around a given step.


CT
#12192 - 01/02/19 03:14 PM Re: Update employee spinal point via API [Re: CT]  
Joined: Feb 2019
Posts: 6
Andrew Offline
lurker
Andrew  Offline
lurker

Joined: Feb 2019
Posts: 6
Thanks very much for the quick responses!

Yes, the changes are for particular employees.

The Grade Step API looks like it just changes the grade without linking to employees. The PER_SPP packages look like they might be useful, but I'll need to look into them to find out for sure.

Andrew

#12193 - 01/02/19 03:21 PM Re: Update employee spinal point via API [Re: Andrew]  
Joined: Feb 2019
Posts: 6
Andrew Offline
lurker
Andrew  Offline
lurker

Joined: Feb 2019
Posts: 6
...table per_spinal_point_placements_f is referenced from the SPP packages and looks to be just the thing - I suppose it would cause problems if I just updated that directly :)

#12194 - 01/02/19 03:25 PM Re: Update employee spinal point via API [Re: Andrew]  
Joined: Mar 2005
Posts: 1,291
bcooper Offline
bcooper  Offline

*****

Joined: Mar 2005
Posts: 1,291
Earth, Europe, England, here
Originally Posted by Andrew
...table per_spinal_point_placements_f is referenced from the SPP packages and looks to be just the thing - I suppose it would cause problems if I just updated that directly smile

I'd always recommend using the published API if one is available - especially on a production system.

Regards

#12195 - 01/02/19 03:33 PM Re: Update employee spinal point via API [Re: Andrew]  
Joined: Mar 2005
Posts: 2,103
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,103
Originally Posted by Andrew
...table per_spinal_point_placements_f is referenced from the SPP packages and looks to be just the thing - I suppose it would cause problems if I just updated that directly smile

It would indeed - principle among them would be Oracle Support not being able to help you in the event something goes awry!

You should always use supported APIs to do programmatic updates to data. On which subject, I stand corrected - the API you need is hr_sp_placement_api. Sorry, senility is setting in.

Cheers,

Clive


CT
#12196 - 01/02/19 03:34 PM Re: Update employee spinal point via API [Re: bcooper]  
Joined: Feb 2019
Posts: 6
Andrew Offline
lurker
Andrew  Offline
lurker

Joined: Feb 2019
Posts: 6
Tempting though, isn't it?

I'll give the API a go and let you know how I get on - thanks again to you both for the help and advice.

Andrew

#12197 - 01/02/19 04:09 PM Re: Update employee spinal point via API [Re: Andrew]  
Joined: Mar 2005
Posts: 2,103
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,103
Originally Posted by Andrew
Tempting though, isn't it?


Try and resist, if you can... on an HR system where someone moans on the phone about you getting their inside leg measurement wrong on their personnel record, then you might get away with a slapped wrist and a temporary cessation of washroom privileges. Whereas, on a large payroll where the entire payroll process grinds to a halt, the ensuing fallout might elevate you to the kind of celebrity status that one might attract by publishing a selfie taken with Gary Glitter*

Hope this helps wink

Cheers,

Clive





*Other pariahs are available




Last edited by CT; 01/02/19 04:10 PM.

CT
Page 1 of 2 1 2

Moderated by  Administrator, bcooper, CT 

Forum Statistics
Forums60
Topics2,221
Posts11,997
Members1,289
Most Online90
Mar 5th, 2017
Today's Birthdays
truddock (51)
Recent vacancies
Top Posters(All Time)
CT 2,103
delboy 1,297
bcooper 1,291
paulgos 436
SBi 426
pat 254
Gus 252
vkumar 223
August
S M T W T F S
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 31
Powered by UBB.threads™ PHP Forum Software 7.6.0
Page Time: 0.030s Queries: 16 (0.007s) Memory: 2.8160 MB (Peak: 3.0145 MB) Zlib disabled. Server Time: 2019-08-20 22:54:02 UTC