Results for “deprn_method_code”

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

Overview

OKL_AM_AMORT_HOLD_SETUPS_UV is a read-only database view owned by the APPS schema in Oracle E-Business Suite, belonging to the OKL (Lease and Finance Management) product family. The view presents amortization hold setup information, combining lease-management configuration records with the corresponding Oracle Assets (FA) definitions for depreciation books, asset categories, and depreciation methods. Its purpose is to expose a denormalized, human-readable representation of the hold-period rules configured in OKL_AMORT_HOLD_SETUPS, enriched with descriptive attributes drawn from the FA schema, so that reporting tools, OA Framework pages, and integration interfaces can present the setup without requiring joins to be redefined by the consumer.

The view is a standard ETRM implementation object and is marked VALID in the APPS schema on release 12.2.2. It carries the "_UV" suffix characteristic of user-facing views in the OKL module, indicating that it is intended primarily for display and query rather than for direct DML. Amortization hold setups govern how lease-related amortization is suspended or deferred for a defined number of days, per asset category and depreciation book, and this view exposes those rules alongside the descriptive context of the referenced FA entities.

Underlying Base Objects

The view is defined over four documented base objects:

• OKL_AMORT_HOLD_SETUPS (SYNONYM) — the primary transactional/setup table. It supplies the hold period days, category, book type, method, depreciation rate, organization, and standard WHO audit columns.
• FA_CATEGORIES_VL (VIEW) — the Oracle Assets asset-category view, used to retrieve the category description and to validate the category identifier.
• FA_BOOK_CONTROLS (SYNONYM) — the Oracle Assets depreciation book definitions, supplying the book name and book class for the associated book type code.
• FA_METHODS (SYNONYM) — the Oracle Assets depreciation method definitions, supplying the method name, method code, and life in months.

Joins are established on BOOK_TYPE_CODE, CATEGORY_ID, and METHOD_ID respectively. Notably, the join to FA_METHODS is an outer join (METHOD_ID (+)), meaning hold setups without a matching depreciation method still appear, with the method columns returning null. In contrast, the joins to FA_BOOK_CONTROLS and FA_CATEGORIES_VL are inner joins, so a valid book and category are required for a row to be returned.

Key Columns

• ROW_ID — the ROWID of the underlying OKL_AMORT_HOLD_SETUPS row, useful as a unique query key.
• ID and OBJECT_VERSION_NUMBER — the primary key and optimistic locking version of the setup record.
• HOLD_PERIOD_DAYS — the number of days for which amortization is held, the core business attribute of the setup.
• CATEGORY_ID and FA_CATEGORY_DESCRIPTION — the asset category identifier and its descriptive name from FA_CATEGORIES_VL.
• BOOK_TYPE_CODE, ASSET_BOOK_NAME, and ASSET_BOOK_TYPE — the depreciation book code, name, and class as defined in FA_BOOK_CONTROLS.
• METHOD_ID, DEPRN_METHOD_NAME, DEPRN_METHOD_CODE, and LIFE_IN_MONTHS — the depreciation method details from FA_METHODS.
• DEPRN_RATE — the stored depreciation rate multiplied by 100, presented as a percentage.
• ORG_ID — the operating unit, supporting multi-org security and filtering.
• CREATED_BY / CREATION_DATE / LAST_UPDATED_BY / LAST_UPDATE_DATE / LAST_UPDATE_LOGIN — standard audit columns.

Common Use Cases and Queries

Typical uses include setup validation during implementation, reporting on which categories have amortization holds configured, and exposing the configuration through custom OA Framework or OBIEE reports. The inclusion of FA_CATEGORIES_VL columns such as the category description is particularly relevant to users who search for asset category descriptions across the EBS data model.

A representative query joining lease amortization hold setups by book and category:

SELECT id,
       fa_category_description,
       asset_book_name,
       hold_period_days,
       deprn_method_name,
       deprn_rate
FROM   apps.okl_am_amort_hold_setups_uv
WHERE  book_type_code = :p_book
AND    org_id = :p_org_id
ORDER  BY fa_category_description;

Because the view already resolves the FA descriptive attributes, it is equally suitable for simple lookups of category descriptions without requiring a direct join to FA_CATEGORIES_VL. Reporting should filter on ORG_ID to respect operating-unit security, and consumers should be aware that method-related columns may be null where the outer join to FA_METHODS finds no match.