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 DECEMBER 03, 2019
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
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:
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
BSV Assignments at Legal Entity level.
926 rows selected.
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