Search Results csc_cust_plans

Overview

The CSC_CUST_PLANS table is a core data object within the Oracle E-Business Suite Customer Care (CSC) module. It functions as the central repository for managing associations between customers and service plans. This table is essential for defining which service plans are assigned to specific customers or customer accounts, enabling the tracking and management of service entitlements, support levels, and contractual service agreements. Its role is to establish and maintain the foundational relationship between the customer entity and the plan definition, which drives service delivery and support processes throughout the application.

Key Information Stored

The table's primary purpose is to store the linkage between a customer and a plan. The most critical columns, as indicated by its foreign key relationships, are the identifiers for these linked entities. The CUST_PLAN_ID column serves as the table's unique primary key. The PLAN_ID column stores the reference to a specific service plan definition held in the CSC_PLAN_HEADERS_B table. To associate this plan with a customer, the table uses two key identifiers: PARTY_ID, which links to the fundamental party definition in HZ_PARTIES, and CUST_ACCOUNT_ID, which links to the specific customer account in HZ_CUST_ACCOUNTS. This structure allows for plan assignments at both the overarching party level and the more specific account level.

Common Use Cases and Queries

A primary use case is generating reports to list all service plans assigned to a particular customer account, which is vital for customer support and contract management. Administrators frequently query this table to audit plan coverage or validate service entitlements when processing service requests. A common SQL pattern involves joining to the related tables to retrieve meaningful names and details. For example, to list all plans for a customer account, a query would join CSC_CUST_PLANS (CCP) to CSC_PLAN_HEADERS_B (CPH) for the plan name and to HZ_CUST_ACCOUNTS (HCA) for the account number, filtering on the specific CUST_ACCOUNT_ID or account number. Another critical use case is during the service request creation process, where the application likely references this table to determine the valid plans and associated service level agreements (SLAs) applicable to the customer.

Related Objects

The CSC_CUST_PLANS table maintains defined foreign key relationships with several fundamental EBS tables, as documented in the provided metadata:

• CSC_PLAN_HEADERS_B: Joined via CSC_CUST_PLANS.PLAN_ID. This is the master table for service plan definitions, containing the plan's name, type, and operational rules.
• HZ_PARTIES: Joined via CSC_CUST_PLANS.PARTY_ID. This Trading Community Architecture (TCA) table stores the universal entity definition for any organization or person.
• HZ_CUST_ACCOUNTS: Joined via CSC_CUST_PLANS.CUST_ACCOUNT_ID. This TCA table defines specific customer accounts belonging to a party, which are used in Order Management and Service transactions.

These relationships ensure data integrity and are crucial for any query or integration that requires detailed customer or plan information alongside the association record.