Search Results completion_start_date

Overview

IGS_GR_CRMN_ROUND is a secured (organization-restricted) view owned by the APPS schema in the Oracle E-Business Suite Student System (IGS) product family. It exposes graduation round scheduling data — the time windows during which conferral and completion processing occurs for a given graduation calendar and calendar instance. The view is a filtered projection over the underlying base table IGS_GR_CRMN_ROUND_ALL, applying Oracle's multi-organization access control (MOAC) predicate so that only records belonging to the operating unit context of the current session are visible.

In Oracle EBS 12.1.1 and 12.2.2 the object is reported as VALID, though ETRM does not publish a business-facing description for it. Functionally it serves the same reporting and integration role as other IGS "_ALL"/base view pairs: the underlying table stores rows across all operating units, while the view presents the subset relevant to the logged-in organization. Release 12.2.2 ETRM metadata records no referenced base objects separately, but the view text itself unambiguously identifies IGS_GR_CRMN_ROUND_ALL as the source object.

Underlying Base Objects

The view is defined over a single base table, IGS_GR_CRMN_ROUND_ALL, and exposes the base table's ROWID as ROW_ID, which allows the view to be used in update/delete operations as well as queries. The defining SQL is a simple SELECT of all columns from the base table with a WHERE clause implementing the MOAC filter:

• Base object: IGS_GR_CRMN_ROUND_ALL (APPS schema).
• Security predicate: The ORG_ID column is compared against the value derived from USERENV('CLIENT_INFO') — the first ten characters of client info, decoded to a number. If CLIENT_INFO is blank, the value resolves to NULL and then to the sentinel -99. Rows whose ORG_ID equals this value (or is likewise NULL/-99) are returned.
• Ownership: Owned by APPS; IGS product module; status VALID in both 12.1.1 and 12.2.2.

Because the MOAC logic is embedded in the view, any report, concurrent program, or interface that selects from IGS_GR_CRMN_ROUND automatically inherits operating-unit security without additional coding.

Key Columns

The view returns seventeen columns, all passed through from the base table:

• ROW_ID — the base table ROWID; used to address the underlying row.
• ORG_ID — operating unit identifier, the pivot of the security predicate.
• GRD_CAL_TYPE — the graduation calendar type, identifying the calendar category to which the round belongs.
• GRD_CI_SEQUENCE_NUMBER — the graduation calendar instance sequence number, pinning the round to a specific instance of that calendar.
• START_DT_ALIAS / START_DAI_SEQUENCE_NUMBER — the date alias and date-alias instance sequence that define the start of the round.
• END_DT_ALIAS / END_DAI_SEQUENCE_NUMBER — the corresponding alias and sequence that define the end of the round.
• CONFERRAL_START_DATE / CONFERRAL_END_DATE — the date range within which conferral (award) processing is valid for the round.
• COMPLETION_START_DATE / COMPLETION_END_DATE — the date range within which completion processing is valid.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS WHO audit columns recording row creation and last modification.

Common Use Cases and Queries

Typical usages include validating that conferral or completion dates fall inside the configured round windows, listing rounds for a graduation calendar instance, and driving downstream interfaces that need the active round for the current organization. Sample queries:

• All rounds for a calendar instance:
  SELECT grd_cal_type, grd_ci_sequence_number, start_dt_alias, end_dt_alias, conferral_start_date, conferral_end_date FROM igs_gr_crmn_round WHERE grd_cal_type = :cal_type AND grd_ci_sequence_number = :ci_seq;
• Rounds open for conferral on a given date:
  SELECT * FROM igs_gr_crmn_round WHERE :check_date BETWEEN conferral_start_date AND conferral_end_date;
• Completion windows by organization:
  SELECT org_id, completion_start_date, completion_end_date FROM igs_gr_crmn_round ORDER BY org_id;

Note that results are always restricted by the session's client-info organization context; queries intended to span multiple operating units must be run with the appropriate MOAC initialization or against the base table IGS_GR_CRMN_ROUND_ALL where authorized.