My Oracle Support Banner

An Invalid Setup Has Been Detected For The Current Transaction Type In Approvals Management. ORA-06502: PL/SQL: numeric or value error: Character string buffer too small (Doc ID 1458422.1)

Last updated on AUGUST 16, 2018

Applies to:

Oracle Self-Service Human Resources - Version 12.1.3 and later
Information in this document applies to any platform.


After defining SIT and setting rules for using AME (SIT Approval), using a condition : WORKFLOW_PROCESS_NAME in (HR_SIT_JSP_PRC_04)

Action Type: Require approvals up to the first three superiors, at most.  the following error occurs after entering Special Information 'Joining Date After Leave'

Your changes have not been sent for approval because the following error occurred:
ORA-06502: PL/SQL: numeric or value error: Character string buffer too small


The test transaction error reported is:

The transaction ID specified returned an incorrect number of rows for AJBP_SUP_NEW_ID. Ensure you specify a valid transaction ID and the dynamic query of the attribute returns correct number of rows.


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

1.Click on the SIT function In SSHR , Fill the fields
2.Click on apply button
3.Click on Next button
4.Click on Submit button


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.