SUPPORT / SAMPLES & SAS NOTES
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 | ||||