Results for “igs_ps_own_hist”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGS_PS_OWN_HIST view is a reporting object within the Oracle E-Business Suite IGS – Student System product family. In the ETRM 12.2.2 documentation, the product is flagged Obsolete, and the view is explicitly noted as "Not implemented in this database." This indicates the object is legacy and is not installed in the reference database against which the metadata was captured; it may still exist in environments migrated from earlier releases where the Student System (formerly Oracle Student System, later folded into Oracle Student Financial Planning / Campus Solutions integrations) was deployed.

Functionally, the view exposes ownership history for course offerings. The base table name, IGS_PS_OWN_HIST_ALL, and the presence of ORG_ID and a multi-org security predicate in the view text confirm that this is a Business Group / Operating Unit (multi-org) secured view. The "_ALL" suffix on the underlying table is the Oracle Applications convention for a table containing rows for multiple operating units, with a corresponding non-suffixed view filtering by the session's operating unit.

Underlying Base Objects

The view text reveals the sole referenced base object:

• IGS_PS_OWN_HIST_ALL — the multi-org ownership history table for course versions/sections.

The view definition is a straightforward projection of that table, renaming ROWID to ROW_ID and selecting every column plus ORG_ID. Note that ETRM lists no separately documented referenced base objects, and the view relies on the IGS_PS_OWN_HIST_ALL table being present. The critical behavioral component is the WHERE clause, which enforces operating unit isolation:

• It extracts the first ten characters of USERENV('CLIENT_INFO') — the standard mechanism by which Oracle Applications stores the current ORG_ID for a session.
• If the first character is a space, the value is NULL; otherwise the 10-character substring is converted to a number.
• The row's ORG_ID is compared against this session value, defaulting to -99 when no operating unit context is present (a "no rows" sentinel).

This predicate is the canonical Oracle multi-org view pattern, meaning the view returns only rows belonging to the operating unit in effect for the connected session.

Key Columns

• ROW_ID — the physical ROWID of the row in IGS_PS_OWN_HIST_ALL, useful for direct row access.
• COURSE_CD and VERSION_NUMBER — identify the course and its version to which the ownership record applies.
• ORG_UNIT_CD and OU_START_DT — the owning organizational unit and the start date from which that ownership applies.
• HIST_START_DT, HIST_END_DT, HIST_WHO — the effective date range of the historical record and the actor who performed the change.
• PERCENTAGE — the ownership share, typically used when courses are jointly owned by multiple organizational units.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO/audit columns.
• ORG_ID — the operating unit discriminator used by the security predicate.

Common Use Cases and Queries

Because the object is obsolete and not implemented in the documented database, no supports open work should be created directly against it. Where legacy environments still contain it, it is used for historical reporting on course ownership changes over time.

• Ownership history for a course:
  SELECT COURSE_CD, VERSION_NUMBER, ORG_UNIT_CD, HIST_START_DT, HIST_END_DT, PERCENTAGE
FROM IGS_PS_OWN_HIST
WHERE COURSE_CD = :course_code
ORDER BY HIST_START_DT DESC;
• Current effective ownership:
  SELECT * FROM IGS_PS_OWN_HIST
WHERE SYSDATE BETWEEN HIST_START_DT AND NVL(HIST_END_DT, SYSDATE);
• Audit of who changed ownership:
  SELECT COURSE_CD, ORG_UNIT_CD, HIST_WHO, HIST_START_DT
FROM IGS_PS_OWN_HIST ORDER BY LAST_UPDATE_DATE DESC;

All queries inherit the operating unit filter automatically through the view predicate, so results are restricted to the current session's ORG_ID.