Home » Applications » Oracle Fusion Apps & E-Business Suite » Can we use data fix to update employee location (Oracle 12.2.8)
Can we use data fix to update employee location [message #686088] Thu, 09 June 2022 14:11 Go to next message
mohan.oracle42@gmail.com
Messages: 7
Registered: April 2021
Junior Member
Hi Team,

My client office shifted from one place to another place now need change employee location.

I'm trying to use following API, can i use DATAFIX to update location instead of using API.

HR_ASSIGNMENT_API.UPDATE_EMP_ASG_CRITERIA (
p_effective_date =>sysdate
,p_datetrack_update_mode =>'CORRECTION'
,p_assignment_id =>8672
,p_validate => FALSE
,p_called_from_mass_update => FALSE --Added By me because there are 3 API with same name but current one using this
,p_grade_id =>l_grade_id
,p_position_id =>l_position_id
,p_job_id =>68
,p_location_id =>78364
,p_organization_id =>0
,p_people_group_id =>l_people_group_id
,p_object_version_number =>l_object_version_number
,p_special_ceiling_step_id =>l_special_ceiling_step_id
,p_group_name =>l_group_name
,p_effective_start_date =>l_effective_start_date
,p_effective_end_date =>l_effective_end_date
,p_org_now_no_manager_warning =>l_org_now_no_manager_warning
,p_other_manager_warning =>l_other_manager_warning
,p_spp_delete_warning =>l_spp_delete_warning
,p_entries_changed_warning =>l_entries_changed_warning
,p_tax_district_changed_warning =>l_tax_district_changed_warning);
Re: Can we use data fix to update employee location [message #686089 is a reply to message #686088] Fri, 10 June 2022 00:57 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
When you say "can i use DATAFIX to update location" what do you mean? I cannot see any reason why Oracle would write a data fix patch for this. Of course you could make the change with SQL*Plus, but that would not be supported and you would have to be sure that there are no side effects.
What is the problem with doing it through the API?
Re: Can we use data fix to update employee location [message #686096 is a reply to message #686089] Fri, 10 June 2022 05:20 Go to previous messageGo to next message
mohan.oracle42@gmail.com
Messages: 7
Registered: April 2021
Junior Member
Hi,

having some challenge to provide all the values.

I've provided all the values but when i execute getting following error.

Error report -
ORA-20001: System Error: Procedure at Step 40

Cause: The procedure has created an error at Step 40.

Action: Contact your system administrator quoting the procedure and Step 40.
ORA-06512: at "APPS.HR_ASSIGNMENT_API", line 17464
ORA-06512: at "APPS.HR_ASSIGNMENT_API", line 15757
ORA-06512: at "APPS.HR_ASSIGNMENT_API", line 15542
ORA-06512: at line 19

Re: Can we use data fix to update employee location [message #686097 is a reply to message #686096] Fri, 10 June 2022 06:24 Go to previous messageGo to next message
mohan.oracle42@gmail.com
Messages: 7
Registered: April 2021
Junior Member
Did i've missed anything in the following api getting above error.

Declare
l_people_group_id number;
l_object_version_number number:=39;
l_special_ceiling_step_id number;
l_group_name varchar2(500);
l_effective_start_date date;
l_effective_end_date date;
l_org_now_no_manager_warning boolean;
l_other_manager_warning boolean;
l_spp_delete_warning boolean;
l_entries_changed_warning varchar2(500);
l_tax_district_changed_warning boolean;
l_called_from_mass_update boolean;
l_grade_id number;
l_payroll_id number;
l_pay_basis_id number;
BEGIN
HR_ASSIGNMENT_API.UPDATE_EMP_ASG_CRITERIA (
p_effective_date =>sysdate
,p_datetrack_update_mode =>'CORRECTION'
,p_assignment_id =>8672
,p_validate => FALSE
,p_called_from_mass_update => FALSE
,p_grade_id =>null --20001 --Need to know
,p_position_id =>null--23664 --need to know
,p_job_id =>68
,p_location_id =>78364
,p_organization_id =>0 --need to know
,p_people_group_id =>l_people_group_id
,p_object_version_number =>l_object_version_number
,p_special_ceiling_step_id =>l_special_ceiling_step_id
,p_group_name =>l_group_name
,p_effective_start_date =>l_effective_start_date
,p_effective_end_date =>l_effective_end_date
,p_org_now_no_manager_warning =>l_org_now_no_manager_warning
,p_other_manager_warning =>l_other_manager_warning
,p_spp_delete_warning =>l_spp_delete_warning
,p_entries_changed_warning =>l_entries_changed_warning
,p_tax_district_changed_warning =>l_tax_district_changed_warning);
end;
Re: Can we use data fix to update employee location [message #686098 is a reply to message #686097] Fri, 10 June 2022 07:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Indent the code, make sure that lines of code do not exceed 100 characters.

Re: Can we use data fix to update employee location [message #686101 is a reply to message #686097] Fri, 10 June 2022 08:41 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I am not familiar with that particular API. However, I would think that if you are not supplying the correct org ID it will not work. I don't think any of the APIs will work without a valid org ID.
Re: Can we use data fix to update employee location [message #686103 is a reply to message #686088] Fri, 10 June 2022 10:17 Go to previous messageGo to next message
Alien
Messages: 289
Registered: June 1999
Senior Member
Hi,

also, is there a reason you need to do this with an API or SQL? Why not update it through the application, and save yourself the trouble of finding the right values?
As John mentioned, the API will need a valid org id, and also a valid position_id.

Regards,

Arian
Re: Can we use data fix to update employee location [message #686113 is a reply to message #686103] Sat, 11 June 2022 11:28 Go to previous messageGo to next message
mohan.oracle42@gmail.com
Messages: 7
Registered: April 2021
Junior Member
Hi Arian,

We are having 300+ employees to updated from application it will take time to update manually.

I've taken one employee and trying to pass values to the API but not able to find Grade ID, position ID and Organization ID from the assignment from.

Thanks,
Mohan Reddy.
Re: Can we use data fix to update employee location [message #686114 is a reply to message #686113] Sat, 11 June 2022 11:34 Go to previous messageGo to next message
Alien
Messages: 289
Registered: June 1999
Senior Member
Hi Mohan,

ok. All the fields are in per_all_assignments_f (organization_id, position_id and grade_id). So a query on this table with the list of person_id's should be enough to supply the values for the API.
That is assuming that the location_id is the only change. If they are also moving to a different organization, you'll have a more complex query to build.

Regards,

Arian
Re: Can we use data fix to update employee location [message #686120 is a reply to message #686114] Mon, 13 June 2022 07:27 Go to previous messageGo to next message
mohan.oracle42@gmail.com
Messages: 7
Registered: April 2021
Junior Member
Hi Arian,

I don't see any values for postion_ID,grade_id and Organization_ID for the respective Person hence i'm unable to pass into the API.

Only location change there is no other change, please advise.

Thanks,
Mohan Reddy
  • Attachment: Capture.JPG
    (Size: 27.96KB, Downloaded 1218 times)
Re: Can we use data fix to update employee location [message #686122 is a reply to message #686120] Mon, 13 June 2022 14:54 Go to previous messageGo to next message
Alien
Messages: 289
Registered: June 1999
Senior Member
Hi Mohan,

ok, you're not using positions and payroll then. I checked your original post and the error message.
What is your eBS version?

MOS Note: 1945587.1 mentions the same error, related to the People Group Keyflexfield.
The note is not clear on the relation with the people_group_id. So you can try using the people_group_id in your API-call.

If you're on 12.1 you can check the mentioned patch or the setup of the People Group Keyflexfield.

Regards,

Arian
Re: Can we use data fix to update employee location [message #686124 is a reply to message #686122] Tue, 14 June 2022 13:21 Go to previous message
mohan.oracle42@gmail.com
Messages: 7
Registered: April 2021
Junior Member
Hi Arian,

Thanks for your suggestion, we are using 12.2.8 version.

I'll try to enable KFF as suggested and come back to you.

Thanks,
Mohan Reddy.
Previous Topic: Oracle Workflow
Next Topic: Paid salary by check
Goto Forum:
  


Current Time: Thu Mar 28 08:12:53 CDT 2024