My Oracle Support Banner

Receiving Unexpected Error in Self Service Benefits (Doc ID 559458.1)

Last updated on JULY 08, 2024

Applies to:

Oracle Advanced Benefits - Version and later
Information in this document applies to any platform.


When attempting to update benefit enrollments in Self-Service, the following error occurs:

Exception Details.
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.

## Detail 0 ##
java.sql.SQLException: ORA-01427: single-row subquery returns more than one row

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

1. Go to responsibility Employee Self-Service and select the Benefits function.
2. Continue to the Update Benefits page and attempt to make benefit election changes.
Error occurs.

The person had one contact with both a Spouse Relationship Type and an Emergency Contact type.



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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.