Search Results ars_code

Overview

OKL_ASSET_RETURNS_ALL_B is the core transaction table within the Oracle E-Business Suite Leasing and Finance Management (OKL) module for managing assets that come off lease following a contract termination, as well as assets identified as potential returns. It functions as the operational record for the off-lease asset lifecycle — from return notification through repossession, title transfer, and repurchase or relocation processing. The table is owned by the OKL schema, holds 59 documented columns in ETRM 12.2.2, and is classified as VALID. Its primary key, OKL_ASSET_RETURNS_ALL_B_PK, is defined on the ID column, with the unique index OKL_ASSET_RETURNS_ALL_B_U1 also enforced on ID.

From a Data Vault modeling perspective, the heuristic classification is satellite-leaning. The table carries descriptive, time-stamped attributes (return dates, hold-until dates, repurchase indicator, floor price) that behave like satellite payload rather than purely relational hub keys, though its foreign keys to master and transactional tables also give it linking characteristics.

Key Information Stored

• ID — surrogate primary key and unique-index business-key candidate; the internal identifier for each asset return record.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the Oracle framework.
• KLE_ID — foreign key to OKL_K_LINES, tying the return to the originating lease line.
• IMR_ID — foreign key to MTL_SYSTEM_ITEMS_B, identifying the returned inventory item.
• RMR_ID — foreign key to JTF_RS_TEAMS_B, associating the responsible sales or resource team.
• SECURITY_DEP_TRX_AP_ID — links the return to a security deposit transaction.
• LEGAL_ENTITY_ID — foreign key to FV_LEGAL_ENTITIES, identifying the owning legal entity.
• ARS_CODE — the asset return status code governing workflow state.
• DATE_RETURN_DUE, DATE_RETURN_NOTIFIED, DATE_RETURNED, DATE_TITLE_RETURNED — the core return milestone dates.
• DATE_REPOSSESSION_REQUIRED, DATE_REPOSSESSION_ACTUAL, DATE_HOLD_UNTIL — repossession and hold scheduling attributes.
• REPURCHASE_AGMT_YN, FLOOR_PRICE, NEW_ITEM_PRICE, NEW_ITEM_NUMBER — repurchase and replacement-item commercial terms.
• ASSET_FMV_AMOUNT — fair market value recorded at return.
• ORG_ID, CURRENCY_CODE and conversion columns — multi-org and currency context.
• ATTRIBUTE1–15, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE provide the standard extensible and audit columns.

Common Use Cases and Queries

Reporting on off-lease inventory typically joins OKL_ASSET_RETURNS_ALL_B to OKL_K_LINES and MTL_SYSTEM_ITEMS_B to reconcile returned assets against lease contracts. A representative query filters by legal entity and status:

• SELECT ar.ID, ar.KLE_ID, ar.IMR_ID, ar.ARS_CODE, ar.DATE_RETURNED FROM OKL_ASSET_RETURNS_ALL_B ar WHERE ar.ORG_ID = :org_id AND ar.LEGAL_ENTITY_ID = :le_id
• Analyze outstanding returns by comparing DATE_RETURN_DUE against DATE_RETURNED where DATE_RETURNED IS NULL.
• Assess repurchase exposure using REPURCHASE_AGMT_YN, FLOOR_PRICE, and ASSET_FMV_AMOUNT.
• Track repossession performance by comparing DATE_REPOSSESSION_REQUIRED with DATE_REPOSSESSION_ACTUAL.
• Reconcile return records to payable invoices by joining OKL_TRX_AP_INVS_ALL_B on ART_ID = ID.

Related Objects

• OKL_K_LINES — joined via KLE_ID; the lease line originating the return.
• MTL_SYSTEM_ITEMS_B — joined via IMR_ID; identifies the inventory item returned.
• JTF_RS_TEAMS_B — joined via RMR_ID; the resource team responsible.
• FV_LEGAL_ENTITIES — joined via LEGAL_ENTITY_ID; legal entity ownership.
• OKL_TRX_AP_INVS_ALL_B — references this table through ART_ID; the payables-side invoice records generated for returns.
• OKL_ASSET_RETURNS_ALL_B_SECURITY_DEP_TRX_AP_ID — links security-deposit transactions to the return.

These relationships make OKL_ASSET_RETURNS_ALL_B the central operational hub for tracking returned or off-lease assets across the OKL leasing lifecycle.