Results for “cart_error_flag”
28 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGS_EN_PLAN_UNITS is a transaction table within the Oracle E-Business Suite Student System (IGS) product family. It stores the unit attempt details that belong to a student's planning sheet — the working record in which an advisor or student assembles the proposed set of unit offerings for an academic term before those units are committed to an actual enrollment. Each row represents one planned unit attempt for a given person and course, capturing the optional unit offering selected, any overrides applied to the planned credit points, and the grading schema that governs the assessment.
The table is owned by the IGS schema and is present in both EBS 12.1.1 and 12.2.2. Its documented physical schema contains 19 columns. Based on the foreign-key structure mined from the ETRM metadata, the object is heuristically classified as a link in Data Vault terms: it resolves many-to-many relationships between a student planning record, a unit offering option, and a grading schema, rather than functioning as a standalone hub or a descriptive satellite.
Key Information Stored
The primary key is enforced by the unique index IGS_EN_PLAN_UNITS_PK, whose documented business-key candidate columns are PERSON_ID, COURSE_CD, UOO_ID, and CART_ERROR_FLAG. The remaining documented columns provide the planning context and audit trail.
- PERSON_ID — identifies the student whose planning sheet contains the unit attempt. Joins to IGS_EN_STDNT_PS_ATT_ALL.
- COURSE_CD — the course (program) within which the planned unit is being taken.
- UOO_ID — the specific unit offering option selected on the plan. Joins to IGS_PS_UNIT_OFR_OPT_ALL.
- CART_ERROR_FLAG — flag indicating whether the planned unit encountered an error when placed in the enrollment/planning cart. This is the column most commonly searched for in support and data-remediation scenarios.
- TERM_CAL_TYPE and TERM_CI_SEQUENCE_NUMBER — the calendar type and sequence number identifying the academic term to which the plan applies.
- SUP_UOO_ID — the superior (parent) unit offering option, used where a planned unit sits within a parent unit structure.
- OVERRIDE_ENROLLED_CP — an override of the standard enrolled credit points for the planned unit.
- GRADING_SCHEMA_CODE and GS_VERSION_NUMBER — the grading schema and version applied to the planned attempt. These join to IGS_AS_GRD_SCHEMA.
- NO_ASSESSMENT_IND — indicates the unit is planned without assessment.
- CORE_INDICATOR_CODE and ALTERNATIVE_TITLE — flag the core status and any alternative title displayed on the plan.
- SESSION_ID — the session associated with the planned attempt.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns.
Common Use Cases and Queries
The most frequent operational need is diagnosing planned units that failed to convert into enrollments. Rows with a non-null or flagged CART_ERROR_FLAG identify these cases, and DBAs or functional consultants typically join back to the student and offering tables to explain the failure.
- Reporting all errored planned units for a term:
SELECT PERSON_ID, COURSE_CD, UOO_ID FROM IGS_EN_PLAN_UNITS WHERE CART_ERROR_FLAG = 'Y' AND TERM_CAL_TYPE = :cal AND TERM_CI_SEQUENCE_NUMBER = :seq; - Listing a student's full planning sheet: filter by PERSON_ID and COURSE_CD, then join UOO_ID to IGS_PS_UNIT_OFR_OPT_ALL for unit codes and titles.
- Auditing credit-point overrides: select rows where OVERRIDE_ENROLLED_CP is populated.
- Validating grading configuration: join GRADING_SCHEMA_CODE and GS_VERSION_NUMBER to IGS_AS_GRD_SCHEMA to confirm the schema is still valid.
Related Objects
The documented foreign keys establish the principal relationships this table depends on:
- IGS_EN_STDNT_PS_ATT_ALL — referenced via PERSON_ID and COURSE_CD; the student program attempt that owns the planning sheet.
- IGS_PS_UNIT_OFR_OPT_ALL — referenced via UOO_ID; the unit offering option selected for the planned attempt.
- IGS_AS_GRD_SCHEMA — referenced via GRADING_SCHEMA_CODE and GS_VERSION_NUMBER; the grading schema definition.
- IGS_EN_PLAN_UNITS_PK — the unique index enforcing the composite key and serving as the business-key access path.
-
Contains the student planning sheet unit attempt details
-
TABLE: IGS.IGS_EN_PLAN_UNITS 12.1.1
-
Table: IGS_EN_PLAN_UNITS 12.2.2
Contains the student planning sheet unit attempt details
Not implemented in this database·Explore IGS module →
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.