Search Results fn_address_line1




Overview
Explore in AI Chat

Overview

IGS_SV_EDT_FADDR_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the IGS (Student System) product family and is documented with the status VALID. Its stated purpose is to fetch US address information as part of the Student System's address verification and extraction processing, specifically the flow commonly associated with third-party address validation vendors.

The view presents a flattened, batch-scoped projection of a person's "F" type (foreign/US-style mailing) address, joined against the batch summary control table that governs which records are eligible for extraction. Because the view applies hard-coded filters on address type, tag code, administrative action code, and a null activity site, its result set is narrowed to records ready for outbound submission rather than exposing all stored addresses. This makes it a staging and reporting object rather than a general-purpose address lookup.

The user search term "fn_address_line1" maps directly to the view column FN_ADDRESS_LINE1, which is a renamed projection of the underlying FGN.ADDRESS_LINE1 column. The "FN_" prefix distinguishes the "first name/foreign normalized" address components surfaced by the view from their base-table equivalents.

Underlying Base Objects

The view text is defined over two base objects in the APPS schema:

  • IGS_SV_ADDRESSES (alias FGN) — the address detail table supplying address lines, city, province, postal code, and country code for the person and batch.
  • IGS_SV_BTCH_SUMMARY (alias FADDRSUMM) — the batch summary table supplying process control attributes such as TAG_CODE and ADM_ACTION_CODE.

The two objects are joined on BATCH_ID and PERSON_ID. The view additionally constrains the result set to ADDRESS_TYPE = 'F', TAG_CODE = 'SV_F_ADDR', ADM_ACTION_CODE = 'SEND', and ACTIVITY_SITE_CD IS NULL. The ETRM metadata for 12.2.2 records no formally documented referenced base objects, so the dependency above is derived from the embedded view definition. Because both base objects reside in the same APPS schema, the view requires no cross-schema grants or synonyms beyond the standard APPS access model.

Key Columns

  • BATCH_ID — Identifier of the Student System batch to which the address record belongs; primary correlation key.
  • PERSON_ID — Surrogate identifier of the person (student or applicant) owning the address.
  • FN_ADDRESS_LINE1 — First line of the address, mapped from ADDRESS_LINE1. This is the column targeted by the "fn_address_line1" search.
  • FN_ADDRESS_LINE2 — Second address line, mapped from ADDRESS_LINE2.
  • FN_CITY — City or locality.
  • FN_PROVINCE — State, province, or region.
  • FN_POSTAL_CODE — Postal or ZIP code.
  • FN_CNTRY_CODE — Country code, mapped from COUNTRY_CODE.

The FN_ aliasing provides a stable interface for downstream extraction routines and reports, insulating them from changes to the underlying IGS_SV_ADDRESSES column names.

Common Use Cases and Queries

Typical uses include confirming which addresses are queued for the SEND administrative action, reconciling batch contents before address validation runs, and supporting data extracts that require line-level address components for a specific person or batch.

Sample query for a single person across batches:

  • SELECT batch_id, person_id, fn_address_line1, fn_address_line2, fn_city, fn_province, fn_postal_code, fn_cntry_code FROM apps.igs_sv_edt_faddr_v WHERE person_id = :p_person_id;

Sample query to list all pending addresses in a batch:

  • SELECT person_id, fn_address_line1, fn_city, fn_postal_code FROM apps.igs_sv_edt_faddr_v WHERE batch_id = :p_batch_id ORDER BY person_id;

Because the view already enforces ADDRESS_TYPE = 'F' and the SEND action filter, callers should not expect to retrieve non-foreign address types or records still pending alternate administrative actions. Where additional address detail or non-batch addresses are required, querying IGS_SV_ADDRESSES directly is necessary.