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 laterInformation 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 |