GL- Unable To Query The Values Added In The Balancing Segment Error Query has exceeded 500 rows. Potentially more rows exists, please restrict your query. (Doc ID 2200880.1)

Last updated on FEBRUARY 01, 2023

Applies to:

Goal

GL- Unable to Query the values added in the Balancing Segment
When trying to query a value added in the Balancing Segment in the Accounting Setup Manager, receive the following error message:
Warning
Query has exceeded 500 rows. Potentially more rows exists, please restrict your query.

The issue can be reproduced at will with the following steps:
1. GL responsibility
2. Accounting Setup Manager, Query the related Ledger
3. Update Balancing Segment Values

For checking the related Balancing Segment Values (BSV) assigned to Ledger or to Legal Entity level,
use the related ASM Diagnostic from the following Note 1643493.1 - R12: Accounting Setup Manager (ASM) Diagnostic

For example:
BSV Assignments at Legal Entity level.
926 rows selected.

Solution

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