Search Results igs_ge_cfg_nav_u1

Overview

The IGS_GE_CFG_NAV table is a configuration repository within the Oracle E-Business Suite (EBS), specifically under the IGS (Oracle's Student Systems) product family. Its primary role is to store form navigation configurations, enabling the customization and control of user interface flow. This table allows for the definition of specific navigation paths between forms and subforms based on a user's assigned responsibility. By linking a responsibility to a form code and a sequence number, administrators can dictate the order and availability of subform navigational elements, such as buttons, ensuring a tailored and controlled user experience that aligns with business processes and security requirements in releases 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is designed to capture the essential elements of a navigation rule. The composite primary key, enforced by the IGS_GE_CFG_NAV_PK index, consists of RESPONSIBILITY_ID, FORM_CODE, and SUBFORM_CODE. This ensures a unique navigation configuration for a specific subform within a given form and responsibility. The SEQ_NUMBER column, which is part of a separate unique index (IGS_GE_CFG_NAV_U1), dictates the order of navigation items. The BUT_LABEL column stores the code for the button or navigational control on the form being configured. Standard Oracle "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) track audit information for each record.

Common Use Cases and Queries

A primary use case is troubleshooting or auditing customized form navigation for a specific responsibility. For instance, an administrator may need to review all configured subform navigations for the "Student Records" responsibility on a particular form to verify business process compliance. The user's search for "subform_code" indicates an interest in queries targeting this specific column. A common reporting query would join this table with FND_RESPONSIBILITY_TL to get the responsibility name. The foundational query, as provided in the ETRM, is:

• SELECT RESPONSIBILITY_ID, FORM_CODE, SEQ_NUMBER, SUBFORM_CODE, BUT_LABEL FROM IGS.IGS_GE_CFG_NAV WHERE RESPONSIBILITY_ID = :resp_id AND FORM_CODE = :form_cd ORDER BY SEQ_NUMBER;

This pattern is essential for generating configuration audits, impact analysis prior to a responsibility change, or debugging navigation issues reported by end-users.

Related Objects

Based on the provided dependency information, the IGS_GE_CFG_NAV table has a straightforward relationship model. The table does not reference any other database objects via foreign keys. However, it is referenced by an object in the APPS schema named IGS_GE_CFG_NAV. This is typically a public synonym (APPS.IGS_GE_CFG_NAV) that points to the underlying IGS.IGS_GE_CFG_NAV table, which is a standard EBS architecture pattern to provide a single, consistent access point for all application modules. The table's design implies a logical relationship with the FND_RESPONSIBILITY table (via the RESPONSIBILITY_ID column) and various form and subform definitions within the Oracle Forms modules, though these are not enforced as database foreign key constraints in the provided metadata.