Search Results cancel_reason

Overview

IGS_SV_CNCL_STDNT_BLK_V is a view owned by the APPS schema in the Oracle E-Business Suite Student System (IGS) product family. Its documented purpose is to retrieve the details required to cancel a student record for a non-immigration student, formatted for consumption in an XML payload. In release 12.1.1 and 12.2.2 the object is reported with a status of VALID and forms part of the integration surface used by the student cancellation process rather than the core data model.

The view is deliberately narrow in scope. It exposes one row per qualifying program action, presenting only the identifiers and remarks necessary to build a cancellation message. Because it is a reporting and integration view rather than a base table, it does not store data; every query re-derives the result set from its underlying source at execution time.

Underlying Base Objects

The view is defined over a single documented source object, IGS_SV_PRGMS_INFO, aliased as PRGMS. No additional base tables are documented in the ETRM metadata for this version, and the view text confirms a straightforward single-source SELECT with a filter predicate.

The defining query selects BATCH_ID, PERSON_ID, TERMINATION_REASON (aliased to CANCEL_REASON), and REMARKS (aliased to CANCEL_REMARKS). The driving filter applies the predicate PRGMS.PRGM_ACTION_TYPE = 'CP', restricting output to records flagged as a cancellation program action. The relationship between the view and its base object is therefore one of projection and filtering: the view narrows IGS_SV_PRGMS_INFO to cancellation actions and renames the termination and remark columns into the vocabulary expected by the XML cancellation interface.

Administrators should note that IGS_SV_PRGMS_INFO functions as a program-action fact source. Any change to that object, such as a data type widening or a change in the PRGM_ACTION_TYPE domain values, will propagate directly to this view.

Key Columns

• BATCH_ID — Identifier of the batch to which the cancellation program action belongs. Used to group cancellation records into a single processing or interface run.
• PERSON_ID — The unique party identifier of the student being cancelled. This is the principal join key to person and student records elsewhere in the Student System.
• CANCEL_REASON — Exposed from TERMINATION_REASON on the base object. Carries the coded reason the student is being terminated or cancelled, and is the column most frequently sought by users searching for "cancel_reason".
• CANCEL_REMARKS — Exposed from REMARKS. Provides free-text supplementary detail explaining or supporting the cancellation.

Common Use Cases and Queries

The primary use case is generation of the cancellation XML for non-immigration students. A concurrent or integration routine queries the view for a given batch, maps the four columns into the outbound XML structure, and submits the result to the external or downstream system. Secondary use cases include reconciliation of cancellation batches, operational reporting on cancellation reasons, and troubleshooting why a particular student was not included in a cancellation file.

To list all cancellations for a specific batch:

SELECT batch_id,
       person_id,
       cancel_reason,
       cancel_remarks
FROM   apps.igs_sv_cncl_stdnt_blk_v
WHERE  batch_id = :p_batch_id;

To profile cancellation reasons across all batches:

SELECT cancel_reason,
       COUNT(DISTINCT person_id) student_count
FROM   apps.igs_sv_cncl_stdnt_blk_v
GROUP  BY cancel_reason
ORDER  BY student_count DESC;

To identify the cancellation status for a single student:

SELECT batch_id,
       cancel_reason,
       cancel_remarks
FROM   apps.igs_sv_cncl_stdnt_blk_v
WHERE  person_id = :p_person_id;

Queries should be executed with APPS-level or equivalent read privileges, and parameters should be bound rather than concatenated, particularly where BATCH_ID and PERSON_ID are numeric identifiers drawn from user input.