Search Results sic_code_dp




Overview
Explore in AI Chat

Overview

The view APPS.FII_AR_SICM_SIC_LCV is an Oracle E-Business Suite internal list-of-values view owned by the APPS schema. It is registered in the Applications FND Design Data repository under the design object identifier FII.FII_AR_SICM_SIC_LCV and is documented with a status of VALID in the ETRM metadata for release 12.2.2 (and is equally present in 12.1.1 deployments where the FII SICM feature set has been applied). The view is classified as Oracle Internal Use Only, meaning Oracle Corporation does not support direct data access through this object except from standard Oracle Applications programs.

Functionally, FII_AR_SICM_SIC_LCV presents the SIC (Standard Industrial Classification) code master data used by the Receivables SICM (SIC Code Management) feature, exposing the primary list-of-values columns used to populate SIC code selection windows and concurrent processing within Oracle Receivables. The "LCV" suffix denotes the list-of-values view role, while the underlying base view FII_AR_SIC_CODE_BASE_V supplies the base row set.

Underlying Base Objects

Per the documented dependency tree, APPS.FII_AR_SICM_SIC_LCV references the following objects:

The view is itself referenced by APPS.FII_AR_SIC_CODE_M_C, the Receivables SIC code maintenance form/controller, which drives insert, update, and delete activity against SIC code records. This places FII_AR_SICM_SIC_LCV in a mid-tier role: it consumes the base view and is consumed by the maintenance UI and LOV infrastructure.

Key Columns

  • SIC_CODE_PK (VARCHAR2(30)) — primary key of the SIC code record; the unique identifier used across the SICM model.
  • ALL_FK (CHAR) — foreign key discriminator, typically identifying which "all" or reference set the row belongs to.
  • SIC_CODE_DP (VARCHAR2(30)) — the display value (DP) column. This is the column most directly relevant to the user's search term "sic_code_dp" and is the value rendered in list-of-values and query dialogs.
  • NAME (VARCHAR2(30)) — descriptive name of the SIC classification.
  • SIC_CODE (VARCHAR2(30)) — the actual SIC code value stored on the underlying transaction/party.
  • INSTANCE (VARCHAR2(40)) — the EBS instance identifier, enabling multi-instance and multi-org filtering.
  • USER_ATTRIBUTE1 through USER_ATTRIBUTE15 — descriptive flexfield segments used to capture client-specific SIC attributes.
  • LAST_UPDATE_DATE (DATE) — the standard "Who" column recording the last modification timestamp.

Common Use Cases and Queries

Practitioners query this view when validating SIC code configuration, troubleshooting LOV display issues (particularly when SIC_CODE_DP is missing or misaligned), or building read-only extracts. A typical diagnostic query is:

  • SELECT sic_code_pk, sic_code_dp, name, sic_code FROM apps.fii_ar_sicm_sic_lcv WHERE sic_code_dp LIKE '62%'; — retrieves SIC codes for reporting or reconciliation.
  • SELECT sic_code_pk FROM apps.fii_ar_sicm_sic_lcv WHERE lo'ssic_code_pk = :block.sic_code_pk; — validates the LOV key during form navigation.

Because the object is flagged Oracle Internal Use Only, any extraction should be restricted to read-only reporting and should not be used as a target for custom DML. All maintenance should flow through FII_AR_SIC_CODE_M_C and the standard SIC Code maintenance screen in Oracle Receivables.