Who's Online Now
0 registered members (), 3 guests, and 12 spiders.
Key: Admin, Global Mod, Mod
Newest Members
lmartin, Kevin, Andi, nicwoody, appetite11
1272 Registered Users
Recent Posts
Migration into Existing Payroll and RTI
by hpatel15. 18/07/18 11:08 AM
Retropay Enhanced Performance Issues
by delboy. 17/07/18 06:06 AM
HR Intelligence in R12.2
by elmilsse. 09/07/18 10:53 AM
by sheebs. 04/07/18 10:46 AM
Top Posters(30 Days)
delboy 4
sheebs 3
Popular Topics(Views)
458,896 PAYE RTI
54,164 HR_PF.K RUP4
Previous Thread
Next Thread
Print Thread
Rate This Thread
#12039 - 13/09/17 03:09 PM Future dated records and API  
Joined: Sep 2009
Posts: 31
ALERO Offline
ALERO  Offline

Joined: Sep 2009
Posts: 31
Hi All,

All our locations have been setup as Global. We have to set them up as Local as part MDC solution provided by Oracle.

I have done the following:

Created new locations
Attached the locations to the Organisations.
Amend the assignment to include the new locations.

All the above done via API

The problem with assignment updates are:

1. Future dated updates .
2. I think the biggest issue is terminate assignments as you can’t update the location against those without reversing the termination. Bearing in mind we need to go back to April 2017. I am guessing there will be a good number of those.

Any advice or sharing your valuable experience will be well appreciated.

Thanks in advance

#12041 - 14/09/17 10:26 AM Re: Future dated records and API [Re: ALERO]  
Joined: Mar 2005
Posts: 2,092
CT Online sleepy
CT  Online Sleepy


Joined: Mar 2005
Posts: 2,092
Can you not reverse the termination where appropriate, apply the assignment change, then re-apply the termination? Obviously you'd need to record somewhere the details of the original termination prior to reversing it.

#12058 - 09/10/17 12:47 PM Re: Future dated records and API [Re: ALERO]  
Joined: May 2008
Posts: 426
SBi Offline
battle-hardened campaigner
SBi  Offline
battle-hardened campaigner

Joined: May 2008
Posts: 426
mmm.. why do you care about historic location of an employee if they have left?
If its required - could you store location in a different place for history purposes? like EIT/SIT?

#12059 - 10/10/17 08:04 AM Re: Future dated records and API [Re: ALERO]  
Joined: Apr 2009
Posts: 56
hpatel15 Online content
hpatel15  Online Content

Joined: Apr 2009
Posts: 56
Berkshire - UK
Can't you update location table directly? value in business_group_id column decides location is global (business_group_id is null) or local (business_group_id is not null).

Moderated by  bcooper, CT 

Forum Statistics
Most Online90
Mar 5th, 2017
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters(All Time)
CT 2,092
bcooper 1,289
delboy 1,286
paulgos 434
SBi 426
pat 254
Gus 252
vkumar 223
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.019s Queries: 15 (0.005s) Memory: 2.7533 MB (Peak: 2.9045 MB) Zlib disabled. Server Time: 2018-07-20 18:05:28 UTC