My Oracle Support Banner

Worker HDL file Cancelling Work Relationships returns error PL/SQL: numeric or value error: character string buffer too small (Doc ID 2755442.1)

Last updated on APRIL 23, 2021

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version and later
Oracle Fusion Global Payroll Cloud Service - Version to [Release 1.0]
Information in this document applies to any platform.


On : version, Data Load

When attempting to load attached Worker HDL file to cancel Work Relationships for a large number of employees, the following error occurs.

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

When submitting the load again, the load success increases a lit bit. below are the last tries of the same file which had the following status

% Loaded - Errors
16% - ~8000 errors
36% - 6219 errors
38% - 5840 errors
41% - 5595 errors
43% - 5350 errors
50% - 4741 errors
54% - 4298 errors
59% - 3863 errors
63% - 3438 errors
63% - 3419 errors

The issue can be reproduced at will with the following steps:
1. Load Worker HDL file
2. Encounter error message above
3. submit same Worker HDL file multiple times and note that the number of errors decrease with each subsequent load


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

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