Subledger Accounting: Hot Patch fails ORA-01427: Single-Row Subquery Returns More Than One Row Error in ar120girpu.sql (Doc ID 1075949.1)

Last updated on MARCH 30, 2016

Applies to:

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

Symptoms

Run the SLA Post Upgrade Process 'SLA hot patch' to upgrade historical data. Process fails with:

ORA-01427: single-row subquery returns more than one row error in ar120girpu.sql

Changes

Upgrading from 11.5 to R12

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