EP_LOAD_MAIN Fails With "-20002 ORA-20002: -1792 ORA-01792: Maximum Number Of Columns In A Table

(Doc ID 2282565.1)

Last updated on JUNE 30, 2017

Applies to:

Oracle Demantra Demand Management - Version and later
Information in this document applies to any platform.


On : version,

Upon running the data load procedure, EP_LOAD_MAIN the same fails

"-20002 ORA-20002: -1792 ORA-01792: maximum number of columns in a table or view is 1000 Error in PROCEDURE EP_LOAD_SALES.EP_LOAD_SALES line 504

  dynamic_ddl( 'CREATE INDEX T_SRC_SALES_TMPL_FI ON T_SRC_SALES_TMPL (lower(asset_group),lower(t_ep_p1),lower(class_code),lower(ebs_demand_class_code),lower(dm_item_code),lower(t_ep_lr1),lower(dm_site_code),lower(dm_org_code),lower(t_ep_ls1),
lower(ebs_sales_channel_code))') BEGIN ep_load_sales; END;"

The issue can be reproduced at will with the following steps:
1. Load data into the staging tables
2. Run ep_load_main to move data from staging tables to the demantra core tables

The issue has the following business impact:
Due to this the data cannot be loaded into Demantra for forecasting and planning the dailty activity
The planners 4 hours behind their daily plan work


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms