Fusion Bi Publisher - BI Scheduler Reduce Queuing Time and Process More Reports in Parallel

(Doc ID 2351582.1)

Last updated on JANUARY 29, 2018

Applies to:

Oracle Fusion Workforce Compensation Cloud Service - Version 11.12.1.0.0 and later
Oracle Fusion Application Toolkit Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Goal

Line Managers will run a custom report for all their direct reports on one particular date. Some Line Managers have up to 50 direct reports. One run of the report finished in approx 40 minutes.  Line Managers  have been instructed to schedule this report instead of running it Adhoc from Reports and Analytics (BI).  The value configured for BIP JMS Processors checked in BI Publisher Administration -> Scheduler Configuration page is 20.

Can any settings can be changed so that the BI scheduler can reduce queuing time and process more reports in parallel? What is the max number of physical users that can schedule this report ? How many sessions can BI handle concurrently for this environment ?

For example, users will have 20 reports running concurrently and 180 queued. What is the maximum this number of queued reports? What if there were 500 users scheduling the report via BI scheduler at the same time. Would only 20 still be processing and remaining 480 queued? Is there an upper limit where the system prompts a message saying something like "max number of sessions for this report scheduling have been reached".?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms