Correcting Issues with Joint Venture Transactions and Distributions

To resolve any issues or disputes, you can delete joint venture distributions and remove their associated joint venture transactions from the Distributions and Transactions work areas respectively. You can then update the joint venture definition to correct the issue.

For example, you might need to add a new stakeholder or adjust the stakeholder percentages in the ownership definition, or identify another account that contains transactions to distribute. After revising the joint venture definition, you can rerun the Oracle Joint Venture Management processes to identify and distribute the transactions again.

This section describes some of the issues you might encounter and the general process for resolving them.

Transaction Split When Entire Transaction Amount Should Be Applied to a Direct Billed Stakeholder

A transaction should have been distributed to a direct billed stakeholder but instead was mistakenly split and distributed among stakeholders. To correct this issue, you need to:

In the Joint Venture Distributions work area, delete the distributions created for the transaction.

This resets the status of the associated transaction from Process Complete to Available to Process in the Joint Venture Transactions work area.
In the Joint Venture Transactions work area, override the ownership definition with the direct billed stakeholder.
Manually run the Create Joint Venture Distributions process, or wait for it to run on its schedule to create a distribution for the stakeholder that contains the entire transaction amount.

Incorrectly Identified Transactions

Distributions have been generated for transactions that aren't associated with a joint venture. In this case, it's likely that the wrong account or project has been identified as distributable in the joint venture definition. To correct this issue, you need to:

In the Joint Venture Distributions work area, delete distributions generated from the incorrectly identified transactions.
Remove the transactions from the Joint Venture Transactions work area.
In the Joint Ventures work area, update the distributable segment values or project values, or update the account set or project set to remove the information used to identify the incorrect distributable account.

Transactions with Missing Transaction Date

Transactions in "Missing Transaction Date" error status can't be distributed.

This can be due to the following issues:

Incorrect setup of supporting references to capture the transaction date in Oracle Financials.
Source transaction doesn’t have the transaction date specified.

To correct the issue about incorrect supporting references setup:

In Oracle Fusion Cloud Financials, update your supporting references.
In the source transaction, review and identify the date to use as the transaction date.
In the Joint Venture Transactions work area, update the transaction date for the transaction.

To correct the issue about the source transaction not having a transaction date:

Determine the date to use as the transaction date.
In the Joint Venture Transactions work area, update the transaction date for the transaction.

For information on supporting references and how to determine a date to use as the transaction date, see About Identifying a Transaction Date for Processing Joint Venture Transactions.

Missing Expenditure Business Unit in Project-Related Transactions

Transactions with the “Missing Expenditure Business Unit” error status can’t be processed further in Joint Venture Management because the expenditure business unit is required to import distributed costs as cost adjustments into Project Costing. The expenditure business unit is required to record cost adjustments to the proper business unit in Project Costing.

For more information on this issue and how to resolve it, refer to My Oracle Support Knowledge Document 10160158, Expenditure Business Unit for Joint Venture Transactions.

Transactions with Missing Ownership Definitions

Transactions that aren’t assigned an ownership definition have a status of Missing Ownership and can't be distributed. This is because of the following reasons:

A default ownership definition wasn’t specified for the joint venture.
An ownership definition wasn’t assigned through ownership definition assignment rules.

If a default ownership definition wasn’t specified for the joint venture:

In the Joint Ventures work area, specify a default ownership definition for the joint venture.
Remove the transactions from the Joint Venture Transactions work area.
To identify the transactions and simultaneously assign the default ownership definition, run the Identify Joint Venture Transactions process without bypassing the default ownership definition assignment.

To assign the default ownership definition after you run the Identify Joint Venture Transactions process, run the Process Ownership Definition Assignment Rules process without bypassing the default ownership definition assignment.

If an ownership definition wasn’t assigned through ownership definition assignment rules:

In the Ownership Definition Assignment Rules work area, update the assignment rule or create a new assignment rule.
Run the Process Ownership Definition Assignment Rules process.

Transactions with Ownership Definitions Not Effective on the Transaction Date

The ownership definition assigned to a transaction isn’t effective on the transaction date and therefore the transaction can’t be distributed. The transaction is in Ownership Not Effective status.

Depending on your scenario, you can correct the issue using one of the following approaches:

Use a new ownership definition with effective dates that cover the transaction date on the transactions.
Override the ownership definition on the transaction with an ownership definition that has the correct effective dates.

To use a new ownership definition on the transactions:

In the Joint Ventures work area, create an ownership definition with effective dates that cover the transaction date on the transactions.
In the Manage in Excel spreadsheet or the Joint Venture Transactions work area, assign the ownership definition to the transactions.
Run the Validate Ownership Definition Effective Dates process.

Copy the existing ownership definition and update the effective dates and ownership percentages.
In the Manage in Excel spreadsheet or the Joint Venture Transactions work area, assign the ownership definition to the transactions.
Run the Validate Ownership Definition Effective Dates process.

To override the ownership definition on the transactions:

In the Manage in Excel spreadsheet or the Joint Venture Transactions work area, assign the appropriate ownership definition or direct billed stakeholder to the transactions.
Run the Validate Ownership Definition Effective Dates process.

Transactions with Inactive Stakeholder

The Create Joint Venture Distributions process updates the transaction status to Inactive Stakeholder in the Joint Venture Transactions work area if there are transactions with inactive direct billed stakeholders. This is because the transactions were assigned to an active direct billed stakeholder when they were identified, but the stakeholder was made inactive before you ran the Create Joint Venture Distributions process. You must correct the issue before you can distribute the transactions.

If the stakeholder shouldn’t have been made inactive:

Change the stakeholder status to Active in the Joint Ventures work area.
Run the Create Joint Venture Distributions process.

If the inactive stakeholder needs to be replaced with a different stakeholder that’s active:

In the Manage in Excel spreadsheet or the Joint Venture Transactions work area, assign the direct billed stakeholder to the transactions.
Run the Create Joint Venture Distributions process.

Or perform the following steps if you use ownership definition assignment rules:

In the Ownership Definition Assignment Rules work area, update the assignment rule with the new stakeholder.
Run the Process Ownership Definition Assignment Rules process.
Run the Create Joint Venture Distributions process.

Distributions with Incorrect Amounts

If you have distributions with incorrect amounts, it’s because of the following reasons:

An incorrect ownership definition was assigned to the transaction.
The percentages on the ownership definition are incorrect.

If an incorrect ownership definition was used:

In the Joint Venture Distributions work area, delete the distributions.
In the Manage in Excel spreadsheet or the Joint Venture Transactions work area, update the transactions with the correct ownership definition.
Run the Create Joint Venture Distributions process.

If the percentages on the ownership definition are incorrect:

In the Joint Venture Distributions work area, delete the distributions.
In the Joint Ventures work area, correct the percentages on the ownership definition.

Or create a new ownership definition with different effective dates in correct ownership percentages.

Note: . Creating a new ownership definition with different effective dates will trigger the reversal of distributions that are not within the new effective dates. See Reverse and Redistribute Distributions Due to a Retroactive Change in Ownership.
Run the Create Joint Venture Distributions process.