My Oracle Support Banner

Unable To Update Employee Category Using 'hr_assignment_api.update_emp_asg' API (Doc ID 2598923.1)

Last updated on OCTOBER 21, 2019

Applies to:

Oracle Human Resources - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Application Programming Interface

When attempting to update employee category using an API hr_assignment_api.update_emp_asg',
the following error occurs.

ERROR
-----------------------
 "Value passed for Employee Category is invalid. Please check value is correct.”


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Written a script using API hr_assignment_api.update_emp_asg',
2. Example

DECLARE
  i_effective_date DATE := TO_DATE ('08-OCT-2018', 'DD-MON-YYYY');
  i_datetrack_update_mode VARCHAR2 (30) := 'CORRECTION';
  i_assignment_id NUMBER := 37871;
  l_obj NUMBER;
  io_cagr_grade_def_id NUMBER;
  o_cagr_concatenated_segments VARCHAR2 (240);
  o_concatenated_segments VARCHAR2 (240);
  o_comment_id NUMBER;
  o_effective_start_date DATE;
  o_effective_end_date DATE;
  o_no_managers_warning BOOLEAN;
  o_other_manager_warning BOOLEAN;
  o_hourly_salaried_warning BOOLEAN;
  o_gsp_post_process_warning VARCHAR2 (240);

  l_people_group_id NUMBER;
  l_object_version_number NUMBER;
  l_special_ceiling_step_id NUMBER;
  l_soft_coding_keyflex_id NUMBER;
  l_group_name VARCHAR2 (240);
  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 (240);
  l_tax_district_changed_warning BOOLEAN;
  l_concatenated_segments VARCHAR2 (240);
  l_projected_assignment_end DATE;
v_chr_err_msg VARCHAR2(10000) :=NULL;

  CURSOR csr_ovn
  IS
  SELECT MAX (object_version_number)
  FROM per_assignments_f
  WHERE assignment_id = i_assignment_id;
BEGIN
  OPEN csr_ovn;

  FETCH csr_ovn INTO l_obj;

  CLOSE csr_ovn;

  hr_assignment_api.update_emp_asg (
  p_effective_date => i_effective_date,
  p_datetrack_update_mode => i_datetrack_update_mode,
  p_assignment_id => i_assignment_id,
  p_object_version_number => l_obj,
  p_cagr_grade_def_id => io_cagr_grade_def_id,
  p_cagr_concatenated_segments => o_cagr_concatenated_segments,
  p_concatenated_segments => o_concatenated_segments,
  p_soft_coding_keyflex_id => l_soft_coding_keyflex_id,
p_employee_category => 'EXEMPT',
  p_comment_id => o_comment_id,
  p_effective_start_date => o_effective_start_date,
  p_effective_end_date => o_effective_end_date,
  p_no_managers_warning => o_no_managers_warning,
  p_other_manager_warning => o_other_manager_warning,
  p_hourly_salaried_warning => o_hourly_salaried_warning,
  p_gsp_post_process_warning => o_gsp_post_process_warning,
  p_assignment_number => 'HCM_TEST16');
  COMMIT;
  EXCEPTION
  WHEN OTHERS
  THEN
  
  DBMS_OUTPUT.put_line (
  ' Err ' || v_chr_err_msg || ' assignment API ');

  
END;
/
3. After executing the script getting above error.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot update employee category using an API.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.