My Oracle Support Banner

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 DECEMBER 04, 2019

Applies to:

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

Symptoms

On : 12.2.4.1 version,

Upon running the data load procedure, EP_LOAD_MAIN the same fails



ERROR
-----------------------
"-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;"



STEPS
-----------------------
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



Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.