Search Results igi_gcc_installed_options




Overview
Explore in AI Chat

Overview

IGI_GCC_INSTALLED_OPTIONS is a read-only view owned by the APPS schema within the IGI – Public Sector Financials International product family. Its purpose, as documented in the ETRM metadata, is to display single-organization status details of Multi Org OPSFI (Oracle Public Sector Financials International) requirements. In practice, the view exposes the set of GCC (Global Country Configurations) installed options that apply to the organization currently established in the user's session context, together with a human-readable description resolved from the lookup definitions.

Because the view is organization-aware and filters implicitly on the session's Org context, it plays a specific role in EBS reporting and integration: it allows concurrent programs, forms, and custom reports to query installed GCC options for one organization without having to reproduce the Multi-Org security predicate themselves. Rather than exposing all rows across all operating units, the view returns only the records matching the organization derived from the session environment, making it suitable for single-org status checks and configuration verification during implementations of Public Sector Financials International.

Underlying Base Objects

According to the documented view text, IGI_GCC_INSTALLED_OPTIONS is defined over two referenced base objects:

The two objects are combined with an inner join, and the result set is additionally constrained by the organization filter applied to ORG_ID. This structure means that any option whose OPTION_NAME has no matching row in the GCC_DESCRIPTION lookup type, or any row belonging to a different operating unit, is excluded from the view's result set.

Key Columns

The view exposes the following columns:

  • OPTION_ID — unique identifier of the installed option row.
  • OPTION_NAME — internal name of the GCC option; also the join key to the GCC_DESCRIPTION lookup.
  • STATUS_FLAG — indicates the current status (typically enabled/disabled) of the option for the organization.
  • VERSION_NUMBER — version of the installed option.
  • SWITCH_OPTION — the switch or toggle setting associated with the option.
  • ORG_ID — the operating unit to which the row belongs; this is the column the Multi-Org predicate filters on.
  • DESCRIPTION — descriptive text sourced from IGI_LOOKUPS (MEANING), providing a user-friendly label for the option.
  • Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, tracking row history.

The organization filter is applied using the USERENV('CLIENT_INFO') value, decoding the first ten characters to determine the active Org context. If CLIENT_INFO is blank, the predicate resolves to a sentinel value (-99), meaning no organization-specific rows are returned.

Common Use Cases and Queries

Typical usage centers on verifying which GCC options are installed and enabled for a given operating unit, generating implementation status reports, and diagnosing configuration differences between environments. A simple query to list enabled options with descriptions is:

SELECT option_name, description, status_flag, version_number
FROM   apps.igi_gcc_installed_options
ORDER BY option_name;

To check a specific option's status within the current Org context:

SELECT option_id, option_name, description, status_flag
FROM   apps.igi_gcc_installed_options
WHERE  option_name = :p_option_name;

Because the view is session-Org sensitive, reports intended to run for a particular organization must initialize the Multi-Org context (for example, via FND_GLOBAL.APPS_INITIALIZE setting an appropriate Org) before querying. As with all APPS-owned views, direct DML is not supported; the view is intended strictly for query and reporting purposes.