My Oracle Support Banner

Subledger Accounting Hot Patch Failing With ORA-01427: Single-Row Subquery Returns More Than One Row (Doc ID 1613213.1)

Last updated on MARCH 30, 2016

Applies to:

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

Symptoms

The Subledger Accounting (SLA) hotpatch upgrade is failing with the following error:

ERROR at line 1:
ORA-01427: single-row subquery returns more than one row
ORA-06512: at line 70

Script ar120girpu_failure_action_plan_ver2.sql identifies the issue and there are lots of issues under section:
'Display the GL journals having reference to duplicate gl_sl_link_id in SLA journals'

MFAR accounting is used in 11i (PSA accounting) and MFAR in R12 as well.

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.