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

Last updated on JANUARY 31, 2017

Applies to:

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

Goal

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

Exception Details.
oracle.apps.fnd.framework.OAException:
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.

 

Solution

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