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

Last updated on MARCH 24, 2017

Applies to:

Oracle General Ledger - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Update Balancing Segment Values

Goal

GL- Unable to Query the values added in the Balancing Segment
Trying to query a value added in the Balancing Segment in the Accounting Setup Manager.


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

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