Search Results update_flag

Overview

IGS_SC_OBJECTS_V is a Self-Service view belonging to the IGS — Student System product family, which Oracle classifies as obsolete within the E-Business Suite Release 12.1.1 and 12.2.2 code lines. The view exposes metadata about student system objects that participate in the Self-Service Portal, presenting registration details for each object together with the security flags that govern whether end users may select, insert, update, or delete records through the self-service interface. Because the IGS product is obsolete, the object is retained primarily for backward compatibility and is documented in the ETRM as "Not implemented in this database," indicating that no physical instantiation exists in a standard 12.2.2 environment. Its reporting role, where present, is to provide a security-annotated catalogue of self-service objects rather than transactional student data.

The view is structured as a join between the IGS Student System registration table and the Oracle Application Object Library's FND_OBJECTS, so it bridges two metadata domains: IGS-specific object groupings and the shared FND object registry.

Underlying Base Objects

The ETRM documentation records no separately named referenced base objects, but the embedded view text is explicit. The view is defined over two tables:

• IGS_SC_OBJECTS SC_OBJ — the IGS self-service object registration table, supplying the object group, primary key column definitions, and the four CRUD security flags plus the parent-security enforcement flag.
• FND_OBJECTS FND_OBJ — the standard EBS object registry, supplying OBJ_NAME and APPLICATION_ID.

The join predicate is SC_OBJ.OBJECT_ID = FND_OBJECTS.OBJECT_ID, restricting output to objects that are registered in both the IGS self-service catalogue and the FND object dictionary. Because the FND join is an inner join, IGS_SC_OBJECTS rows lacking a matching FND_OBJECTS record are excluded.

Key Columns

• OBJ_GROUP_ID / OBJECT_ID — identify the object group and the specific object; OBJECT_ID is the join key to FND_OBJECTS.
• OBJ_NAME / APPLICATION_ID — sourced from FND_OBJECTS, giving the developer-facing object name and the owning application.
• DATABASE_OBJECT_NAME — the underlying database object (typically a table or view) that the self-service object represents.
• PK1_COLUMN_NAME … PK5_COLUMN_NAME and PK1_COLUMN_TYPE … PK5_COLUMN_TYPE — up to five primary key columns and their data types, defining row identity for the target object.
• SELECT_FLAG, INSERT_FLAG, UPDATE_FLAG, DELETE_FLAG — self-service privilege indicators controlling allowed DML operations.
• ENFORCE_PAR_SEC_FLAG — indicates whether parent-level security must be enforced when this object is accessed.
• ACTIVE_FLAG — denotes whether the object registration is currently active.
• CREATION_DATE, CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns tracking record provenance.

Common Use Cases and Queries

The view is used diagnostically to audit which self-service objects are active, what DML permissions they carry, and how primary keys are mapped. A representative query lists active objects with their security posture:

• SELECT OBJECT_ID, OBJ_NAME, DATABASE_OBJECT_NAME, SELECT_FLAG, INSERT_FLAG, UPDATE_FLAG, DELETE_FLAG FROM IGS_SC_OBJECTS_V WHERE ACTIVE_FLAG = 'Y' ORDER BY OBJ_NAME;
• SELECT OBJECT_ID, PK1_COLUMN_NAME, PK1_COLUMN_TYPE FROM IGS_SC_OBJECTS_V WHERE ENFORCE_PAR_SEC_FLAG = 'Y';
• SELECT APPLICATION_ID, COUNT(*) FROM IGS_SC_OBJECTS_V GROUP BY APPLICATION_ID;

These queries support security reviews and troubleshooting of self-service registration logic. Because the object is obsolete and marked as not implemented in the documented database, such queries may return no rows or fail with ORA-00942 unless the IGS schema has been retained from a legacy installation.