5 Replies Latest reply: Dec 28, 2012 12:17 AM by 978959 RSS

    Create position api error

    978959
      Hi All,
      I am using create position api but ut is giving me following error "Flex ID does not exist' although ,i have defined all the values in the value set.Below is the code:


      DECLARE


      v_out_position_id NUMBER NULL;
      v_out_effective_start_date DATE;
      v_out_effective_end_date DATE:= TO_DATE ('31-Dec-4712');
      v_out_object_version_number1 NUMBER:= NULL;
      v_out_object_version_number2 NUMBER:= NULL;
      v_valid_grade_id NUMBER:= NULL;
      v_in_out_position_def_id NUMBER:= NULL;
      v_in_out_name VARCHAR2(200):= NULL;





      BEGIN --8.
      hr_position_api.create_position
      (p_position_id => v_out_position_id,
      p_effective_start_date => v_out_effective_start_date,
      p_effective_end_date => v_out_effective_end_date,
      p_position_definition_id => v_in_out_position_def_id,
      p_name => v_in_out_name,
      p_object_version_number => v_out_object_version_number1,
      p_pay_basis_id => 88,
      p_job_id => 23546,
      p_permanent_temporary_flag => 'Y',
      p_organization_id => 9324,
      p_effective_date => to_date('01-Jan-1960'),
      p_date_effective => to_date('01-Jan-1960'),
      p_validate => FALSE,
      p_availability_status_id => 1,
      p_business_group_id => 9035,
      p_location_id => 13658,
      p_position_type => 'NONE',
      p_segment1 => 'Country Manager',
      p_segment2 => 9324,
      p_pay_freq_payroll_id => 105
      );

      END;


      here country manager is already defined in value set but still it is giving me ORA-20001: FLEX-ID DOES NOT EXIST:
      ORA-06512: at "APPS.HR_POSITION_API", line 2978
      ORA-06512: at line 18 these errors.

      quick help wd b much appreciated.

      regards
      akash