Create an Account Set for a Joint Venture Definition

Create and assign an account set to a joint venture definition to identify the following accounts:

Distributable accounts

Accounts with transactions that you need to split and distribute among the joint venture partners.
Distribution Only accounts

Accounts with transactions that aren’t directly related to costs or revenue. These transactions need to be accounted for the joint venture but not billed to stakeholders.
Billable asset accounts

Accounts with transactions for billable assets that you want to distribute and bill to joint venture partners. An account set to identify billable assets enables you to differentiate between billable assets and nonbillable assets. Asset accounts identified in the account set for distributable accounts, but not identified in the account set for billable asset accounts, are set to Distribution Only in Joint Venture Management.

Important:
If you don’t assign an account set for billable asset accounts to a joint venture definition, then asset accounts included in the distributable accounts account set will be identified as distributable, regardless of whether the asset accounts are billable or nonbillable.

You can create an account set for a specific joint venture or for use in multiple joint ventures.

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.
For multiple joint ventures, 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 transactions identified for processing by Joint Venture Management are specific to a particular joint venture.

You must set an account set to Active status before you can assign it to a joint venture definition.

To create an account set for a joint venture definition:

Navigate to Setup and Maintenance and select the Joint Venture Management functional area under the Financials offering.
Select the Manage Joint Venture Account Sets task.
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.
On New Account Set, enter a name and description for the account set.
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.
- 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.
Click Create and then proceed to add filter sets and filters to the account set.
To add a filter set, complete these steps:
1. Open the account set from the Account Sets page.
2. Click Create Filter Set and give it a name and description.
  Important: Filter set names must be unique across all account sets.
3. Click Create.
To add a filter to a filter set, complete these steps:
1. Click Add Filter and then in the row that appears, enter the following details:
  - Filter Set. Select the filter set that you created.
  - 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. However, before you do, make sure you understand how it will be processed based on 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 the 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. Click Submit at the end of the filter row.
Continue to add filters and additional filter sets as needed.

Your changes are saved automatically.
When complete, click Go back.