1. Using Joint Venture Management
  2. About Audit Reports for Joint Ventures

About Audit Reports for Joint Ventures

You run the "Export Data for Audit Report" mode of the Create Joint Venture Distributions 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, the process extracts additional data required for auditing directly from these subledgers.

The report includes the following information:

  • Transaction reference

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

    • For Payroll Costing, 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.

  • Transaction source, for example, Payables and Payroll

  • Transaction type, for example, Payables Invoice and Payroll Costing

  • Transaction identifier

  • Transaction party identifier (Only for Payables transactions)

  • Transaction party name (Only for Payables transactions)

  • Joint venture

  • Invoicing partner

  • Customer

  • Transaction date

  • General Ledger accounting date

  • Posted date (Only for General Ledger transactions)

  • Transaction description

  • Stakeholder

  • Accounted debit

  • Accounted credit

  • Ownership percentage

  • Distributed debit

  • Distributed credit

  • Currency code

  • Original account

  • Joint venture distribution ID

  • Joint venture distribution line number

  • Joint venture distribution line status, for example, Original, Reversed, and Redistributed

  • Receivables invoice number

  • Receivables invoice date

  • Receivables invoice type, for example, receivables invoice and credit memo

  • Creation date

  • Created by

Additionally, the report also includes the following project information for subledger transactions if Project Costing is integrated with Oracle Joint Venture Management:

  • Project ID

  • Project number

  • Project name

  • Project expenditure type

  • Project task number

  • Project task name

  • Project expenditure organization