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.

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)

• Joint venture source transactions (manual and overhead)

  You can use a spreadsheet to add and update manual joint venture source transactions and update the status, the transaction date, and the accounting date in overhead source transactions.

You can use spreadsheets to perform these tasks only for the joint ventures that are associated with the business units you're authorized to manage through data security.

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