My Oracle Support Banner

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

Last updated on JULY 12, 2020

Applies to:

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

Symptoms and later versions, LoadData

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

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;

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 


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

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