Search Results addr_usage

Overview

The IGS.IGR_IS_ADDRESS table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Institutional Grants (IGS) product family. Its primary role is to serve as a staging table for self-service address data related to inquiry persons. As indicated by its storage in the APPS_TS_INTERFACE tablespace, it functions as a temporary holding area for address information entered through self-service interfaces before this data is potentially validated, processed, and transferred to permanent master tables. This design supports data integrity and manages the flow of information from user entry points into the core application tables.

Key Information Stored

The table stores comprehensive address details for individuals identified as inquiries. The structure is centered on the unique identifier, INQ_ADDR_ID, which is enforced by the primary key index IGR_IS_ADDRESS_PK. The key columns include:

• INQ_ADDR_ID: A mandatory, unique numeric identifier for each address record.
• INQ_PERSON_ID: Links the address to a specific inquiry person, referencing the IGR_IS_PER_ALL table.
• ADDR_USAGE: Defines the purpose of the address (e.g., Home, Mailing, Billing).
• Standard address components: ADDR_LINE_1-4, CITY, STATE, COUNTY, PROVINCE, COUNTRY, and POSTCODE.
• START_DATE and END_DATE: Manage the temporal validity of the address record.
• STATUS: Indicates the current processing state of the staged address data.
• Standard WHO columns (CREATED_BY, CREATION_DATE, etc.) for auditing and concurrent program tracking.

Common Use Cases and Queries

A primary use case is retrieving all active staged addresses for a specific inquiry person to support data review or integration processes. The foreign key relationship on INQ_PERSON_ID is central to this operation. A typical query pattern involves joining to the person table and filtering by status and date validity.

Sample Query: To find current mailing addresses for an inquiry person with ID 1001:
SELECT addr_line_1, city, state, country, postcode
FROM igs.igr_is_address
WHERE inq_person_id = 1001
AND addr_usage = 'MAILING'
AND status = 'ACTIVE'
AND TRUNC(SYSDATE) BETWEEN NVL(start_date, TRUNC(SYSDATE)) AND NVL(end_date, TRUNC(SYSDATE));

Reporting use cases often involve auditing data entry or analyzing the geographic distribution of inquiries by joining address data with related person information from IGR_IS_PER_ALL.

Related Objects

The table has a direct and documented foreign key relationship, establishing its dependency within the IGS schema.

• TABLE: IGS.IGR_IS_PER_ALL: This is the primary related object. The column IGR_IS_ADDRESS.INQ_PERSON_ID is a foreign key that references the IGR_IS_PER_ALL table. This relationship ensures that every address record in the staging table is associated with a valid inquiry person record, maintaining referential integrity. Joins between these tables are performed on the INQ_PERSON_ID column.