My Oracle Support Banner

'ORA-01795: maximum number of expressions in a list is 1000' Error When Trying to Edit the Trade Transaction After Running the 'Screen Restricted Parties' Action (Doc ID 2073287.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Global Trade Management - Version 6.2.10 to 6.4.0 [Release 6.2 to 6.4]
Information in this document applies to any platform.


When attempting to do a parties screening by running the 'Screen Restricted Parties' action on a GTM Trade Transaction, the following error occurs when you try to edit the trade transaction after running the action.

- Create a Trade Transaction with 120 lines.
- Add around 12 to 15 contacts at transaction level and perform the restricted party screening.
- You will observe that more 1000 records (i.e. 120 * 12 = 1440 records) are added to gtm_tr_party_screen entity because of this transaction.
- Now edit the trade transaction you should see an error in the UI or logs like Max Number of expression in a list of 1000 error or system slowness.




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.