Hi

I have got an issue where the employees created by data pump are all being created with a default value, even though we have different user person types for the respective employee records.

Eg : User person Types
Permanent
Fixed Term
Casual
etc

Data Pump call
hrdpp_create_gb_employee.insert_batch_lines
(p_batch_id => l_batch_id
,p_user_sequence => NULL
....
....
,p_user_person_type => emp.user_person_type)

Note that the user_person_type is passed from the source data and I can see different values in the hr_pump_batch_lines_table in column pval113.

On further investigation, I noticed that the key value is resolved by a call to hr_pump_get.get_person_type_id from within the data pump api.

Still teh values in the application appear to default to "Permanent".

Any ideas?? Thanks for your help

Vin

Hello Vin

What's in the person type usages table for these emps? If you're looking at the person_type_id on the per_all_people_F table, it always puts the 'EMP' person_type_id in there. The real story is contained in the PER_PERSON_TYPE_USAGES table.

Just a thought...

We have a similar issue in HR Self Service New Hire. We tried to default the User Person Type in Self Service to be 'Contractor' and although the default is 'Employee'. For a number of reasons we are not using Contingent Worker.

When reviewing the change is showed as the new Person Type 'Contractor', but when the HR record is created the person type is the default i.e. 'Employee'.

Raised a SR with Oracle, but they say this is expected functionality! I think it is a bug, but Oracle has said it is an enhancement. My guess is SSHR uses the same API when committing.

Not much help really, but we have the same or similar problem. Please let us know if you find a resolution.

yes, found the quirk in data pump.

Need to pass p_language_code = 'US' because

hr_pump_get.get_person_type_id actually uses the following cursor to get the id and all the values in the per_person_types_tl have 'US' in the language column. So if this is null, the api defaults it to "Permanent"

select typ.person_type_id
into l_person_type_id
from per_person_types_tl typtl,
per_person_types typ
where typtl.user_person_type = p_user_person_type
and typ.business_group_id + 0 = p_business_group_id
and typ.person_type_id = typtl.person_type_id
and typtl.LANGUAGE = p_language_code;

On passing p_language_code=>'US' in hrdpp_create_gb_employee.insert_batch_lines everything works fine

Cheers
Vin