Results for “configurability_function_name”

7 results




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

Overview

IGSBV_AD_ADM_APPL_TYP is a read-only Oracle EBS view in the Student System (IGS) product family that exposes Self Service Admission Application Type details. In the Oracle E-Business Suite 12.1.1 and 12.2.2 release streams, IGS objects belong to the obsolete Student System module and are not implemented in a standard EBS database; the ETRM metadata explicitly records "Not implemented in this database." The view is therefore documented for reference purposes only, and its presence in a database indicates a legacy or customized installation rather than a standard EBS configuration.

Functionally, the view presents the configuration attributes that govern how an admission application type behaves in the self-service admissions flow, including application type identity, admission category, fee and deposit amounts, accounting flexfield references, and instructional text used during the submission process. The searched term "submit_instr" maps directly to the SUBMIT_INSTR column, one of three instructional text columns exposed by this view.

Underlying Base Objects

The view text shows that IGSBV_AD_ADM_APPL_TYP is defined over a single base object, IGS_AD_SS_APPL_TYP (aliased APT), and is created "WITH READ ONLY." The ETRM metadata records no additional referenced base objects, so the view is a straightforward projection of the underlying self-service application type table rather than a join across multiple tables. Several columns are translated at query time through lookup references to IGS_LOOKUP_VALUES, specifically for admission process type meaning, the yes/no closed indicator flag, and deposit level meaning. As a read-only view, it carries no independent storage, and any data change made to IGS_AD_SS_APPL_TYP is reflected immediately in queries against this view.

Key Columns

The view exposes a number of columns that are central to self-service admissions configuration:

Common Use Cases and Queries

The view is typically queried to review self-service admission application type configuration and instructional messaging. A representative query retrieves the application type and its submission instructions:

  • SELECT admission_application_type, application_type_desc, submit_instr FROM igsbv_ad_adm_appl_typ;
  • SELECT admission_application_type, application_fee_amount, enroll_deposit_amount FROM igsbv_ad_adm_appl_typ WHERE system_default = 'Y';
  • SELECT admission_application_type, revenue_account_code, cash_account_code FROM igsbv_ad_adm_appl_typ WHERE application_fee_amount > 0;

Because the object is not implemented in a standard EBS 12.1.1 or 12.2.2 database, these queries apply only where the legacy IGS schema has been deployed. In standard installations, equivalent self-service admissions configuration should be sourced from the supported replacement objects provided by the current admissions module.