Oracle Financials Cloud: Joint Venture Management Fundamentals

Introduction to Joint Venture Management

• Course Objectives
• Course Schedule
• Lesson Objectives
• Oracle Joint Venture Management Overview
• Enterprise Structures Model Related to Joint Venture Management
• Oracle Joint Venture Business Process
• Joint Venture Distributions Example
• How Joint Venture Management Works
• Step 1: Create Joint Venture Definitions
• Step 2: Automatically Identify Joint Venture Transactions
• Step 3: Automatically Calculate Splits and Create Distributions
• Step 4: Review Distributions
• Step 5: Automatically Create Invoices of the Distributed Costs
• Joint Venture Overhead
• Auditing and Tracking in Joint Venture Management
• Summary

Common Configuration for Joint Venture Management

• Objectives
• Joint Venture Prerequisites and Assumptions
• Audience and Scope
• Practice 2-1 Overview: Entering Cost Center Segment Values in Chart of
• Accounts
• Enabling Joint Venture Management
• Setting Up Joint Venture Management Users and Security
• Joint Venture Functional Security
• Practice 2-2 Overview: Adding the Joint Venture Management Roles to
• Your User
• Practice 2-3 Overview: Creating Joint Venture Data Security for Your User
• Summary

System Configuration for Joint Venture Management

• Objectives
• Enabling Detailed Logging of Joint Venture Management Processes
• Practice 3-1 Overview: Enabling Detailed Logging of Joint Venture Management Processes
• Ingesting Joint Venture Invoice Data and Setting Up Search
• Demonstration 3-2 Overview: Ingesting Joint Venture Invoices Data and Setting Up Search
• Creating Receivables Invoices: Prerequisites
• Demonstration 3-3 Overview: Reviewing Setups to Create Receivables Invoices for Joint Venture
• Additional Information in Receivables Invoices
• Demonstration 3-4 Overview: Setups for Printing Joint Venture Receivables
• Invoices
• Creating Rules in Subledger Accounting
• Subledger Accounting Setup to Derive the Offset to Receivables Account for Joint Venture Invoices
• Setting Up Oracle Financials to Capture a Transaction Date in General Ledger Journals
• Setting Up Oracle Financials to Capture a Transaction Date in Subledger Accounting Journals
• Demonstration 3-5 Overview: Setting Up Offset to Receivable Accounts for Joint Venture Invoices
• Managing Joint Venture Management Lookups
• Creating and Editing Lookups
• Specifying Transaction Date Sources in the Joint Venture System Options
• Joint Venture System Options
• Demonstration 3-6 Overview: Identifying a Transaction Date for Processing Joint Venture Transactions
• Summary

Set Up Invoicing Partners and Joint Venture Definitions

• Objectives
• Setting Up Joint Venture Management
• Invoicing Partners: Overview
• Adding an Invoicing Partner
• Adding and Activating an Invoicing Partner
• Practice 4-1 Overview: Creating Invoicing Partners and Associating Them with Customers
• Joint Venture Definitions: Overview
• Entering Joint Venture Details
• Identifying Distributable Accounts
• Setting Up Stakeholders
• Adding Different Types of Stakeholders
• Setting Up Ownership Definitions
• Rounding Partner
• Ownership Definition Status
• Activating an Ownership Definition
• Minimum Amount for Joint Venture Receivables Invoices
• Approving a Joint Venture
• Activating a Joint Venture
• Additional Joint Venture Activities
• Practice 4-2 Overview: Setting Up a Joint Venture Definition
• Using Alerts and Dashboards
• Summary

Joint Venture Management Rapid Implementation

• Objectives
• Overview of Joint Venture Rapid Implementation
• Configuring Joint Venture Management Rapid Implementation
• Preparing Setup Data
• Setup Steps for Rapid Implementation
• Using Rapid Implementation Spreadsheet
• Practice 5-1 Overview: Creating a Joint Venture Definition Using a Rapid Implementation Spreadsheet
• Summary

Migrating Joint Venture Setup Data to Production

• Objectives
• Migrating Joint Venture Setup Data to Production
• Creating an Implementation Project for Migrating Setup Data
• Exporting Joint Venture Setup Data
• Importing Joint Venture Setup Data
• Demonstration 6-1 Overview: Exporting Joint Venture Setup Data
• Summary

Manage Joint Venture Transactions and Distributions

• Objectives
• Joint Venture Management Processes: Overview
• Joint Venture Business Process
• Processing Joint Venture Transactions
• How Joint Venture Management Works
• Step 1: Automatically Identify Joint Venture Transactions
• Step 2: Automatically Calculate Splits and Create Distributions
• Step 3: Review Distributions
• Step 4: Automatically Create Invoices of the Distributed Costs
• Searching for Joint Venture Invoices
• Scheduling and Running Processes for Joint Venture Management
• Practice 7-1 Overview: Creating Payable Invoices by Using a Spreadsheet
• Practice 7-2 Overview: Running the Scheduled Process to Identify Joint Venture Transactions
• Managing Joint Venture Transactions and Distributions
• Accessing Joint Venture Transactions and Distributions Work Areas
• Managing Joint Venture Transactions
• Searching for Joint Venture Transactions
• Transaction Details: Joint Venture Transactions Work Area
• Overriding Joint Venture Transaction Processing
• Overriding How Transactions Are Processed
• Resolving Disputes Over Distributed Amounts
• Practice 7-3 Overview: Editing Transactions in the Joint Venture Transactions Work Area
• Practice 7-4 Overview: Deleting Transactions in the Joint Venture Transactions Work Area
• Practice 7-5 Overview: Downloading the Joint Venture Transactions Template and Editing a Joint Venture Transaction’s Status
• Managing Joint Venture Distributions
• Deleting Joint Venture Distributions
• Distributions with Incorrect Amounts
• Transaction Split When Entire Transaction Amount Should be Applied to Direct Billed Stakeholder
• Incorrectly Identified Transactions
• Practice 7-6 Overview: Running the Scheduled Process to Create Joint Venture Distributions
• Practice 7-7 Overview: Editing Distributions in the Joint Venture Distributions Work Area
• Practice 7-8 Overview: Deleting Distributions in the Joint Venture Distributions Work Area
• Practice 7-9 Overview: Downloading the Joint Venture Distributions Spreadsheet Template and Editing a Distribution
• Practice 7-10 Overview: Correcting Issues with Joint Venture Transactions and Distributions
• Billing Retroactive Adjustments for Joint Ventures
• Correcting Issues with Joint Venture Transactions and Distributions
• Summary

Set Up and Draw from Partner Contributions

• Objectives
• Partner Contributions
• Setting Up Partner Contributions
• Drawing from Partner Contributions
• Managing Partner Contributions
• Editing Partner Contributions
• Practice 8-1 Overview: Creating a Payables Invoice and Running Joint Venture Scheduled Processes
• Practice 8-2 Overview: Setting Up and Drawing from Partner Contributions
• Closing a Partner Contribution
• Summary

Create Invoices to Bill Partners for Joint Venture Costs

• Objectives
• Managing Joint Venture Invoices
• Correcting Issues with Creating Joint Venture Invoices
• Practice 9-1 Overview: Running the Create Joint Venture Invoices Process and Searching for Invoices
• Practice 9-2 Overview: Updating Accounting Information for Posted Receivables Invoices
• Practice 9-3 Overview: Creating and Printing Joint Venture Invoices
• Summary

Create Billing Adjustments and Redistribute Joint Venture Transactions to Rebill

• Objectives
• Changes to an Active Date Effective Ownership Definition
• Example: Reversing Joint Venture Invoices and Redistributing the
• Transactions
• Joint Venture Invoicing Adjustments Process
• Creating Reversed Distributions
• Redistribution After the Reversal Process
• Practice 10-1 Overview: Running the Scheduled Process to Create Reversed Distributions and Redistributions
• Sending the Reversed Distributions to Create Credit Memos
• Practice 10-2 Overview: Running the Scheduled Process to Send Reversed Distributions to Create Credit Memos
• Creating Credit Memos for Joint Venture Invoices
• Practice 10-3 Overview: Running the Scheduled Process to Create Credit Memos for Reversed Distributions
• Updating Credit Memo Information in Joint Venture Management
• Practice 10-4 Overview: Running the Scheduled Process to Update Credit Memo Information for Reversed Distributions
• Reversing Distributions Associated with Partner Contributions
• Summary

Set Up Joint Venture Management Integration with Project Costing

• Objectives
• Setting Up Joint Venture Management Integration with Project Costing
• Prerequisites for Exporting to Project Costing
• Demonstration 11-1 Overview: Opting In to Project Capitalization and Progress Management Features
• Specifying a Transaction Source to Identify Cost Adjustments to Import into Project Costing
• Creating Transaction Sources and Document Entries
• Demonstration 11-2 Overview: Setting Up a Project Transaction Source for Identifying Cost Adjustments from Joint Venture Management
• Setting Up Oracle Financials to Capture Project Details in Subledger Accounting Journals
• Demonstration 11-3 Overview: Reviewing Supporting References to Capture Project Details
• Demonstration 11-4 Overview: Reviewing Supporting References Association to Journal Entry Rule Set
• Specifying Project References in Joint Venture System Options
• Demonstration 11-5 Overview: Joint Venture Management System Options for Project References
• Summary

Create Cost Adjustments for Project Costing

• Objectives
• Creating and Sending Cost Adjustments to Project Costing: Overview
• Tracing Transactions to Project Costing and Receivables
• Task and Expenditure Type Overrides
• Cost Adjustments Sent to Project Costing as Accounted
• Project Costing Statuses and the Processing of Cost Adjustments
• Creating Cost Adjustments for Project Costing: Example
• Creating Cost Adjustments for Distributions in Available to Process Status:
• Example
• Importing Cost Adjustments into Project Costing: Example
• Prerequisites for Creating Cost Adjustments for Project Costing
• Practice 12-1 to 12-3 Overview: Creating Projects, Payables Invoices, and Importing to Project Costing
• Creating and Sending Cost Adjustments to Project Costing
• Joint Venture Management: Processes Flow
• Practice 12-4 to 12-7 Overview: Creating Joint Venture Distributions, Invoices, and Updating Ledger
• Creating Project Costing Adjustments
• Practice 12-8 Overview: Creating Cost Adjustments
• Importing Cost Adjustments into Project Costing
• Practice 12-9 Overview: Importing Costs from Joint Venture Management to Projects
• Updating Project Costing Status to Process Complete
• Practice 12-10 Overview: Updating Project Costing Status to Process Complete and Verifying
• Troubleshooting Issues with Cost Adjustments
• Summary

Managing the Life Cycle of Joint Venture and Joint Venture Definitions

• Objectives
• Managing the Life Cycle of Joint Venture Definitions
• Practice 13-1 Overview: Searching and Reviewing a Joint Venture Definition and Adding a Distributable Account to It
• Modifying a Joint Venture: Changing the Status of a Joint Venture
• Updating Distributable Accounts
• Modifying a Joint Venture: Updating Distributable Accounts
• Modifying a Joint Venture: Updating a Stakeholder
• Modifying a Joint Venture: Updating an Ownership Definition
• Modifying a Joint Venture: Frequently Asked Questions
• Deleting a Joint Venture
• Summary

Monitor Joint Venture Data in Joint Venture Accounting Manager Dashboard

• Objectives
• Joint Venture Accounting Manager Dashboard
• Practice 14-1 Overview: Reviewing the Data in Joint Venture Accounting Manager Dashboard
• Using Alerts and Dashboards
• Summary

Joint Venture Reporting

• Objectives
• Creating Audit Reports for Joint Ventures
• Process to Create Audit Reports
• Practice 15-1 Overview: Running the Scheduled Process to Export Data for Audit Reports
• Summary