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

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 Liability Account for Partner Contribution Invoice Lines in Joint Venture 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 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
  • 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 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 Values
  • How Oracle Joint Venture Management Processes Joint Venture Definitions with Distributable Project Value Rules
  • Before You Create Distributable Project Value Rules
  • Create a Distributable Project Value Rule
• 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 Ownership Definition Assignment Rules

• Overview of Ownership Definition Assignment Rules
• How Ownership Definition Assignment Rules Are Applied to Joint Venture Transactions
• 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

17 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

18 Set Up Joint Venture Management Integration with Project Costing

• About the Oracle Joint Venture Management Integration with Oracle Project Costing Setup
• Opt in to Features Required for the Integration with Oracle Project Costing
• Prevent the Identification and Distribution of Transactions Related to Capitalization of Fixed Assets
• Exclude Nondistributable Project-Related Transactions 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
• Set Up Oracle Joint Venture Management to Display Project Values by Joint Venture
  • Activate Profile Option to Enable the Project Descriptive Flexfield Association
  • Set Up a Descriptive Flexfield in Oracle Fusion Cloud Project Management
  • Set Up the Joint Venture System Options with the Descriptive Flexfield Attribute
  • Associate Joint Ventures to Projects in Oracle Fusion Cloud Project Management
  • Set Up Oracle Joint Venture Management Users with Privilege to View Project Values

19 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

20 Configure Business Intelligence Publisher to Print Joint Venture Receivables Invoices

• Configure Business Intelligence Publisher to Print Joint Venture Receivables Invoices

21 Joint Venture Reporting

• About Joint Venture Reporting
• Joint Venture Operational Reporting
  • Before Users Can Create Joint Venture Operational Reports
  • Considerations and Recommendations for Creating Joint Venture Operational Reports
• Joint Interest Billing Reports
  • Before Users Can View and Work with the BI Publisher Catalog for Oracle Joint Venture Management
  • Set Up Joint Venture Management to Create and Print Joint Interest Billing Reports
    • Before You Can Deliver Joint Interest Billing Reports Through Emails
    • 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
  • Generate a Joint Interest Billing Report
  • 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

22 Schedule or Run Joint Venture Management Processes

• About Scheduling and Running Oracle Joint Venture Management Processes

23 Migrate Joint Venture Setup Data to Production

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

24 Enable Detailed Logging of Joint Venture Management Processes

• Enable Detailed Logging of Oracle Joint Venture Management Processes

25 Audit Joint Ventures

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

26 Manage Joint Venture Management Lookups

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

27 Integrate and Extend Joint Venture Management

• Integrate and Extend Oracle Joint Venture Management
• 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

28 Frequently Asked Questions

• FAQs When Implementing Oracle Joint Venture Management