My Oracle Support Banner

R12 GDF patch script ap_sync_match_type_fix.sql error Unhandled Exception, -1427-ORA-01427: single-row subquery returns more than one row (Doc ID 1992870.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version 12.0.0 to 12.2.4 [Release 12.0 to 12.2]
Information in this document applies to any platform.


When running the fix script delivered by the GDF Patch documented in Note 1906407.1, the following error occurs:

Encountered an Unhandled Exception, -1427-ORA-01427: single-row subquery
returns more than one row in Generic Data Fix Script
(ap_sync_match_type_fix.sql) while performing Step 3.1: Validating
Application User Name and Responsibility. : Data-Fix Failed.
Undone changes and driver table rows process_flag reset to E

Steps to reproduce
Follow the steps from Note 1906407.1.
The error occurs after running step 4.

Business impact
The business cannot process off the transactions, potentially leading to period close / reporting issues.


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.