Reviewing and Revising Joint Venture Account Ledger Records (P09J11)

After running the R09J401, you can review, and if necessary, revise the records in the F09J11 using the Joint Venture Account Ledger Revisions program (P09J11). This program enables you to manually enter or override the DOI or the direct billed partner that was assigned to the F09J11 record by the R09J401.

You can use this program to make the following updates to the joint venture account ledger records:

• Update the Transaction Status value.

  When records are created in the F09J11 table, they are automatically assigned the Available to Process status. You can manually update this status if necessary.

• Update the DOI Name value.

  This is the DOI that was assigned to the record by the R09J401 program. You can update this value if necessary.

  Note that you can have a value in only one of the following fields: DOI Name, the Direct Billed To Insider BU, or the Direct Billed To Outside Partner. Each record in the F09J11 must have either a valid DOI or partner for direct billing to complete the distribution process.

• Update the Direct Billed To Outside Partner or Direct Billed To Insider BU value.

  If you do not want the transaction amount to be distributed among partners using a DOI, you can specify that you want the entire amount to be directly billed to a single partner. If the single partner is an insider, you update the Direct Billed To Insider BU field. If the single partner is an outside partner, you update the Direct Billed To Outside Partner field.

  Note that you can have a value in only one of the following fields: DOI Name, the Direct Billed To Insider BU, or the Direct Billed To Outside Partner. Each record in the F09J11 must have a valid DOI or direct billed partner to complete the distribution process.

• Remark

  You can enter a remark on any of the F09J11 records.

Note: You cannot update individual records or perform mass update of multiple records for transactions that have the Process Complete status. When you make changes to individual records using the editable fields in the grid, the system requires you to click OK on the form to apply the changes. However, when you use the mass update features, the system applies the changes immediately and does not require you to click OK on the form.

You can also use the P09J11 program to perform specific searches over the records in the F09J11. Using options on the form header, you can easily search for these types of records:

• DOI or Direct Billed Not Assigned

  This option displays all records that have a blank DOI Name, blank Direct Billed To Outside Partner, and blank Direct Billed To Insider BU field. Oracle recommends doing this search after processing the R09J401 to identify and update these records. The system cannot successfully complete distribution processing for these records.

  If records exist when you use this search option, it is because no DOI rule matched the criteria of the F09J11 record. You might need to reevaluate your DOI assignment rules, and create additional rules for these transactions.

• DOI or Direct Billed Assigned

  This option displays all records that include a value in the DOI Name, Direct Billed To Outside Partner, or Direct Billed To Insider BU field.

• DOI Direct Billed Overridden

  This option displays all records where the value in the Original DOI Name, Original Direct Billed To Outside Partner, or Original Direct Billed To Insider BU field does not match the value in the DOI Name, Direct Billed To Outside Partner, or Direct Billed To Insider BU field respectively.

Mass Update Features

You can also use several mass update features to update multiple records at the same time. You can select records for mass update using the selection box at the beginning of each row, or you can use the form header, QBE line, or Advanced Query function to search for all records that you want to update.

If you select records using the selection box, you can then select the Update Selected or Delete Dist Selected option from the Row menu on the Joint Venture Account Ledger Revisions form. If you use query criteria to search for the records you want to update, you can choose Update All, Delete All, or Delete Dist All from the Form menu. The Delete All option enables you to delete all the records included in your query that are not at the Process Complete status. The Delete Dist Selected and Delete Dist All options enable you to reset the distribution information of selected records or all the records included in your query. You can then enter a a new DOI or a direct billed partner to the records.

Note: If you want to delete distribution records associated with the joint venture account ledger transaction, all the associated distributed details must not be at the Process Complete status. Distribution records at any other status can be deleted.

Note: Processing numerous records at a time using the mass update features may lead to time-out web exception error. Run the Joint Venture Account Ledger and Dist Detail Revisions batch program (R09J412) to update a large volume of account ledger records. See (Release 9.2 Update)Processing Joint Venture Account Ledger and Distribution Transactions Using a Batch Process (R09J412).

Both the Update Selected and Update All options enable you to make the following updates to the selected records:

• DOI Name

  You can update the DOI for all selected records.

  Note that if you have selected records with a value in the Direct Billed To Outside Partner or Direct Billed To Insider BU field, the system clears that value and populates the DOI Name field with the value you specify.

• Direct Billed To Outside Partner

  You can update the Direct Billed To Outside Partner used for direct billing for the selected records to an outside partner.

  Note that if you have selected records with a value in the DOI Name or Direct Billed To Insider BU field, the system clears that value and populates the Direct Billed To Outside Partner field with the value you specify.

• Direct Billed To Insider BU

  You can update the Direct Billed To Insider BU used for direct billing for the selected records to an insider business unit.

  Note that if you have selected records with a value in the DOI Name or Direct Billed To Outside Partner field, the system clears that value and populates the Direct Billed To Insider BU field with the value you specify.

• Transaction Status

  You cannot change the Transaction Status to Process Complete. If you want to prevent the transaction from being processed, you can delete the transaction or change the Transaction Status to On Hold.

• Clear for Reassignment

  After using this option, the DOI and Direct Bill fields will be blank. You must rerun the R09J401 program to process the DOI Assignment Rules over the records.

• Reset DOI or Direct Billed to Original

  This option returns the DOI and Direct Billed fields of the selected F09J11 records to the state they were in immediately after running the R09J401 program.

Note: When using the mass update features, you can update only one of these values at a time:

• DOI Name

• Direct Billed To Outside Partner

• Direct Billed To Insider Business Unit

• Clear for Reassignment

• Reset DOI or Direct Billed to Original

You can update the Transaction Status value by itself, or along with one of these options.

You can use the media object attachment feature to save and attach documents or files that are relevant to the joint venture.

For transactions where the amounts have been distributed to the partners, you can access the Work with JV Account Ledger program (P09J12) from the Row menu on the Joint Venture Account Ledger Revisions form. You use this program to review distribution information for the selected transaction. You can also revise the transaction status and remark for the transaction.