Search Results sic_code_pk

Overview

FII_AR_SICM_SIC_LCV is a database view shipped within the Financial Intelligence (FII) product family of Oracle E-Business Suite. FII is listed as obsolete in the ETRM repository, and this specific view is documented as "Not implemented in this database" in the reference metadata, meaning it exists as a defined object in the FII data model but may not be deployed or active in a given EBS instance. The view is named according to FII's SICM (Standard Interface Common Model) conventions; the "LCV" suffix typically denotes a "List of Values" or "Code View" style construct used to expose a normalized, deduplicated result set for reporting, integration, and LOV lookups.

Its role is to present a single, distinct list of Standard Industrial Classification (SIC) codes, each with a stable surrogate key and a consistent display value, derived from the FII AR SIC code base view. Because it aggregates and de-duplicates, it is suited to dimensions in a data warehouse or to value sets backing concurrent-program parameters and OAF list-of-values components in an FII-enabled EBS environment.

Underlying Base Objects

The view is defined over a single documented source, FII_AR_SIC_CODE_BASE_V, itself a view. ETRM lists no documented base tables for FII_AR_SICM_SIC_LCV, so its dependency graph extends transitively through FII_AR_SIC_CODE_BASE_V rather than directly to physical tables. The SQL groups by SIC_CODE and applies MAX(LAST_UPDATE_DATE), which flattens the base view to one row per SIC code and carries the most recent change timestamp forward for each.

Several positional literals are injected: the second column is the constant string 'ALL', and the SIC_CODE column is repeated across multiple ordinal positions. A call to EDW_INSTANCE.GET_CODE supplies the INSTANCE value, truncated to 40 bytes. This pattern is characteristic of FII's shared interface templates, where a fixed number of generic columns are bound to a standardized SELECT so that downstream extracts can rely on a uniform column layout.

Key Columns

• SIC_CODE_PK — The primary-key column exposed by the view; in the underlying SELECT it is populated from SIC_CODE, providing the surrogate identifier used by FII joins and foreign-key-driven lookups.
• ALL_FK — Bound to the literal 'ALL', a constant foreign key used by FII's "ALL" domain convention.
• SIC_CODE_DP — The display value for the list; also sourced from SIC_CODE in this definition.
• NAME — The descriptive name column, likewise populated from SIC_CODE here.
• SIC_CODE — The business code itself, appearing again in the standard code slot of the interface layout.
• INSTANCE — The FII instance code returned by EDW_INSTANCE.GET_CODE, truncated to 40 bytes.
• USER_ATTRIBUTE1 through USER_ATTRIBUTE15 — Fifteen generic extension columns, all set to NULL in this view definition, reserved for FII's configurable attribute mapping.
• LAST_UPDATE_DATE — The maximum last-update timestamp per SIC code, supporting incremental or changed-data identification.

Common Use Cases and Queries

The canonical usage is populating a list of values for a SIC code parameter, joining the view to a fact or staging table by SIC_CODE_PK, and extracting distinct code sets to a warehouse dimension. A basic lookup:

SELECT sic_code_pk, sic_code, name, instance
FROM   fii_ar_sicm_sic_lcv
ORDER BY sic_code;

To obtain only the most recently changed codes for incremental processing:

SELECT sic_code_pk, sic_code, last_update_date
FROM   fii_ar_sicm_sic_lcv
WHERE  last_update_date > :p_since;

Where the view is reported as not implemented, alternatives in the FII AR SIC code base view should be queried directly, and the environment's FII implementation should be confirmed before referencing this object in custom code or value sets.