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 Planning checks job status, displayed on the Job Console (see the Oracle Hyperion Planning User's Online Help).

  To set background processing and the frequency of status checks:

  1. Select Administration, then Application, 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 entering a value in Property Value:

    Table 17.  Job Property Names and Values

    PROPERTY_NAME ColumnProperty ValueDescription
    HBR_MAX_WAIT_FOR_RULE

    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.

    		For business rules created with Business Rules or those migrated from Business Rules to this release.

    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 data form is loaded or saved never run in the background.

    HBR_MONITOR_DELAY

    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 for checking the status of business rules created with Business Rules.

    RULE_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.

    		For business rules created with Calculation Manager.

    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 data form is loaded or saved never run in the background.

    RULE_MONITOR_DELAY

    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 for checking the status of business rules created with Calculation Manager.

    CLR_CELL_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 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 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 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 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 for checking the status of Copy Data jobs.

    PUSH_DATA_MONITOR_DELAY

    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 for checking the status of Push Data jobs.

    PUSH_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 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. There is no default or 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.