1. Using Joint Venture Management
  2. Manage Joint Venture Data in Microsoft Excel

Manage Joint Venture Data in Microsoft Excel

You can download, analyze, and edit joint venture data in Microsoft Excel spreadsheets that are integrated with Oracle Visual Builder Add-in for Excel. After you work with the data, you can upload your changes back to Oracle Joint Venture Management.

Each spreadsheet is delivered ready-to-use and contains all columns from the Joint Venture application that the spreadsheet is associated with. Joint venture accountants can download the spreadsheets from Functional Setup Manager or from within each Joint Venture application. The spreadsheets include an Instructions worksheet that describe how to install and enable the add-in.

You can use the spreadsheets to set up and modify the following joint venture configurations:

  • Joint venture definitions

  • Joint venture account sets

  • Ownership definition assignment rules

  • Joint venture periodic adjustment factors

  • Carried interest agreements

  • Operational measure types

You can also use the spreadsheets to download and work with the following joint venture data:

  • Joint venture transactions

  • Joint venture distributions

  • Carried interest distributions

  • Operational states

  • Operational measures

  • Partner contribution requests

  • Partner contributions (added manually)

If Data Security for Joint Venture Management is enabled, you can perform these tasks only for the joint ventures that are associated with the business units you are authorized to manage.

Important: Release 24A is the final release in which data security setup is optional. Therefore, you must set up your users with data security if you haven’t already done so. After this release, if you haven’t set up Joint Venture Management users with data security, they won't be able to access, set up, and process Joint Venture Management objects and data.