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

Sowbhagya B

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

Sumanth V -Oracle

@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!

MandeepGupta

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

Thanks.