My Oracle Support Banner

When Executing API(HR_EX_EMPLOYEE_API.FINAL_PROCESS_EMP), "ORA-06502: PL/SQL: numeric or value error" Occurs (Doc ID 3068269.1)

Last updated on JANUARY 20, 2025

Applies to:

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

Symptoms

When executing the API(HR_EX_EMPLOYEE_API.FINAL_PROCESS_EMP), the following error occurs.

ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APPS.HR_EX_EMPLOYEE_API", line 2623
ORA-06512: at "APPS.PAY_US_TAX_INTERNAL", line 3541
ORA-06512: at "APPS.PER_US_EXTRA_REHIRE_RULES", line 23
ORA-06512: at "APPS.HR_EX_EMPLOYEE_BK2", line 68
ORA-06512: at "APPS.HR_EX_EMPLOYEE_API", line 2251
ORA-06512: at line 19
06502. 00000 - "PL/SQL: numeric or value error%s"
*Cause: An arithmetic, numeric, string, conversion, or constraint error
occurred. For example, this error occurs if an attempt is made to
assign the value NULL to a variable declared NOT NULL, or if an
attempt is made to assign an integer larger than 99 to a variable
declared NUMBER(2).
*Action: Change the data, how it is manipulated, or how it is declared so
that values do not violate constraints.

 

The issue can be reproduced at will with the following steps:

  1.  Execute the API(HR_EX_EMPLOYEE_API.FINAL_PROCESS_EMP).

    Sample script:
      

  2.  Error occurs.




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
References


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