'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 DECEMBER 15, 2015

Applies to:

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

Symptoms

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.



STEPS
-----------------------
- 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.

Cause

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