Search Results sup_repeating_group_cd




Overview
Explore in AI Chat

Overview

The IGS_CO_LTR_RPT_GRP_ALL table is a core repository for defining hierarchical repeating group structures within the correspondence letter generation functionality of Oracle E-Business Suite, specifically within the IGS (presumably Institutional Global Systems) module. Its primary role is to establish and manage the logical grouping of repeating parameters or data elements within a system-generated letter. This structure is essential for producing complex, data-driven correspondence where certain sections, such as line items or dependent details, need to be iterated. The table supports multi-organization data through the ORG_ID column, making it a central "ALL" table in the EBS architecture.

Key Information Stored

The table's structure is defined by a composite primary key and columns that manage group hierarchy and metadata. The most critical columns include:

Common Use Cases and Queries

This table is primarily accessed during the configuration of letter templates and the runtime generation of letters. A common operational query is to retrieve the hierarchical structure of all repeating groups for a specific letter to validate setup or troubleshoot generation issues. For example, to find all child groups under a specific parent group for a letter, one might use:

SELECT child.LETTER_REPEATING_GROUP_CD, child.DESCRIPTION
FROM IGS_CO_LTR_RPT_GRP_ALL child
WHERE child.CORRESPONDENCE_TYPE = '<TYPE>'
AND child.LETTER_REFERENCE_NUMBER = <REF_NUM>
AND child.SUP_REPEATING_GROUP_CD = '<PARENT_GROUP_CD>'
AND child.ORG_ID = <OU_ID>;

Another frequent reporting use case involves listing all top-level groups (those without a parent) for a correspondence type: SELECT * FROM IGS_CO_LTR_RPT_GRP_ALL WHERE SUP_REPEATING_GROUP_CD IS NULL;. The column SUP_REPEATING_GROUP_CD, which was the user's search term, is the linchpin for these hierarchical queries.

Related Objects

The table maintains several documented foreign key relationships, indicating its integration within the correspondence subsystem:

  • Primary Key: IGS_CO_LTR_RPT_GRP_PK (CORRESPONDENCE_TYPE, LETTER_REFERENCE_NUMBER, LETTER_REPEATING_GROUP_CD).
  • Self-Referencing Foreign Key: The SUP_REPEATING_GROUP_CD column references the LETTER_REPEATING_GROUP_CD in the same table, enforcing valid parent-child relationships.
  • Referenced By:
  • References:
    • IGS_CO_S_LTR: Establishes that the letter reference and type are valid master letter definitions.