Additional Subledger Information in Joint Venture Transactions

View additional subledger information in joint venture transactions and distributions, including the source invoice number for Payables-originating transactions and the event type for all subledger transactions. These details are available in the Joint Venture Transactions work area, the Joint Venture Distributions details page, and their respective spreadsheets. You can find the invoice number in the Source Reference Number field. Additionally, these new fields are available in OTBI, enabling you to generate comprehensive reconciliation and audit reports.

Business Benefits: 

  • Additional subledger information gives joint venture accountants increased visibility and access to critical transaction details.
  • Including invoice numbers and event types across joint venture work areas and reports helps users efficiently research, reconcile, and correct errors in joint venture setup and individual transactions.
  • Improves accuracy in financial reporting and stakeholder communications. 

Steps to Enable and Configure

You don't need to do anything to enable this feature.

Tips And Considerations

  • Run the process “ESS job to create index definition and perform initial ingest to OSCS” to recreate index definition and perform ingest to Oracle Search Extension Framework database. Run the process twice, once for each index:
    • fa-fin-jv-transactions
    • fa-fin-jv-distributions 
  • The new Source Transaction Reference and Event Type fields are read-only and cannot be edited in the joint venture work areas or Microsoft Excel spreadsheets.
  • You can include these fields in searches and filters for faster identification of relevant transactions.
  • You can run the Identify Joint Venture Transactions process to update existing joint venture transactions with this information without requiring a change to the status of the transactions.

Key Resources

For more information, refer to:

  • Implementing Joint Venture Management guide and
  • Using Joint Venture Management guide.

Access Requirements

The privileges required for access are Review and Update Joint Venture Transactions and View Joint Venture Distributions. These privileges are included as part of the Joint Venture Accountant role.