Results for “igs_ad_apl_rev_prf”

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

Overview

IGS_AD_APL_REV_PRF is a Multi-Org secured view in the Oracle E-Business Suite IGS (Student System) product family. Its documented purpose is to present a Multi-Org filtered projection of the base table IGS_AD_APL_REV_PRF_ALL, exposing records for admission application review profiles. The view applies Oracle's standard Multi-Org (MO) security predicate against the ORG_ID column so that only rows belonging to the operating unit of the current session are visible. In the context of ETRM 12.1.1 and 12.2.2, this object is classified as obsolete, meaning it is retained for backward compatibility and reference purposes only.

The user search term "appl_rev_profile_gr_cd" corresponds directly to the column APPL_REV_PROFILE_GR_CD, which is the primary functional discriminator within the review profile record. This column is exposed by the view but is not the security key; ORG_ID governs visibility. The view therefore fits into the standard Oracle EBS reporting and integration pattern: consumers query the "non-ALL" view, and the Multi-Org predicate is applied transparently, while the "_ALL" table remains the physical store for all operating units.

Underlying Base Objects

The single documented base object is the table IGS_AD_APL_REV_PRF_ALL. The view aliases this table as RP and selects all of its columns plus the ROWID. No other referenced base objects are documented in the ETRM metadata for this view, and the view itself is not implemented in the reference database used to generate the excerpt.

The Multi-Org security logic embedded in the view is the classic Client_Info pattern. The predicate compares the ORG_ID on the row against a value decoded from USERENV('CLIENT_INFO'): leading blanks are treated as NULL, the first ten bytes are converted to a number, and missing values are defaulted to -99. In practice this means the view returns rows whose ORG_ID matches the operating unit established in the session context, with a default sentinel of -99 when no client information is set.

Key Columns

• APPL_REV_PROFILE_ID — Unique identifier (primary key) of the application review profile record.
• ORG_ID — Operating unit identifier; drives the Multi-Org security predicate applied by the view.
• REVIEW_PROFILE_NAME — Descriptive name assigned to the review profile.
• START_DATE / END_DATE — Effective date range during which the review profile is active.
• MIN_EVALUATOR / MAX_EVALUATOR — Minimum and maximum number of evaluators permitted for the profile.
• PROG_APPROVAL_REQUIRED — Flag indicating whether program-level approval is required.
• SEQUENTIAL_CONCURRENT_IND — Indicator for sequential versus concurrent review processing.
• APPL_REV_PROFILE_GR_CD — Code classifying the review profile group; this is the column referenced by the search term "appl_rev_profile_gr_cd".
• SITE_USE_CODE — Site use code associated with the profile record.
• CLOSED_IND — Flag denoting whether the review profile is closed.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle EBS auditing (WHO) columns.
• ROW_ID — The underlying ROWID of the base table row, exposed for direct row addressing.

Common Use Cases and Queries

The view is typically queried to list active admission review profiles for the current operating unit, to look up profile configuration such as evaluator limits and approval flags, or to join profile data to evaluation and admission records. Because it is Multi-Org secured, queries automatically return only rows for the session's operating unit, including records where ORG_ID is the -99 sentinel when no client information is set.

Example: retrieve all review profiles and their group codes for the current operating unit.

• SELECT appl_rev_profile_id, review_profile_name, appl_rev_profile_gr_cd, start_date, end_date, closed_ind FROM igs_ad_apl_rev_prf ORDER BY review_profile_name;

Example: filter by the profile group code referenced in the search term.

• SELECT appl_rev_profile_id, review_profile_name, appl_rev_profile_gr_cd FROM igs_ad_apl_rev_prf WHERE appl_rev_profile_gr_cd = :profile_gr_cd;

Example: identify open profiles requiring program approval.

• SELECT review_profile_name, min_evaluator, max_evaluator, prog_approval_required FROM igs_ad_apl_rev_prf WHERE closed_ind = 'N' AND prog_approval_required = 'Y';

Because the object is obsolete and not implemented in the documented database, these queries are provided for reference and migration assessment rather than for production use in new implementations.