1. Implementing Joint Venture Management
  2. Filter Sets and Filters in an Account Set

Filter Sets and Filters in an Account Set

In an account set, you create filter sets with one or more filters to identify accounts.

In a filter, you provide the following details to identify accounts in a ledger:

  • An account segment.
  • An operator to specify a range of values or one or more values to include or exclude for the segment. You can select one of these operators:
    • Is
    • Between
    • Is Not
    • Matches Any
    • Does Not Match Any
  • A value or values for the selected operator.

Oracle Joint Venture Management uses account sets to identify transactions in a ledger. An account set is composed of filter sets. In a filter set, you can include filters to identify values in different segments.

The following example shows a filter set with filters for two different segments. Joint Venture Management will use the filter set to identify the following transactions:

  • Transactions in segment HEPPAccount with values that include 24000 through 24999.

  • Transactions in segment HEPPCostcenter with values that include 33000.

This image shows a filter set with two filters that are described in surrounding text.

You can add more than one filter for the same segment to a filter set, but only in the following scenario:

  • If one filter for the segment uses a Between operator to identify a range of account values.

  • If additional filters for the same segment use an Is Not or Does Not Match Any operator to exclude values within the range of values specified in the Between filter.

The following image shows an example of using a combination of Between and Does Not Match Any filters in a filter set. Joint Venture Management will use this filter set to identify distribution only transactions with natural accounts between 00000 and 39999, except for accounts 17910, 17911, and 17912.

This image shows a filter set with two filters that are described in surrounding text.

If you need to identify two or more individual values in a segment, and the values can't be identified by a range, use the Matches Any operator as shown in the following example. Joint Venture Management will use this filter set to identify all transactions with natural accounts 60000, 60002, and 60005.

This image shows a filter set with a Matches Any filter, which is described in surrounding text.

To make the setup and maintenance of an account set more manageable:

  • For each filter set, enter a name and description that's descriptive of the category or type of transactions that you're identifying with the filter set.
  • Whenever possible, use the combination of filters with Between and "Is Not" operators. If there's an account added in the future that's within the Between filter's range, it will be identified automatically as distributable.