Requesting an Increase in Planning Dimension Governor Limits

Planning, Planning Modules, Strategic Workforce Planning, and Sales Planning use default dimension governor limits to ensure optimal performance. In some cases, Oracle will increase the limit on the governors at your request through a technical service request.

Governors exist in various parts of the application. The approval process detailed in this section applies to the governors for dimension limits that are enforced when you create objects in each dimension in the application.

If you determine that you need to increase the governors in your environment, Oracle requires you to test the impact of the governor limit increase on the overall performance of the application. To run such tests, Oracle will provide a loaner environment from which governor limits have been removed. You are responsible for designing and executing test plans to determine the performance implications of your application design (data loads, integrations, refreshes, restructures, Oracle Smart View for Office retrievals, form loads, form saves, report loads, business rules execution times, Smart Push, Data Maps, daily maintenance time, and so on). After adequate testing, you can request that Oracle increase the governor limits on specific dimensions in your environments.

Note:

This discussion does not apply to the following:

1. Increasing the limits of the number of cells in forms and reports (before and after suppression).
2. Increasing the Oracle Essbase block size and number of blocks.
3. Increasing the limits of best practices governors in Planning Modules.

To increase governor limits:

1. Get a temporary loaner environment from Oracle by submitting a technical service request. In the service request, specify the business justification for requesting the loaner environment. See these topics:
   • Requesting a Temporary Loaner Environment.
   • Submitting a Technical Service Request.

     The service request must contain the following additional information:

     • A list of 10 or less users (first name, last name, and email address) of the loaner environment. These users will be created as Service Administrators.
     • Expected number of dimension members for each application dimension.
     • The earliest date when the loaner environment is to be available for testing.

     Generally, Oracle makes loaner environments available within one week after you submit a service request containing the required information. You have a maximum of three months to complete testing.

2. Test your application design (data loads, integrations, reports, refreshes, restructures, Smart View retrievals, form loads, form saves, business rules execution times, Smart Push, Data Maps, daily maintenance time, and so on) to ensure that performance is acceptable.
3. Ask Oracle to increase the governor limits on your production environments by updating the service request that you submitted to request the loaner environment. Complete the following steps:
   • Create a Provide Feedback submission from the loaner environment that was used for testing. Optionally, allow Oracle to access the maintenance snapshot of the environment by consenting to application snapshot submission. See Creating a Provide Feedback Submission.
   • Add the Provide Feedback reference number to the technical service request.
   • Provide the following additional information:
     • Confirmation that you completed performance tests with acceptable results. It is important that the performance tests are executed with similar user load as expected when using the system in production.
     • A list of the activities that were tested for performance.
     • A list of the specific application dimensions for which the governor limits should be increased, and the new values to which governor limits are to be set.
     • URLs of all the environments where the governor limits are to be increased.
     • Written approval permitting Oracle to apply the increased governor limits.

     Note:

     Generally, governor limits are increased during the next monthly update cycle of each environment that you identify. Depending on the monthly update development cycle, it may take up to six weeks for Oracle to increase the governor limits. Oracle may provide a one-off patch with the governor limit increase if you need it urgently because the current governor limit is blocking a critical milestone.