Patch Application Error: Running arhmcaru.sql Fails with ORA-1427: single-row subquery returns more than one row (Doc ID 1071980.1)

Last updated on AUGUST 24, 2016

Applies to:

Oracle Receivables - Version 12 and later
Information in this document applies to any platform.

Symptoms

You are attempting to apply <Patch 7303033>, it fails with the following error:

ERROR
-----------------------
sqlplus -s APPS/*****
  @/applprod/R12/appltop/ar/12.0.0/patch/115/sql/arhmcaru.sql &un_ar &batchsize 7 16
declare
*
ERROR at line 1:
ORA-1427: single-row subquery returns more than one row
ORA-6512: at line 50

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