My Oracle Support Banner

Demantra Create Series ORA-01792: Maximum Number of Columns in a Table or View is 1000 (Doc ID 2425546.1)

Last updated on DECEMBER 16, 2022

Applies to:

Oracle Demantra Demand Management - Version 7.3.0 and later
Oracle Demantra Deduction and Settlement Management - Version 7.3.0 and later
Oracle Demantra Advanced Forecasting and Demand Modeling - Version 7.3.0 and later
Oracle Demantra Predictive Trade Planning - Version 7.3.0 and later
Oracle Demantra Real-Time Sales and Operations Planning - Version 7.3.0 and later
Information in this document applies to any platform.

Symptoms

Customer is trying to create a new series that has an update update field and receives the error:  ORA-01792:maximum number of columns in a table or view is 1000

Changes

 Creating a new custom series that will cause an update field on the sales_data table and add a column to the sales_data table.

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.