Search Results cs_system_party_links




Overview
Explore in AI Chat

Overview

CS_SYSTEM_PARTY_LINKS is a Service (CS) module table in the Oracle E-Business Suite 12.1.1 and 12.2.2 environments. It establishes the association between an operational system record and the party (customer, contact, or organization) that the system serves. The table resides in the CS schema and is classified as a link table under a heuristic Data Vault modeling suggestion derived from its foreign key structure. As a link, it resolves many-to-many relationships between two business hubs: the party hub (HZ_PARTIES) and the system hub (CS_SYSTEMS_ALL_B). It carries only the keys, a surrogate identifier, and audit columns, allowing the CS module to represent which parties are bound to a given instance of installed base equipment or service system.

Key Information Stored

The table contains 12 documented columns. The most significant are:

Because no business columns beyond the two foreign keys and the date range exist, the table is a pure association link rather than a descriptive satellite.

Common Use Cases and Queries

Typical reporting scenarios include identifying all parties associated with a piece of service system, validating effective party-system relationships, and reconciling installed base data for service contracts. A representative query joining the link table to its hubs follows:

  • List parties for a given system:
    SELECT p.party_name, l.start_date, l.end_date
    FROM cs.cs_system_party_links l, hz_parties p
    WHERE l.party_id = p.party_id
    AND l.system_id = :system_id;
  • Retrieve all systems linked to a recognized customer:
    SELECT s.system_number, l.start_date
    FROM cs.cs_system_party_links l, cs.cs_systems_all_b s
    WHERE l.system_id = s.system_id
    AND l.party_id = :party_id;
  • Check active associations within a validity window by comparing SYSDATE against START_DATE and END_DATE.

These patterns support service dashboards, installed base analysis, and data migration validation between legacy and 12.2.2 instances.

Related Objects

  • HZ_PARTIES — Joined via CS_SYSTEM_PARTY_LINKS.PARTY_ID to HZ_PARTIES.PARTY_ID; supplies party identity and profile data.
  • CS_SYSTEMS_ALL_B — Joined via CS_SYSTEM_PARTY_LINKS.SYSTEM_ID to CS_SYSTEMS_ALL_B.SYSTEM_ID; supplies system/installed base records.
  • FND_SECURITY_GROUPS — Joined via SECURITY_GROUP_ID; governs row-level security and multi-org access.
  • CS_SYSTEMS_ALL_TL — Translation table commonly joined with CS_SYSTEMS_ALL_B to resolve system names for reporting.
  • HZ_CUST_ACCOUNTS and HZ_ORG_CONTACTS — Reference party context when the association must be resolved to a customer account or contact role.
  • CS_INCIDENTS_ALL and CS_SERVICE_REQUESTS — Service transaction tables that consume party-system links when locating the correct party for a system-related incident.

Together these objects form the service data model that connects customers, parties, and installed base systems within Oracle EBS 12.1.1 and 12.2.2.