EBS Download ORA-20002 ORA-20003 Error In PACKAGE BODY DATA_LOAD (Doc ID 2009346.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 7.3.1.4 version, LoadData

When attempting to perform EBS full download the following error occurs.

ERROR
-----------------------
Database internal error:ORA-20002: -20003 ORA-20003: Error in PACKAGE BODY DATA_LOAD line 4050


The error msg from db_exception_log:

-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(dm_item_code),lower(t_ep_p1),lower(ebs_demand_class_code),lower(class_code),lower(t_ep_ls1),lower(t_ep_lr1),lower(dm_site_code),lower(ebs_sales_channel_code),
lower(dm_org_code))') BEGIN EP_LOAD_SALES; END;
 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Demantra Workflow Manager
2. Run EBS Full Download Workflow
3. Same error occurs when running EP_LOAD manually

The issue can also be reproduced in Demantra 12.2.x 

Cause

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