Results for “cs_customer_products_all”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CS_CUSTOMER_PRODUCTS_ALL is the core table in the Oracle E-Business Suite Service (CS) module that stores customer installed base product information. Each row represents an instance of a product or item that a customer owns, has purchased, or has had installed at a specific site. This table serves as the authoritative registry of the customer's installed assets and is central to service operations such as incident management, depot repair, entitlement verification, and service contract fulfillment.

In Oracle EBS 12.1.1 and 12.2.2, the table underpins the Customer Products (also called Installed Base) functionality accessed through the Service responsibility. It supports hierarchical product configurations, versioning through revisions, and status tracking across the product lifecycle. The table is not implemented in every database; its presence depends on whether the Service module's Installed Base feature set has been licensed and configured.

From a Data Vault modeling perspective, the mined foreign key structure suggests a satellite-leaning classification. The table is anchored by a surrogate primary key and carries numerous descriptive attributes plus foreign keys to hub-like entities (customers, sites, inventory items, systems), which is characteristic of a satellite surrounding a central business key rather than a pure hub or link.

Key Information Stored

The primary key is CUSTOMER_PRODUCT_ID, enforced through the CS_CUSTOMER_PRODUCTS_PK constraint. This surrogate key uniquely identifies each installed base record and is the column referenced by nearly all dependent child tables. Business-key candidates include combinations of CUSTOMER_ID, MIB_INVENTORY_ITEM_ID, MIB_ORGANIZATION_ID, and MIB_REVISION_ID, though no separate unique index is documented in the provided metadata.

The most significant columns fall into several categories:

• Customer identification: CUSTOMER_ID references HZ_CUST_ACCOUNTS; INSTALL_SITE_USE_ID, SHIP_TO_SITE_USE_ID, and BILL_TO_SITE_USE_ID link to HZ_PARTY_SITES and HZ_CUST_ACCT_SITES_ALL to record installation, shipping, and billing locations.
• Product/item identity: MIB_INVENTORY_ITEM_ID, MIB_ORGANIZATION_ID, and MIB_REVISION_ID reference MTL_ITEM_REVISIONS_B, defining the exact inventory item and revision installed.
• Hierarchy: PARENT_CP_ID, CONFIG_PARENT_ID, and CONFIG_ROOT_ID are self-referencing keys that model component relationships, configuration structure, and the root of a configured product tree.
• Status and revision: CUSTOMER_PRODUCT_STATUS_ID references CS_CUSTOMER_PRODUCT_STATUSES, while CURRENT_CP_REVISION_ID points to CS_CP_REVISIONS to track the active revision.
• System and provenance: SYSTEM_ID links to CS_SYSTEMS_ALL_B and ORIGINAL_LINE_SERV_DETAIL_ID traces back to CS_LINE_INST_DETAILS for the originating service line.

Common Use Cases and Queries

The table supports incident resolution, where agents must identify the customer's installed product before logging a service request; depot repair processing, where the repair record links via CUSTOMER_PRODUCT_ID; and entitlement validation, which compares the installed product against contract coverage. Reporting on installed base by customer, site, or product is a frequent requirement.

A typical query retrieves all products installed at a customer's site:

• SELECT cp.customer_product_id, cp.customer_id, cp.mib_inventory_item_id, cp.customer_product_status_id FROM cs_customer_products_all cp WHERE cp.customer_id = :cust_id AND cp.install_site_use_id = :site_id;

Hierarchical queries using CONNECT BY on PARENT_CP_ID or CONFIG_PARENT_ID reconstruct configured product assemblies. Joins to CS_CP_REVISIONS and CS_CP_LANGUAGES enrich records with revision and translation detail, while joins to CSD_REPAIRS identify products with active repair activity.

Related Objects

The most significant related objects and their join columns include:

• HZ_CUST_ACCOUNTS — joined on CUSTOMER_ID, providing customer account context.
• HZ_PARTY_SITES — joined on INSTALL_SITE_USE_ID and SHIP_TO_SITE_USE_ID for site detail.
• MTL_ITEM_REVISIONS_B — joined on MIB_INVENTORY_ITEM_ID, MIB_ORGANIZATION_ID, and MIB_REVISION_ID for item master information.
• CS_CP_REVISIONS — child table keyed by CUSTOMER_PRODUCT_ID, tracking revision history.
• CS_CP_PARAMETERS and CS_CP_LANGUAGES — child tables holding configuration parameters and language translations.
• CSD_REPAIRS — references CUSTOMER_PRODUCT_ID to link repair orders to installed products.
• CS_INCIDENTS_ALL_B — references CP_COMPONENT_ID and CP_SUBCOMPONENT_ID for incident tracking.
• CS_CONTACTS — references SOURCE_OBJECT_ID, linking contacts to installed products.
• CS_SYSTEMS_ALL_B — joined on SYSTEM_ID to associate products with defined systems.