Search Results reg_viewer_id

Overview

The IGP_US_REG_VIEWERS table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, residing in the IGS (iGrants) schema. Its primary function is to manage access control for portfolio assignments by storing records of registered viewers. A portfolio, in this context, is a collection of related data or documents, and this table acts as a junction table that defines which specific parties (individuals or organizational contacts) are authorized to view a given portfolio. It enforces a critical security and data-sharing model within the associated iGrants modules, ensuring that portfolio access is explicitly granted, tracked, and can be constrained by effective dates.

Key Information Stored

The table's structure is designed to capture the relationship between a portfolio, a viewer, and the context of that access. The REG_VIEWER_ID column serves as the unique, system-generated primary key for each access grant. The core relationship is defined by PORTFOLIO_ID, which links to the specific portfolio, and PARTY_ID, which identifies the person granted access. A key nuance is the ORG_PARTY_ID; this field is populated if the access was granted in the context of the person being a contact for a specific organization, linking to the organization's party record. Temporal control is provided through START_DATE (defaulted to SYSDATE) and END_DATE columns, allowing for time-bound access permissions. The table also includes standard EBS "Who" columns (CREATED_BY, CREATION_DATE, etc.) and an OBJECT_VERSION_NUMBER for data integrity and auditing.

Common Use Cases and Queries

A primary use case is generating reports to audit who has access to sensitive portfolios. Administrators frequently query this table to list all active viewers for a specific portfolio or to review all portfolios accessible to a particular party. Another common operational need is to identify and expire outdated access grants by evaluating records against the END_DATE. Sample queries support these scenarios:

• To find all active viewers for a portfolio: SELECT p.party_name, rv.start_date, rv.end_date FROM igs.igp_us_reg_viewers rv, hz_parties p WHERE rv.party_id = p.party_id AND rv.portfolio_id = :portfolio_id AND (rv.end_date IS NULL OR rv.end_date >= SYSDATE);
• To list all portfolios accessible to a given party: SELECT pf.portfolio_name, rv.start_date, rv.end_date FROM igs.igp_us_reg_viewers rv, igs.igp_us_portfolios pf WHERE rv.portfolio_id = pf.portfolio_id AND rv.party_id = :party_id;

Related Objects

The IGP_US_REG_VIEWERS table is centrally connected to other fundamental EBS entities through foreign key relationships, which are essential for accurate joins in reports and integrations. The documented relationships are:

• IGP_US_PORTFOLIOS: The PORTFOLIO_ID column references this table to identify the specific portfolio for which viewing rights are granted.
• HZ_PARTIES (twice): The PARTY_ID column references HZ_PARTIES to identify the individual person (viewer). The ORG_PARTY_ID column also references HZ_PARTIES to optionally identify the related organization party record.

These relationships ensure data consistency and enable comprehensive reporting that combines portfolio details with the full party information of both the individual viewer and their associated organization from the Trading Community Architecture (TCA) model.