Results for “ind_rate_sch_id”

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

Overview

The IGW_IDC_SCHEDULE_V view is a database object historically associated with the Oracle E-Business Suite Grants Proposal module (product code IGW). In the ETRM reference documentation for release 12.2.2, this object carries the designation "Obsolete," and its implementation status is explicitly documented as "Not implemented in this database." Consequently, the view is not expected to be present in a standard Oracle EBS 12.1.1 or 12.2.2 installation, and any attempt to query it directly will generally return an "ORA-00942: table or view does not exist" error. Its documented purpose, inferred from its definition, is to present a filtered list of indirect cost rate schedules that are currently active, exposing the schedule name and schedule identifier. It would have served reporting and integration consumers within the Grants Proposal application that needed to resolve the set of rate schedules effective on the current system date.

Underlying Base Objects

The view text is defined over a single base table, PA_IND_RATE_SCHEDULES, which resides in the Projects (PA) schema and remains a live, supported object in Oracle EBS. The view itself is a thin projection and filter over that table rather than a join or aggregation. The documented definition is:

• SELECT IND_RATE_SCH_NAME, IND_RATE_SCH_ID FROM PA_IND_RATE_SCHEDULES WHERE TRUNC(SYSDATE) BETWEEN START_DATE_ACTIVE AND DECODE(END_DATE_ACTIVE, NULL, SYSDATE+1, END_DATE_ACTIVE)

The metadata indicates the view owner is not documented, and no other referenced base objects are recorded. Because the predicate references START_DATE_ACTIVE and END_DATE_ACTIVE — columns of PA_IND_RATE_SCHEDULES — the view's behavior is entirely governed by the effective-dating columns of the underlying rate schedule table.

Key Columns

The view exposes exactly two columns, both sourced from PA_IND_RATE_SCHEDULES:

• IND_RATE_SCH_NAME — the descriptive name of the indirect cost rate schedule, used for display and identification in user-facing reports.
• IND_RATE_SCH_ID — the unique numeric identifier of the indirect rate schedule. This is the primary key of PA_IND_RATE_SCHEDULES and is the column referenced by foreign keys in downstream rate and cost objects.

Notably, the effective-dating columns (START_DATE_ACTIVE, END_DATE_ACTIVE) used in the view's filter are not projected, so consumers see only the currently effective schedules without the governing dates.

Common Use Cases and Queries

The view's intended use was to answer the question "which indirect rate schedules are active today?" in the simplest possible form, typically for validation lists, concurrent program parameters, or lightweight integrations within Grants Proposal. Because it is documented as obsolete and unimplemented in the 12.2.2 ETRM, it should not be relied upon in current customizations. The equivalent query should be executed directly against the supported base table, which is present in both 12.1.1 and 12.2.2:

• SELECT ind_rate_sch_name, ind_rate_sch_id FROM pa_ind_rate_schedules WHERE TRUNC(SYSDATE) BETWEEN start_date_active AND NVL(end_date_active, SYSDATE + 1);
• SELECT ind_rate_sch_id, ind_rate_sch_name, start_date_active, end_date_active FROM pa_ind_rate_schedules WHERE ind_rate_sch_id = :ind_rate_sch_id;

The search term "ind_rate_sch_id" maps directly to the identifier column exposed by this view and carried on PA_IND_RATE_SCHEDULES. Developers migrating or remediating legacy IGW customizations should replace references to IGW_IDC_SCHEDULE_V with the base-table query above to ensure compatibility across supported EBS releases.