Idea Summary
Today we seem to be limited to about ~135 columns with minimal data in them when we PIVOT an IR table. 

Use Case

Restating the issue from - https://einstein.oracle.com/q/how-can-i-get-more-than-140-columns-in-a-pivot-on-interacti-9878

I have created a test application where I am trying to get more that 140 columns in a Pivot on IR. Here is the sample query to generate sample data -

SELECT
    ROWNUM AS rpp_name,
    'test' positions,
    FLOOR(DBMS_RANDOM.VALUE(1, 101)) AS rpp_power
FROM
    dual
CONNECT BY LEVEL <= 140

Here is the URL to the test application - https://apex.oraclecorp.com/pls/apex/r/sambchat_sandbox/test-pivot/home

The top IR with the Pivot table shows 140 columns. The bottom IR with the Pivot table having 141 columns (using the above query) gives the error - 

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

The test application is just to showcase the issue, we are extensively using Pivot tables in our APEX app running in production and we are running into this error message and the requirement is to show around 300 columns in a Pivot table.

Any help/workaround is much appreciated, if there is any simple way to override the IR's limit of 32KB per report row or completely remove the limit.