Error ORA-06502: PL/SQL: numeric or value error: character string buffer too small reported with Submitted Timecards at Workflow Level
(Doc ID 2868097.1)
Last updated on MAY 13, 2022
Applies to:
Oracle Time and Labor - Version 12.2.6 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.6 version, Timecard Approval
When attempting to Submit Timecard,
the following error occurs.
ERROR
-----------------------
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
HCAPPRWF.hxc_approval_wf_pkg.create_appl_period_info(HXCEMP, 9976027,1195734, RUN, 130 approval style_id=3021)
Wf_Engine_Util.Function_Call(HXC_APPROVAL_WF_PKG.create_appl_period_info,HXCEMP, 9976027, 1195734, RUN)
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Login to Self Service Time
2.Create and submit the Timecards
3.Timesheets are getting into the error status in the workflow level.
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 |