Search Results gcc_description




Overview
Explore in AI Chat

Overview

The view APPS.IGI_GCC_GL_FA_INST_OPS is a reporting and integration construct within the Oracle EBS Global Consolidation System (GCS) / Global Country Configuration (GCC) family of objects. It exposes the instance-level options configured for the GCC General Ledger and Fixed Assets integration, presenting each option alongside a human-readable description derived from the Oracle lookup mechanism. Its principal role is to decouple the consuming application or report from the raw option storage table, allowing presentation-layer consumers to retrieve an option's descriptive text without themselves joining to the lookup view. This is particularly relevant to the requested search term gcc_description, since the view's most salient added value is the translated DESCRIPTION column sourced from the lookup type of that name.

Underlying Base Objects

The view is defined over two documented objects, both owned by APPS:

  • IGI_GCC_GL_FA_INST_OPTIONS (referenced as a synonym) — the primary storage of GCC GL/FA instance option rows, contributing the identifier, name, status, version, switch, and audit columns.
  • IGI_LOOKUPS (a view) — the lookup repository used to resolve the descriptive meaning for each option name.

The join is an equi-join between the option record and the lookup entry, constrained so that LUP.LOOKUP_TYPE = 'GCC_DESCRIPTION' and LUP.LOOKUP_CODE = OPTION_NAME. Because the join is written with comma-separated tables and an implicit inner join predicate, any option whose name lacks a corresponding lookup row under the GCC_DESCRIPTION type will not appear in the view result set. Consumers must therefore account for the possibility that options without a matching lookup definition are silently filtered.

Key Columns

  • OPTION_ID — Surrogate identifier for the instance option row; the primary key of the underlying options object.
  • OPTION_NAME — The internal code for the option; also serves as the lookup code joined to GCC_DESCRIPTION.
  • DESCRIPTION — The lookup meaning (LUP.MEANING) providing the user-facing label for the option. This is the column most directly associated with the gcc_description lookup type.
  • STATUS_FLAG — Indicates the enablement or processing status of the option.
  • VERSION_NUMBER — Versioning attribute for the option configuration.
  • SWITCH_OPTION — A toggle-style attribute governing option behaviour.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard Oracle audit columns for change tracking.

Common Use Cases and Queries

The view is typically used to validate GCC GL/FA instance configuration and to render option labels in reports, concurrent program outputs, or integration extracts. A representative query that retrieves the descriptive labels for all enabled options follows:

  • SELECT option_id, option_name, description, status_flag, switch_option FROM apps.igi_gcc_gl_fa_inst_ops WHERE status_flag = 'Y' ORDER BY option_name;
  • SELECT option_name, description, version_number FROM apps.igi_gcc_gl_fa_inst_ops WHERE option_name = :p_option_name;
  • SELECT o.option_id, o.description, o.last_update_date, o.last_updated_by FROM apps.igi_gcc_gl_fa_inst_ops o WHERE o.last_update_date >= :p_since_date;

Because the description text is sourced from the GCC_DESCRIPTION lookup, administrators should maintain that lookup type in tandem with the instance options to ensure complete coverage and to prevent rows being dropped by the inner join predicate.