EAP: Data Conversion abended at Step UPG_AP.APC40.Step05 (SQL) -- ORA-01427: single-row subquery returns more than one row (Doc ID 1662398.1)

Last updated on MARCH 18, 2016

Applies to:

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

Symptoms

Upgrade script fails at Step UPG_AP.APC40.Step05 with an error

ERROR
SQL Error: ORA-01427: single-row subquery returns more than one row

Failed SQL stmt: UPDATE PS_AP_ARC_VCH_LN_H SET PS_AP_ARC_VCH_LN_H.PACKSLIP_NO = ( SELECT VH.PACKSLIP_NO FROM PS_AP_ARC_VOUCH_H VH WHERE VH.BUSINESS_UNIT = PS_AP_ARC_VCH_LN_H.BUSINESS_UNIT AND VH.VOUCHER_ID = PS_AP_ARC_VCH_LN_H.VOUCHER_ID) WHERE EXISTS ( SELECT 'X' FROM PS_AP_ARC_VOUCH_H VH WHERE VH.BUSINESS_UNIT = PS_AP_ARC_VCH_LN_H.BUSINESS_UNIT AND VH.VOUCHER_ID = PS_AP_ARC_VCH_LN_H.VOUCHER_ID)
Process 1769117 ABENDED at Step UPG_AP.APC40.Step05 (SQL) -- RC = 1427 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
PSAESRV completed service request at 01.33.06 2014-04-01

STEPS
1. Create a Voucher
2. Delete the Voucher
3. Execute the Archive process to load the tables, PS_AP_ARC_VCH_LN_H and PS_AP_ARC_VOUCH_H
4. Execute the SQL from Upgrade script UPG_AP.APC40.Step05
5. Above error will occur

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