Examples of Creating Condition
The following provides examples of defining an account rule with a condition.
Example 1: User-Defined Real Estate Application Account Rule Condition Example
This example defines an account rule for assignment to a loan journal line. The account rule has two priorities, a mapping set and a constant.
-
The first priority creates an output for an account based on the mapping set rule definition.
-
A condition is created using the first priority rule. This rule is only used if the condition is met.
-
The condition is Credit Status must not be null.
-
The accounts derived from the mapping set rule are used if the Credit Status has a valid value. Otherwise, the accounts derived from the entered constants value from the second priority are used.
-
-
This table contains the setup of the condition for the first priority:
(
Source
Operator
Value
)
(
"Credit Status"
isn't null
)
-
-
The second priority creates an output from a constant value (0.9100030.50034206331.0.0.0). No condition is associated with the second priority.
Example 2: Oracle Fusion Assets Account Rule Condition Example
This example defines a rule for a capital purchase. The rule is applied if the distribution account cost center is the same as the liability account cost center, and the asset tracking option is Yes.
This condition can be expressed as:
-
Where Distribution Cost Center = Liability Cost Center and Asset Tracking option = Yes
This table contains the setup of the condition formula.
|
( |
Source |
Delimiter |
Segment |
Operator |
Value |
Delimiter |
Segment |
) |
And Or |
|---|---|---|---|---|---|---|---|---|---|
|
( |
"Distribution Account" |
. |
"Cost Center" |
= |
"Liability Account" |
. |
"Cost Center" |
) |
'AND' |
|
( |
"Asset Indicator" |
= |
Yes |
) |
The following two rows of data are used in the accounting event, to which the account rule and condition applies.
Account Rule Condition Example: Accounting Event Data
This table contains the values to which the condition is applied.
|
Account |
Invoice 1 |
Invoice 2 |
Asset Indicator |
|---|---|---|---|
|
Distribution Account |
02-640-2210-1234 |
01-780-6120-0000 |
Yes |
|
Liability Account |
01-640-2210-0000 |
02-782-2210-0000 |
Yes |
In the Accounting Event Data table, assume the cost center segment is the second segment. When the account rule with this condition is used the account rule is applied to derive the account of Invoice 1 only. For Invoice 2, (assets tracking option = Yes), the cost center for the Distribution and Liability accounts aren't the same. Both conditions must be met in order for the rule to apply.