Search Results igw_prop_users

Overview

The IGW_PROP_USERS table is a core data object within the Oracle E-Business Suite Grants Proposal module (IGW). It functions as a junction table that establishes and manages the relationship between proposals and the users who are authorized to access them. Its primary role is to enforce data security and access control by defining a list of users for each specific proposal. This table is essential for the collaborative workflow of proposal development, ensuring that only designated individuals can view or modify a proposal based on their assigned roles, which are managed through the related IGW_PROP_USER_ROLES table.

Key Information Stored

The table's structure is minimal, designed specifically to link two key entities. Its critical columns, which together form the primary key, are PROPOSAL_ID and USER_ID. The PROPOSAL_ID column stores a foreign key reference to a specific proposal record in the IGW_PROPOSALS_ALL table. The USER_ID column stores a foreign key reference to a user defined in the FND_USER table, which is the central repository for all E-Business Suite user accounts. This pairing ensures a unique association between a user and a proposal, preventing duplicate access entries. The table itself does not store role or permission details; that information is maintained separately in IGW_PROP_USER_ROLES.

Common Use Cases and Queries

A primary use case is generating access reports for proposal audits or administrative reviews. System administrators or proposal managers frequently query this table to list all users with access to a particular proposal or to identify all proposals accessible to a specific user. Common SQL patterns include joining to FND_USER to retrieve usernames and joining to IGW_PROPOSALS_ALL for proposal details. For example, to list users for a specific proposal:

• SELECT fu.user_name, fu.description FROM igw_prop_users ipu, fnd_user fu WHERE ipu.user_id = fu.user_id AND ipu.proposal_id = <PROPOSAL_ID>;

Another critical use case is during data migration or security synchronization, where scripts may populate this table to grant initial access to proposal teams based on legacy system data or organizational hierarchies.

Related Objects

The IGW_PROP_USERS table maintains defined foreign key relationships with several other EBS objects, centralizing its role in the data model:

• IGW_PROPOSALS_ALL: The primary proposal table. The IGW_PROP_USERS.PROPOSAL_ID column references IGW_PROPOSALS_ALL, ensuring every user association is linked to a valid proposal.
• FND_USER: The core application user table. The IGW_PROP_USERS.USER_ID column references FND_USER.USER_ID, ensuring access is granted only to registered system users.
• IGW_PROP_USER_ROLES: This table holds the specific roles (e.g., Writer, Approver, Viewer) for each user-proposal combination. It references IGW_PROP_USERS using both the PROPOSAL_ID and USER_ID columns, creating a dependent relationship where role assignments require a prior access entry.