Joint Interest Billing Reports

For each period or on an as-needed basis, you can print a joint interest billing report that provides details about financial transactions for the partners in a joint venture.

This enables the managing partner to provide the partner with details about their share of expenses, revenue, assets, and liabilities. It also provides information on the status of their partner contributions.

You use the Oracle Business Intelligence Publisher (BI Publisher) to create joint interest billing reports. The BI Publisher catalog for Oracle Joint Venture Management includes two predefined templates and a data model containing instructions to retrieve and structure data for the report.

These are the predefined templates for Joint Venture Management:

• Joint Interest Billing For Joint Venture

  Use this template to create a report for one or more joint ventures, which includes financial details for all stakeholders in each joint venture.

• Joint Interest Billing For Stakeholder

  Use this template to create a report by stakeholder, which includes financial details for all of the joint ventures that the stakeholder participates in.

The templates enable you to quickly set up Joint Venture Management to generate reports. To generate a report by joint venture, you simply need to associate the “Joint Interest Billing For Joint Venture” template with the joint venture definition of the joint venture and then choose an output format. To generate a report by stakeholder, associate the “Joint Interest Billing For Stakeholder” template with the with the stakeholder or with the invoicing partner associated with stakeholder, and then choose the output format.

You can deliver the report to stakeholders through email, File, FTP, and so on. The data model contains predefined instructions to deliver the report through email. So if you plan to deliver your reports through email, you only have to set up your email subject and body once in the Joint Venture System Options. You identify the sender’s email address in the joint venture definition or in the process to generate joint interest billing reports.

After specifying the appropriate template for your joint ventures, stakeholders, or both, you can run the process to generate the reports by joint venture or by stakeholder.

You also have the option to modify the provided templates to include additional information such as project, account hierarchy, and so on.