Search Results okl_df_ctgy_rmk_tms_all

Overview

The table OKL_DF_CTGY_RMK_TMS_ALL is a core data object within Oracle E-Business Suite (EBS) Release 12.1.1 and 12.2.2, specifically for the OKL (Leasing and Finance Management) product module. Its primary function is to store default assignments of remarketing teams to asset categories. This configuration is critical for automating workflow and responsibility assignments in the asset remarketing process. When an asset, classified under a specific inventory category, enters a remarketing phase, the system can automatically determine the responsible team based on the defaults established in this table, thereby streamlining operational procedures and ensuring consistent process governance.

Key Information Stored

The table's structure is designed to link an asset category with a designated team, effective for a specific period. Key columns include the surrogate primary key ID. The unique key constraint (UK1) highlights the core business columns: RMR_ID, which holds the identifier for the remarketing team from JTF_RS_TEAMS_B; ICO_ID, which stores the asset category identifier linking to MTL_ITEM_CATALOG_GROUPS_B; and ILN_ID, typically representing the inventory organization. The DATE_EFFECTIVE_FROM column enables time-dependent assignments, allowing for historical tracking and future-dated team assignments. This structure supports a many-to-many relationship between categories and teams over time.

Common Use Cases and Queries

A primary use case is the automated assignment of a remarketing team to a leased asset upon lease termination or default, based on the asset's category. Administrators use this table to set up and maintain these business rules. Common reporting and validation queries include identifying all default team assignments for a specific asset category or finding the currently effective team for a given category and organization. A sample SQL pattern to retrieve active assignments is:

• SELECT rmt.rnr_id, rmt.ico_id, rmt.iln_id, rmt.date_effective_from, cat.concatenated_segments, team.team_name FROM okl_df_ctgy_rmk_tms_all rmt, mtl_item_catalog_groups_b cat, jtf_rs_teams_b team WHERE rmt.ico_id = cat.item_catalog_group_id AND rmt.rnr_id = team.team_id AND SYSDATE BETWEEN rmt.date_effective_from AND NVL(rmt.date_effective_to, SYSDATE);

This data is also crucial for audit reports on team assignment configurations and their effective dates.

Related Objects

OKL_DF_CTGY_RMK_TMS_ALL is integrally connected to other EBS foundation and application tables through foreign key relationships. The key dependencies are:

• MTL_ITEM_CATALOG_GROUPS_B: The foreign key on ICO_ID links to this Inventory table, which defines the asset categories or item catalog groups.
• JTF_RS_TEAMS_B: The foreign key on RMR_ID links to this Trading Community Architecture (TCA) resource table, which defines the team structures available for assignment.
• The table's primary key constraint (OKL_DF_CTGY_RMK_TMS_ALL_PK) and unique key constraint (OKL_DF_CTGY_RMK_TMS_ALL_UK1) are referenced by any dependent integrity constraints or application logic that enforces data uniqueness.

This table is typically accessed via OKL's application programming interfaces (APIs) or through custom reports for operational and analytical purposes within the leasing lifecycle.