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