Audit Reports for Joint Ventures

You might be required to provide an audit report to external auditors to help ensure that the joint venture is operating in accordance with the joint operating agreement. The report includes a subset of the transactional data for joint venture costs, expenses, and other transactions, along with information about the original transaction. If Project Costing is integrated with Oracle Joint Venture Management, the report also includes project information for subledger transactions.

You run a process to retrieve and extract the data to a file in CSV (Comma-Separated Values) format. The process extracts transactional data from the Joint Venture Distributions work area. For joint venture transactions that originate from Oracle Payables and Payroll Costing, it extracts additional data, such as the transaction reference, directly from these subledgers.

The transaction reference differs depending on the origin of the transaction:

• For Payables transactions, this is a concatenation of the invoice number, invoice line number, distribution line number, and invoice date.

• For Payroll Costing transactions, this is a concatenation of the Payroll Costing ID, element name (basic Pay, HRA, and so on), and payroll period.

• For General Ledger transactions, this is a concatenation of the journal source, journal name, and journal batch name.

• For joint venture source transactions, this is a concatenation of the joint venture name, transaction date, and overhead method name.

Perform the following steps to run the process to generate audit reports:

Note: You can run the process only for the joint ventures that are associated with the business units you're authorized to manage through data security.

1. From the Home page, select Joint Venture Management, and then select Create Joint Venture Distributions from the Quick Actions list.

2. For the Processing Mode, select Export Data for Audit Report.

3. Complete at least one of the following parameters to select the data for the report. The process will end in error otherwise.

   • Transaction from Date and Transaction to Date.

   • Receivables Invoice from Date and Receivables Invoice to Date.

     If you use these parameters, you must enter both the beginning and ending date in the range.

   • Process By. Use the Process By drop-down list to select transactions by period or accounting date.

     If you select Period, then select the period in the field provided.

     If you select Accounting Date, use these fields to enter a date range:

     • From Date. If you complete this field and leave the To Date field blank, the process will select all transactions that have the accounting date starting from the date you specified to the current date.

     • To Date. If you complete this field and leave the From Date field blank, the process will select all transactions that have the accounting date before and on the date you specified.

     Note: Only transactions posted in the specified period or within the date range will be processed.

     If you select Period or Accounting Date in the drop-down list but don’t specify a period or a date range, the process will select transactions that have an accounting date corresponding with the earliest open period.

     If you leave the Process By field blank, the process will select all transactions that are available for processing.

4. Optionally, complete these ranges to select data for the report:

   • From and To Joint Venture

   • From and To Invoicing partner

   • From and To Project Number

   If you enter only the beginning value in a range, the process will run over all data starting from the value you entered. If you leave these fields blank, the process will run over all your joint ventures, invoicing partners, and project numbers.

5. Click Submit.

6. Click your instance of the Create Joint Venture Distributions process in the Search Results section. In the Log and Output section, click the attachment to find the generated file in CSV format. Or, you can click the notifications button (bell icon) and access the file from the All Notifications window. You can also view a log for the details of any processing errors. For example, if you don't select a value in the Process By field or specify at least one date range for transactions or invoices, the process doesn't generate the file and reports the error in the log.