Search Results get_per_addr_for_corr




Overview
Explore in AI Chat

Overview

IGF_SL_DISB_LTR_V is a Financial Aid (IGF) module view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is a correspondence-oriented projection that consolidates party-level address and biographical attributes with loan disbursement details for the purpose of generating student loan correspondence letters. The view is flagged as VALID and is documented as storing "persons loan details used for correspondence."

The object is not a base transaction table; it is a read-only reporting and integration construct. Its primary consumers are concurrent programs, letter generation routines, and reporting extracts that must produce formatted disbursement notices, award-year summaries, or borrower correspondence for financial aid recipients. Notably, the user search term "get_per_addr_for_corr" corresponds directly to a function invoked inside this view, indicating that a common reason for searching this object is to trace how the formatted correspondence address is derived.

Underlying Base Objects

The view is defined over the TCA party model plus IGF person and award/disbursement tables. The principal documented sources in the view text are:

Key Columns

  • PARTY_ID, PARTY_NAME, PARTY_NUMBER, PARTY_TYPE — identity of the correspondence recipient.
  • ADDRESS1–ADDRESS4, CITY, STATE, PROVINCE, COUNTY, COUNTRY, POSTAL_CODE — address components flattened from HZ_PARTIES.
  • GET_PER_ADDR_FOR_CORR(PARTY_ID) — the unaliased result of the correspondence-address function, returning the mailing address formatted specifically for correspondence. This is the column most relevant to the search term.
  • API_PERSON_ID — the IGF person identifier used in joining and in the generated letter reference string.
  • AWARD_YEAR — derived via IGF_GR_GEN.GET_CALENDAR_DESC(CI_CAL_TYPE, CI_SEQUENCE_NUMBER).
  • CI_CAL_TYPE, CI_SEQUENCE_NUMBER, ALTERNATE_CODE — award calendar identification.
  • Letter reference literal — 'DB/'||API_PERSON_ID||TO_CHAR(SYSDATE,'/MM/DD/YYYY'), a disbursement letter key.
  • FMAST.DESCRIPTION — award description.
  • SUM(DISB.DISB_GROSS_AMT) — aggregated gross disbursement amount.
  • TO_CHAR(DISB.DISB_DATE,'DD-MON-YYYY') — formatted disbursement date.
  • SYSDATE formatted literal — the correspondence run date.

Common Use Cases and Queries

The view supports letter generation, disbursement reconciliation, and address-verification reporting. A typical query returns a single borrower with correspondence address and disbursement totals:

SELECT party_id,
       party_name,
       get_per_addr_for_corr(party_id) AS corr_addr,
       award_year,
       SUM(disb_gross_amt) AS total_disb
FROM   apps.igf_sl_disb_ltr_v
WHERE  party_number = :p_party_number
GROUP  BY party_id, party_name, award_year;

To audit correspondence addresses across a population, query the address columns alongside the function output and filter on DO_NOT_MAIL_FLAG or STATUS. Because the view aggregates disbursements, callers should anticipate GROUP BY semantics and validate that joined award calendars do not multiply rows. Restricting by CI_CAL_TYPE, CI_SEQUENCE_NUMBER, or the formatted disbursement date improves performance on large aid populations.