Hi all

I'm trying to build a data load using the hr_employee_api.create_gb_employee. As the business_group_id is mandatory, I want to pick it up from the user session that is running the load (could be different business groups).

I tried the following:

SQL> exec fnd_global.apps_initialize(24678,20536,800);

PL/SQL procedure successfully completed.

SQL> select fnd_profile.value('PER_BUSINESS_GROUP_ID')
2 from dual;

FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
-----------------------------------------------------------
0

Problem is, business_group_id should be 41, not 0.

Anybody got any suggestions on where to start looking?

We are on 11.5.8, and are using security profiles. I have run security list maintenance.

Thanks

Alex

Fixed it. Was missing the security group profile parameter in the apps_initialize function.