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:

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