Deployment and Considerations

The Configurable Formula functionality is a System Administrator function and needs careful attention to develop, test, and deploy configurations to production. Configurable Formulas are stored in the R_BO_FORMULA_CNFG database table in each Advantage product schema. It is highly recommended that implementers develop and test formulas in a pre-production environment and once satisfied with the changes, deploy configurations to production environments during down time.  

configurableFormula

{

    flushCacheOnConfigFormulaUpdates=false

}

flushCacheOnConfigFormulaUpdates is applicable ONLY to test environments and enables the capability to immediately reflect the changes made to configurable formula records without a need for an application bounce. This property, when enabled, clears cached formula records and reloads updated configurable formula record(s). In a production environment, flushCacheOnConfigFormulaUpdates must remain false all the time.

flushCacheOnConfigFormulaUpdates is not used for Performance Budgeting, since the cache is updated whenever a formula is added/updated or deleted.

Sites implementing multiple Advantage products need to apply the above settings and considerations in each product environment.

An informational message is displayed at the top of the BOFRMLA page indicating whether the Flush Cache on Configurable Formula Updates feature is enabled or disabled. This allows users to quickly determine the current setting.

  • If flushCacheOnConfigFormulaUpdates is set to true: “Flush cache on formula update is enabled. Your changes apply immediately in the application server that you are logged into without restarting. If there are other application servers running, those instances must be restarted for changes to take effect there.”

  • If flushCacheOnConfigFormulaUpdates is not equal to true: “Flush cache on formula update is disabled. In order for the changes to take effect, all the instances of the application must be restarted.”

Note: Additional text can be appended to the informational message via the SYSADMDT record on the Configurable Text (CTEXT) page. For instance, sites can include information about contacting a System Administrator, along with specific contact details. This additional text will be appended to the end of the baseline message on the BORULE, BOFRMLA, and DESIGNER pages.