Setting Background Processing

You can set jobs—for business rules, Clear Cell Details, Copy Data, and Push Data—to switch to background processing after a threshold that you configure. After the specified period, jobs execute in the background. You can also set how often Oracle Hyperion Planning checks job status, displayed on the Job Console (see the Oracle Hyperion Planning User's Guide).

To set background processing and the frequency of status checks:

  1. Select Administration, then Application, and then Properties.
  2. Select Application Properties to set properties and values for a Planning application.
  3. Add the property by clicking Add, entering the property in the blank row, and then entering a value in Property Value:

    Table 2-3 Job Property Names and Values

    PROPERTY_NAME Column Property Value Description
    RULE_MAX_WAIT

    The default and minimum value is 180,000 milliseconds (3 minutes). If you set a lower value, that value is ignored, and the property is set to the default value.

    The interval in milliseconds to wait before running business rules in the background. If this property is not set, the feature does not work, and business rules do not run in the background.

    Note:

    Business rules that are set to automatically run when a form is loaded or saved never run in the background.

    RULE_MONITOR_DELAY

    The default and minimum value is 180,000 milliseconds (3 minutes). If you set a lower value, that value is ignored, and the property is set to the default value.

    The interval in milliseconds for checking the status of business rules.

    CLR_CELL_MAX_WAIT

    The default and minimum value is 180,000 milliseconds (3 minutes). If you set a lower value, that value is ignored, and the property is set to the default value.

    The interval in milliseconds to wait before running Clear Cell Details jobs in the background. If this property is not set, Clear Cell Details jobs do not run in the background.

    CLR_CELL_MONITOR_DELAY

    The default and minimum value is 180,000 milliseconds (3 minutes). If you set a lower value, that value is ignored, and the property is set to the default value.

    The interval in milliseconds for checking the status of Clear Cell Detail operations.

    COPY_DATA_MAX_WAIT

    The default and minimum value is 180000 milliseconds (3 minutes). If you set a lower value, that value is ignored, and the property is set to the default value.

    The interval in milliseconds to wait before running Copy Data jobs in the background. If this property is not set, Copy Data jobs do not run in the background.

    COPY_DATA_MONITOR_DELAY

    The default and minimum value is 180,000 milliseconds (3 minutes). If you set a lower value, that value is ignored, and the property is set to the default value.

    The interval in milliseconds for checking the status of Copy Data jobs.

    PUSH_DATA_MONITOR_DELAY

    The default and minimum value is 180,000 milliseconds (3 minutes). If you set a lower value, that value is ignored, and the property is set to the default value.

    The interval in milliseconds for checking the status of Push Data jobs.

    PUSH_DATA_MAX_WAIT

    The default and minimum value is 180,000 milliseconds (3 minutes). If you set a lower value, that value is ignored, and the property is set to the default value.

    The interval in milliseconds to wait before running Push Data jobs in the background. If this property is not set, Push Data jobs do not run in the background.

    JOB_STATUS_MAX_AGE

    Specify the value in milliseconds. The default value is 4 days (set in milliseconds).There is no minimum value.

    The maximum age of a completed job record before Planning deletes it from the database table, HSP_JOB_STATUS. Planning checks the job records every 30 minutes.

    For example, if you set the property value to 60,000 (1 minute), a job completes at 3:00, and Planning checks the job records at 3:01, then Planning would delete the completed job record.

    Removing completed job records can improve performance.

  4. Click Save and confirm your changes.