My Oracle Support Banner

Error "JBO-27022: Failed to load value" When Viewing Next Page Of Absences Results (Doc ID 1124913.1)

Last updated on JANUARY 19, 2017

Applies to:

Oracle Self-Service Human Resources - Version 12.0.6 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.


Attempting to view next page with absences, the following error occurs:

Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.AttributeLoadException:
JBO-27022: Failed to load value at index 16 with java object of type java.lang.String due to java.sql.SQLException.
at oracle.apps.fnd.framework.OAException.wrapperException(
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(

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

1. Access manager self service
2. Select annual and other leave.
3. Select details for member of staff and progress through absence with next "10 option".
4. Error


To view full details, 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 a vibrant support community of peers and Oracle experts.