1. Implementing Joint Venture Management
  2. Prepare Setup Data

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.

  • 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 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.