Problem Note 62895: An "ORA-01795: maximum number of expressions in a list is 1000" might occur when you create a new regular price plan from the Alerts List view
 |  |  |  |  |
In SAS® Regular Price Optimization, the following error might occur when you create a new plan from the Alerts List view:
ORA-01795: maximum number of expressions in a list is 1000
The error occurs when you have chosen to create a new plan with 1000 or more product-locations.
The workaround for this issue is to create new plans with less than 1000 members, if possible. There is no workaround if you choose to create a new plan for a product that is available at 1000 or more stores.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Regular Price Optimization | Microsoft® Windows® for x64 | 5.2_M4 | 9.3 TS1M2 | ||
| Linux for x64 | 5.2_M4 | 9.3 TS1M2 | ||||
A fix for this issue for SAS Revenue Optimization 5.4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/B3R.html#62895A fix for this issue for SAS Size Optimization 3.41 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/D3R.html#62895| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2019-07-03 11:59:28 |
| Date Created: | 2018-09-10 10:36:07 |