Problem Note 62745: "ORA-01438: value larger than specified precision allowed for this column" might occur when you save a worksheet
In SAS® Merchandise Planning, the following Oracle error might occur when you save a worksheet:
ORA-01438: value larger than specified precision allowed for this column
The error is likely to occur when values used in calculations cannot be translated exactly from binary to floating-point decimals. For example, if the calculation is ((A-B)/(A-B+C))*100, and A=7140.33, B=7146.44, and C = 6.11, then the expectation is that the calculation results in 0. However, due to the values in the formula not being represented exactly in binary format, the result is -1864294967698662.5000 and the Oracle error occurs.
There is no workaround for this issue.
Operating System and Release Information
| SAS System | SAS Merchandise Financial Planning and SAS Merchandise In-Season Management | Microsoft Windows Server 2012 R2 Std | 6.7 | | 9.4 TS1M4 | |
| 64-bit Enabled AIX | 6.7 | | 9.4 TS1M4 | |
| Linux for x64 | 6.7 | | 9.4 TS1M4 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2020-05-21 12:39:18 |
| Date Created: | 2018-08-10 15:29:57 |