HR_IN_ASSIGNMENT_API Errors with: ORA-06502: PL/SQL: Numeric Or Value Error: Character To Number Conversion Error

(Doc ID 1428813.1)

Last updated on JANUARY 10, 2017

Applies to:

Oracle HRMS (India) - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.


When attempting to perform an assignment conversion using hr_in_assignment_api.update_emp_asg,  the following error occurs.

Entering: hr_in_assignment_api.update_emp_asg 10
Entering: hr_assignment_api.update_emp_asg 5
XXX hr_assignment_api.update_emp_asg/$Sys_Def$ 6
Entering: per_asg_bus1.return_legislation_code 10
Leaving: per_asg_bus1.return_legislation_code 20
Leaving: per_asg_bus1.return_legislation_code 30
INLOG: Entering: per_in_asg_leg_hook.check_asg_update 10
INLOG: Entering: per_in_asg_leg_hook.check_asg 10
INLOG: per_in_asg_leg_hook.check_asg 30
other err 11ORA-06502: PL/SQL: numeric or value error: character to number conversion error


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

1. Call HR_IN_ASSIGNMENT_API.update_in_emp_asg
2. The error occurs.



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