Error "single-row subquery returns more than one row" when accessing Oracle Applications Endpoint.

Products

• CA Identity Suite

Issue/Introduction

Below error was seen in the jcs_daily log when trying to access the Oracle endpoint:

2025-07-01 06:33:12,991 76867683 [ApacheDS Worker-thread-37] (com.ca.jcs.core:com.ca.jcs.osgi.persistence.CoreFileConnectorPersister:255) INFO   - No Connector was found to be deleted: eTFNDDirectoryName=ORAPRD,eTNamespaceName=Oracle Applications,dc=post,dc=etasa
2025-07-01 06:33:12,991 76867683 [ApacheDS Worker-thread-37] (com.ca.jcs.core:com.ca.jcs.osgi.exchange.router.MessageRouter:551) ERROR  - A remote server returned an error: org.apache.directory.shared.ldap.exception.LdapNamingException: JCS@posap023: JNDI: Failed to activate connector on proxy connector server: [LDAP: error code 1 - Error executing "SELECT (SELECT USER_ID FROM APPLSYS.FND_USER WHERE USER_NAME = UPPER(?)) USER_ID, (SELECT APPLICATION_ID FROM APPLSYS.FND_APPLICATION WHERE APPLICATION_SHORT_NAME = UPPER(?)) APPLICATION_ID, (SELECT RESPONSIBILITY_ID FROM APPLSYS.FND_RESPONSIBILITY WHERE  RESPONSIBILITY_KEY = UPPER(?) AND   APPLICATION_ID = (SELECT APPLICATION_ID FROM APPLSYS.FND_APPLICATION WHERE APPLICATION_SHORT_NAME = UPPER(?))) RESPONSIBILITY_ID, (SELECT SECURITY_GROUP_ID FROM APPLSYS.FND_SECURITY_GROUPS WHERE SECURITY_GROUP_KEY = UPPER(?)) SECURITY_GROUP_ID FROM DUAL": [Oracle][ODBC][Ora]ORA-01427: single-row subquery returns more than one row

Environment

Identity Manager 14.5
Database version: 19.25.0.0.0
Oracle Applications version: R12.10

Cause

Starting with AD & TXK Delta 8, a new feature "Enhanced Seed Data Management" is introduced that greatly increases the speed and efficiency with which seed data is synchronized as part of an online patching cycle. This is the Dual Row Set Seed Data Synchronization model. With this change, the ZD_EDITION_NAME column for the Seed Data Tables will be replaced by "SET1" or "SET2". In this particular case the base table APPLSYS.FND_SECURITY_GROUPS was updated (any DML operation) during the ECC patch application process which resulted in introduction of the new row  in the base table while the SYNONYM of the table which resides in the APPS schema contains single row.

Resolution

The solution is to manually update the eTFNDDirFndAdminDbName value to APPS (instead of APPLSYS) - APPS and APPLSYS use the same password, so no need to update credentials.

This update or change from APPLSYS to APPS can also be done in the Identity Manager User Console. We need to update the value of 'Administrative Database Name' to APPS.