My Oracle Support Banner

Journal Entry Reserve Ledger Report Completed In Error "REP-1401: 'period1formula': Fatal PL/SQL error occurred." (Doc ID 2999894.1)

Last updated on MARCH 21, 2024

Applies to:

Oracle Assets - Version 12.2.9 and later
Information in this document applies to any platform.


When running the Journal Entry Reserve Ledger Report for an Asset Book that is associated with a secondary ledger and has a Reporting Ledger as well, it fails with the following error, that is displayed in the concurrent request log file.


REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1401: 'period1formula': Fatal PL/SQL error occurred.
ORA-01422: exact fetch returns more than requested number of rows

The issue can be reproduced at will with the following steps:

1. Assets responsibility > Other > Requests > Run

2. Run Journal Entry Reserve Ledger Report

3. Request ends in Error status. Check the concurrent request log file where above error will be displayed.


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

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