Search Results letter_order_number




Overview
Explore in AI Chat

Overview

The IGS_CO_LTR_PR_RPT_GR_ALL table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (Oracle Student Management) product family. It functions as a junction or mapping table that defines the relationship between letter parameters and repeating groups within the correspondence engine. Its primary role is to configure which parameter types are associated with a specific repeating group for a given system letter, thereby controlling the dynamic data merged into letter templates. The inclusion of the ORG_ID column signifies it is a multi-org enabled table, storing data specific to individual operating units.

Key Information Stored

The table's columns define the key relationships and attributes for letter parameter grouping. The composite primary key uniquely identifies a single parameter within a repeating group for a letter. Critical columns include:

Common Use Cases and Queries

This table is central to troubleshooting and reporting on letter template configurations. A common use case is to audit all parameters assigned to a specific repeating group for a letter to verify setup or diagnose merge issues. For example, to find all parameters in the 'ADDR_GRP' repeating group for a specific letter, one would execute:

SELECT LETTER_PARAMETER_TYPE, LETTER_ORDER_NUMBER
FROM IGS.IGS_CO_LTR_PR_RPT_GR_ALL
WHERE CORRESPONDENCE_TYPE = 'XYZ'
AND LETTER_REFERENCE_NUMBER = 100
AND LETTER_REPEATING_GROUP_CD = 'ADDR_GRP'
ORDER BY LETTER_ORDER_NUMBER;

Another critical reporting scenario involves listing all distinct repeating groups defined for a correspondence type to understand the letter's structural components:
SELECT DISTINCT LETTER_REPEATING_GROUP_CD
FROM IGS.IGS_CO_LTR_PR_RPT_GR_ALL
WHERE CORRESPONDENCE_TYPE = 'XYZ';

Related Objects

The table maintains defined relationships with other key configuration tables in the correspondence module, as per the provided metadata. The primary key (IGS_CO_LTR_PR_RPT_GR_PK) enforces uniqueness on the combination of its core columns. Foreign key relationships indicate its dependencies:

  • References IGS_CO_LTR_PARAM: Via the LETTER_ORDER_NUMBER column, linking to the master list of available letter parameters.
  • References IGS_CO_LTR_RPT_GRP_ALL: Via the CORRESPONDENCE_TYPE column (and implicitly LETTER_REPEATING_GROUP_CD), linking to the master definition of repeating groups.
  • Referenced by APPS.IGS_CO_LTR_PR_: This indicates the table is likely accessed by application code or a public synonym for programmatic operations within the letter generation process.