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 and later
Oracle Fusion Application Toolkit Cloud Service - Version and later
Information in this document applies to any platform.


During the testing of BICC View Objects we found that we cannot extract when more than 1000 columns are selected in a view object. 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\n\tat oracle.obiacm.queryprocessing.BIServerQuery.runQuery(\n\t... 9…

Is there a way to change the limit in BICC?



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.