Results for “igs_ad_addr_int”
26 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The IGS_AD_ADDR_INT view belongs to the IGS (Student System) product family, which is documented as obsolete in Oracle EBS 12.1.1 and 12.2.2. In the ETRM reference for release 12.2.2, this object is explicitly listed as "Not implemented in this database," meaning it is a legacy metadata artifact retained for documentation and migration auditing rather than an active runtime object. The view presents address interface data — the staging records that were historically loaded into Oracle's party and location infrastructure through the customer or student data import process. Its role in reporting and integration was to expose inbound address rows, their validation status, and any error codes produced during import, before those rows were promoted into the base party/site tables.
Users searching for the column token other_details_2 encounter this view because that column appears in the documented SELECT text, but practitioners should note that the view is not instantiated in the current database, so any reference to it in custom code will fail at runtime.
Underlying Base Objects
The documented view text selects from a single underlying object: IGS_AD_ADDR_INT_ALL. The _ALL suffix indicates that the interface table was partitioned or filtered by ORG_ID to support multi-organization (operating unit) security. ETRM metadata lists no other dependent objects, which is consistent with a thin interface view whose purpose was to apply the organization security predicate on top of the staging table.
Because the base interface table carries the full set of address attributes plus TCA-style interface columns (MATCH_IND, STATUS, ERROR_CODE, REQUEST_ID, PROGRAM_ID), the view behaves as a pass-through projection. It does not denormalize, aggregate, or join to lookup tables; it simply restricts rows by operating unit and renames ROWID as ROW_ID for downstream identification.
Key Columns
INTERFACE_ADDR_ID/INTERFACE_ID— surrogate and batch identifiers for each staged address record.ADDR_LINE_1throughADDR_LINE_4— free-text address lines.POSTCODE,CITY,STATE,COUNTY,PROVINCE,COUNTRY— geographic components.OTHER_DETAILS,OTHER_DETAILS_1,OTHER_DETAILS_2,OTHER_DETAILS_3— generic overflow fields used to carry locale-specific or institution-specific address attributes that had no dedicated column.OTHER_DETAILS_2is the third of these slots in positional order.DELIVERY_POINT_CODE— postal delivery point reference.CORRESPONDENCE_FLAG— indicates whether the address is used for correspondence.START_DATE/END_DATE— validity window for the address.MATCH_IND— matching outcome during import processing.STATUS,ERROR_CODE— import processing state and validation failure reason.ORG_ID— operating unit used for security filtering.CONTACT_PERSON_ID,DUP_PARTY_SITE_ID,DATE_LAST_VERIFIED— party/site linkage and de-duplication attributes.- Audit columns —
CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,REQUEST_ID,PROGRAM_ID,PROGRAM_APPLICATION_ID,PROGRAM_UPDATE_DATE.
Common Use Cases and Queries
The classic use case was monitoring an inbound address import batch, checking which rows failed validation, and inspecting the overflow columns such as OTHER_DETAILS_2 that carried non-standard attributes. A representative query would be:
SELECT INTERFACE_ADDR_ID, STATUS, ERROR_CODE, OTHER_DETAILS_2 FROM IGS_AD_ADDR_INT WHERE STATUS = 'ERROR';SELECT ORG_ID, COUNT(*) FROM IGS_AD_ADDR_INT GROUP BY ORG_ID;SELECT INTERFACE_ID, MATCH_IND, CONTACT_PERSON_ID FROM IGS_AD_ADDR_INT WHERE REQUEST_ID = :request_id;
Given the "Not implemented" designation, these queries are only meaningful against an environment where the underlying IGS_AD_ADDR_INT_ALL table still exists. In current 12.1.1 and 12.2.2 instances, equivalent functionality is provided by the TCA interface tables (for example HZ_IMP_ADDRESSES_TBL and related HZ_IMP_* objects). Consultants should reference this view only for historical or migration documentation, and should not build new dependencies on it.
-
View: IGS_AD_ADDR_INT 12.1.1
APPS.IGS_AD_ADDR_INT·↳ IGS_AD_ADDR_INT_ALL·Explore IGS module →
-
VIEW: APPS.IGS_AD_ADDR_INT 12.1.1
-
View: IGS_AD_ADDR_INT 12.2.2
Not implemented in this database·Explore IGS module →
-
Gets the person details for the import process from the interface tables
APPS.IGS_AD_IMP_MATCHES_PA_V·↳ IGS_AD_ADDRUSAGE_INT·↳ IGS_AD_ADDR_INT·↳ IGS_AD_INTERFACE·Explore IGS module →
-
Gets the person details for the import process from the interface and person address tables
APPS.IGS_AD_IMP_MATCHES_PPA_V·↳ IGS_AD_ADDRUSAGE_INT·↳ IGS_AD_ADDR_INT·↳ IGS_AD_API_INT·Explore IGS module →
-
Gets the person details for the import process from the interface tables
Not implemented in this database·Explore IGS module →
-
Gets the person details for the import process from the interface and person address tables
Not implemented in this database·Explore IGS module →
-
PACKAGE: APPS.IGR_IMP_001 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.