Prepare Setup Data

Refer to the Instructions worksheet in each rapid implementation spreadsheet (RIS) for information on how to enter setup data and any data dependencies that must be met. Here are some additional details to remember when adding setup data to each RIS:

• Adding system options to the RapidImplementationForJointVentureSystemOptions.xlsm:

  There are three sets of system options. One set is used to identify the sources of the transaction date in subledger accounting and general ledger transactions, which is an optional configuration. Before you upload this set of system options with this RIS, you must set up Oracle Fusion Cloud Financials to capture the transaction date in subledger accounting and general ledger journals. See About Identifying a Transaction Date for Processing Joint Venture Transactions for more information.

  A second set of system options is for the optional Oracle Joint Venture Management integration with Oracle Project Costing. These system options identify the supporting references set up to capture project details in project-related transactions processed by Joint Venture Management. These details enable Joint Venture Management to send cost adjustments to Project Costing. Before you enter these system options in the RIS, you must set up supporting references in Oracle Financials to capture project details. See Setup Required for the Joint Venture Management Integration with Project Costing for more information.

  Lastly, there is a single system option for identifying the primary segment label. This is the label of the segment in the Financials chart of accounts where the transactions for all your joint ventures are managed. If you don’t enter a value for this system option, Joint Venture Management uses the segment associated with the Cost Center Segment label.

• Adding invoicing partners to the RapidImplementationForInvoicingPartner.xlsm:

  Invoicing partners are associated to stakeholders in a joint venture definition. As such, you should refer to this spreadsheet when completing the RIS for joint venture definitions. You will need to reference the invoicing partner information as you identify the stakeholders for each joint venture definition.

• Adding joint venture definitions to the RapidImplementationForJointVenture.xlsm:

  This spreadsheet has multiple worksheets for entering a joint venture name and business unit, primary segment values, distributable segment values, stakeholders, and ownership definitions with ownership percentages. You have the option to upload only the joint venture name and business unit for each joint venture, and then complete the other details in a separate upload or within the Joint Venture Management application itself.

  This spreadsheet also includes a worksheet to add distributable project value rules to a joint venture definition to distribute transactions related to specific capital projects. This capability requires opting in to additional features. See Identify Distributable Transactions by Project Information for more information.

• Adding joint venture overhead methods to the RapidImplementationForJointVentureOverheadMethod.xlsm:

  You can set up one or more overhead methods for a joint venture. Each overhead method that you add to the spreadsheet must reference a valid joint venture. You can find additional instructions for adding overhead methods in the rapid implementation spreadsheet.

To prepare setup data:

1. Navigate to Setup and Maintenance and select the Joint Venture Management functional area under the Financials offering.

2. In the Joint Venture Management area, select All Tasks in Show drop-down list.

   The system displays a task for each RIS for Joint Venture Management.

3. Click each task to download the associated rapid implementation spreadsheet:

   • Create Joint Venture System Options in Spreadsheet

   • Create Invoicing Partners in Spreadsheet

   • Create Joint Venture Definitions in Spreadsheet

   • Create Joint Venture Overhead Methods in Spreadsheet

4. Open each RIS. If a security warning appears, click Options, select “Enable this content,” and click OK.

5. Follow the instructions in the spreadsheet to enter setup data.

   Note: You can’t upload data in Joint Venture rapid implementation spreadsheets that contain the following special characters: & ‘ “ > <

6. Save the files before you generate XML files from the spreadsheets.