Results for “inv_type_pk”

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

Overview

FII_AP_IVTY_INV_TYPE_LCV is a Financial Intelligence (FII) view in Oracle EBS 12.1.1 and 12.2.2 that exposes inventory type (INV_TYPE) activity information used by the Application Programmatic Interface (API) layer of the Financial Intelligence product. The "_LCV" suffix indicates that the object is a "logical column view" — an API-layer construct that maps physical table columns into the canonical logical column set expected by the FII API framework. This pattern was used where the underlying base table did not itself carry the full complement of logical columns required by the API, so a view was constructed to present a uniform structure.

The FII product is documented as obsolete in the ETRM metadata. The description states "Not implemented in this database," meaning the object is not instantiated in a standard Oracle EBS installation; it exists only as documented metadata and would only be present in environments where the FII platform was historically deployed. Despite this status, the object remains relevant to installations that retain FII-derived schemas when interpreting legacy columns such as DELETION_DATE.

Underlying Base Objects

The view text selects from a single base object: FIIBV_AP_IVTY_INV_TYPE_LCV. The ETRM metadata documents no referenced base objects beyond this immediate source view. The prefix "FIIBV" follows the FII naming convention (FII Base View), suggesting the base view itself resolves to one or more physical FII staging or interface tables. Because the object is not implemented in a standard database, the physical tables beneath FIIBV_AP_IVTY_INV_TYPE_LCV are not enumerated in the available metadata.

The projection is a straight column list with no join, filter, or aggregation visible, confirming that FII_AP_IVTY_INV_TYPE_LCV is a pure projection layer. Its purpose is structural normalization rather than data transformation.

Key Columns

• INV_TYPE_PK — Primary key identifying the inventory type record.
• ALL_FK — Foreign key or all-purpose reference column used by the FII API to link related records.
• INSTANCE — Identifies the FII instance or data partition to which the record belongs.
• NAME — Descriptive name of the inventory type.
• INV_TYPE — The inventory type code value.
• DESCRIPTION — Free-text description of the inventory type.
• LAST_UPDATE_DATE — Audit timestamp of the most recent modification.
• CREATION_DATE — Audit timestamp of record creation.
• DELETION_DATE — Logical deletion indicator, populated when a record is soft-deleted or logically inactivated rather than physically removed.
• INV_TYPE_DP — Display value (descriptive flex) associated with the inventory type.
• USER_ATTRIBUTE1–USER_ATTRIBUTE5 — Five descriptive flexfield attribute columns mapped to NULL placeholders in the underlying view, reserved for customer-defined extensions.

The DELETION_DATE column — the term the user searched for — is the key soft-delete marker. Records with a NULL DELETION_DATE represent active entries; a non-NULL value indicates the record has been logically retired.

Common Use Cases and Queries

The principal use case is auditing which inventory types have been logically removed from the FII API layer. A standard query to isolate soft-deleted records is:

SELECT INV_TYPE_PK, NAME, INV_TYPE, CREATION_DATE, DELETION_DATE FROM FII_AP_IVTY_INV_TYPE_LCV WHERE DELETION_DATE IS NOT NULL;

Because the view is not implemented in a standard database, this query will raise an invalid-object error unless the FII schema is present. In environments where FII remains deployed, the view is generally consumed by FII extraction and reconciliation processes rather than by end-user reports. Analysts should confirm object validity with ALL_VIEWS before relying on it.