SFO9.2: Subquery Returned More Than 1 Value Error While Applying PUM 17 On FSCM 9.2

(Doc ID 2117131.1)

Last updated on JULY 11, 2016

Applies to:

PeopleSoft Enterprise FIN Staffing Front Office - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When applying PUM 17 of FSCM 9.2, it fails at the step Run Data Conversion AE - DCFO21633131.

Steps:
--------
1) Apply FSCM 9.2 Image 17.
2) Run data conversion AE - DCFO21633131.


Error:
---------

[Microsoft][SQL Server Native Client 11.0][SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
[Microsoft][SQL Server Native Client 11.0][SQL
Failed SQL stmt: UPDATE PS_FO_AGENDA_DTL SET USERID = COALESCE((SELECT PS_FO_SVC_CAT_TBL.USERID FROM PS_FO_EVENTS_SETUP , PS_FO_SVC_CAT_TBL WHERE PS_FO_EVENTS_SETUP.EVENT = 'TMP' AND PS_FO_EVENTS_SETUP.EVENT_CATEGORY = PS_FO_SVC_CAT_TBL.EVENT_CATEGORY AND PS_FO_SVC_CAT_TBL.SERVICE_GROUP_ID = PS_FO_AGENDA_DTL.OPRID AND PS_FO_EVENTS_SETUP.EVENT_TYPE = PS_FO_AGENDA_DTL.EVENT_TYPE), ' ') WHERE PS_FO_AGENDA_DTL.USERID = ' ' AND EXISTS ( SELECT 'X' FROM PS_FO_SVC_GRP_TBL WHERE PS_FO_SVC_GRP_TBL.SERVICE_GROUP_ID = PS_FO_AGENDA_DTL.OPRID)


When Database is Oracle, Error is - ORA-01427: single-row subquery returns more than one row.

Cause

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