Patch Fauadjsrc.sql Errors ORA-01422: Exact Fetch Returns More Than Requested Number Of Rows (Doc ID 1604750.1)

Last updated on JULY 20, 2017

Applies to:

Oracle Assets - Version 12.1.2 and later
Information in this document applies to any platform.
fauadjsrc.sql

Symptoms

Applying <Patch 17080568>:R12.FA.B Fixed Assets Recommended Patch Collection (RPC), September 2013

Or <Patch 20687418>:R12.FA.B R12.1: FIXED ASSETS RECOMMENDED PATCH COLLECTION, FEB 2015

Or <Patch 22485014>:R12.FA.B R12.1: FIXED ASSETS RECOMMENDED PATCH COLLECTION, FEB 2016

Or later RPCs

fauadjsrc.sql fails with
DECLARE
*
ERROR at line 1:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 136

Changes

Applied <Patch 17080568>:R12.FA.B Fixed Assets Recommended Patch Collection (RPC), September 2013

Or <Patch 20687418>:R12.FA.B R12.1: FIXED ASSETS RECOMMENDED PATCH COLLECTION, FEB 2015

Cause

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 hundreds of Community platforms