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 MARCH 08, 2017

Applies to:

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

Symptoms

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

Cause

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