Search Results okl_txl_itm_insts_pk

Overview

The OKL_TXL_ITM_INSTS table is a core transactional entity within the Oracle E-Business Suite Lease and Finance Management (OKL) module, specifically for versions 12.1.1 and 12.2.2. It functions as a staging or transaction table at the contract line level. Its primary role is to capture and temporarily hold critical asset location attributes required by the Oracle Install Base (CSI) module before a lease or finance contract can be activated. This table facilitates the integration between the leasing lifecycle and the physical asset tracking system, ensuring that asset instance data is correctly prepared and validated for handoff to the Install Base repository.

Key Information Stored

The table's structure is designed to link leasing transaction data with physical asset instances. While the full column list is not provided in the metadata, the documented foreign key relationships highlight its most critical columns. The primary key is the ID column. The INSTANCE_ID column holds a reference to a specific serialized item in the CSI_ITEM_INSTANCES table. The ASD_ID column links to the OKL_TXD_ASSETS_B table, connecting to detailed asset definition data. Finally, the TAS_ID column references the OKL_TRX_ASSETS table, tying the record to the broader asset transaction context within the lease contract line.

Common Use Cases and Queries

The primary use case for this table is during the contract activation workflow. Data is populated into OKL_TXL_ITM_INSTS as part of processing a contract line, capturing the intended Install Base location details for the leased asset. A common operational query would join this table to CSI_ITEM_INSTANCES to validate that all required asset instances for a pending contract have their location attributes correctly staged. For troubleshooting, one might query for records where the INSTANCE_ID is populated but the corresponding contract remains in a draft status. A sample reporting query to list staged assets for a contract line would be:

• SELECT txi.instance_id, csi.serial_number, txi.tas_id
• FROM okl_txl_itm_insts txi, csi_item_instances csi
• WHERE txi.instance_id = csi.instance_id
• AND txi.tas_id = :p_tas_id;

Related Objects

OKL_TXL_ITM_INSTS is centrally connected to several key objects in the OKL and Install Base modules, as defined by its foreign key constraints.

• CSI_ITEM_INSTANCES: Joined via OKL_TXL_ITM_INSTS.INSTANCE_ID. This is the definitive relationship to the serialized asset in the Install Base.
• OKL_TXD_ASSETS_B: Joined via OKL_TXL_ITM_INSTS.ASD_ID. This links to the transactional asset definition details.
• OKL_TRX_ASSETS: Joined via OKL_TXL_ITM_INSTS.TAS_ID. This connects the record to the overarching asset transaction within the lease contract.

The table's primary key, OKL_TXL_ITM_INSTS_PK on the ID column, is referenced by any other tables or integrity constraints that require a link to this staging data.