Unifier (MOSC)

MOSC Banner

Cost Sheet - ORA-01792: maximum number of columns in a table or view is 1000

in Unifier (MOSC) 3 commentsAnswered

Hi Everyone,


We have one Unifier environment to test and study and, as we create BPs and configure Workflows, we reach the maximum column quantity at the budgetrow table.

At this point, we have 1045 columns and, for this reason, every time we try to open a Cost sheet, we received a 202 Success "error" and when we open a log file, we can see the ORA-01792 error.

Even if we deactivate a BP, the number of columns doesn't change. Regarding the fact that we can't delete a BP already deployed, what we can do at this point? Delete some columns directly in our DB? 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center