My Oracle Support Banner

Asset Cost and Reserve Report: ORA-06512 Line 1653 ORA-01422 Errors for Asset Book with Same Currency for Primary and Reporting Ledgers (Doc ID 2877409.1)

Last updated on JUNE 24, 2022

Applies to:

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

Symptoms

The Asset Cost and Reserve Report fails when run for ALC asset book with reporting ledger currency the same as the primary ledger.

The errors seen in the engine log when running the report via the data model in BI are:

BEGIN l_flag := FA_ASSET_SUMM_RPT_PKG.BEFOREREPORT ;if (l_flag) then
:XDO_OUT_PARAMETER := 1; end if; end;
[2022-06-03T16:56:35.726+00:00][dp id:2000810600][sch
info:]java.sql.SQLException: ORA-01422: exact fetch
returns more than requested number of rowsORA-06512: at
"FUSION.FA_ASSET_SUMM_RPT_PKG", line 1653
ORA-06512: at line 4at
oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:510)
...
...

BEGIN l_flag := FA_ASSET_SUMM_RPT_PKG.BEFOREREPORT ;if (l_flag) then
:XDO_OUT_PARAMETER := 1; end if; end; , Error Msg = ORA-01422: exact fetch
returns more than requested number of rowsORA-06512: at
"FUSION.FA_ASSET_SUMM_RPT_PKG", line 1653
ORA-06512: at line 4
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:514)...

 

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
References


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