Spain NIF Validation - Errors Ora-06502:PL/SQL , Works in Professional User Interface (PUI)

(Doc ID 2228294.1)

Last updated on FEBRUARY 06, 2018

Applies to:

Oracle HRMS (Spain) - Version 12.2.4 and later
Information in this document applies to any platform.


When attempting to Hire employees in the Spain Business Group the following error occurs.

ORA-06502: PL/SQL: numeric or value error:  character string buffer too small

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

1. XX Manager Self Service
2. Hire
3. Enter required data and 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