4 Replies Latest reply: May 8, 2014 11:12 PM by Narpalan RSS

    Error in Custom Employee Number Generation Formula

    NEWHCM

      Hi,

      we have implemented a custom employee number generation  through FF- EMP_NUMBER_GENERATION.

      we are using R12.1.3  and For Saudi Arabian Legislation.

      i have defined the custom package to generate the sequence to meets the customer requirements.

      I have define the FF:

       

      DEFAULT FOR Person_Number IS ' '

      DEFAULT FOR Party_ID IS 0

      DEFAULT FOR Person_ID IS 0

      DEFAULT FOR National_ID IS ' '

      DEFAULT FOR DATE_OF_BIRTH IS '1900/01/01 00:00:00' (date)

      DEFAULT FOR Hire_Date IS '1900/01/01 00:00:00' (date)

       

       

      INPUTS ARE

      Legislation_Code (text),

      Person_Type (text),

      Person_number (text),

      Party_id,

      Person_id,

      Date_of_birth (date),

      Hire_date (date),

      National_ID (text)

       

       

      Next_Number = '0'

      Invalid_msg = ' '

       

       

      IF Person_Type = 'EMP' then

      Next_Number = GET_CUSTOM_EMP_NUMBER(Legislation_Code,Person_Type,Person_Number,Party_Id,Person_Id,National_ID,Date_Of_Birth,hire_date)

      Else

      Invalid_msg = 'This is not an person_type of Employee!'

       

       

      Return Next_Number

       

      /*****************************************************************************************/

       

      while creating the new employees , i am getting this error:

       

      APP-PER-449943:The Definition of the  Person Number Generation Fast Formula is Incorrect.

       

       

      Please can anyone  provide the solution for the above error..  your early response will be highly appreciated.

       

      Thanks

      Mohsin