Search Results show_on_bill




Overview
Explore in AI Chat

Overview

APPS.IGS_FI_PLN_CREDITS_V is a supplementary view in the Oracle Student System (also branded as Oracle Student Financials / Financial Aid) that exposes planned disbursement credit information for awards, person records, and related calendar instances. The ETRM metadata classifies the object as a VIEW owned by the APPS schema, with FND Design Data IGS.IGS_FI_PLN_CREDITS_V and a status of VALID. The documented view type annotation states that it is "a supplementary view used to simplify forms coding," accompanied by the standard Oracle caution that querying or altering data through this view is not recommended because its definition may change dramatically in subsequent minor or major releases.

In practice, the view serves as a reporting and integration surface for planned-versus-actual disbursement figures tied to a student's award and a billing cycle. Because it joins award, person, disbursement, fund, and calendar context into a single row shape, developers and report authors can use it to drive bill presentation logic, disbursement reconciliation, and financial aid notification reporting. The presence of standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) confirms that the underlying data is auditable and version-tracked.

Underlying Base Objects

The documented metadata does not enumerate the base tables over which IGS_FI_PLN_CREDITS_V is defined; ETRM records "none documented" for referenced base objects. This is typical for views that are layered over other IGS financial aid entities and whose definition is considered internal. Based on the column set, the view is anchored on award and person identifiers (AWARD_ID, PERSON_ID) combined with planned disbursement records (DISB_NUM, DISB_NET_AMT, DISB_DATE), calendar instance attributes (LD_CAL_TYPE, LD_SEQUENCE_NUMBER, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, START_DT, END_DT), and fund/accounting context (FUND_CODE, FUND_ID, SUBACCOUNT_ID, CREDIT_TYPE_ID).

The ROW_ID column exposes the underlying ROWID, which is useful for de-duplication and for correlating a view row back to its physical source row. Because the view is not documented as an updateable entity and carries the Oracle warning against direct modification, it should be treated strictly as a read-only reporting construct. Any changes to the underlying award or disbursement data must be made through the supported forms and APIs rather than through this view.

Key Columns

  • SHOW_ON_BILL (VARCHAR2(30)) — Indicates whether the notification associated with the planned credit should be shown on the bill. This is the column most directly relevant to the search term.
  • AWARD_ID / PERSON_ID — Identify the award record and the person for whom the planned disbursement applies.
  • DISB_NUM, DISB_NET_AMT, DISB_DATE — Disbursement number, net amount, and date; the comment for DISB_NUM notes it stores the award ID of the award record whose planned disbursement was considered for the bill.
  • TRANS_TYPE — Distinguishes planned from actual transactions, enabling planned-versus-actual comparison.
  • LD_CAL_TYPE, LD_SEQUENCE_NUMBER, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, START_DT, END_DT — Load and fee calendar context, including the effective start and end dates of the calendar instance.
  • FUND_CODE, FUND_ID, SUBACCOUNT_ID, CREDIT_TYPE_ID — Financial fund and credit classification attributes used for accounting and reporting.
  • WHO columns — Standard audit columns for created and last-updated metadata.

Common Use Cases and Queries

A primary use case is determining which planned disbursements should appear on a student's bill. The SHOW_ON_BILL flag supports filtering logic for billing presentation, while TRANS_TYPE allows separation of planned notifications from actual postings. A representative query follows:

SELECT AWARD_ID, PERSON_ID, DISB_NUM, DISB_NET_AMT, DISB_DATE, SHOW_ON_BILL, TRANS_TYPE
FROM APPS.IGS_FI_PLN_CREDITS_V
WHERE PERSON_ID = :p_person_id
AND SHOW_ON_BILL = 'Y';

Another common pattern aggregates planned credits by fund and calendar for reconciliation:

SELECT FUND_CODE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, SUM(DISB_NET_AMT) NET_PLANNED
FROM APPS.IGS_FI_PLN_CREDITS_V
WHERE TRANS_TYPE = 'PLANNED'
GROUP BY FUND_CODE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER;

Because the view may change between releases, consumers should confine usage to reporting and integration layers, avoid DML, and validate column semantics against the current IGS data model.