Working with the Transaction Generator

This topic provides an overview of the transaction generator and discusses how to run the Transaction Generator.

Page Name

Definition Name

Usage

Manage Transaction Generator Page

RUN_RE_GENTRANS

Create a run control ID for the Manage Transactions Generator process and run the process.

The Transaction Generator process generates transactions into the transaction queue by monitoring the transaction schedule and processing transactions into the queue when the schedule date is reached, less the processing lead time that is defined at the business unit level. Use the transaction queue to manage the financial transactions that are created by the transaction generator, as well as the manual ad hoc transaction entries that are entered directly in the transaction queue.

When you run the Transaction Generator process, the process picks up all recurring items that are due within the lead time that is defined for the Lease Administration business unit. Note that two different lead times are defined—one for receivables leases and one for payables leases. You also use the transaction generator to manage automatic lease expiration for leases that are due to expire. When the transaction generator identifies a row that is ready for processing, the system verifies the accuracy of the transaction amounts and modifies the transaction as needed. For example, if a base rent has an indexed escalation and the new index value goes into effect, the transaction schedule amount might be out of date. When the transaction generator picks up this row, the system recalculates the amount, revises the schedule, and inserts the modified transaction into the transaction queue for further processing.

The Transaction Generator processes records in these transaction tables:

  • Lease Transaction (RE_LS_TXN)

    Contains the recurring and nonrecurring lease transactions.

  • Lease Transaction Detail (RE_LS_TXN_DTL)

    Contains the details such as amount per sales categories.

  • Lease Transaction Note (RE_LS_TXN_NOTE)

    Contains the transaction history.

  • Lease Transaction Error (RE_LS_TXN_ERROR)

    Contains the interface error description.

  • Lease Term Schedule (RE_LS_TRM_SCHED)

    Contains the financial terms schedules.

Typically, you run the Manage Transaction Generator process as a scheduled process. You can run the process automatically on a recurring basis or as needed. For efficient and timely processing of any outstanding transactions, you should set up this process to run on a nightly recurring basis. Depending on the volume of transactions that are processed within your organization, you can set up this process to run more frequently, but you should run it at least once every day. You can also initiate this process at any time in addition to the normal recurring schedule.

Use the Manage Transaction Generator page (RUN_RE_GENTRANS) to create a run control ID for the Manage Transactions Generator process and run the process.

Navigation:

Lease Administration > Integrations > Manage Transaction Generator

Note: As part of the shared product functionality, the Manage Transaction Generator page can also be accessed through the Asset Management navigation as follows: Asset Management > Asset Transactions > Leased Assets > Manage Transaction Generator.

Field or Control

Description

Calculate Escalation Catchup

Select the check box and run the transaction generator process to determine the escalation amounts, not calculated due to the unavailability of index values in the system, for the previously generated transactions. The schedule amount is recalculated and the difference in amount, if any, is added to the transaction that is generated.

Although the system does not require any parameters, you can limit the processing by business unit. If you do not enter a business unit, the system will process all business units. Click Run to run the Transaction Generator process.