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 FEBRUARY 21, 2019

Applies to:

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


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.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.