Who's Online
0 registered (), 1 Guest and 6 Spiders online.
Key: Admin, Global Mod, Mod
Recent Posts
Abseces in oracle hrms, super user: how to do I:
by tovia123
Today at 01:18 PM
Update EIT in SSHR
by Sahir
Yesterday at 03:45 PM
End of Year Legislation Patch for 11i
by delboy
Yesterday at 01:35 PM
Interfacing iRec and external sites
by DanC
09/02/12 11:42 PM
Capturing, Storing, & Paying Banked Overtime
by Paul
09/02/12 08:51 PM
Time and Labour & Oracle Projects
by Paul
09/02/12 07:34 PM
Search Engine Optimizers
by delboy
09/02/12 01:30 PM
Function for getting retropay-maintained balances
by CT
08/02/12 12:21 PM
Grade End Date
by Chris
03/02/12 10:46 AM
OLM Mandatory Enrolments
by bcooper
01/02/12 12:23 PM
Top Posters (30 Days)
CT 26
delboy 24
bcooper 14
Sahir 5
Gus 5
tovia123 5
Tim Bailey 3
SBi 3
christm 3
Simon_Mc 3
(Views)Popular Topics
Family Pack K issues thread 18240
CREATE_GRADE api returns:PLS-00306: wrong number o 13772
Still trying to locate... 12214
Creating hr jobs ORA-20001: HR_289477_JOB_GROUP_ID 10658
Viewing Output of another user 9137
HR_PF.K RUP4 8851
Review of my Release 12 laptop 8500
Adding a taskflow button to a form 7861
Enhanced Retro & Release 12 7689
Family Pack K 7127
Page 2 of 2 < 1 2
Topic Options
Rate This Topic
#5109 - 01/02/10 03:05 PM Re: Correcting PERSON_TYPE_ID in per_all_people_f [Re: CT]
natkins Offline
hanger-on

Registered: 15/03/05
Posts: 72
Loc: Lloyds Register
.. only bell i hear is at home time ..

Top
#5118 - 03/02/10 09:53 AM Re: Correcting PERSON_TYPE_ID in per_all_people_f [Re: natkins]
bcooper Offline

Guru
*****

Registered: 11/03/05
Posts: 1095
Loc: Earth, Europe, England, here
Late to the party as usual....

We have a constant stream of issues/data fixes for this sort of thing. Its amazing what damage unleased users can do to a system when no-one is looking.

We've found that providing the person-type on the PER_ALL_PEOPLE_F table is some form of valid employee type then the system dont seem to care that it may be mismatched with PPTU.

Our issues seem to centre on PPTU suddenly "losing" the employee person type entry - which causes all sorts of chaos.

Happy boating
_________________________
HCM Aces is for sale! Please contact me if you are interested.
Also my random musings courtesy of Twitter

Top
Page 2 of 2 < 1 2



Moderator:  bcooper, CT 
Forum Stats
756 Members
48 Forums
1517 Topics
7287 Posts

Max Online: 63 @ 24/11/10 07:21 AM
Today's Birthdays
No Birthdays
Recent vacancies
Tea boy available 4 basic chores & some! services
by Simon_Mc
19/01/12 03:59 PM
Top Posters
bcooper 1095
CT 1080
delboy 500
Geoff Dixon 369
SBi 344
vkumar 223
kp_rapolu 213
cbrookes 197
Gavin Harris 160
Gus 132
February
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