You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Smart View Performance Issue and "The provider returned an empty response" Error During Large Data R

in General Ledger & Intercompany

Hello,

We are currently validating an Oracle Smart View ad hoc report and have two questions regarding performance and behavior.

Issue 1: Refresh performance

We are using Smart View ad hoc analysis to retrieve balances from Oracle Fusion General Ledger.

The report contains approximately 100,000 cells (for example, around 100,000 row members × 1 period).

The refresh takes more than 10 minutes, and in some cases it does not complete successfully.

According to Oracle documentation, Smart View supports retrieval of up to 1,000,000 cells in a single query. Therefore, we believe our query is well within the documented limit.

Could you please advise:

  • Is there any known limitation or performance consideration for retrieving approximately 100,000 cells?
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!