Search Results replace_fc

Overview

IGF_AW_AWD_FRML_DET is a reporting view within the Oracle E-Business Suite Financial Aid (IGF) module. It is classified as obsolete in Oracle EBS 12.1.1 and 12.2.2, and the ETRM metadata records that it is not implemented in the reference database. The view exists as part of the legacy IGF schema and exposes the award formula detail records used by the Financial Aid award calculation engine.

Its purpose is to present award formula detail rows filtered by the multi-organization access rule. Award formulas in IGF define the rules by which a student's financial aid package is calculated: minimum and maximum award amounts per fund, sequencing rules, calendar applicability, and behavior flags. This view is named "AW" (Award) "AWD" (Award) "FRML" (Formula) "DET" (Detail), which aligns with the underlying base table. The view is intended for reporting and integration queries rather than for transactional DML; it is a read-only projection of the "_ALL" table, resolved against the organization identifier supplied by the session's client information.

Underlying Base Objects

The view is defined over a single base table, IGF_AW_AWD_FRML_DET_ALL, aliased as FMDET in the view text. The ETRM metadata lists no other referenced base objects, and the distinguishing _ALL suffix indicates that the underlying table carries an ORG_ID column and is horizontally partitioned by operating unit or financial aid organization.

The WHERE clause enforces the organization security predicate: it compares the row's ORG_ID to a value derived from USERENV('CLIENT_INFO'), decoding the first ten characters of that client information string and substituting -99 when the value is blank or unavailable. The predicate is wrapped in NVL on both sides so that rows with a null ORG_ID or an unset client information value resolve to the same sentinel, preventing cross-organization leakage while still returning records where organization context is absent. Because the view is not implemented in the database, it should be treated as a documented object that may exist in older or custom environments rather than in a standard 12.1.1 or 12.2.2 installation.

Key Columns

The view exposes the following columns, in the order defined by the view text:

• ROW_ID — the physical ROWID of the underlying base-table row; useful for direct row addressing during troubleshooting.
• FORMULA_CODE — identifier of the parent award formula.
• CI_CAL_TYPE and CI_SEQUENCE_NUMBER — the calendar type and sequence to which the formula detail applies, supporting academic-period-based award rules.
• SEQ_NO — the sequencing position of the detail rule within the formula.
• FUND_ID — the award fund to which the minimum and maximum amounts apply.
• MIN_AWARD_AMT and MAX_AWARD_AMT — the floor and ceiling award amounts for the fund.
• REPLACE_FC — the "replace family contribution" flag, which controls whether the calculated family contribution is substituted when this formula line is applied. This is the column most relevant to the search term "replace_fc."
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.
• ORG_ID — the organization that owns the row; drives the view's security predicate.
• PE_GROUP_ID — the award group used for need analysis or packaging.
• ADPLANS_ID — the associated academic plan identifier.
• LOCK_AWARD_FLAG — indicates whether awards generated from the formula line are locked against recalculation.

Common Use Cases and Queries

Because the view is documented as obsolete and not implemented, use cases are largely historical: migration and data-archaeology queries on legacy IGF instances, comparison of formula definitions across environments, and validation of the REPLACE_FC setting for a given formula and fund.

A simple listing of formula details:

SELECT formula_code, seq_no, fund_id,
       min_award_amt, max_award_amt, replace_fc
  FROM igf_aw_awd_frml_det
 ORDER BY formula_code, seq_no;

Isolating lines where the family contribution is replaced:

SELECT formula_code, fund_id, min_award_amt, max_award_amt
  FROM igf_aw_awd_frml_det
 WHERE replace_fc = 'Y';

Auditing recently changed formula lines:

SELECT formula_code, fund_id, replace_fc,
       last_updated_by, last_update_date
  FROM igf_aw_awd_frml_det
 WHERE last_update_date >= SYSDATE - 30;

Joining to the calendar type and fund dimensions gives a complete picture of the award rule set, and any query run from a session without a valid client information value will only return rows whose ORG_ID resolves to the -99 sentinel; setting the client information correctly is therefore essential for reliable results.