My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.