Who's Online Now
0 registered members (), 6 guests, and 9 spiders.
Key: Admin, Global Mod, Mod
Newest Members
Renuka, KavyaMurthy, Del, Bejoylin P, Shaqirre
1278 Registered Users
Recent Posts
Oracle Support Communications
by delboy. 26/10/18 08:32 AM
Top Posters(30 Days)
delboy 1
Popular Topics(Views)
465,951 PAYE RTI
55,146 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 Offline
CT  Offline


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

Forum Statistics
Most Online90
Mar 5th, 2017
Today's Birthdays
cbrookes (63)
Recent vacancies
Top Posters(All Time)
CT 2,092
bcooper 1,289
delboy 1,288
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
Powered by UBB.threads™ PHP Forum Software 7.6.0
Page Time: 0.017s Queries: 15 (0.004s) Memory: 2.7507 MB (Peak: 2.9032 MB) Zlib disabled. Server Time: 2018-11-15 18:38:35 UTC