Search Results cua_life_end_date




Overview
Explore in AI Chat

Overview

The view APPS.OKX_AST_CT_BK_DFS_V is a reporting and integration layer defined in the Oracle E-Business Suite (EBS) Applications schema (APPS) for the Oracle Assets (FA) module. It exposes depreciation and book default attributes maintained at the asset category/book level, and is primarily used to feed Oracle Assets category book defaults into external systems, conversion programs, or downstream reporting. The "OKX" prefix identifies it as part of the Oracle Assets extensions object namespace, while the trailing "DFS" (defaults) and "V" (view) indicate its role as a defaults-oriented projection. Because it is owned by APPS and is not a base transaction table, it functions as a read-only abstraction that shields consumers — including concurrent programs, Oracle Discoverer reports, and interface extracts — from the underlying normalized FA_CATEGORY_BOOK_DEFAULTS table structure. In the context of EBS 12.1.1 and 12.2.2, this view is especially relevant to users searching for cua_life_end_date, a depreciable-life control column related to CUA (country-specific) rule sets.

Underlying Base Objects

Per the documented ETRM metadata for 12.2.2, the view is defined over a single referenced object: FA_CATEGORY_BOOK_DEFAULTS, accessed through a synonym. FA_CATEGORY_BOOK_DEFAULTS is the Oracle Assets table that stores the default depreciation attributes assigned to a given asset category and book combination. Each row represents one category/book pairing and carries the default depreciation method, life, prorate convention, and related tax and CUA rule settings inherited by assets created in that category. The view does not perform multi-table joins; it is a straight column projection with two synthetic identity columns added for the benefit of its consumers. This means the view's row cardinality and semantics are identical to those of FA_CATEGORY_BOOK_DEFAULTS, simply presented with a flattened, integration-friendly shape.

Key Columns

Common Use Cases and Queries

The view is typically queried to extract category/book defaults for conversions, interfaces, or diagnostics involving CUA life rules. To identify categories governed by a CUA life end date:

  • SELECT CATEGORY_ID, BOOK_TYPE_CODE, LIFE_IN_MONTHS, CUA_LIFE_END_DATE, CUA_RULE_SET_ID FROM APPS.OKX_AST_CT_BK_DFS_V WHERE CUA_LIFE_END_DATE IS NOT NULL;
  • SELECT CATEGORY_ID, BOOK_TYPE_CODE, DEPRN_METHOD, LIFE_IN_MONTHS, PRORATE_CONVENTION_CODE FROM APPS.OKX_AST_CT_BK_DFS_V WHERE BOOK_TYPE_CODE = :book;

Because the view maps one-to-one to FA_CATEGORY_BOOK_DEFAULTS, it is safe for read-only extraction but should not be used for DML; updates must target the base table.