My Oracle Support Banner

GTM Declaration SmartLink 'View Related Trade Transactions' Fails With Error 'ORA-01795: maximum number of expressions in a list is 1000' (Doc ID 2757270.1)

Last updated on JUNE 01, 2023

Applies to:

Oracle Customs Management - Version 6.4.3 and later
Oracle Global Trade Management - Version 6.4.3 and later
Oracle Trade Compliance - Version 6.4.3 and later
Oracle Global Trade Management Cloud Service - Version 21.1 and later
Oracle Trade Compliance Cloud Service - Version 21.1 and later
Information in this document applies to any platform.

Symptoms

GTM Declaration SmartLink 'View Related Trade Transactions' fails when there are more than 1000 related trade transactions.

Customs > Declarations > Enter declaration number > Click on 'Search' button > Right click on Declaration ID and select 'View Related Trade Transactions'

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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