My Oracle Support Banner

Workflow Error when Submitting Timecard: ORA-06502: PL/SQL: Numeric or Value Error: Character String Buffer Too Small (Doc ID 2859522.1)

Last updated on MAY 13, 2022

Applies to:

Oracle Time and Labor - Version 12.2.10 and later
Information in this document applies to any platform.

Symptoms

When submitting timecards with large number of projects and having the same manager, the OTL Workflows for Employees (HXCEMP) encounteres the following error in the workflow form:




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

1. Using Workflow Administrator Web Application responsibility

2. Navigate to Administrator Workflow > Status Monitor

3. Check for Workflow Type "OTL Workflows for Employees"

4. Employee workflow HXCEMP is in error.


Changes

 Customer applied Patch 32836146:R12.HXT.C 1OFF:32717486:3146: COMMIT HAPPENED IN ACT WF NOTIFICTNS NOT TRIGERD but it did not resolve issue.

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
Changes
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.