Search Results igs_ad_relations_int_all_n1

Overview

IGS.IGS_AD_RELATIONS_INT_ALL is the Admission Import interface table that stages person-to-person relationship records prior to validation and loading into the Oracle E-Business Suite Trading Community and Student System person model. The table is owned by the IGS (Student Systems / Admission) product and is classified under the BUSINESS_ENTITY HZ_PERSON category, with FND Design Data registered as IGS.IGS_AD_RELATIONS_INT_ALL. Its documented status is VALID and its lifecycle is active in both 12.1.1 and 12.2.2.

Functionally, the table stores relationship details for each person to be imported. The Admission Import process consumes rows from this interface and creates corresponding records in IGS_PE_HZ_REL, HZ_PARTIES, HZ_PERSON_PROFILES, HZ_RELATIONSHIPS, IGS_PE_HZ_PARTIES, and IGS_PE_TYP_INSTANCES_ALL (with the default logic assigning an "OTHERS" person type). It is therefore a staging surface rather than a transactional master table; rows are transient and are purged or archived after import processing completes.

From a Data Vault modeling perspective, the mined foreign-key structure suggests a satellite-leaning classification. The table's grain is a single interface relationship record identified by INTERFACE_RELATIONS_ID, and much of its payload consists of descriptive person attributes associated with that grain rather than independent business entities. The reference to HZ_PARTIES through REL_PERSON_ID behaves as a link-to-hub style relationship, reinforcing the satellite interpretation.

Key Information Stored

The surrogate primary key is INTERFACE_RELATIONS_ID, backed by unique index IGS_AD_RELATIONS_INT_ALL_U1 on the same column. This is the only documented unique (business-key candidate) index; the remaining indexes are nonunique.

• INTERFACE_RELATIONS_ID — System-generated surrogate identifier and primary key for each staged relationship row.
• INTERFACE_ID — Groups relationship rows under a single import interface header; indexed by IGS_AD_RELATIONS_INT_ALL_N1.
• INTERFACE_RUN_ID — Identifies the specific import execution; indexed by IGS_AD_RELATIONS_INT_ALL_N4 for run-level processing and reconciliation.
• ORG_ID — Operating unit identifier supporting multi-org security in R12.
• RELATIONSHIP_CODE / RELATIONSHIP_TYPE / OTH_RELATIONSHIP_TYPE — Define the relationship between the two concerned parties. Documented values are pre-seeded under lookup type PARTY_RELATIONS_TYPE.
• SURNAME, GIVEN_NAMES, MIDDLE_NAME, TITLE, PRE_NAME_ADJUNCT, PREFERRED_GIVEN_NAME — Person name attributes used to create or match the related party.
• BIRTH_DT, SEX, DECEASED, DECEASED_DATE — Demographic attributes carried into HZ_PERSON_PROFILES.
• REL_PERSON_ID — Reference to HZ_PARTIES, anchoring the related person in the trading community model.
• STATUS / ERROR_CODE — Import processing state and failure diagnostics; STATUS is indexed by IGS_AD_RELATIONS_INT_ALL_N2 for exception reporting and reprocessing.
• PERSON_NUMBER / ACCOUNT_NUMBER — Business-facing identifiers used during matching and reconciliation.
• REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID — Concurrent program audit trail linking rows to the import request that populated them.

Note that RECIPROCAL_FLAG is documented as obsolete and should not be relied upon in new development.

Common Use Cases and Queries

Typical usage centers on monitoring and troubleshooting the Admission Import process, plus pre-import data quality review. A standard pattern selects failed rows for a given run:

SELECT r.INTERFACE_RELATIONS_ID, r.SURNAME, r.GIVEN_NAMES, r.RELATIONSHIP_CODE, r.ERROR_CODE
FROM IGS.IGS_AD_RELATIONS_INT_ALL r
WHERE r.STATUS = 'ERROR' AND r.INTERFACE_RUN_ID = :p_run_id;

Reconciliation between staged and loaded volumes is another frequent need, using INTERFACE_ID to group by logical batch and INTERFACE_RUN_ID to separate executions. Join to IGS_AD_RELADDR_INT_ALL, IGS_AD_RELEMP_INT_ALL, IGS_AD_RELACAD_INT_ALL, and IGS_AD_REL_CON_INT_ALL on INTERFACE_RELATIONS_ID to review the full relationship payload — addresses, employment, academic history, and contacts — in a single view. Near-match analysis joins IGS_AD_IMP_NEAR_MTCH_ALL to the same key. Exception dashboards group by STATUS, then by ERROR_CODE, to identify repetitive failures. Because the table resides in APPS_TS_INTERFACE, queries should be scoped carefully and typically run outside peak import windows.

Related Objects

• IGS.IGS_AD_RELADDR_INT_ALL — References this table via INTERFACE_RELATIONS_ID; holds relationship addresses.
• IGS.IGS_AD_RELEMP_INT_ALL — References via INTERFACE_RELATIONS_ID; employment details for the related person.
• IGS.IGS_AD_RELACAD_INT_ALL — References via INTERFACE_RELATIONS_ID; academic history details.
• IGS.IGS_AD_REL_CON_INT_ALL — References via INTERFACE_RELATIONS_ID; relationship contact information.
• IGS.IGS_AD_IMP_NEAR_MTCH_ALL — References via INTERFACE_RELATIONS_ID; stores near-match candidates for de-duplication.
• HZ_PARTIES — Referenced through REL_PERSON_ID; target of person creation and matching.
• HZ_RELATIONSHIPS — Target of relationship creation by the Admission Import process.
• HZ_PERSON_PROFILES — Target for demographic attributes such as BIRTH_DT and SEX.
• IGS_PE_HZ_PARTIES / IGS_PE_HZ_REL — Target person and relationship tables populated by the import.
• IGS_PE_TYP_INSTANCES_ALL — Populated with the default "OTHERS" person type during import.