My Oracle Support Banner

Mass Copy: ORA-01427: single-row subquery returns more than one row When Copying Reinstatement of Member Assets to Tax Book (Doc ID 2972458.1)

Last updated on NOVEMBER 09, 2023

Applies to:

Oracle Fusion Assets Cloud Service - Version 11.13.23.04.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to run Mass Copy, the following error occurs.

Error

Asset number XXXXX.
Transaction header ID XXXXXXX.
FA_GAINLOSS_UND_PKG.fa_reins_cost
ORA-01427: single-row subquery returns more than one row

The Mass Copy process couldn't be completed on this asset and transaction.


The failing transaction is a Reinstatement.  The asset is a member asset in the tax book but not in the corporate book.

Changes

 Group asset without tracking or ALLOCATE if using ALC-enabled book

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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