Search Results tdf_tdf_uk

Overview

The table OKL_TUOM_DFNTNS_B is a core master data table within the Oracle E-Business Suite Leasing and Finance Management (OKL) module. It serves as a repository for defining time unit of measure (UOM) definitions, which are critical for standardizing and calculating time-based metrics across the leasing lifecycle. These definitions are foundational for configuring and executing complex financial operations, such as calculating late charges, interest accruals, and other period-based fees. The table's role is to provide a centralized, controlled list of time intervals (e.g., days, months, calendar quarters) that other transactional and setup tables reference to ensure consistency in financial computations for contracts and agreements.

Key Information Stored

Based on the provided metadata, the table's structure centers on a unique identifier and a descriptive name for each time unit definition. The primary key column is ID, which uniquely identifies each time unit record within the system. A second key column, NAME, holds the descriptive label for the time unit (e.g., "Calendar Month," "Business Day," "Year"). This column is enforced as unique by the TDF_TDF_UK constraint, preventing duplicate entries. While the full column list is not detailed in the excerpt, the presence of these core columns indicates the table's function as a simple yet essential lookup or reference entity.

Common Use Cases and Queries

This table is primarily referenced during the setup and execution of time-sensitive financial policies. A common use case is the configuration of a late payment policy, where an administrator selects a specific time unit definition (e.g., "Per Day") from this table to determine how a late interest penalty accrues. For reporting and data validation, typical queries involve joining this table to its referencing transactional tables. A sample SQL pattern to list all time unit definitions and their associated late policies would be:

• SELECT tdf.NAME, lp.POLICY_NAME FROM OKL_TUOM_DFNTNS_B tdf, OKL_LATE_POLICIES_B lp WHERE tdf.ID = lp.TDF_ID;

Another critical use case is ensuring data integrity during migrations or integrations, where validating the existence of TDF_ID values in OKL_TUOM_DFNTNS_B is essential before loading data into dependent tables.

Related Objects

The table OKL_TUOM_DFNTNS_B is a parent reference table for several key setup and transactional entities in the Leasing module, as documented by its foreign key relationships. The following tables reference it via the TDF_ID column:

• OKL_LTE_CHRG_SETUPS: Links time unit definitions to specific lease charge setups.
• OKL_LATE_INTERESTS: References a time unit to define the period for late interest calculations on transactions.
• OKL_LATE_POLICIES_B: Uses a time unit definition as part of the core configuration for a late payment policy.

These relationships underscore the table's central role in standardizing time-based calculations across charge setups, interest computations, and policy enforcement within Oracle EBS Leasing.