Search Results splrg_sequence_number

Overview

The APPS.IGS_CO_S_PER_LT_PARM view is a multi-org enabled object within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically in the Oracle Student Management (OSM) product family, often indicated by the IGS (Internet Global Services) prefix. Its primary function is to provide a filtered, operating-unit-specific view of parameter values used in generating system letters for individuals. The view acts as a security and data isolation layer, retrieving data only for the current session's operating unit (ORG_ID) and ignoring records from others. It serves as the primary interface for applications and reports to access personalized letter parameters without directly querying the underlying transactional table.

Key Information Stored

The view stores the specific values for parameters that populate templates when generating correspondence (letters) for a person. Key columns define the letter context and the parameter data itself. The primary key is a composite of PERSON_ID, CORRESPONDENCE_TYPE, LETTER_REFERENCE_NUMBER, SPL_SEQUENCE_NUMBER, LETTER_PARAMETER_TYPE, and SEQUENCE_NUMBER. Notable columns include:

• PERSON_ID: Identifies the individual for whom the letter is generated.
• CORRESPONDENCE_TYPE & LETTER_REFERENCE_NUMBER: Define the category and specific instance of the letter template.
• SPL_SEQUENCE_NUMBER: The sequence number for the system-produced letter (SPL).
• SPLRG_SEQUENCE_NUMBER: Directly related to the user's search term; this stores the sequence number for a repeating group within the system-produced letter, crucial for letters containing iterative data blocks.
• LETTER_PARAMETER_TYPE & SEQUENCE_NUMBER: Identify the type and instance of the parameter being stored.
• PARAMETER_VALUE: Holds the actual data (up to 2000 characters) to be inserted into the letter.
• ORG_ID: The operating unit identifier, enabling the multi-org filter.

Common Use Cases and Queries

This view is central to letter generation processes and auditing. A common use case is troubleshooting or verifying the data that will populate a specific letter for a person. For example, to retrieve all parameter values for a specific letter instance, one would query using the key identifiers. The search for "splrg_sequence_number" indicates a need to analyze repeating group data within letters.

Sample Query 1: Find all parameters for a specific letter.
SELECT * FROM apps.igs_co_s_per_lt_parm
WHERE person_id = 12345
AND correspondence_type = 'ADMISSION'
AND letter_reference_number = 100
AND spl_sequence_number = 1;

Sample Query 2: Examine parameters for a specific repeating group sequence.
SELECT letter_parameter_type, parameter_value
FROM apps.igs_co_s_per_lt_parm
WHERE person_id = 12345
AND splrg_sequence_number = 3 -- Focus on the third instance of a repeating group
ORDER BY sequence_number;

Related Objects

The view has direct dependencies that are critical for understanding its place in the data model. It is built directly upon the APPS.IGS_CO_S_PER_LT_PARM_ALL table, which likely stores the unfiltered, multi-org data. The view is referenced by key OSM packages, including IGS_AD_GEN_011 and IGS_CO_GEN_002, which contain generated code for letter-related logic in the Admissions and Correspondence modules, respectively. The documented foreign key relationships indicate that PERSON_ID and CORRESPONDENCE_TYPE columns reference other lookup or base tables to maintain referential integrity, though the specific target tables are not fully detailed in the provided excerpt.