Search Results replace_fc




Overview
Explore in AI Chat

Overview

APPS.IGF_AW_AWD_FRML_DET is a multi-org database view in the Oracle E-Business Suite Financials schema (APPS) that exposes the components of award formula definitions used by the Oracle Student Financial Aid / Awards (IGF) module. In Oracle EBS 12.1.1 and 12.2.2, this object provides a reporting and integration surface over the award formula detail records that govern how funds are distributed to individual students. The view is classified as a multi-org view, meaning it retrieves data only for the current operating unit and suppresses records belonging to other operating units. The ORG_ID column drives this filtering through the standard multi-org security mechanism, so queries executed without an operational unit context may return no rows or only rows for the environment's default organization.

Because award formula details are configuration data rather than transaction data, this view is primarily consulted for auditing, validation, and integration extraction. It is registered as FND Design Data under the IGF.IGF_AW_AWD_FRML_DET designation and has a status of VALID.

Underlying Base Objects

The documented dependency information identifies the base object as APPS.IGF_AW_AWD_FRML_DET_ALL. The view applies the multi-org filter and exposes the same column set as the underlying table. It does not reference other documented base objects, so consumers can treat it as a direct projection of the _ALL table with operating-unit restriction applied. The view is therefore the correct entry point when security by operating unit is required, whereas the _ALL table is used only when all operating units must be visible.

Key Columns

  • ROW_ID – the database ROWID of the corresponding row in IGF_AW_AWD_FRML_DET.
  • FORMULA_CODE – unique code identifying the award formula to which the detail row belongs.
  • CI_CAL_TYPE / CI_SEQUENCE_NUMBER – calendar type code and sequence number for the award year calendar instance, linking the formula to the applicable academic period within the operating unit.
  • SEQ_NO – the order in which funds are processed within the formula.
  • FUND_ID – unique identifier for the fund associated with the detail row.
  • MIN_AWARD_AMT / MAX_AWARD_AMT – the minimum and maximum award amounts payable under the fund.
  • REPLACE_FC – a flag indicating whether the need calculation includes the family contribution. This is the column most often sought when diagnosing award calculation behavior.
  • ORG_ID – operating unit identifier; the column that enables multi-org filtering.
  • PE_GROUP_ID – group identifier associated with the funding period or eligibility grouping.
  • ADPLANS_ID – foreign key to the award distribution plan table.
  • LOCK_AWARD_FLAG – indicates whether an award is automatically locked after being awarded.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – standard WHO audit columns.

Common Use Cases and Queries

Typical usage includes reviewing formula configuration before an award run, auditing REPLACE_FC settings to confirm whether family contribution is included in need, and extracting formula details into external systems. The following query lists all details for a formula within the current operating unit:

  • SELECT FORMULA_CODE, SEQ_NO, FUND_ID, REPLACE_FC, MIN_AWARD_AMT, MAX_AWARD_AMT FROM APPS.IGF_AW_AWD_FRML_DET WHERE FORMULA_CODE = :p_formula_code ORDER BY SEQ_NO;
  • SELECT FORMULA_CODE, FUND_ID, REPLACE_FC FROM APPS.IGF_AW_AWD_FRML_DET WHERE CI_CAL_TYPE = :p_cal_type AND CI_SEQUENCE_NUMBER = :p_seq ORDER BY SEQ_NO;
  • SELECT FUND_ID, LOCK_AWARD_FLAG, ADPLANS_ID FROM APPS.IGF_AW_AWD_FRML_DET WHERE FORMULA_CODE = :p_formula_code AND ORG_ID = :p_org_id;

For complete cross-operating-unit reporting, query IGF_AW_AWD_FRML_DET_ALL directly; otherwise this view remains the preferred, security-compliant access path.