Results for “adjusted_rate”

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

Overview

OKL_ASSET_DEPRN_METHODS_UV is an APPS-owned user interface view within the Oracle Leasing and Finance Management (OKL) module. It exposes depreciation method definitions that originate in Oracle Assets (FA) and presents them in a form suitable for leasing asset depreciation processing and reporting. The view is registered as VALID in the EBS data dictionary and is documented for both 12.1.1 and 12.2.2, where it is classified as a VIEW and identified by the description "User interface view for FA depreciation methods."

Its principal design objective is to surface the depreciation method code, useful life, and the flat-rate percentages maintained in Oracle Assets so that leasing users and downstream OKL processes can reference a consistent, formatted representation of depreciation methods. Because it is a view and not a table, it carries no storage of its own and reflects the live contents of the underlying FA tables at query time. This makes it appropriate for read-only reporting and integration rather than transactional maintenance.

Underlying Base Objects

The view is defined over two documented base objects, both referenced through synonyms: FA_METHODS and FA_FLAT_RATES. FA_METHODS is the Oracle Assets table that stores depreciation method headers, including the method identifier and method code, as well as life in months. FA_FLAT_RATES stores the rate components for flat-rate methods, including the basic rate, adjusting rate, and adjusted rate.

The join is performed on METHOD_ID, with the FA_FLAT_RATES side expressed as an outer join (FFR.METHOD_ID(+) = FM.METHOD_ID). This ensures that depreciation methods without a corresponding flat-rate row are still returned. A filter of NVL(FFR.ADJUSTING_RATE, 0) = 0 restricts the result set to methods with no adjusting rate, isolating the base flat-rate component. Results are ordered by method code, life in months, and adjusted rate.

Key Columns

• METHOD_ID — The unique identifier of the depreciation method from FA_METHODS, used to join to other depreciation-related objects.
• METHOD_CODE — The user-facing code that names the depreciation method, such as a flat-rate or straight-line designation.
• LIFE_IN_MONTHS — The useful life of the method expressed in months, converted to character via TO_CHAR and defaulted to an empty string when null.
• BASIC_RATE — The flat rate from FA_FLAT_RATES multiplied by 100 and converted to character, presenting the rate as a percentage. This is the column most directly associated with the search term "basic_rate."
• ADJUSTING_RATE — The adjusting rate from FA_FLAT_RATES, likewise scaled by 100 and formatted as text.
• ADJUSTED_RATE — The adjusted rate from FA_FLAT_RATES, scaled by 100 and formatted as text.

All numeric rate columns are wrapped in NVL and TO_CHAR to return empty strings instead of nulls, simplifying display in the OKL user interface.

Common Use Cases and Queries

Typical uses include validating depreciation method setup before leasing asset depreciation runs, populating leasing method selection lists, and reconciling OKL depreciation results against Oracle Assets definitions. A basic query retrieves all methods with their formatted rates:

• SELECT method_id, method_code, life_in_months, basic_rate, adjusted_rate FROM okl_asset_deprn_methods_uv ORDER BY method_code;
• SELECT method_code, basic_rate FROM okl_asset_deprn_methods_uv WHERE basic_rate IS NOT NULL;
• SELECT method_code, life_in_months, basic_rate FROM okl_asset_deprn_methods_uv WHERE life_in_months = '60';

Because rate values are returned as character strings, comparisons and arithmetic against BASIC_RATE should be performed with TO_NUMBER when numeric evaluation is required, for example WHERE TO_NUMBER(basic_rate) > 0. Users searching for "basic_rate" will find this view to be the direct source of that percentage value as maintained for flat-rate depreciation methods in Oracle Assets.