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.
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.
Changes
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!