ORA-20001: Employment category is not valid for Italian employment Category (Doc ID 1957425.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

When trying to update employee assignment in Italy business group using hr_assignment_api.update_emp_asg_criteria
get following error :

ERROR
----------------------------------
ORA-20001: Employment category is not valid

WHAT IS WORKING
----------------------------------
only face issue in Italy legislation, other legislations have no problem
can update employment category for Italy business group employee through forms without error


STEPS TO REPRODUCE
----------------------------------
Use responsibility : na
Navigation :na
use below code to update assignment
DECLARE
x_object_version_number NUMBER :=12;
x_special_ceiling_step_id NUMBER;
x_people_group_id NUMBER;
x_soft_coding_keyflex_id NUMBER;
x_group_name VARCHAR2 (2000);
x_effective_start_date DATE;
x_effective_end_date DATE;
x_org_now_no_manager_warning BOOLEAN;
x_other_manager_warning BOOLEAN;
x_spp_delete_warning BOOLEAN;
x_entries_changed_warning VARCHAR2 (2000);
x_tax_district_changed_warning BOOLEAN;
x_concatenated_segments VARCHAR2 (2000);
x_gsp_post_process_warning VARCHAR2 (2000);

BEGIN
hr_assignment_api.update_emp_asg_criteria
  (p_effective_date => TO_DATE('01/01/2013','MM/DD/YYYY'),
  p_datetrack_update_mode => 'CORRECTION',
  p_assignment_id => 11965,
  p_validate => TRUE,
  p_called_from_mass_update => FALSE,
  p_grade_id => 726,
  p_position_id => NULL,
  p_job_id => 11998,
  p_payroll_id => 116,
  p_location_id => 385,
  p_organization_id => 672,
  p_pay_basis_id => 95,
  p_segment1 => NULL,
  p_segment2 => NULL,
  p_segment3 => NULL,
  p_segment4 => NULL,
  p_segment5 => NULL,
  p_segment6 => NULL,
  p_segment7 => NULL,
  p_segment8 => NULL,
  p_segment9 => NULL,
  p_segment10 => NULL,
  p_employment_category => 'IT_FULL_NORMAL',
  p_object_version_number => x_object_version_number,
  p_special_ceiling_step_id => x_special_ceiling_step_id,
  p_people_group_id => x_people_group_id,
  p_soft_coding_keyflex_id => x_soft_coding_keyflex_id,
  p_group_name => x_group_name,
  p_effective_start_date => x_effective_start_date,
  p_effective_end_date => x_effective_end_date,
  p_org_now_no_manager_warning => x_org_now_no_manager_warning,
  p_other_manager_warning => x_other_manager_warning,
  p_spp_delete_warning => x_spp_delete_warning,
  p_entries_changed_warning => x_entries_changed_warning,
  p_tax_district_changed_warning => x_tax_district_changed_warning,
  p_concatenated_segments => x_concatenated_segments,
  p_gsp_post_process_warning => x_gsp_post_process_warning
  );
EXCEPTION WHEN OTHERS
  THEN
  DBMS_OUTPUT.PUT_LINE('Error in Calling API'||SQLERRM);
END;





Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms