Contents

• Title and Copyright Information
• Get Help

1 Introduction to Joint Venture Management

• Introduction to Oracle Joint Venture Management
• How Oracle Joint Venture Management Works

2 Prepare to Implement Joint Venture Management

• What You Need to Know About Oracle Fusion Cloud Financials
• Prerequisites and Assumptions
• About the Setup Tasks for Oracle Joint Venture Management

3 Enable Joint Venture Management

• Enable Oracle Joint Venture Management

4 Set Up Joint Venture Management Users and Security

• About Oracle Joint Venture Management Users and Security
• Set Up Oracle Joint Venture Management Users
  • Joint Venture Accountant
  • Joint Venture Accounting Manager
  • Joint Venture Application Administrator
• Set Up Data Security for Oracle Joint Venture Management
  • Set Up Business Unit Access to Users and Roles
• Configure Access to Source Journal Entries from Joint Venture Transactions, Distributions, and Invoices
• Configure Access to Customer Information
• Configure Access to Joint Venture Operational Reporting in Oracle Transactional Business Intelligence
• Configure Access to BI Publisher Catalog for Oracle Joint Venture Management

5 Set Up Oracle Fusion Cloud Financials to Create Receivables Invoices for Joint Ventures

• Overview of the Setup in Oracle Financials to Create Receivables Invoices for Joint Ventures
• Set Up Partner Accounts for Joint Venture Receivables Invoices
  • Predefined Flexfields for Joint Venture Receivables Invoices
  • Derive the Partner Account for Reimbursement Invoices
  • Derive the Partner Account for Credit Memos
• Set Up Profile Option to Create Receivables Credit Memos
• Derive the Default Receivable Account
• Configure the Joint Venture Transaction Types to Exclude Tax from Receivables Invoices
• Set Up Conversion Rates and Rate Types to Create Invoices in Multiple Currencies
• Create Accounting Entries for Zero Amount Invoice
• Override the Receivable Account Using Subledger Accounting Rules
• Populate the Joint Venture Name in Credit Memos
• Configure the Joint Venture Transaction Type to Create Credit Memos That Increase the Invoice Balance
• Configure the Joint Venture Transaction Type to Create Credit Memos That Exceed the Invoice Balance
• Set Up the Logging Level of Detail for Joint Venture Invoices

6 Set Up Oracle Fusion Cloud Financials to Create Payables Invoices for Joint Ventures

• Overview of the Setup in Oracle Financials to Create Payables Invoices for Joint Ventures
• Set Up Partner Accounts for Joint Venture Payables Invoices
  • Reference Keys for Joint Venture Payables Invoices
  • Override an Account Segment Value for Partner Accounts in Payable Invoices
• Set Up Conversion Rates and Rate Types to Create Payables Invoices in Multiple Currencies
• Override the Liability Account Using Subledger Accounting Rules
• Set Up the Logging Level of Detail for Joint Venture Invoices

7 Identify a Transaction Date for Processing Joint Venture Transactions

• About Identifying a Transaction Date for Processing Joint Venture Transactions
  • Considerations When the Transaction Date is a Free-Form Text Field
• Identify a Transaction Date for Processing Subledger Accounting Transactions
  • Create a Supporting Reference to Capture a Transaction Date
  • Associate the Supporting Reference to Accounting Methods
  • Configure the Joint Venture System Options to Reference the Supporting Reference
• Identify a Transaction Date for Processing General Ledger Journals

8 Setup to Display Joint Venture Transactions, Distributions, and Invoices

• Setup to Display Joint Venture Transactions, Distributions, and Invoices
  • Verify that Oracle Search Extension Framework is Enabled
  • Ingest Joint Venture Data

9 Set Up the Joint Venture Subledger

• Overview of the Joint Venture Subledger Setup
• Tasks in Functional Setup Manager for Setting Up the Joint Venture Subledger
• Set Up the Joint Venture Subledger for Internal Transfer Journals
  • Set Up the Joint Venture Subledger for Internal Transfer Journals Related to Costs
    • Derive Stakeholder Accounts for Internal Transfer Journals Related to Costs
      • Identify Stakeholder Accounts to Record Cost Amounts
      • Review Provided Accounts Rules for Deriving Stakeholder Accounts to Record Cost Amounts
    • Derive Expense Cutback Accounts for Internal Transfer Journals
    • Derive Cost Recovery or Revenue Accounts for Internal Transfer Journals for Overhead
    • Derive Partner Contribution Accounts for Internal Transfer Journals
    • Derive Partner Contribution Accounts for Journal Entries Created to Close Partner Contributions
    • Derive Partner Contribution Accounts for Journal Entries Created to Transfer Partner Contributions
  • Set Up the Joint Venture Subledger for Internal Transfer Journals Related to Revenue
    • Derive Stakeholder Accounts for Internal Transfer Journals Related to Revenue
      • Identify Stakeholder Accounts to Record Revenue Amounts
      • Review Provided Accounts Rules for Deriving Stakeholder Accounts to Record Revenue Amounts
    • Derive Revenue Cutback Accounts for Internal Transfer Journals
• Set Up the Joint Venture Subledger for Statistical Journal Entries
• Set Up the Joint Venture Subledger for Carried Interest Journals
  • Derive Carried Interest Accounts for Carried Interest Journals
  • Derive Expense Cutback Accounts for Carried Interest Journals
  • Derive Revenue Cutback Accounts for Carried Interest Journals
  • Derive Cost Recovery or Revenue Accounts for Carried Interest Journals for Overhead

10 Configure Joint Venture System Options

• About Joint Venture System Options

11 Set Up Invoicing Partners

• About Invoicing Partners
• Invoicing Partner Statuses
• Before You Add Invoicing Partners
• Add an Invoicing Partner
• Activate an Invoicing Partner

12 Create Joint Venture Definitions

• What Is a Joint Venture Definition?
• Monitor Your Progress with Alerts and Dashboards
• Before You Create Joint Venture Definitions
• Enter Joint Venture Basic Properties
  • Specify a Business Unit
  • Associate a Legal Entity with a Joint Venture
  • Specify an Inception Date for a Joint Venture
  • Approve a Joint Venture (optional)
  • Add Attachments
• Enter Billing and Reporting Information
  • Define Information to Create Receivables Invoices
    • Specify a Minimum Amount for Joint Venture Receivables Invoices
    • Specify a Receivable Account for Joint Venture Receivables Invoices
    • Enable Joint Venture Distribution and Invoicing Only for Paid Expenses
  • Define Information to Create Payables Invoices
    • Specify a Minimum Amount for Joint Venture Payables Invoices
    • Specify a Liability Account for Joint Venture Payables Invoices
  • Define Information for Joint Interest Billing Reports
• Identify Distributable Accounts for Joint Venture Processing
  • Use an Account Set to Identify Distributable Accounts
    • Assign an Account Set to Identify Accounts as Distribution Only
    • Example of Identifying Distributable Accounts Using an Account Set
  • Identify Distributable Accounts in the Joint Venture Definition
    • Specify Segments with Distributable Accounts
    • Specify Distributable Segment Values
  • Exclude Joint Venture Invoices and Journals from Oracle Joint Venture Management Processing
• Identify Distributable Transactions by Project Information
  • How Oracle Joint Venture Management Processes Joint Venture Definitions with Project Information
  • Before You Can Specify Project Information in a Joint Venture Definition
  • Use a Project Set to Identify Distributable Transactions
  • Use Project Values to Identify Distributable Transactions
• Set Up Stakeholders
  • Before You Set Up Stakeholders
  • Add an External Stakeholder
  • Add an Internal Stakeholder
  • Add an Interested Stakeholder
  • Activate a Stakeholder
• Set Up Ownership Definitions
  • Rounding Partner
  • Ownership Definition Statuses
  • Example of Processing Transactions with a Default Ownership Definition
  • Example of Assigning Different Ownership Definitions to Transactions
  • Create an Ownership Definition
  • Copy an Ownership Definition
  • Activate an Ownership Definition
  • Specify the Default Ownership Definition for a Joint Venture
• Activate a Joint Venture

13 Create Joint Venture Definitions for Nonoperated Joint Ventures

• About Nonoperated Joint Ventures
• Example of the Setup and Processing of Nonoperated Joint Ventures
• Set Up a Nonoperated Joint Venture Definition

14 Create Overhead Methods for Processing Joint Venture Overhead

• About Overhead Methods
  • Percentage of Cost Overhead Method
  • Rate Based Overhead Method
  • Fixed Amount Overhead Method
  • Generation of Transactions with Overhead Amounts
  • Multiple Overhead Methods for a Single Joint Venture
  • Overhead Method Statuses
  • Examples of Using a Percentage of Cost Overhead Method to Calculate Overhead
  • Example of Using a Percentage of Cost Overhead Method with a Sliding Scale
  • Example of Using a Rate Based Overhead Method to Calculate Overhead
  • Example of Using a Rate Based Overhead Method with a Sliding Scale
• Create an Overhead Method to Calculate Overhead Using a Percentage of Joint Venture Cost Transactions
• Create an Overhead Method to Calculate Overhead Using a Percentage of Costs from Indirect, General Operating Expenses
• Create an Overhead Method to Calculate Overhead Based on a Rate Applied to Operational Measures
• Create a Fixed Amount Overhead Method
• Activate an Overhead Method
• Set Up Periodic Adjustments to Overhead Calculations
  • Example of Applying Periodic Adjustments to Overhead Calculations
  • Create a Periodic Adjustment Factor
  • Activate a Periodic Adjustment Factor
  • Assign a Periodic Adjustment Factor to an Overhead Method
  • Delete a Periodic Adjustment Factor
  • Manage Periodic Adjustment Factors

15 Create and Manage Joint Venture Account Sets

• Overview of Joint Venture Account Sets
• Filter Sets and Filters
• Account Set Statuses
• Create an Account Set for a Joint Venture Definition
• Create an Account Set for an Ownership Definition Assignment Rule
• Create an Account Set for an Overhead Method
  • Example of Setting Up Filter Sets with the Include Primary Segment Values Option Enabled
• Activate an Account Set
• Manage Account Sets

16 Create and Manage Project Sets

• Overview of Project Sets
• Filter Sets and Filters in a Project Set
• Before You Can Create Project Sets
• Project Set Statuses
• Create a Project Set
  • Enter the Basic Details for a Project Set
  • Add Filter Sets and Filters to Your Project Set
• Activate a Project Set
• Delete a Project Set

17 Create Ownership Definition Assignment Rules

• Overview of Ownership Definition Assignment Rules
• How Ownership Definition Assignment Rules Are Applied to Joint Venture Transactions
• Assignment Rule Sequencing
• Example of Setting Up and Processing Assignment Rules
• Before You Create Ownership Definition Assignment Rules
• Create an Ownership Definition Assignment Rule
• Activate an Ownership Definition Assignment Rule
• Manage Ownership Definition Assignment Rules

18 Create Carried Interest Agreements

• About Carried Interest Agreements and the Tracking of Carried Interest
• Where You Can Use Carried Interest Ownership Definitions
• Example of the Setup and Tracking of Carried Interest
• Prerequisite for Setting Up Carried Interest Agreements
• Create a Carried Interest Agreement
  • Enter the Initial Details for the Carried Interest Agreement
  • Add a Stakeholder Group
  • Create Carried Interest Ownership Definitions
  • Review or Update a Carried Interest Ownership Definition
• Activate a Carried Interest Agreement
• Assign a Carried Interest Ownership Definition to a Joint Venture
• Delete a Carried Interest Agreement
• Manage Carried Interest Agreements
  • Changes That You Can Make to a Source Ownership Definition

19 Set Up Joint Venture Management Integration with Project Costing

• About the Oracle Joint Venture Management Integration with Oracle Project Costing Setup
• Prevent the Identification and Distribution of Transactions Related to Capitalization of Fixed Assets
• Exclude Project-Related Transactions that Aren't Distributable from Displaying in Joint Venture Management
• Set Up a Transaction Source for Identifying Cost Adjustments from Oracle Joint Venture Management
• Set Up Supporting References to Capture Project Details in Subledger Accounting Journals
  • Create Supporting References to Capture Project Details
  • Associate the Project Supporting References to Accounting Methods
  • Specify the Supporting References with Project Details in the Joint Venture System Options
• Verify Setup of Partner Accounts for Proper Processing of Cost Adjustments
• Set Up Overrides for Task and Expenditure Type in Cost Adjustments
  • How the System Applies Task and Expenditure Type Overrides to Cost Adjustments
  • Before You Set Up Task and Expenditure Type Overrides
  • Set Up Task and Expenditure Type Overrides

20 Rapid Implementation of Joint Venture Management

• About Joint Venture Rapid Implementation
• Before You Begin
• Configure Oracle Joint Venture Management Rapid Implementation
  • Prepare Setup Data
  • Generate XML Files
  • Upload Setup Data
  • Correct Any Errors and Reload Data

21 Configure Business Intelligence Publisher to Print Joint Venture Receivables Invoices

• Configure Business Intelligence Publisher to Print Joint Venture Receivables Invoices

22 Set Up Joint Venture Reporting

• About Joint Venture Reporting Setup
• Joint Interest Billing Reports
  • Before Users Can View and Work with the BI Publisher Catalog for Oracle Joint Venture Management
  • Before Users Can Deliver Joint Interest Billing Reports Through Emails
  • Set Up Oracle Joint Venture Management to Create and Print Joint Interest Billing Reports
    • Set Up Email Information to Deliver Joint Interest Billing Reports
    • Specify the Report Template and Output Format for Stakeholders
    • Specify the Report Template and Output Format for Joint Ventures
  • Modify the Joint Interest Billing Report to Include Additional Information
    • Modify the Dataset to Add Project Information
    • Modify the Dataset to Add Account Hierarchy
    • Modify the Bursting Definition to Update the Report Delivery Method
    • Build the RTF Template
  • FAQs About Joint Interest Billing Reports

23 Schedule or Run Joint Venture Management Processes

• About Scheduling and Running Oracle Joint Venture Management Processes

24 Migrate Joint Venture Setup Data to Production

• Migrate Joint Venture Setup Data to Production
  • Export Joint Venture Setup Data
  • Import Joint Venture Setup Data

25 Enable Detailed Logging of Joint Venture Management Processes

• Enable Detailed Logging of Oracle Joint Venture Management Processes

26 Audit Joint Ventures

• Overview of Joint Venture Auditing
• Enable Auditing
• View Audit History

27 Manage Joint Venture Management Lookups

• Manage Oracle Joint Venture Management Lookups
  • Create and Edit Lookups

28 Integrate and Extend Joint Venture Management

• Integrate and Extend Oracle Joint Venture Management
• Use Oracle Visual Builder Studio to Extend Oracle Joint Venture Management
  • Set Up Oracle Visual Builder Studio to Extend Oracle Joint Venture Management
  • Extend Oracle Joint Venture Management Pages That Use Dynamic Tables
• Use Descriptive Flexfields to Add Additional Joint Venture Information
  • Set Up Descriptive Flexfields for Oracle Joint Venture Management
    • Create a Global Segment
    • Create a Context Segment

29 Frequently Asked Questions

• FAQs When Implementing Oracle Joint Venture Management