Who's Online
0 registered (), 2 Guests and 5 Spiders online.
Key: Admin, Global Mod, Mod
Recent Posts
In which table is external learning data stored
by DMC
Yesterday at 03:43 PM
Pension Auto Enrolment
by CT
Yesterday at 09:46 AM
Vehicle Mileage Setup
by Shyam
Yesterday at 06:45 AM
11.5.10 "Extended Support" extended til..... when?
by Vigneswar Battu
17/05/12 10:59 AM
Hacking element definitions
by CT
15/05/12 08:42 AM
GB EOY reports
by Vigneswar Battu
09/05/12 02:07 PM
Oracle Payroll and Cash Management
by Vigneswar Battu
08/05/12 03:08 PM
BG setup/changes - brain dump
by Ryan
05/05/12 07:20 PM
Fusion Collateral
by CT
04/05/12 11:09 AM
BEE - ordering Batch lines
by Vigneswar Battu
03/05/12 04:22 PM
Top Posters (30 Days)
delboy 37
CT 35
Vigneswar Battu 15
pat.woodall 9
bcooper 4
Mani 3
7Giri 3
Gus 3
Ryan 3
SBi 2
(Views)Popular Topics
Family Pack K issues thread 20107
CREATE_GRADE api returns:PLS-00306: wrong number o 15174
Still trying to locate... 13817
Creating hr jobs ORA-20001: HR_289477_JOB_GROUP_ID 11848
Viewing Output of another user 10266
HR_PF.K RUP4 10240
Review of my Release 12 laptop 9703
Enhanced Retro & Release 12 9375
Adding a taskflow button to a form 9111
Family Pack K 7882
Topic Options
Rate This Topic
#2081 - 19/05/06 09:54 AM Starting/Ending Ele Entries on same date via APIs
CT Offline
Guru
***

Registered: 11/03/05
Posts: 1182
Loc: Bath
Morning all gurus

Here at W-D a wee annoyance has just surfaced, whereby we are required to load a (recurring) element entry that starts and ends on the same day. Creating it is OK, however when one tries to end-date it, we get the message:

"DateTrack delete not allowed

Cause: You cannot perform the DateTrack delete operation because your effective date is set to the last datetracked row.

Action: Clear your changes and move your current effective date back in time"

All well and good, but if I shift the effective date back it won't even see the entry as it's before the effective start date!

I can do this through the screen, so what gives then?

Just in case anyone's tempted to ask, I have already checked Mentalink and, surprise-surprise, nothing doing.

Anyone else encountered this on their travels?
_________________________
L&K
CT

Remember: A dog is for life, not just for Christmas... unless you're in Korea

Top
#2082 - 22/05/06 04:07 PM Re: Starting/Ending Ele Entries on same date via APIs [Re: CT]
bfrost Offline
enthusiast

Registered: 17/03/05
Posts: 40
Loc: Wherever the highway takes me....
Just a thought (which may not be useable)

After you load your data, so it has a start date but no end date, can you just delete the element link with an Effective End date, as this will end date all open occurrences of the element ?
Or just create a link for the specific group of people you are loading and do the above.

Cheers
Brian

Top
#2083 - 22/05/06 09:49 PM Re: Starting/Ending Ele Entries on same date via APIs [Re: bfrost]
CT Offline
Guru
***

Registered: 11/03/05
Posts: 1182
Loc: Bath
Nice try Brian! However, this element has to remain visible at all times, so no option to end-date the links, sadly...

Cheers anyway

Clive

Top
#2084 - 23/05/06 02:35 PM Re: Starting/Ending Ele Entries on same date via APIs [Re: CT]
bcooper Offline

Guru
*****

Registered: 11/03/05
Posts: 1112
Loc: Earth, Europe, England, here
I've achieved this here using the api, by accident it must be said! I'd have to rumage around to find the original (and faulty) code that did do it.

Another idea...how's about doing a DT change, and then doing a delete next change on the change.
The DT change (on the day after the start date) will, in effect create an entry with 1 days validity. You could then remove the next change - will this leave the end-date intact i wonder?
_________________________
HCM Aces is for sale! Please contact me if you are interested.
Also my random musings courtesy of Twitter

Top



Moderator:  bcooper, CT 
Forum Stats
790 Members
48 Forums
1580 Topics
7641 Posts

Max Online: 67 @ 14/04/12 05:38 PM
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters
CT 1182
bcooper 1112
delboy 594
Geoff Dixon 369
SBi 356
vkumar 223
kp_rapolu 213
cbrookes 197
Gavin Harris 163
Gus 145
May
Su M Tu W Th F Sa
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