My Oracle Support Banner

BICC View Object Errors with: ORA-01792: maximum number of columns in a table or view is 1000 (Doc ID 2608079.1)

Last updated on NOVEMBER 16, 2019

Applies to:

Oracle Fusion Financials Common Module Cloud Service - Version 11.13.18.01.0 and later
Oracle Fusion Application Toolkit Cloud Service - Version 11.13.18.01.0 and later
Information in this document applies to any platform.

Goal

During the testing of BICC View Objects we found that we cannot extract when more than 1000 columns are selected in a view object.

java.io.IOException: execute query failed[nQSError: 43113] Message returned from OBIS.\n[nQSError: 43119] Query Failed: \n[nQSError: 17001] Oracle Error code: 1792, message: ORA-01792: maximum number of columns in a table or view is 1000\n at OCI call OCIStmtExecute.\n[nQSError: 17010] SQL statement preparation failed.\n\tat oracle.bi.jdbc.AnaJdbcStatementImpl.executeQuery(AnaJdbcStatementImpl.java:387)\n\tat oracle.obiacm.queryprocessing.BIServerQuery.runQuery(BIServerQuery.java:1508)\n\t... 9…


Is there a way to change the limit in BICC?

 

Solution

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
Goal
Solution


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