Search Results csb_csb_uk

Overview

The table OKL_CRTRN_SBCLSSES is a core data object within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module. It functions as a mapping or junction table that defines the relationship between business criteria and the asset subclasses to which those criteria apply. Its primary role is to support the configuration and enforcement of business rules within the leasing lifecycle by linking specific conditions or requirements (criteria) to the detailed asset classifications (subclasses) they govern. This table is essential for ensuring that the correct rules are evaluated for the appropriate asset types during processes like contract creation, asset qualification, and financial calculations in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table stores a unique combination of a criterion identifier and a subclass code, establishing a many-to-many relationship between these two entities. The primary columns are the unique identifier (ID) and the two foreign key columns that form the relationship. The CRN_ID column holds the identifier for a specific business criterion, linking to the OKL_CRITERIA_B table. The SCS_CODE column stores the code for an asset subclass, linking to the OKC_SUBCLASSES_B table. The table enforces uniqueness on the combination of CRN_ID and SCS_CODE through the CSB_CSB_UK unique key, preventing duplicate mappings.

Common Use Cases and Queries

A primary use case is validating which business rules are applicable to a given asset subclass during contract booking or amendment. For instance, a developer might query for all criteria linked to a specific asset subclass to determine which validations to run. Conversely, an administrator might query for all subclasses governed by a particular criterion to understand its scope. Common reporting needs include generating a list of all criterion-to-subclass mappings for audit or configuration review purposes. A typical SQL pattern to retrieve these mappings would involve joining to the related tables for descriptive information:

• SELECT crn.name, scs.name FROM okl_crtrn_sbclsses csb JOIN okl_criteria_b crn ON csb.crn_id = crn.id JOIN okc_subclasses_b scs ON csb.scs_code = scs.code WHERE scs.code = '<SUBCLASS_CODE>';

Related Objects

OKL_CRTRN_SBCLSSES is centrally linked to two key master data tables via foreign key constraints, as documented in the ETRM metadata.

• OKL_CRITERIA_B: This is the primary foreign key relationship. The CRN_ID column in OKL_CRTRN_SBCLSSES references the ID column in OKL_CRITERIA_B, linking each mapping record to a specific business criterion.
• OKC_SUBCLASSES_B: This is the secondary foreign key relationship. The SCS_CODE column in OKL_CRTRN_SBCLSSES references the CODE column in OKC_SUBCLASSES_B, linking each mapping record to a specific asset subclass definition.

These relationships are critical for maintaining referential integrity and for any data analysis or integration that requires traversing from a criterion to its applicable subclasses or vice versa.