My Oracle Support Banner

Initial Mass Copy Fails with: ORA-01422: exact fetch returns more than requested number of rows (Doc ID 2643536.1)

Last updated on MARCH 31, 2020

Applies to:

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

Symptoms

When attempting to run Initial Mass Copy for new tax books,
the following error occurs.

Error
FA.PLSQL.fa_masscp_pkg.process_lines: l_transaction_type_code(l_loop_count) has the value of ADDITION
FA.PLSQL.fa_masscp_pkg.process_lines: l_tax_thid(l_loop_count) has the value of
fa_cache_pkg.fazccbd
ORA-01422: exact fetch returns more than requested number of rows
fa_cache_pkg.fazccbd
fa_masscp_pkg.mcp_addition
fa_masscp_pkg.process_lines

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
Cause
Solution


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