Results for “okl_fe_resi_cat_objects”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The OKL_FE_RESI_CAT_OBJECTS table is a transactional child table within the Oracle Leasing and Finance Management (OKL) module of Oracle E-Business Suite. It stores the individual inventory item assignments that belong to a residual category set, which is the parent structure defined in OKL_FE_RESI_CAT_ALL_B. Residual category sets in OKL are used to support residual value accounting, where leased assets are grouped by category so that residual amounts, depreciation behavior, and fair value calculations can be applied consistently across a population of items. The OKL_FE_RESI_CAT_OBJECTS table records which specific item, in which inventory organization, has been associated with a given residual category set, along with the category and category set identifiers used to classify it.

Under a heuristic Data Vault classification mined from the foreign key structure, this object resolves as a link entity. It connects distinct business keys — an inventory item/organization pair, an item category, and a residual category set — into an associative relationship, rather than holding descriptive attributes of a single dimension (hub) or a time-variant attribute history (satellite). This classification is offered as a modeling suggestion, not as a prescribed physical design.

Key Information Stored

The table is defined in the OKL schema with twelve documented columns in ETRM 12.2.2. The most significant are:

• RESI_CAT_OBJECT_ID — the surrogate primary key, enforced by OKL_FE_RESI_CAT_OBJECTS_PK and also documented as the unique index OKL_FE_RESI_CAT_OBJECTS_U1, making it the principal business-key candidate as well.
• RESI_CATEGORY_SET_ID — the foreign key to OKL_FE_RESI_CAT_ALL_B, identifying the parent residual category set to which the item assignment belongs.
• INVENTORY_ITEM_ID — the item being assigned, referencing MTL_SYSTEM_ITEMS_B and participating in the composite relationship to MTL_ITEM_CATEGORIES.
• ORGANIZATION_ID — the inventory organization context for the item, joined together with INVENTORY_ITEM_ID against MTL_ITEM_CATEGORIES to resolve the actual item-category membership.
• CATEGORY_ID and CATEGORY_SET_ID — the classification attributes that tie the item to a specific category within a category set, aligning the OKL residual grouping with the standard Oracle Inventory category model.
• OBJECT_VERSION_NUMBER — the concurrency control token used by the OKL business layer.
• The standard WHO columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — provide audit and multi-session traceability.

Common Use Cases and Queries

A frequent requirement is to list every item assigned to a residual category set for a given organization. Authoring such a query joins the parent set to the child objects:

• Reporting which items are covered by a residual category set: join OKL_FE_RESI_CAT_OBJECTS to OKL_FE_RESI_CAT_ALL_B using RESI_CATEGORY_SET_ID to obtain the set name and effective dating.
• Reconciling OKL residual assignments against Oracle Inventory categories: join INVENTORY_ITEM_ID and ORGANIZATION_ID to MTL_ITEM_CATEGORIES, filtering on CATEGORY_SET_ID = 1 for the purchasing category set or the relevant set used for residual grouping.
• Resolving item descriptive data: join MTL_SYSTEM_ITEMS_B on INVENTORY_ITEM_ID and ORGANIZATION_ID to obtain segment1 item numbers and descriptions.
• Auditing recent maintenance: query by LAST_UPDATE_DATE and LAST_UPDATED_BY to identify who changed item-to-set assignments during a period.

Analysts building OBIEE or BI Publisher residual-value reports typically stage this table with its parent and item dimension to form a residual item catalog.

Related Objects

• OKL_FE_RESI_CAT_ALL_B — parent table, joined on RESI_CATEGORY_SET_ID; holds category set header information.
• MTL_SYSTEM_ITEMS_B — item definition, joined on INVENTORY_ITEM_ID and ORGANIZATION_ID.
• MTL_ITEM_CATEGORIES — item-to-category assignment, joined on INVENTORY_ITEM_ID, ORGANIZATION_ID, and CATEGORY_SET_ID.
• OKL_FE_RESI_CAT_OBJECTS_PK — primary key constraint enforcing uniqueness of RESI_CAT_OBJECT_ID.
• OKL_FE_RESI_CAT_OBJECTS_U1 — unique index on the same column, serving as the documented business-key candidate.

These objects collectively support residual value setup, item classification, and downstream lease accounting within the OKL module.