Cost Sheet - ORA-01792: maximum number of columns in a table or view is 1000
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?