Who's Online
2 registered (CT, natkins), 3 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Recent Posts
Heres a simple question on Workflow then ..
by natkins
0 seconds ago
Defaulting PO Information on assignment screen
by SBi
Yesterday at 02:24 PM
E-Bus Configuration and Management
by PeterP
Yesterday at 01:28 PM
UMX : Oracle User Management Application
by natkins
Yesterday at 12:58 PM
HRMS organization structures
by Geoff_Dixon
Yesterday at 11:53 AM
HR_PF.K RUP4
by bcooper
10/03/10 06:50 PM
Pay_Action_Parameter
s

by John Akinyode
09/03/10 11:05 AM
Error ORA-01002: fetch out of sequence
by delboy
03/03/10 04:46 PM
Multiple html sessions opening
by MarinaH
03/03/10 12:16 AM
Tories to revamp PAYE system
by Geoff_Dixon
26/02/10 01:48 PM
Top Posters (30 Days)
CT 20
delboy 19
natkins 15
bcooper 14
MarinaH 14
SBi 10
gaztorres 8
Geoff_Dixon 7
Gus 4
Simon_Mc 3
(Views)Popular Topics
Family Pack K issues thread 5172
Review of my Release 12 laptop 3113
CREATE_GRADE api returns:PLS-00306: wrong number o 3085
Log-on problems for existing users 2997
Creating hr jobs ORA-20001: HR_289477_JOB_GROUP_ID 2340
October UK-OUG? 1956
Viewing Output of another user 1887
uploading bank branches to PAYROLL 1850
Still trying to locate... 1836
Family Pack K 1822
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 Online   content
enthusiast

Registered: 15/03/05
Posts: 48
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
veteran
*****

Registered: 11/03/05
Posts: 886
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
_________________________
I'm blogging again - albeit sporadically
Also my random musings courtesy of Twitter

Top
Page 2 of 2 < 1 2


Moderator:  bcooper, CT 
March
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
Forum Stats
421 Members
48 Forums
1123 Topics
5227 Posts

Max Online: 15 @ 20/10/09 02:30 PM
Today's Birthdays
No Birthdays
Recent vacancies
Developer - Permanent - based in Bracknell
by Geoff_Dixon
Yesterday at 11:59 AM
Top Posters
bcooper 886
CT 751
Geoff_Dixon 340
delboy 255
SBi 249
vkumar 223
kp_rapolu 200
cbrookes 197
Gavin Harris 101
jhatten 95