Unable To Complete Secondary Ledger Setup Options - Exception Raised: Query has exceeded 999 rows (Doc ID 2005617.1)

Last updated on NOVEMBER 08, 2015

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.
Add Secondary Ledger from Accounting Setup Manager process

Symptoms

Attempting to create Secondary Ledger for a Primary Ledger. After filling in all required fields on the Ledger Options page > click Finish > note the status of the 'Ledger's Options' remains 'In Progress'.
The users were able to create Secondary Ledgers for other ledgers successfully, status changed to 'Complete' as expected.

From Accounting Setups -Accounting Options page, can see the below error:
Warning: Query has exceeded 999 row. Potentially more rows exists, please restrict your query.

Trace log shows: 

Changes

 None

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms