Predefined Flexfields for Joint Venture Receivables Invoices

Flexfields allow additional joint venture information to be captured and stored as references for the invoice in Oracle Receivables. Six flexfields are preconfigured with joint venture attributes. These flexfields are grouped using the context value Joint Venture Invoice.

When you create mapping sets to derive the segment values for the partner account, you use a combination of these flexfields as input sources. Subledger accounting uses the input sources in a mapping set to select joint venture invoices. It uses output sources to override the original segment values for the selected invoices.

This table lists the flexfields that you can use to derive the segment values for the partner account.

Flexfield Attribute
Transaction Line Flexfield Attribute 1 Joint Venture Name
Transaction Line Flexfield Attribute 2 Primary Segment Value
Transaction Line Flexfield Attribute 4 Joint Venture Distribution Type
Transaction Line Flexfield Attribute 5 Joint Venture Source ID
Transaction Line Flexfield Attribute 6 Account Code Combination ID
Transaction Line Flexfield Attribute 9 Project Number

The joint venture distribution type code can be E (Expense), A (Assets), H (Overhead), F (Fees and other charges), or P (partner contributions).

The joint venture source ID can be the distribution ID or partner contribution ID. The joint venture invoicing process generates the distribution ID when you create receivables invoices to reimburse distributed costs. The joint venture partner contributions process generates the partner contribution ID for receivables invoices that you create to collect cash advances from partners.

To review the flexfields for joint venture invoices:

  1. Navigate to Setup and Maintenance and select the Receivables functional area under the Financials offering.

  2. In the Search Tasks field, enter Manage Receivables Descriptive Flexfields and click the search button.

  3. Click the task Manage Receivables Descriptive Flexfields.

  4. On Manage Receivables Descriptive Flexfields page, in the Flexfield Code field, enter RA_INTERFACE_LINES and click Search.

  5. Select the Line Transactions row and click Edit.

  6. On Edit Descriptive Flexfield: Line Transactions, click Manage Contexts.

  7. On Manage Contexts page, in the Context Code field, enter Joint Venture Invoice.

  8. Under Search Results, select the row for Joint Venture Invoice and click Edit.

  9. On Edit Context: Joint Venture Invoice page, review the flexfields for joint venture invoices.