After a merchandise reclass event, database procedures are used to re-aggregate data in core tables of MFINC and MINVENTORY. The procedures used in SAS® Merchandise Planning might encounter Oracle errors similar to the below:
ERROR at line 1:
ORA-20001: ORA-20001: ORA-20001: ORA-20001: ORA-14097: column type or size
mismatch in ALTER TABLE EXCHANGE PARTITION (ALTER TABLE MINVENTORY EXCHANGE
PARTITION MINVENTORY_P51_502016001_D WITH TABLE , SQL#:11000) (p_agg_post (
MINVENTORY,51,502016001,ML,0 ) , SQL#:27000) (p_agg_load (
ACTUAL,RECLASS,MINVENTORY,47,2016,YEAR ) , SQL#:21700) (p_agg_batch (
ACTUAL,RECLASS,MINVENTORY ) , SQL#:14110)
ORA-06512: at "MAXDATA.P_AGG_BATCH", line 244
ORA-06512: at line 1
If these errors occur, it might be due to new columns required for multi-currency that have been added to core tables via alter table statements with default values. To validate that this is the issue, run a query similar to the following:
select * from user_tab_cols where table_name = '<your_fact_table>';
Beginning with Oracle 12c, a new optimizer feature that creates hidden columns on tables when alter table statements are run was added. These columns prevent the in-database procedures from working. The columns have a name similar to "sys_nc#####" where the name includes a number that matches the column ID of the exchange_rate column.
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.