Search Results tracking_step_number




Overview
Explore in AI Chat

Overview

IGS_TR_STEP_V is a reporting and integration view owned by the APPS schema in the Oracle E-Business Suite Student System (IGS) product family. It exposes the individual tracking steps associated with student tracking records, enriching the underlying step data with derived scheduling figures and recipient identification. In the Oracle EBS 12.1.1 and 12.2.2 releases the view remains a valid, deployed object, and it functions as the canonical read interface for applications, concurrent programs, and custom reports that need to display or process tracking step progress.

The view materialises each step as a single row containing the step's sequence number, descriptive text, completion information, and calculated action and overdue dates. Because the derived columns are produced by PL/SQL functions in the IGS_TR_GEN_001 package rather than stored in a base table, the view abstracts business-date arithmetic away from the consumer, so reporting tools can query due dates and lateness without reimplementing the tracking calendar logic.

Underlying Base Objects

The view is defined over four referenced objects joined in its text:

The joins are driven from IGS_TR_ITEM to IGS_TR_STEP on TRACKING_ID, with the person and lookup joins expressed as outer joins. The tracked row identity is preserved through ROWID, allowing the view to be used as the basis for updateable-region or DML-aware processing in some toolkits.

Key Columns

Common Use Cases and Queries

Typical consumers are correspondence and admissions tracking reports, overdue-step exception lists, and interfaces that publish pending actions to external systems. The following query lists all steps for a tracking item with derived due dates:

  • SELECT tracking_step_number, description, action_dt, completion_dt, overdue_days, desc_step_type, dsp_preferred_name FROM igs_tr_step_v WHERE tracking_id = :p_tracking_id ORDER BY tracking_step_number;
  • SELECT tracking_id, tracking_step_number, description, dsp_preferred_name, overdue_days FROM igs_tr_step_v WHERE step_completion_ind = 'N' AND by_pass_ind = 'N' AND publish_ind = 'Y' AND overdue_days > 0 ORDER BY overdue_days DESC;
  • SELECT desc_step_type, COUNT(*) FROM igs_tr_step_v WHERE step_completion_ind = 'Y' GROUP BY desc_step_type;

Note that ACTION_DT and OVERDUE_DAYS are evaluated per row by the IGS_TR_GEN_001 functions, so queries filtering heavily on those columns over large volumes may benefit from restricting TRACKING_ID or creation dates first.