1. Implementing Joint Venture Management
  2. Identify a Transaction Date for Processing General Ledger Journals

Identify a Transaction Date for Processing General Ledger Journals

Determine the field or attribute that you want to use to capture the transaction date for general ledger journals. You can then specify this field or attribute in the Joint Venture System Options for the general ledger transaction date.

For general ledger journal entries, you can use the effective date or reference date as the transaction date for a journal. There are also header and line level attributes that can be used by descriptive flexfields to enter a transaction date. After identifying the source to use for the transaction date in the general ledger, perform the following steps to specify this source in the Joint Venture System Options.

  1. In the Functional Setup Manager, select the Joint Venture Management functional area under the Financials offering.
  2. Click the Manage Joint Venture System Options task.
  3. Under Transaction Date References, click the GL Selection Date list and select the source for the journal date:
    • General ledger reference date. This is a field in the header of general ledger journals that can be used to capture the transaction date.
    • A general ledger attribute. If a descriptive flexfield was set up to capture the transaction date, select the attribute defined in the flexfield to capture the date.
    • Or select one of the date or text attributes, which can be used with a flexfield.
    Caution: A flexfield defined with a general ledger line text attribute to capture the transaction date requires users to manually enter a date in a journal entry. For Oracle Joint Venture Management to process these transactions correctly, users must enter the date in this format if the source of transaction date is a free-form text field: YYYY/MM/DD. If this format isn't used, unpredictable results will occur when running the Identify Joint Venture Transactions process.
  4. Configure the Default GL Transaction Date system option to determine how to handle the processing of transactions with a missing date:
    • Select to use the general ledger effective date or system date for the transaction date
    • Or select “No date” to leave the transaction date blank. This sets the transaction to an error status in the Joint Venture Transactions work area. This enables you to locate the transactions in error for troubleshooting purposes.
  5. Click Save.