Search Results cs_hz_sr_contact_points

Overview

CS_HZ_SR_CONTACT_POINTS is a table owned by the CS (Service) schema in Oracle E-Business Suite and is documented as VALID in both 12.1.1 and 12.2.2. Its purpose is to store the contact points associated with a service request, effectively serving as the intersection between a service request (incident) and the parties and contact mechanisms through which the requester may be reached. Each row links a specific party to a specific incident and, optionally, to a particular contact point record in the Trading Community Architecture (TCA) model.

From a Data Vault modeling perspective, the metadata heuristic suggests a satellite-leaning classification. The table carries descriptive and state attributes (flags, active date ranges, audit columns) around the relationship between an incident and a party, rather than acting purely as a hub of unique business entities. Modelers should treat it as a candidate satellite or dependent link attached to the incident and party hubs when designing downstream analytical or integration models.

Key Information Stored

The table comprises 21 documented columns. The most significant are summarized below.

SR_CONTACT_POINT_ID — The surrogate primary key of the table, backed by unique index CS_HZ_SR_CP_PK. A second unique index, CS_HZ_SR_CONTACT_POINTS_U2, is also defined on this column, reinforcing its role as the single-row identifier.
PARTY_ID and INCIDENT_ID — Together these form the unique business key CS_HZ_SR_CONTACT_POINTS_UK1, meaning a given party may appear only once per service request. PARTY_ID references HZ_PARTIES, and INCIDENT_ID references CS_INCIDENTS_ALL_B.
CONTACT_POINT_ID — References HZ_CONTACT_POINTS, identifying the specific TCA contact mechanism (for example, phone, email, or fax) recorded for the party on the service request.
CONTACT_POINT_TYPE and CONTACT_TYPE — Classify the contact point and the nature of the contact relationship.
PARTY_ROLE_CODE — References CS_PARTY_ROLES_B, describing the role the party plays relative to the incident, such as requester, owner, or affected party.
PRIMARY_FLAG — Indicates whether the contact point is the primary one for the service request.
START_DATE_ACTIVE and END_DATE_ACTIVE — Define the active date window during which the contact point association is valid.
OBJECT_VERSION_NUMBER — Supports optimistic locking for concurrent updates.
SECURITY_GROUP_ID — References FND_SECURITY_GROUPS and enforces multi-tenant data separation.
Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, and the concurrent program columns REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE capture standard EBS audit and program context.

Common Use Cases and Queries

This table is most frequently queried to retrieve the parties and contact methods attached to a service request, to identify the primary contact, and to reconcile service request activity with TCA contact data.

Listing contacts for a given incident: SELECT p.party_id, p.contact_point_id, c.contact_point_type FROM cs_hz_sr_contact_points c, hz_parties p WHERE c.incident_id = :incident_id AND c.party_id = p.party_id;
Identifying the primary contact for a service request using PRIMARY_FLAG and the active date window.
Reporting on the roles played by parties across incidents by joining PARTY_ROLE_CODE to CS_PARTY_ROLES_B.
Auditing changes over time through the companion audit table CS_HZ_SR_CONTACT_PNTS_AUDIT, which stores historical rows keyed by SR_CONTACT_POINT_ID.
Determining the designated contact on the incident header via CS_INCIDENTS_ALL_B.PRIMARY_CONTACT_ID, which points back to this table.

Related Objects

The following objects are most significant in relation to CS_HZ_SR_CONTACT_POINTS.

CS_INCIDENTS_ALL_B — Referenced through INCIDENT_ID, and it in turn references this table via PRIMARY_CONTACT_ID, forming a bidirectional relationship.
HZ_PARTIES — Referenced through PARTY_ID, supplying party identity details.
HZ_CONTACT_POINTS — Referenced through CONTACT_POINT_ID, providing the actual TCA contact mechanism.
CS_PARTY_ROLES_B — Referenced through PARTY_ROLE_CODE, defining valid party roles.
FND_SECURITY_GROUPS — Referenced through SECURITY_GROUP_ID for multi-tenant security.
CS_HZ_SR_CONTACT_PNTS_AUDIT — The audit shadow table, keyed by SR_CONTACT_POINT_ID, capturing historical changes to contact point associations.

Table: CS_HZ_SR_CONTACT_POINTS 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_HZ_SR_CONTACT_POINTS, object_name:CS_HZ_SR_CONTACT_POINTS, status:VALID, product: CS - Service , description: This table stores contact points for a service requests. , implementation_dba_data: CS.CS_HZ_SR_CONTACT_POINTS ,
Table: CS_HZ_SR_CONTACT_POINTS 12.2.2
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_HZ_SR_CONTACT_POINTS, object_name:CS_HZ_SR_CONTACT_POINTS, status:VALID, product: CS - Service , description: This table stores contact points for a service requests. , implementation_dba_data: CS.CS_HZ_SR_CONTACT_POINTS ,
View: CS_HZ_SR_CONTACT_POINTS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_HZ_SR_CONTACT_POINTS_V, object_name:CS_HZ_SR_CONTACT_POINTS_V, status:VALID, product: CS - Service , description: This view is created for backward compatibility for CS_HZ_SR_CONTACT_POINTS table. , implementation_dba_data: APPS.CS_HZ_SR_CONTACT_POINTS_V ,
View: CS_HZ_SR_CONTACT_POINTS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_HZ_SR_CONTACT_POINTS_V, object_name:CS_HZ_SR_CONTACT_POINTS_V, status:VALID, product: CS - Service , description: This view is created for backward compatibility for CS_HZ_SR_CONTACT_POINTS table. , implementation_dba_data: APPS.CS_HZ_SR_CONTACT_POINTS_V ,
View: CS_SR_CONTACT_DETAILS_V 12.2.2
product: CS - Service , description: This view obtains the contact information such as Job Title, Address etc. for each of the contacts pertaining to a service request depending on the Caller Type i,e. ORGANIZATION / PERSON. , implementation_dba_data: Not implemented in this database ,
View: CS_SR_CONTACT_DETAILS_V 12.1.1
product: CS - Service , description: This view obtains the contact information such as Job Title, Address etc. for each of the contacts pertaining to a service request depending on the Caller Type i,e. ORGANIZATION / PERSON. , implementation_dba_data: Not implemented in this database ,
View: CS_SR_CONTACT_POINTS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_SR_CONTACT_POINTS_V, object_name:CS_SR_CONTACT_POINTS_V, status:VALID, product: CS - Service , description: This view corresponds to the contact point type information such as PHONE/FAX/EMAIL & numbers of the individual contacts. , implementation_dba_data: APPS.CS_SR_CONTACT_POINTS_V ,
View: CS_SR_CONTACT_POINTS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_SR_CONTACT_POINTS_V, object_name:CS_SR_CONTACT_POINTS_V, status:VALID, product: CS - Service , description: This view corresponds to the contact point type information such as PHONE/FAX/EMAIL & numbers of the individual contacts. , implementation_dba_data: APPS.CS_SR_CONTACT_POINTS_V ,
Table: CS_HZ_SR_CONTACT_PNTS_AUDIT 12.2.2
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_HZ_SR_CONTACT_PNTS_AUDIT, object_name:CS_HZ_SR_CONTACT_PNTS_AUDIT, status:VALID, product: CS - Service , description: To maintain audit history for service request party role information. , implementation_dba_data: CS.CS_HZ_SR_CONTACT_PNTS_AUDIT ,
Table: CS_HZ_SR_CONTACT_PNTS_AUDIT 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_HZ_SR_CONTACT_PNTS_AUDIT, object_name:CS_HZ_SR_CONTACT_PNTS_AUDIT, status:VALID, product: CS - Service , description: To maintain audit history for service request party role information. , implementation_dba_data: CS.CS_HZ_SR_CONTACT_PNTS_AUDIT ,
Table: CS_PARTY_ROLES_B 12.2.2
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_PARTY_ROLES_B, object_name:CS_PARTY_ROLES_B, status:VALID, product: CS - Service , description: This is the base table for storing all the party role definitions. , implementation_dba_data: CS.CS_PARTY_ROLES_B ,
Table: CS_PARTY_ROLES_B 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_PARTY_ROLES_B, object_name:CS_PARTY_ROLES_B, status:VALID, product: CS - Service , description: This is the base table for storing all the party role definitions. , implementation_dba_data: CS.CS_PARTY_ROLES_B ,
Table: CS_INCIDENTS_ALL_B 12.2.2
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_INCIDENTS_ALL_B, object_name:CS_INCIDENTS_ALL_B, status:VALID, product: CS - Service , description: This table stores non-translated information about service requests. , implementation_dba_data: CS.CS_INCIDENTS_ALL_B ,
Table: CS_INCIDENTS_ALL_B 12.1.1
owner:CS, object_type:TABLE, fnd_design_data:CS.CS_INCIDENTS_ALL_B, object_name:CS_INCIDENTS_ALL_B, status:VALID, product: CS - Service , description: This table stores non-translated information about service requests. , implementation_dba_data: CS.CS_INCIDENTS_ALL_B ,
View: CS_NEW_INCIDENTS_V_SEC 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_NEW_INCIDENTS_V_SEC, object_name:CS_NEW_INCIDENTS_V_SEC, status:VALID, product: CS - Service , description: This is a secured view created on top of the view CS_NEW_INCIDENTS_V , implementation_dba_data: APPS.CS_NEW_INCIDENTS_V_SEC ,
View: CS_NEW_INCIDENTS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_NEW_INCIDENTS_V, object_name:CS_NEW_INCIDENTS_V, status:VALID, product: CS - Service , description: This is a simplified version of view CS_INCIDENTS_V , implementation_dba_data: APPS.CS_NEW_INCIDENTS_V ,
View: CS_NEW_INCIDENTS_V_SEC 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_NEW_INCIDENTS_V_SEC, object_name:CS_NEW_INCIDENTS_V_SEC, status:VALID, product: CS - Service , description: This is a secured view created on top of the view CS_NEW_INCIDENTS_V , implementation_dba_data: APPS.CS_NEW_INCIDENTS_V_SEC ,
View: CS_NEW_INCIDENTS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_NEW_INCIDENTS_V, object_name:CS_NEW_INCIDENTS_V, status:VALID, product: CS - Service , description: This is a simplified version of view CS_INCIDENTS_V , implementation_dba_data: APPS.CS_NEW_INCIDENTS_V ,
View: CS_SR_UWQ_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_SR_UWQ_V, object_name:CS_SR_UWQ_V, status:VALID, product: CS - Service , description: This view is used by the UWQ (Universal Work Queue) to query up Service Requests against the user logged in. The view is a snapshot of information like Status, Severity, Escalation. , implementation_dba_data: APPS.CS_SR_UWQ_V ,
View: CS_SR_UWQ_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_SR_UWQ_V, object_name:CS_SR_UWQ_V, status:VALID, product: CS - Service , description: This view is used by the UWQ (Universal Work Queue) to query up Service Requests against the user logged in. The view is a snapshot of information like Status, Severity, Escalation. , implementation_dba_data: APPS.CS_SR_UWQ_V ,
View: CS_SR_UWQ_UNOWNED_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_SR_UWQ_UNOWNED_V, object_name:CS_SR_UWQ_UNOWNED_V, status:VALID, product: CS - Service , description: This view is used by the UWQ (Universal Work Queue) to query up Service Requests that are not owned. The view is a snapshot of information like Status, Severity, Escalation. , implementation_dba_data: APPS.CS_SR_UWQ_UNOWNED_V ,
View: CS_SR_UWQ_UNOWNED_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_SR_UWQ_UNOWNED_V, object_name:CS_SR_UWQ_UNOWNED_V, status:VALID, product: CS - Service , description: This view is used by the UWQ (Universal Work Queue) to query up Service Requests that are not owned. The view is a snapshot of information like Status, Severity, Escalation. , implementation_dba_data: APPS.CS_SR_UWQ_UNOWNED_V ,
View: CS_SR_INCIDENTS_V_SEC 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_SR_INCIDENTS_V_SEC, object_name:CS_SR_INCIDENTS_V_SEC, status:VALID, product: CS - Service , description: Base view for SR main form. , implementation_dba_data: APPS.CS_SR_INCIDENTS_V_SEC ,
View: CS_SR_INCIDENTS_V_SEC 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_SR_INCIDENTS_V_SEC, object_name:CS_SR_INCIDENTS_V_SEC, status:VALID, product: CS - Service , description: Base view for SR main form. , implementation_dba_data: APPS.CS_SR_INCIDENTS_V_SEC ,
View: CS_SR_INCIDENTS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_SR_INCIDENTS_V, object_name:CS_SR_INCIDENTS_V, status:VALID, product: CS - Service , description: Base view for SR main form. , implementation_dba_data: APPS.CS_SR_INCIDENTS_V ,
View: CS_SR_INCIDENTS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_SR_INCIDENTS_V, object_name:CS_SR_INCIDENTS_V, status:VALID, product: CS - Service , description: Base view for SR main form. , implementation_dba_data: APPS.CS_SR_INCIDENTS_V ,
View: CS_SR_SEARCH_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_SR_SEARCH_V, object_name:CS_SR_SEARCH_V, status:VALID, product: CS - Service , description: This view is used in the SR find window on Bali spread table , implementation_dba_data: APPS.CS_SR_SEARCH_V ,
View: CS_SR_SEARCH_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_SR_SEARCH_V, object_name:CS_SR_SEARCH_V, status:VALID, product: CS - Service , description: This view is used in the SR find window on Bali spread table , implementation_dba_data: APPS.CS_SR_SEARCH_V ,
View: CS_SR_UWQ_TEAM_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_SR_UWQ_TEAM_V, object_name:CS_SR_UWQ_TEAM_V, status:VALID, product: CS - Service , description: This view is used by the UWQ (Universal Work Queue) to query up Service Requests against the user logged in. The view is a snapshot of information like Status, Severity, Escalation. , implementation_dba_data: APPS.CS_SR_UWQ_TEAM_V ,
View: CS_INCIDENTS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_INCIDENTS_V, object_name:CS_INCIDENTS_V, status:VALID, product: CS - Service , description: Service requests and their attributes. This view is used by the main service request form. , implementation_dba_data: APPS.CS_INCIDENTS_V ,
View: CS_SR_UWQ_TEAM_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_SR_UWQ_TEAM_V, object_name:CS_SR_UWQ_TEAM_V, status:VALID, product: CS - Service , description: This view is used by the UWQ (Universal Work Queue) to query up Service Requests against the user logged in. The view is a snapshot of information like Status, Severity, Escalation. , implementation_dba_data: APPS.CS_SR_UWQ_TEAM_V ,
View: CS_INCIDENTS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_INCIDENTS_V, object_name:CS_INCIDENTS_V, status:VALID, product: CS - Service , description: Service requests and their attributes. This view is used by the main service request form. , implementation_dba_data: APPS.CS_INCIDENTS_V ,
View: CS_SR_UWQ_GROUP_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_SR_UWQ_GROUP_V, object_name:CS_SR_UWQ_GROUP_V, status:VALID, product: CS - Service , description: This view is used by the UWQ (Universal Work Queue) to query up Service Requests against the user logged in. The view is a snapshot of information like Status, Severity, Escalation. , implementation_dba_data: APPS.CS_SR_UWQ_GROUP_V ,
View: CS_SR_UWQ_GROUP_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_SR_UWQ_GROUP_V, object_name:CS_SR_UWQ_GROUP_V, status:VALID, product: CS - Service , description: This view is used by the UWQ (Universal Work Queue) to query up Service Requests against the user logged in. The view is a snapshot of information like Status, Severity, Escalation. , implementation_dba_data: APPS.CS_SR_UWQ_GROUP_V ,
View: CS_SR_UWQ_EMPLOYEE_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_SR_UWQ_EMPLOYEE_V, object_name:CS_SR_UWQ_EMPLOYEE_V, status:VALID, product: CS - Service , description: This view is used by the UWQ (Universal Work Queue) to query up Service Requests against the user logged in. The view is a snapshot of information like Status, Severity, Escalation. , implementation_dba_data: APPS.CS_SR_UWQ_EMPLOYEE_V ,
View: CS_SR_UWQ_EMPLOYEE_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CS.CS_SR_UWQ_EMPLOYEE_V, object_name:CS_SR_UWQ_EMPLOYEE_V, status:VALID, product: CS - Service , description: This view is used by the UWQ (Universal Work Queue) to query up Service Requests against the user logged in. The view is a snapshot of information like Status, Severity, Escalation. , implementation_dba_data: APPS.CS_SR_UWQ_EMPLOYEE_V ,