My Oracle Support Banner

INV_ADJUST_TEMPLATE Over 1000 Rows Per Store Does Not Allow To Create New Adjustment (Doc ID 2694017.1)

Last updated on JULY 30, 2020

Applies to:

Oracle Retail Store Inventory Management - Version 15.0 and later
Information in this document applies to any platform.


When users have more than 1000 records in INV_ADJUST_TEMPLATE for one store and when they try to create a new adjust the following error occurs.

ORA-01795: maximum number of expressions in a list is 1000 occurs

Steps to Reproduce:

1. Make sure that you have more than 1000 records in INV_ADJUST_TEMPLATE table for one store
2. Go to SIM app and create a new inventory adjustment
3. Note that an error occurs and you cannot make a new adjustment




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.