Search Results igp_ac_accounts

Overview

The IGP_AC_ACCOUNTS table is a core data object within the Oracle E-Business Suite (EBS) Student System (IGS). Its primary function is to serve as the master repository for portfolio account information. In the context of the Student System, a portfolio account is a logical container that associates a user with a collection of academic and professional artifacts, portfolios, and classifications. This table acts as a central hub, linking student or user identity data from the broader EBS foundation to the specialized portfolio management functionality. Its existence is critical for enabling features related to academic records, competency tracking, and the presentation of student work, which are central to modern student information systems.

Key Information Stored

While the provided ETRM excerpt does not list specific columns beyond the keys, the structure and relationships indicate the nature of the data stored. The primary identifier is the ACCOUNT_ID, a unique system-generated key. Two critical foreign key columns establish foundational links: PARTY_ID, which joins to HZ_PARTIES (the Trading Community Architecture registry for persons and organizations), and USER_ID, which joins to FND_USER (the EBS user management table). This dual linkage ensures the portfolio account is anchored to both a person in the system and a specific application user. Other columns likely include account status, creation and last update dates, and descriptive attributes that define the portfolio account's purpose and lifecycle state.

Common Use Cases and Queries

This table is central to queries that retrieve or report on a user's complete portfolio ecosystem. A common use case is generating a list of all portfolio accounts for a specific student or user. The following sample SQL pattern demonstrates joining to party and user information:

• SELECT a.ACCOUNT_ID, p.PARTY_NAME, u.USER_NAME, a.CREATION_DATE FROM IGS.IGP_AC_ACCOUNTS a, HZ_PARTIES p, FND_USER u WHERE a.PARTY_ID = p.PARTY_ID AND a.USER_ID = u.USER_ID AND p.PARTY_NUMBER = '&student_number';

Another critical use case involves data integrity checks and impact analysis, such as identifying all portfolio artifacts linked to an account before performing administrative actions. Reporting on account utilization and portfolio creation metrics also relies heavily on this table as the primary fact source.

Related Objects

The IGP_AC_ACCOUNTS table has documented relationships with several key objects in the IGS module, primarily as a parent table. The following list details these relationships using the provided foreign key metadata:

• Parent Tables: The table references HZ_PARTIES via PARTY_ID and FND_USER via USER_ID to obtain person and system user details.
• Child Tables: It is referenced as a foreign key by several portfolio-related tables:
  • IGP_AC_ACC_CLASSES (via ACCOUNT_ID): Stores classification data for the account.
  • IGP_US_ARTIFACTS (via ACCOUNT_ID): Stores the individual artifacts or items within the portfolio.
  • IGP_US_PORTFOLIOS (via ACCOUNT_ID): Stores the portfolio definitions or collections themselves.
  • IGP_US_PUB_ARTIFACTS (via ACCOUNT_ID): Likely stores artifacts designated for publication or sharing.

These relationships form a clear hierarchy where IGP_AC_ACCOUNTS is the central record, connecting a user to their associated portfolio structures, classifications, and content.