Configurable Formula

The Configurable Formula (BOFRMLA) page is available in the Administration, Financial, Vendor Self Service, Human Resource Management and Performance Budgeting areas of Advantage. The Configurable Formula page is used to define additional attribute-level formulas on the business object. Formulas defined on the Configurable Formula page are evaluated during business object processing in addition to, but not replacing/overriding those formulas coming from native metadata and data object extensions. The formulas are applied to attributes for a specific business object. For example, if in the Financial application a formula is added to the DOC_CREAT_DT attribute on the Purchase Order Header component (PO_DOC_HDR) then it is also defined for each transaction (including clones) referring to the Purchase Order Header component.

Field	Required?	Description
Formula ID	Required	This field defaults to give each record a unique identifier.
Name	Required	A descriptive name of the formula to allow for a quick reference to the formula.
Active	Required	Only records marked as active will be considered during business object processing.
Business Object	Required	This is the database table name where the formula applies. For example, if applying a formula to a field on the Purchase Order Header component then use PO_DOC_HDR. For PB, if applying a formula to a field on Fund, then use Fund2.
Priority	Required	Indicates the execution order of formula records.
Description	Optional	A lengthy description to record any details about the formula, reason for the formula, etc.
Trigger Action	Required	Indicates the action on the specified business object that will trigger the formula. Carefully, select the action to match the type of business object, as not all actions are available to all business objects.
Formula Field	Required	The database field name on the selected business object for the formula.
Script	Required	(Hidden) For future CGI use. Defaulted to True.
Formula	Required	The formula used during business object processing. For example, if changing the date used to set the Created On (DOC_CREA_DT) from the system (server date) to the current application date as defined on the Application Parameter, then application date is entered.