Results for “category_type_code”

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

Overview

OKL_FE_ITEM_RESIDUAL_ALL is the item residual header table within the Oracle E-Business Suite Lease and Finance Management (OKL) module, whose schema owner is OKL. Its documented description is "Item Residual Header." The table stores residual value definitions applied at the inventory item level, allowing residual amounts to be established, versioned, and reused across lease and finance contracts during pricing, booking, and end-of-term processing.

In Oracle EBS 12.1.1 and 12.2.2, this object functions as the anchor record for a residual structure. Each row is uniquely identified by ITEM_RESIDUAL_ID, enforced by the primary key constraint OKL_FE_ITEM_RESIDUAL_ALL_PK and the unique index OKL_FE_ITEM_RESIDUAL_ALL_U1. The table includes self-referencing foreign keys on ITEM_RESIDUAL_ID and ORIG_ITEM_RESIDUAL_ID, and it carries EFFECTIVE_FROM_DATE and EFFECTIVE_TO_DATE columns, indicating that residual definitions are date-effective. Under a heuristic Data Vault classification derived from the foreign key structure, this object can be viewed as satellite-leaning, which is a modeling suggestion rather than an Oracle designation.

Key Information Stored

The documented physical schema contains 20 columns. The most significant are:

• ITEM_RESIDUAL_ID — surrogate primary key and the unique business-key candidate documented by OKL_FE_ITEM_RESIDUAL_ALL_U1.
• ORIG_ITEM_RESIDUAL_ID — self-referencing link to the originating residual record, used for versioning or lineage when a residual is copied or superseded.
• INVENTORY_ITEM_ID — the inventory item for which the residual is defined; foreign key to MTL_SYSTEM_ITEMS_B and to MTL_ITEM_CATEGORIES.
• ORGANIZATION_ID and ORG_ID — organization context for the item and the residual record respectively.
• CATEGORY_ID, CATEGORY_SET_ID, and CATEGORY_TYPE_CODE — item category and category set references used to scope the residual definition.
• RESI_CATEGORY_SET_ID — foreign key to OKL_FE_RESI_CAT_ALL_B, identifying the residual category set.
• RESIDUAL_TYPE_CODE, CURRENCY_CODE, and STS_CODE — residual type, currency of the residual amount, and the status of the residual record.
• EFFECTIVE_FROM_DATE and EFFECTIVE_TO_DATE — the validity window that governs when the residual applies.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the Oracle Applications Framework.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns.

Common Use Cases and Queries

Typical scenarios include retrieving the active residual for an item in a given organization, auditing changes to residual definitions, and validating that a contract's residual references a valid, in-effect header. A common query pattern joins the header to its detail values and to the item master:

• Active residual by item: SELECT ITEM_RESIDUAL_ID, RESIDUAL_TYPE_CODE, CURRENCY_CODE, STS_CODE FROM OKL_FE_ITEM_RESIDUAL_ALL WHERE INVENTORY_ITEM_ID = :item_id AND ORG_ID = :org_id AND TRUNC(SYSDATE) BETWEEN EFFECTIVE_FROM_DATE AND NVL(EFFECTIVE_TO_DATE, TRUNC(SYSDATE));
• Category-based lookup: filter by CATEGORY_SET_ID and CATEGORY_ID to find residuals assigned through item categories.
• Version trail: self-join on ITEM_RESIDUAL_ID = ORIG_ITEM_RESIDUAL_ID to trace superseded residual definitions.
• Detail reporting: join to OKL_FE_ITEM_RESDL_VALUES on ITEM_RESIDUAL_ID to report the residual amounts and periods attached to each header.

These patterns support residual reporting, contract pricing validation, and reconciliation extracts used in lease and finance implementations.

Related Objects

• OKL_FE_ITEM_RESDL_VALUES — references this table via ITEM_RESIDUAL_ID; holds the detail residual values attached to each header.
• OKL_ITM_CAT_RV_PRCS — references this table via ITEM_RESIDUAL_ID; records item category residual value processing.
• OKL_FE_RESI_CAT_ALL_B — referenced by RESI_CATEGORY_SET_ID; defines residual category sets.
• MTL_SYSTEM_ITEMS_B — referenced by INVENTORY_ITEM_ID and ORG_ID; the item master.
• MTL_ITEM_CATEGORIES — referenced by INVENTORY_ITEM_ID, ORGANIZATION_ID, and CATEGORY_SET_ID; associates items with categories.
• OKL_FE_ITEM_RESIDUAL_ALL — self-referencing on ITEM_RESIDUAL_ID and ORIG_ITEM_RESIDUAL_ID for version lineage.