Create an Account Set for a Joint Venture Definition

You can create an account set to identify the following types of accounts for a joint venture:

• Distributable accounts

  Distributable accounts contain the transactions that you need to split and distribute among the joint venture partners.

• Distribution only accounts

  Distribution only accounts contain transactions that aren’t directly related to costs or revenue. These transactions need to be accounted for the joint venture, but not invoiced to stakeholders.

When setting up an account set to identify distributable accounts, you can set it up for a specific joint venture or for use in multiple joint ventures.

• To set it up for a specific joint venture, you select a joint venture and the ledger associated with the joint venture.

  In this scenario, the primary segment value or values specified in the joint venture definition are automatically included as filter criteria for identifying distributable accounts.

• To set it up for more than one joint venture, you select a ledger without specifying a joint venture.

  In this scenario, you can set up filters for identifying the same category of accounts that exist under different primary segments. Remember that the primary segment values identified in a joint venture definition are unique to the joint venture. To identify distributable accounts, Oracle Joint Venture Management uses account combinations assembled from the primary segment values in the joint venture definition and the accounts identified in the account set. This helps ensure that the transactions identified for processing by Joint Venture Management are specific to a particular joint venture.

After you set up an account set for a joint venture, you must activate it and assign it to the joint venture definition.

To create an account set for a joint venture definition:

1. Navigate to Setup and Maintenance and select the Joint Venture Management functional area under the Financials offering.
2. Select the Manage Joint Venture Account Sets task.
3. On Account Sets, click Add.

   Or click Manage in Excel and use the spreadsheet to add multiple account sets. The spreadsheet contains instructions on how to complete the columns, which reflect the fields in the user interface and include a list of values for fields when applicable.

4. On New Account Set, enter a name and description for the account set.
5. Select a ledger using one of these options:
   • Specify a joint venture and then click the “Use Joint Venture Ledger” checkbox to automatically select the ledger of the joint venture.

     After you click Save, the name of the ledger is displayed in the Default Ledger field.

   • Specify a ledger without specifying a joint venture.

     When you assign this type of account set to a joint venture, the COA for the ledger specified here must match the COA for the primary ledger of the joint venture.

     Ignore the "Include Primary Segment Values” option. This option is applicable only to setting up an account set for an overhead method.

6. Click Save and then proceed to add filter sets and filters to the account set.
7. To add a filter set:
   • In the Filter Sets area of the account set, click Add to add a filter set.
   • Enter a name and description for the filter set.
     Note: Avoid using the same name for a filter set in more than one account set. Try to make the filter set names unique in each account set.
8. To add a filter to a filter set:
   1. In the filter set, click Add Filter and then enter the following details for the filter:
      • Segment. Select from a list of segments in the ledger.
      • Operator. Select Is, Is Not, or Between.
      • Enter a value or a range of values according to the selected operator.
        Caution: You can include a primary segment value in a filter. But before you do, make sure that you understand how it will be processed based upon the setup of the account set:

        • An account set that’s set up for a particular joint venture and the joint venture’s ledger

          The account set will automatically use the primary segment values identified in the joint venture definition as filter criteria. If you add a filter that includes one of the primary segment values, the filter overrides the use of any other primary segment values from the joint venture definition. For example, if the joint venture definition includes three primary segment values and you set up a filter with one of those primary segment values, only the single primary segment value will be used to identify transactions for that filter.

        • An account set that’s set up only for a ledger and not a joint venture

          If you use a primary segment value in a filter, the filter will only be used if the primary segment is valid for the joint venture that the account set is assigned to.

   2. Add additional filters as needed.
   3. Click Save.
9. Continue to add additional filter sets and filters as needed.
10. When complete, click Submit to save and exit the page. Or you can click Submit and Next to create another account set.