Search Results rel_party_id

Overview

IGS_OR_CONTACTS_V is a reporting and integration view belonging to the Oracle E-Business Suite product family IGS (Student System), which is documented in ETRM as obsolete. The view describes institution contact details, presenting a consolidated, denormalized picture of the relationships between persons, parties, and organizational contacts held in the Oracle Trading Community Architecture (TCA) model. In practice, it acts as a convenience layer that joins person base information, HZ relationship rows, and HZ organizational contact rows so that downstream reports, interfaces, and legacy forms can retrieve contact details through a single object rather than assembling the underlying joins manually.

The view is documented in ETRM 12.1.1 and 12.2.2 metadata, but the metadata explicitly states "Not implemented in this database," meaning it may or may not exist in a given environment depending on whether the Student System product is installed and whether the view was deployed. Reports or concurrent programs that reference it will fail if the object is absent.

Underlying Base Objects

The ETRM metadata records no formally documented base objects. However, the view text exposes its actual dependencies. It is defined over four sources:

• IGS_PE_PERSON_BASE_V — an IGS person base view supplying PERSON_ID, PERSON_NUMBER, and FULL_NAME.
• HZ_RELATIONSHIPS — TCA relationship rows, filtered to DIRECTIONAL_FLAG = 'F' and RELATIONSHIP_TYPE = 'CONTACT'.
• HZ_ORG_CONTACTS — the organizational contact records holding title, mail stop, contact number, and descriptive flexfield attributes.
• HZ_PARTIES — aliased REL_PARTY, providing the related party's email address.

The join chain links ORG_CONT.PARTY_RELATIONSHIP_ID to REL.RELATIONSHIP_ID, REL.SUBJECT_ID to the person, and REL.OBJECT_ID to REL_PARTY.PARTY_ID, with both subject and object table names constrained to HZ_PARTIES.

Key Columns

Several columns are literal NULLs and carry no data. CONTACT_ID, ORIG_SYSTEM_REFERENCE, TITLE_MEANING, PRIMARY_ROLE, and ORG_ROLE_OVN are all defined as TO_NUMBER(NULL) or NULL. The searched term "title_meaning" maps directly to the TITLE_MEANING column, which is a null placeholder rather than a populated lookup value; the actual title text is carried in the TITLE column sourced from ORG_CONT.TITLE.

Populated columns include ROW_ID (from HZ_RELATIONSHIPS), REL_PARTY_ID, STATUS, PERSON_NUMBER, FULL_NAME, TITLE, MAIL_STOP, CONTACT_NUMBER, EMAIL_ADDRESS, the ATTRIBUTE1 through ATTRIBUTE24 descriptive flexfield columns, REFERENCE_USE_FLAG, and the audit and object version columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REL_OVN, REL_PARTY_OVN, ORG_CONT_OVN). The columns ORG_CONTACT_ID, RELATIONSHIP_ID, and ORG_PARTY_ID provide the primary key components for the underlying records.

Common Use Cases and Queries

The view is typically used to list institutional contacts for an organization, display titles and mail stops, or extract contact details for integrations. A representative query is:

• SELECT person_number, full_name, title, mail_stop, contact_number, email_address FROM igs_or_contacts_v WHERE status = 'A';
• SELECT org_party_id, full_name, title FROM igs_or_contacts_v WHERE org_contact_id = :p_contact_id;
• SELECT * FROM igs_or_contacts_v WHERE title LIKE 'Dean%';

Because TITLE_MEANING, CONTACT_ID, and PRIMARY_ROLE are null placeholders, queries relying on them return no values. Consumers should validate the view's existence before use in any 12.1.1 or 12.2.2 instance.