Search Results cart_error_flag

Overview

The IGS_EN_PLAN_UNITS table is a core data object within the Oracle E-Business Suite (EBS) Student Administration module, specifically in the context of Release 12.1.1 and 12.2.2. It functions as the primary repository for storing detailed information about a student's planned unit attempts within a specific academic program. This table is integral to the student planning and enrollment processes, capturing the intended course load for a given term before formal enrollment is finalized. Its role is to support academic advising, course planning, and the management of the student's academic progression within the institutional framework.

Key Information Stored

The table's columns store critical data points that define a planned unit attempt. The primary key is a composite of PERSON_ID, COURSE_CD, and UOO_ID, uniquely identifying a student's plan for a specific unit offering. Key columns include TERM_CAL_TYPE and TERM_CI_SEQUENCE_NUMBER, which define the academic term for the plan. The CART_ERROR_FLAG column, referenced in the user's search, is a significant indicator used to mark a planned unit that has encountered an error during the validation or "shopping cart" process, preventing its successful enrollment. Other notable columns include NO_ASSESSMENT_IND (for audit status), OVERRIDE_ENROLLED_CP (for manual credit point overrides), and CORE_INDICATOR_CODE (specifying if the unit is core or optional).

Common Use Cases and Queries

A primary use case is identifying and reporting on planned units that have failed validation checks, which is directly tied to the CART_ERROR_FLAG. Administrators can run queries to list all problematic planned units for a student or term to facilitate troubleshooting. Sample SQL to find such records for a specific student and program would be:

• SELECT * FROM IGS.IGS_EN_PLAN_UNITS WHERE PERSON_ID = 12345 AND COURSE_CD = 'BSC001' AND CART_ERROR_FLAG = 'Y';

Another common scenario involves generating a student's planned course schedule for an upcoming term, joining with calendar and unit tables. The table is also central to processes that convert planned units into enrolled unit attempts upon successful completion of the enrollment cart process.

Related Objects

The IGS_EN_PLAN_UNITS table has defined relationships with other key EBS entities. Its primary key is enforced by the IGS_EN_PLAN_UNITS_PK index. The PERSON_ID column is a foreign key to HZ_PARTIES, linking the student's plan to their core party record in the Trading Community Architecture. The UOO_ID and SUP_UOO_ID columns logically relate to unit offering option tables within the IGS schema. Furthermore, the presence of the CART_ERROR_FLAG in both the primary and a non-unique index (IGS_EN_PLAN_UNITS_N1) indicates its operational importance for performance in queries that filter by term and error status, often in conjunction with PERSON_ID and COURSE_CD.