Search Results csf_gnticons_setup_v

Overview

CSF_GNTICONS_SETUP_V is a reporting and integration view owned by the APPS schema within the CSF (Field Service) product family of Oracle E-Business Suite, applicable to releases 12.1.1 and 12.2.2. Its purpose is to expose the icon setup configuration used by the Field Service graphical scheduling and dispatch interface, where visual icons are associated with assignment, task, or status conditions. The view presents the "Gantt icon" setup definitions that drive how the scheduling workbench renders status indicators and other visual cues to dispatchers and field service personnel.

The view is classified as VALID in the ETRM metadata, indicating that it is a supported, compiled object in the APPS schema. It is a simple projection view: the metadata confirms that its defining query selects all columns from a single base table using ROWID as a ROW_ID column. Because it references a base table, schema and patch-level changes to the underlying table are automatically reflected in the view, which reduces maintenance overhead and ensures consistency with the application's own logic. The presence of an OBJECT_VERSION_NUMBER column reflects the standard Oracle EBS optimistic locking pattern and confirms that the base object supports concurrent update protection through the OAF/ADF framework.

Because the view is a direct projection of the base table, it behaves as a thin reporting layer. ETRM metadata does not identify any joins, filters, or aggregation in the view text, so row counts and value sets are identical to those of the base table.

Underlying Base Objects

The documented base object is CSF_GNTICONS_SETUP_B, a table held under a synonym in the APPS schema. The view contains no joins and selects every column from the base table, adding only a ROWID alias. This design is consistent with the "_B" (base) and "_V" (view) naming convention used throughout Oracle EBS for the entity/view pair pattern, in which the view normally exists to present a translated or derived form of the base row. However, in this case the metadata shows the view is a straight column passthrough.

The ETRM reference lists only this single base object; no related translation table (such as a "_TL" table) appears in the documented metadata, and the DESCRIPTION column exposed by the view is stored directly on the base record rather than being translatable. Consequently, any change to a row in CSF_GNTICONS_SETUP_B — including deactivation of an icon definition — is immediately visible through CSF_GNTICONS_SETUP_V.

Key Columns

• ROW_ID — Pseudo-column exposing the ROWID of the underlying base table row; useful for unambiguously identifying a specific record.
• SEQ_ID — Primary identifier for the icon setup record, matching the sequence key of the base row. This is the column most directly relevant to lookups keyed by "seq_id."
• ICON_FILE_NAME — Name of the icon file or resource used to render the visual indicator in the scheduling interface.
• DESCRIPTION — Free-text description of the icon's meaning or usage context.
• RANKING — Ordering or priority value used to determine which icon is selected when multiple icon definitions match.
• ACTIVE — Flag indicating whether the icon setup row is currently enabled; inactive rows should normally be excluded from runtime and reporting queries.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns recording who created and last modified the record and when.
• OBJECT_VERSION_NUMBER — Optimistic locking version counter maintained by the framework.

Common Use Cases and Queries

Typical usage centres on extracting the icon configuration for audit purposes, diagnosing missing or mis-ranked icons, or validating the active setup after a configuration change. When the user's search term is "seq_id," the intent is usually to resolve a specific icon definition or to join icon setup data to another table on the sequence key.

A common pattern is to list all active icon definitions in display order:

• SELECT seq_id, icon_file_name, description, ranking FROM apps.csf_gnticons_setup_v WHERE active = 'Y' ORDER BY ranking, seq_id;
• SELECT seq_id, icon_file_name, ranking, active FROM apps.csf_gnticons_setup_v WHERE seq_id = :seq_id;
• SELECT seq_id, icon_file_name, description, active FROM apps.csf_gnticons_setup_v WHERE icon_file_name LIKE '%STATUS%';

Because the view exposes ROW_ID and the audit columns, it can also be used for change-tracking queries, for example retrieving records modified after a given date using LAST_UPDATE_DATE. All queries should be run against the APPS schema with appropriate read privileges, and production reporting should filter on ACTIVE = 'Y' unless historical configuration is explicitly required.