Search Results oss_registered




Overview
Explore in AI Chat

Overview

APPS.IGR_I_STATUS_V is a reporting view in the Oracle E-Business Suite environment that exposes the status values available for IGR (Oracle Student System / iGrants) enquiry records. Its principal role is to present a curated, human-readable list of enquiry statuses that are meaningful to the student enquiry lifecycle, combining descriptive meaning text with codes and closed-indicator flags. The view is commonly touched by forms, concurrent programs, and integration components that need to validate, display, or drive transitions of an enquiry's status without querying the underlying status tables directly.

The user search term "oss_acknowlege" corresponds directly to one of the lookup codes embedded in the view definition. This misspelling (acknowlege rather than acknowledge) is preserved in the Oracle seed data and is therefore the value that must be used when filtering or joining against this view.

Underlying Base Objects

The view is defined over two documented sources:

  • AS_STATUSES_VL — aliased as ES. This is the statuses value-list view providing the row identifier, meaning, description, status code, and enabled flag.
  • IGS_LOOKUP_VALUES — aliased as LKUP. This supplies the display meaning and the closed indicator, filtered to the lookup type IGR_ENQUIRY_STATUS.

The join condition matches LKUP.LOOKUP_CODE to ES.STATUS_CODE, and the result set is further restricted to three specific codes: OSS_ACKNOWLEGE, OSS_COMPLETE, and OSS_REGISTERED. Notably, no base tables are separately documented in the ETRM metadata for this view beyond the two sources above.

Key Columns

  • ROW_ID — Unique identifier for the status row, sourced from AS_STATUSES_VL.
  • ENQUIRY_STATUS — The user-facing meaning of the status from the statuses view.
  • DESCRIPTION — Additional descriptive text for the status.
  • S_ENQUIRY_STATUS — The underlying status code (e.g., OSS_ACKNOWLEGE).
  • ENABLED_FLAG — Indicates whether the status is currently active and selectable.
  • MEANING — The lookup-derived meaning text from IGS_LOOKUP_VALUES.
  • DSP_CLOSED_IND — The closed indicator flag, used to determine whether the status represents a terminal, closed enquiry state.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle WHO columns inherited from the status record.

Common Use Cases and Queries

Typical scenarios include displaying a status list on enquiry forms, validating incoming status codes during integration, and identifying which enquiries are in a closed state. A simple listing that includes the acknowledgement status referenced by the user search is shown below.

  • Populating a status LOV on an enquiry form.
  • Filtering enquiries that are not yet complete using DSP_CLOSED_IND.
  • Resolving lookup meaning text for reporting or extracts.

Sample query:

  • SELECT ROW_ID, ENQUIRY_STATUS, S_ENQUIRY_STATUS, MEANING, DSP_CLOSED_IND FROM APPS.IGR_I_STATUS_V WHERE S_ENQUIRY_STATUS = 'OSS_ACKNOWLEGE';
  • SELECT S_ENQUIRY_STATUS, ENQUIRY_STATUS FROM APPS.IGR_I_STATUS_V WHERE ENABLED_FLAG = 'Y' ORDER BY ENQUIRY_STATUS;