Who's Online Now
0 registered members (), 6 guests, and 16 spiders.
Key: Admin, Global Mod, Mod
Newest Members
vjnanda, NickyB, AKR, Barry_Test_User, KVS
1286 Registered Users
Recent Posts
Top Posters(30 Days)
Popular Topics(Views)
481,388 PAYE RTI
57,620 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,103
CT Offline
CT  Offline


Joined: Mar 2005
Posts: 2,103
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 Offline
hpatel15  Offline

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  Administrator, bcooper, CT 

Forum Statistics
Most Online90
Mar 5th, 2017
Today's Birthdays
No Birthdays
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
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
Powered by UBB.threads™ PHP Forum Software 7.6.0
Page Time: 0.023s Queries: 15 (0.005s) Memory: 2.7537 MB (Peak: 2.9060 MB) Zlib disabled. Server Time: 2019-06-27 08:08:34 UTC