Search Results unit_offering_option

Overview

APPS.IGS_PS_TCH_RESP_UOO_V is a public view in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 releases, owned by the APPS schema and registered under FND Design Data as IGS.IGS_PS_TCH_RESP_UOO_V. It is part of the Student System (IGS) product family. The view exposes teaching responsibility information as it applies to a specific unit offering option. Its purpose is to consolidate, for a given unit offering option, the applicable teaching responsibility, resolving the record from either the base teaching responsibility table or the teaching responsibility override table. Because it is documented by Oracle as a public view "which may be useful for custom reporting or other data requirements," it is intended for read-only reporting and integration use rather than for transactional processing. The object is currently VALID, and it is not referenced by any other database object, which indicates it sits at a reporting boundary rather than within an internal dependency chain.

Underlying Base Objects

Per the documented dependency information, APPS.IGS_PS_TCH_RESP_UOO_V references the following base objects in the APPS schema:

• IGS_PS_UNIT_OFR_OPT — the unit offering option table, supplying the unit offering option identity and its descriptive key attributes.
• IGS_PS_TCH_RESP — the teaching responsibility table, supplying the primary teaching responsibility, percentage, and organization unit.
• IGS_PS_TCH_RESP_OVRD — the teaching responsibility override table, used where an override supersedes the base teaching responsibility.

The view logic joins unit offering option context to the relevant responsibility record, using either IGS_PS_TCH_RESP or IGS_PS_TCH_RESP_OVRD to determine which responsibility is deemed relevant. The view itself is not referenced by any database object, confirming it is a terminal reporting object. No additional base tables are documented beyond these three.

Key Columns

The view exposes fifteen columns. The following are the most significant:

• UNIT_CD, VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER, LOCATION_CD, UNIT_CLASS — the unit offering option key attributes, all sourced from IGS_PS_UNIT_OFR_OPT. These define the specific unit offering option context.
• UOO_ID — the numeric identifier of the unit offering option, from IGS_PS_UNIT_OFR_OPT. This is the primary join key for the option.
• ORG_UNIT_CD — the organization unit code carrying the teaching responsibility, sourced from IGS_PS_TCH_RESP.
• OU_START_DT — the start date of the organisational unit responsibility, sourced from IGS_PS_TCH_RESP.
• PERCENTAGE — the proportion of the teaching responsibility assigned, sourced from IGS_PS_TCH_RESP.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Who columns for auditability.

Common Use Cases and Queries

A frequent use case is reporting on the teaching responsibility and its percentage split for each unit offering option, including responsibility defined through overrides. Because the view resolves overrides internally, consumers do not need to apply the override logic themselves. Typical filtering is by unit code, version, calendar type, or organisation unit.

The documented query text is:

• SELECT UNIT_CD, VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER, LOCATION_CD, UNIT_CLASS, ORG_UNIT_CD, OU_START_DT, UOO_ID, PERCENTAGE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN FROM APPS.IGS_PS_TCH_RESP_UOO_V;

A representative filtered example retrieves responsibility per option for a given unit:

• SELECT UOO_ID, UNIT_CD, VERSION_NUMBER, ORG_UNIT_CD, PERCENTAGE FROM APPS.IGS_PS_TCH_RESP_UOO_V WHERE UNIT_CD = :unit_code;

Aggregation queries summing PERCENTAGE by ORG_UNIT_CD are also common for workload reporting. As the view is read-only and not referenced by other objects, it is safe to query directly for custom reports without impacting transactional integrity.