'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