When scheduling the BIP Report ending with error ORA-56733: logical I/O limit exceeded -call aborted

Question

There is a BIP report created ESS job when trying to schedule it is failing with timeout error

So I have tuned the query removing the Views and adding the main tables. Then when i tried too schedule the report it is failing with below error

ORA-56733: logical I/O limit exceeded - call aborted

When i tried to run the report taking From and to date as same day (i.e. one day) then also it is failing with below error

ORA-01652: unable to extend temp segment by 128 in tablespace FUSION_TEMP

Anyone suggest what is the issue here and how to overcome

Using this report in Oracle fusion cloud

MandeepGupta · Answer

Do you know the count expected? It is mostly related to performance only.

Thanks.

Sumanth V -Oracle · Answer

@Sowbhagya B -

This is a change or limitation implemented in Fusion Applications. Kindly refer to the following document for detailed information:

* FA-SAAS SQL Guardrails for Long-Running BI Reports and Queries (Doc ID 2884584.1)

For Fusion Applications-related queries, please utilize the dedicated community for those topics:

https://community.oracle.com/customerconnect/

This community is specifically for OAC, OAS, and BI Publisher-related discussions. Thank you!