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.