Can Not Use "View and Update" Icon on Assigment Set Name over 30 character of Manage Assignment Set
(Doc ID 2410580.1)
Last updated on MAY 25, 2019
Applies to:Oracle Payroll - Version 12.2.7 to 12.2 HRMS RUP12 [Release 12.2]
Information in this document applies to any platform.
When accessing "Manage Assignment Set" and use the icon "View and Update" on Assignment Set Name which is over 30 character , the following error occurs.
Click here for exception details
If we click the above here link, here are more details error.
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-12899:
value too large for column "HR"."PAY_BATCH_HEADERS"."BATCH_NAME" (actual: 36,
ORA-06512: at "APPS.HR_ASSIGNMENT_SETS_SS_PKG", line 634
ORA-06512: at line 1
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
- Accesss Manage Assignment Set
- Search assignment set whose name is over 30 character
- Click the icon of "View and Update"
- The error occurs
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