Search Results resi_cat_object_id




Overview
Explore in AI Chat

Overview

The OKL_FE_RESI_CAT_OBJECTS table is a core data structure within the Oracle E-Business Suite (EBS) Financial Services (OKL) module, specifically for lease and asset management. It functions as a detail table, storing the individual line items that constitute a residual category set. A residual category set is a configuration used to define the expected residual value of leased assets by associating specific inventory items or item categories. This table is critical for the accurate calculation and management of end-of-lease residual values, a fundamental aspect of lease accounting and profitability analysis in EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's primary purpose is to link a residual category set to specific inventory items or item categories. Its key columns include:

Common Use Cases and Queries

This table is primarily accessed for setup validation, reporting on residual value configurations, and data integrity checks. A common use case is to retrieve all items or categories assigned to a specific residual category set for review or troubleshooting. The following query pattern is fundamental:

SELECT rc.resi_cat_object_id,
       rc.inventory_item_id,
       rc.organization_id,
       rc.category_id,
       rc.category_set_id,
       msi.concatenated_segments item_code
FROM okl_fe_resi_cat_objects rc,
     mtl_system_items_kfv msi
WHERE rc.resi_category_set_id = :p_set_id
AND rc.inventory_item_id = msi.inventory_item_id(+)
AND rc.organization_id = msi.organization_id(+);

Another critical scenario involves identifying which residual category set a particular inventory item belongs to, which is essential for lease pricing and residual value calculations during contract creation.

Related Objects

The OKL_FE_RESI_CAT_OBJECTS table maintains defined foreign key relationships with several key EBS inventory and setup tables:

  • OKL_FE_RESI_CAT_ALL_B: The parent header table. Joined via OKL_FE_RESI_CAT_OBJECTS.RESI_CATEGORY_SET_ID = OKL_FE_RESI_CAT_ALL_B.RESI_CATEGORY_SET_ID.
  • MTL_SYSTEM_ITEMS_B: The master inventory items table. Joined via the composite key OKL_FE_RESI_CAT_OBJECTS.INVENTORY_ITEM_ID = MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID and OKL_FE_RESI_CAT_OBJECTS.ORGANIZATION_ID = MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID.
  • MTL_ITEM_CATEGORIES: The inventory item categories table. Joined via the composite key OKL_FE_RESI_CAT_OBJECTS.CATEGORY_ID = MTL_ITEM_CATEGORIES.CATEGORY_ID and OKL_FE_RESI_CAT_OBJECTS.CATEGORY_SET_ID = MTL_ITEM_CATEGORIES.CATEGORY_SET_ID.