Search Results igs_ge_cfg_nav_pk




Overview
Explore in AI Chat

Overview

The IGS_GE_CFG_NAV table is a core configuration table within the Oracle E-Business Suite (EBS) Student System (IGS). It functions as a repository for form navigation definitions, specifically mapping which forms and subforms are accessible under a given responsibility. This table is essential for enforcing application security and controlling the user interface flow within the Student System modules. By defining the permissible navigation paths, it ensures that users with a specific responsibility can only access the forms and functions authorized for their role, thereby maintaining data integrity and security in implementations across versions 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is defined by its composite primary key, which consists of three columns. The RESPONSIBILITY_ID column identifies the specific EBS responsibility or role. The FORM_CODE column stores the identifier for a primary form or function. The SUBFORM_CODE column holds the identifier for a child form or subfunction that is accessible from the primary form under the given responsibility. Together, these columns create a unique record that authorizes a specific navigation link within the application's menu hierarchy for a user assigned that responsibility.

Common Use Cases and Queries

A primary use case involves troubleshooting user access issues or auditing security configurations. Administrators can query this table to verify or list all forms and subforms available to a particular responsibility. For example, to find all navigation entries for a responsibility with ID '12345', one would execute: SELECT form_code, subform_code FROM igs.igs_ge_cfg_nav WHERE responsibility_id = '12345';. Conversely, to identify which responsibilities grant access to a specific form (e.g., 'STUDENT_MAIN'), the query SELECT responsibility_id FROM igs.igs_ge_cfg_nav WHERE form_code = 'STUDENT_MAIN'; is used. This data is critical for customizing role-based access during implementations and upgrades.

Related Objects

The IGS_GE_CFG_NAV table maintains a direct foreign key relationship with the IGS_GE_CFG_FORM table, as documented in the provided metadata. This relationship validates the form codes stored in the navigation configuration against a master list of defined forms. The foreign key is defined on the columns (RESPONSIBILITY_ID, FORM_CODE) in IGS_GE_CFG_NAV referencing the same columns in IGS_GE_CFG_FORM. This ensures referential integrity, meaning a navigation record cannot point to a form that does not exist in the configuration master table.