Who's Online
2 registered (CT, Chris Abraham), 7 Guests and 3 Spiders online.
Key: Admin, Global Mod, Mod
Recent Posts
Concurrent Request - running slow
by CT
11 minutes 59 seconds ago
P11d's
by jkavia
38 minutes 53 seconds ago
Assignment EIT not displaying in Self Service
by CT
Today at 06:45 AM
Vehicle Mileage Setup
by Chris Abraham
Yesterday at 12:24 PM
In which table is external learning data stored
by DMC
Yesterday at 08:45 AM
Oracle Payroll and Cash Management
by Gus
20/05/12 11:27 AM
Pension Auto Enrolment
by CT
18/05/12 09:46 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
Top Posters (30 Days)
CT 38
delboy 36
Vigneswar Battu 15
pat.woodall 9
bcooper 4
Gus 4
DMC 3
Mani 3
7Giri 3
Ryan 3
(Views)Popular Topics
Family Pack K issues thread 20153
CREATE_GRADE api returns:PLS-00306: wrong number o 15194
Still trying to locate... 13844
Creating hr jobs ORA-20001: HR_289477_JOB_GROUP_ID 11889
Viewing Output of another user 10307
HR_PF.K RUP4 10271
Review of my Release 12 laptop 9733
Enhanced Retro & Release 12 9397
Adding a taskflow button to a form 9129
Family Pack K 7906
Topic Options
Rate This Topic
#2835 - 06/02/08 07:17 AM Strange error when Terminating an employee
bcooper Offline

Guru
*****

Registered: 11/03/05
Posts: 1112
Loc: Earth, Europe, England, here
Hi All
I am encountering a strange error when trying to terminate an employee through the application screens (see attached doc of the screen shot).

In the example given, i am using 30th Nov 2007 as the projected, actual and last standard process dates, and 29th Feb 2008 as the final process date.

The error seems to be SSP related, however this emp only has 2 episodes of sickness absence - one for 7 days in august 2007 and one for 3 days in july of 2006.
We do not appear to have any rows in the SSP_TEMP_AFFECTED_ROWS table either.

Would appreciate any pointers on this for me.

Oh, and if i try to perform the termination using the 2 API's in an SQL session it terminates without issue??

Cheers

Barry


Attachments
term-error.doc (37 downloads)
Description: term error doc




Edited by bcooper (06/02/08 07:17 AM)
Edit Reason: added the attachment
_________________________
HCM Aces is for sale! Please contact me if you are interested.
Also my random musings courtesy of Twitter

Top
#2836 - 06/02/08 08:35 AM Re: Strange error when Terminating an employee [Re: bcooper]
CT Online   content
Guru
***

Registered: 11/03/05
Posts: 1185
Loc: Bath
Baz

Re our very recent conversation about payroll calendars, note number 303907.1 on Metalink suggests that the calendar needs to extend at least 2 years into the future! Although this was specifically about the same message encountered whilst entering an absence.

The other thing I was going to ask is: what is the effective (session) date in each case? Also, what if any offsets are present on the payroll in question?

Interesting that the APIs do it OK but the screen does not... oh of course, the screens don't use the APIs do they whistle
_________________________
L&K
CT

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

Top



Moderator:  Administrator, Geoff Dixon 
Forum Stats
791 Members
48 Forums
1582 Topics
7650 Posts

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