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 InformationField Information
|
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. |
Refer to the following topics for additional information:
