About Distribution Details

The Joint Venture Distributions work area provides details about the distributions created for your joint ventures, including:

The transaction from which the distribution was generated.
The distribution amount in the entered and accounting currency.
Distributions generated to rebill partners.
Distributions paid for by partner contributions.
Distributions processed to send cost adjustments to Oracle Project Costing when the integration with Project Costing is enabled.

The main page of the work area displays general information about each distribution. From here, you can click the Distribution ID link of each distribution to review additional details about the distribution.

The columns in the main page of the Joint Venture Distributions work area provide the following distribution details:

Column	Description
Creation Date	The date the distribution was created.
Distribution ID	The unique identifier for the distribution record.
Distribution Status	The status of the joint venture distribution.
Ledger	The name of the ledger associated with the distribution.
Joint Venture	The name of the joint venture associated with the distribution.
Source	The source of the transaction that the joint venture distribution originated from: General Ledger, Subledger, Manual, or Overhead.
Ownership Percentage	The percentage of ownership the stakeholder has in the joint venture transaction.
Transaction Date	The date when the transaction occurred, which might be different from the journal entry effective date or subledger acccounting date.
Distributed Accounted Debit	The distributed debit amount for the stakeholder in the accounting currency.
Distributed Accounted Credit	The distributed credit amount for the stakeholder in the accounting currency.
Distributed Entered Debit	The distributed debit amount for the stakeholder in the entered currency.
Distributed Entered Credit	The distributed credit amount for the stakeholder in the entered currency.
Distribution Only	Indicates whether the distribution for the stakeholder is for distribution only. Distributions marked as “Distribution Only” have a status of “Process complete” and aren't available for invoicing.
Invoicing Partner	The name of the partner associated with the stakeholder that will be invoiced for the distributed amount.
Invoice	The value that identifies the invoice or a credit memo for a joint venture distribution.
Cost Center	The cost center associated with the distributable stakeholder.
Invoice Date	The date that was assigned to the invoice or credit memo when it was created.
Distribution Line Type	The value that identifies the line type of the joint venture distribution line, for example, Original, Reversed, Canceled, and Redistributed.
Transaction Description	The description of the accounting transaction.
Project Costing Status	For a Project Costing integration only. See About Creating and Sending Cost Adjustments to Oracle Project Costing for information about Project Costing statuses.
Project Number	For a Project Costing integration only. The unique identifier for the project that the transaction is associated with.
Project Name	For a Project Costing integration only. The name associated with the project number.
Task Number	For a Project Costing integration only. The unique identifier for a project task that the transaction is associated with.
Task Name	For a Project Costing integration only. The name associated with the task number.
Expenditure Type	For a Project Costing integration only. The expenditure type of the transaction.
Expenditure Type Description	For a Project Costing integration only. The description of the expenditure type.

The page with additional details for a distribution provide information grouped logically in the following sections:

Details

Field	Description
Transaction ID	The unique identifier of the transaction from which the distribution was generated.
Ledger	The name of the ledger associated with the distribution.
Transaction Date	The date when the transaction occurred, which might be different from the journal entry effective date or subledger acccounting date.
Creation Date	The date the distribution was created.
Accounting Date	For distributions originating from manual joint venture source transactions and overhead transactions only. The accounting date of the transaction.
Accounting Period	For distributions originating from manual joint venture source transactions and overhead transactions only. The accounting period determined by the accounting date of the transaction.
Distribution Only	Indicates whether the joint venture stakeholder is participating in the transaction distribution only or is also being invoiced.
Distribution Line Type	The value that identifies the line type of the joint venture distribution line, for example, Original, Reversed, Canceled, and Redistributed.
Distribution Line Number	The distribution line number for a joint venture distribution that's split into multiple lines.
Source	Indicates the source of the joint venture transaction associated with the joint venture distribution. If it’s from a subledger, this field is populated with the value “Subledger” appended with the subledger name, for example, Subledger - Payables.
Source Transaction Reference	For distributions originating from subledger transactions only. The reference for the source transaction that you can use to identify and review the details of the transaction in the source systems. Currently, this field populates the reference for only Payables and Payroll Costing transactions. For Payables transaction, the reference is the invoice number. For Payroll Costing, it’s the concatenation of the Payroll Costing ID, element name (Basic Pay, HRA, and so on) and payroll period name.
Subledger Journal	For distributions originating from subledger transactions only. Click this link to review subledger journal entries from which the joint venture transaction was created. You must be a user who’s set up with the required security to access and review the corresponding journal entries in subledger accounting. See Configure Access to Source Journal Entries from Joint Venture Transactions, Distributions, and Invoices for more information.
General Ledger Journal	For distributions originating from general ledger transactions only. Click this link to review general ledger journal entries from which the joint venture transaction was created. You must be a user who’s set up with the required security to access and review the corresponding journal entries in General Ledger. See Configure Access to Source Journal Entries from Joint Venture Transactions, Distributions, and Invoices for more information.

Ownership Details

Field	Description
Ownership Definition	The name of the ownership definition that was used to split the transaction and generate the distribution.
Ownership Percentage	The percentage of ownership the stakeholder has in the joint venture transaction.
Start Date	The start date of the ownership definition.
End Date	The end date of the ownership definition.
Original Ownership Definition	The name of the default ownership definition associated with the transaction when initially identified for processing. If the transaction was overridden to use a different ownership definition, the name of the ownership definition used to create the distribution is displayed in the Ownership Definition column.
Direct Billed Stakeholder	This column displays the name of the direct billed stakeholder if the entire amount of the transaction was applied to a stakeholder.
Original Direct Billed Stakeholder	The name of the direct billed stakeholder associated with the transaction when initially identified for processing. If the transaction was overridden to use a different stakeholder, the name of the stakeholder used to create the distribution is displayed in the Ownership Definition column.
Ownership Definition Assignment Rule	The name of the assignment rule used to assign the ownership definition or direct billed stakeholder to the joint venture transaction.
Carried Interest Agreement	The name of the carried interest agreement associated with the joint venture distribution.
Description	The description of the carried interest agreement associated with the joint venture distribution.

Stakeholder

Field	Description
Invoicing Partner	The name of the partner associated with the stakeholder that will be invoiced for the distributed amount.
Customer	The name of the customer associated with the invoicing partner.
Supplier	The name of the supplier associated with the invoicing partner.
Cost Center	The cost center associated with the internal stakeholder.
Invoicing Preference	Indicates whether an invoice or a general ledger transaction will be created for the stakeholder.
Original Stakeholder	The original stakeholder associated with the distribution.

Amounts

Field	Description
Transaction Accounted Amount	For subledger and general ledger transactions only. The total transaction amount in the accounting currency. It’s the sum of the debit minus the credit and can be a negative number. A positive number indicates it’s a debit and a negative number indicates it’s a credit. When you hover over the icon, you can view the actual debit and credit amounts used to derive the amount.
Transaction Entered Amount	For subledger and general ledger transactions only. The transaction amount in the entered currency. It’s the sum of the debit minus the credit and can be a negative number. A positive number indicates it’s a debit and a negative number indicates it’s a credit. When you hover over the icon, you can view the actual debit and credit amounts used to derive the amount.
Distributed Accounted Amount	For subledger and general ledger transactions only. The distributed amount for the stakeholder in the accounting currency. It’s the sum of the debit minus the credit and can be a negative number. A positive number indicates it’s a debit and a negative number indicates it’s a credit. When you hover over the icon, you can view the actual distributed debit and credit amounts used to derive the amount.
Distributed Entered Amount	For subledger and general ledger transactions only. The distributed amount for the stakeholder in the entered currency. It’s the sum of the debit minus the credit and can be a negative number. A positive number indicates it’s a debit and a negative number indicates it’s a credit. When you hover over the icon, you can view the actual distributed debit and credit amounts used to derive the amount.
Original Distributed Accounted Amount	For subledger and general ledger transactions only. The original distributed amount for the stakeholder in the accounting currency. It’s the sum of the debit minus the credit and can be a negative number. A positive number indicates it’s a debit and a negative number indicates it’s a credit. When you hover over the icon, you can view the actual distributed debit and credit amounts used to derive the amount.
Original Distributed Entered Amount	For subledger and general ledger transactions only. The original distributed amount for the stakeholder in the entered currency. It’s the sum of the debit minus the credit and can be a negative number. A positive number indicates it’s a debit and a negative number indicates it’s a credit. When you hover over the icon, you can view the actual distributed debit and credit amounts used to derive the amount.
Transaction Amount	For overhead transactions only. The amount of the overhead transaction. When you hover over the icon, you can view whether the amount is a debit or a credit.
Distributed Amount	For overhead transactions only. The distributed amount for the stakeholder. When you hover over the icon, you can view whether the amount is a debit or a credit.
Original Distributed Amount	For overhead transactions only. The original distributed amount for the stakeholder. When you hover over the icon, you can view whether the amount is a debit or a credit.
Rounding Applied	If the stakeholder is a rounding partner, this indicates if the transaction amount could not be divided evenly among stakeholders and the remaining amount was applied to the stakeholder’s distribution.

Accounts

This section displays accounts information only for distributions originating from general ledger and subledger transactions. Accounts information for overhead transactions are in the Overhead section.

Field	Description
Account Type	This indicates if the account is for assets, liabilities, and so forth. The joint venture account types are: Expense (for operating expenses), Assets (for capital expenditures), Revenue, Overhead, and Fees and other charges.
Business Unit	The name of the business unit on the joint venture.
Account	For distributions originating from general ledger and subledger transactions only. The account of the source transaction.
Partner Account	The account in Receivables where invoices generated from joint venture distributions are recorded. If the integration with Project Costing is enabled, the partner account is included in cost adjustments sent to Project Costing.
Receivable Account	For distributions originating from general ledger and subledger transactions only. The receivable account used when creating a receivables invoice, which can be overridden.
Payables Liability Account	For distributions originating from general ledger and subledger transactions only. The liability account used when creating a payables invoice, which can be overridden.
Transaction Description	The description of the accounting transaction.

Project Information

The details in this section are displayed only for distributions originating from subledger transactions and if Project Costing is integrated with Oracle Joint Venture Management.

Field	Description
Project Costing status (displayed as a badge)	See About Creating and Sending Cost Adjustments to Oracle Project Costing for information about Project Costing statuses.
Project Number	The unique identifier for the project that the transaction is associated with.
Project Name	The name associated with the project number.
Task Number	The unique identifier for a project task the transaction is associated with.
Task Name	The name associated with the task.
Expenditure Type	The expenditure type of the transaction.
Expenditure Type Description	The description of the expenditure type.

Journal Transaction Details

This section is displayed only for distributions associated with internal stakeholders that have their invoicing preference set to create journals.

Field	Description
Invoice Number	The value that identifies the journal transaction created for a joint venture distribution.
Invoice Type	The type of journal transaction generated for the joint venture distribution.
Invoice Date	The date that was assigned to the invoice or credit memo when it was created.
Target Transaction ID	The unique identifier for the internal journal entry created for joint venture distributions. This is displayed only if the distribution was to an internal cost center.
Partner Contribution ID	The ID of the partner contribution that was assigned to the joint venture distribution to draw from.
Partner Contribution Request	The name of the partner contribution request that the partner contribution was created from.

Receivables Transaction Details

This section is displayed only for cost distributions associated with stakeholders that have their invoicing preference set to create invoices.

Field	Description
Invoice Number	The value that identifies the invoice or a credit memo for a joint venture distribution.
Invoice Type	The type of invoice generated for the joint venture distribution, such as receivable invoice and credit memo.
Invoice Date	The date that was assigned to the invoice or credit memo when it was created.
Partner Contribution ID	The ID of the partner contribution if a partner contribution was applied to pay for the distribution.
Partner Contribution Request	The name of the partner contribution request if a partner contribution was applied to pay for the distribution and the partner contribution was created from a request.

Payables Transaction Details

This section is displayed only for revenue distributions associated with external stakeholders that have their invoicing preference set to create invoices.

Field	Description
Invoice Number	The value that identifies the payables invoice or debit memo for a joint venture distribution.
Invoice Type	The type of invoice generated for the joint venture distribution, such as payables invoice or debit memo.
Invoice Date	The date that was assigned to the payables invoice or debit memo when it was created.
Partner Contribution ID	The ID of the partner contribution that was assigned to the joint venture distribution to draw from.
Partner Contribution Request	The name of the partner contribution request that the partner contribution was created from.

Overhead

This section is displayed only for distributions originating from overhead transactions.

Field	Description
Method	The name of the method that was used to calculate overhead costs for this joint venture distribution.
Description	The description of the joint venture overhead method.
Type	The method type used to determine how the overhead amount is calculated, for example, Percentage of cost.
Basis Source	The source of the overhead calculation.
Period Basis	This indicates whether the overhead was calculated based on a period, year to period, or inception to period.
Source	This indicates that the source of transaction is overhead.
Business Unit	The name of the business unit on the joint venture.
Transaction Description	The description of the accounting transaction.
Distribution Type	This indicates if the distribution is for overhead or fees and other charges.
Partner Account	The account in Receivables where invoices generated from joint venture distributions are recorded.
Target Transaction Account	The receivable or liability account used when posting a receivables or payables invoice.

Reversal Reason

This section is displayed only for distributions that have the distribution line type “Reversed”.

Field	Description
Change Reason	A user-defined value that indicates the reason the joint venture distribution was canceled.
Change Reason Details	Additional details about the reason the joint venture distribution was canceled, if entered by the joint venture accountant.

Audit

Field	Description
Created By	The user who created the joint venture distribution.
Last Updated By	The user who last updated the joint venture distribution.
Last Updated Date	The date and time when the joint venture distribution was last updated.