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