Problem Note 37030: SAS® Regular Price Optimization and Oracle might produce an error when making changes to competitive rules
 |  |  |  |  |
When you use SAS Regular Price Optimization with Oracle to select a plan member and then select Override Rules►Competitive Price Rules or Override Rules►Future Competitive Price to make changes to the appropriate competitive rules, you may receive the following error after you click OK and then Save plan:
java.sql.SQLException: ORA-01400: cannot insert NULL into
("DI_DM"."RPO_PLAN_MBR_COMP_RULE_OVRD"."RPO_MBR_RULE_OVRD_SK")
Select 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 Server 2003 Datacenter Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M2 |
| Microsoft Windows Server 2003 Enterprise Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Standard Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
| 64-bit Enabled AIX | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
A fix for this issue for SAS Merchandise Intelligence 3.2 is available at:
http://www.sas.com/techsup/download/hotfix/ro32.html#037030| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2009-09-11 13:20:46 |
| Date Created: | 2009-08-28 13:17:17 |