My Oracle Support Banner

Can Not View Reference Numbers on Transaction Lines When Transaction has Many Lines with Many Reference Numbers (Doc ID 1905003.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Global Trade Management - Version 6.2.0 and later
Information in this document applies to any platform.


A Trade Transaction is created with multiple Trade Transaction Lines. Each Trade Transaction Line has less then 1000 Reference Numbers, however the total number of Reference Numbers for all the Trade Transaction Lines on the Trade Transaction sum up to over 1000. When the user edits a Trade Transaction Line the following message is presented under the Reference Number section:

"The number of records returned (1080) has exceeded the maximum configured limit of 1000."

Steps to replicate:

1. Navigate to Trade Compliance Management -> Trade Transaction Management -> Trade Transaction
2. Search for Transaction
3. Edit the Transaction
4. Go to Transaction Line tab
5. Edit a Transaction Line by clicking on one of the pencil icons
6 .Scroll down and you will see the following even though there are less than 1000 Refnums on this specific Line

The number of records returned (1080) has exceeded the maximum configured limit of 1000


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.