You are not logged in. [Log In] HRMS Aces - The Online HRMS Community » Forums » Apps Technical » Data Conversion / Data Migration » Correcting PERSON_TYPE_ID in per_all_people_f
Register User    Forum List        Calendar     Active Topics     FAQ
Who's Online
0 registered (), 0 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Recent Posts
Irecruitment
by spiro
18/03/10 03:21 PM
Appraisal Session Timeout
by spiro
17/03/10 07:48 PM
Heres a simple question on Workflow then ..
by bcooper
17/03/10 09:54 AM
Defaulting PO Information on assignment screen
by bcooper
17/03/10 09:52 AM
Creating an Attachment Table or Attachment Link
by Sahir
16/03/10 02:35 PM
OLM - Custom Role based on the 'Data Security'
by Geoff_Dixon
15/03/10 03:28 PM
E-Bus Configuration and Management
by PeterP
11/03/10 01:28 PM
UMX : Oracle User Management Application
by natkins
11/03/10 12:58 PM
HRMS organization structures
by Geoff_Dixon
11/03/10 11:53 AM
HR_PF.K RUP4
by bcooper
10/03/10 06:50 PM
Top Posters (30 Days)
CT 19
bcooper 18
natkins 16
delboy 16
MarinaH 12
SBi 10
gaztorres 8
Geoff_Dixon 8
kp_rapolu 4
Gus 4
(Views)Popular Topics
Family Pack K issues thread 5207
Review of my Release 12 laptop 3134
CREATE_GRADE api returns:PLS-00306: wrong number o 3123
Log-on problems for existing users 3014
Creating hr jobs ORA-20001: HR_289477_JOB_GROUP_ID 2392
October UK-OUG? 1998
Viewing Output of another user 1924
uploading bank branches to PAYROLL 1877
Still trying to locate... 1855
Family Pack K 1841
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: 50
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: 890
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
422 Members
48 Forums
1129 Topics
5248 Posts

Max Online: 15 @ 20/10/09 02:30 PM
Today's Birthdays
No Birthdays
Recent vacancies
Oracle HRMS Consultants needed! Perm £70k!
by Shaylan
18/03/10 11:33 AM
Developer - Permanent - based in Bracknell
by Geoff_Dixon
11/03/10 11:59 AM
Perm Positions 1 x HR and 1 x Payroll
by bfrost
10/03/10 05:35 PM
Top Posters
bcooper 890
CT 752
Geoff_Dixon 343
delboy 255
SBi 249
vkumar 223
kp_rapolu 203
cbrookes 197
Gavin Harris 101
jhatten 95
Privacy statement · Board Rules · Mark all read
Contact Us · HRMS Aces - The Online HRMS Community · Top