Results for “cs_cp_parameters_u1”
12 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
CS.CS_CP_PARAMETERS is a child (extension) table in the Oracle E-Business Suite Customer Support (CS) module, designed to extend the CS_CUSTOMER_PRODUCTS_ALL table with additional parameter-level attributes associated with a customer product in the Installed Base. Each row represents a single named parameter that belongs to an installed product instance, capturing configuration settings, status, effective dating, and descriptive flexfield context. The table is owned by the CS schema, registered under FND Design Data as CS.CS_CP_PARAMETERS, and resides in the APPS_TS_ARCHIVE tablespace with a PCTFREE of 10.
From a Data Vault modeling perspective, the mined FK structure classifies this object as satellite-leaning: it aggregates descriptive and contextual attributes (parameter type, name, value, status, effective dates) around the customer product hub, driven by its foreign key to CS_CUSTOMER_PRODUCTS_ALL. It is not a hub (no natural business key of its own) and functions as an attribute-bearing extension rather than a link between unrelated entities.
Key Information Stored
- CP_PARAMETER_ID — Surrogate primary key (CS_CP_PARAMETERS_PK); unique identifier for each parameter row, uniquely enforced by index CS_CP_PARAMETERS_U1.
- CUSTOMER_PRODUCT_ID — FK to CS_CUSTOMER_PRODUCTS_ALL; identifies the installed product instance to which the parameter belongs. Indexed non-uniquely via CS_CP_PARAMETERS_N1.
- PARAMETER_TYPE — VARCHAR2(30); categorizes the parameter (e.g., configuration or operational grouping).
- NAME — VARCHAR2(30); the parameter's name/label.
- VALUE — VARCHAR2(1996); the actual parameter value, the largest descriptive column.
- STATUS — VARCHAR2(30); lifecycle state of the parameter.
- APPLICATION_ID — the application that populated the parameter, enabling ownership traceability.
- START_DATE_ACTIVE / END_DATE_ACTIVE — effective dating range for the parameter's validity.
- OBJECT_VERSION_NUMBER — sequential number used for optimistic database locking control.
- SECURITY_GROUP_ID — FK to FND_SECURITY_GROUPS; controls multi-org/security access.
- ATTRIBUTE1–15, CONTEXT — descriptive flexfield segments for client-specific extension.
- MIGRATED_STATUS_FLAG — indicates migration state of the parameter record.
- WHO columns (LAST_UPDATED_BY, CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) — standard audit tracking.
Common Use Cases and Queries
Typical usage centers on retrieving and reporting parameter configuration against installed products. A common pattern joins the extension table back to its parent:
- List all parameters for a given installed product:
SELECT p.name, p.value, p.status FROM cs_cp_parameters p WHERE p.customer_product_id = :cp_id AND (p.end_date_active IS NULL OR p.end_date_active > SYSDATE); - Filter active parameters by type and effective window using START_DATE_ACTIVE / END_DATE_ACTIVE for point-in-time reporting.
- Report application ownership via APPLICATION_ID to determine which module populated each parameter.
- Extract descriptive flexfield context via CONTEXT and ATTRIBUTE1–15 for client-specific attributes.
- Security-scoped extracts constrained by SECURITY_GROUP_ID in multi-org environments.
Related Objects
- CS.CS_CUSTOMER_PRODUCTS_ALL — parent table; joined on CUSTOMER_PRODUCT_ID = CUSTOMER_PRODUCT_ID.
- FND_SECURITY_GROUPS — joined on SECURITY_GROUP_ID for access control.
- CS_CP_PARAMETERS_U1 — unique index on CP_PARAMETER_ID; enforces the surrogate key.
- CS_CP_PARAMETERS_N1 — non-unique index on CUSTOMER_PRODUCT_ID; supports parent-child lookups.
- Installed Base APIs (CS_* and CSI_* public APIs) — used to create and update customer product parameters programmatically.
-
TABLE: CS.CS_CP_PARAMETERS 12.2.2
-
Used to extend CS_CUSTOMER_PRODUCTS_ALL table.
-
Used to extend CS_CUSTOMER_PRODUCTS_ALL table.
-
TABLE: CS.CS_CP_PARAMETERS 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
eTRM - CS Tables and Views 12.2.2
-
eTRM - CS Tables and Views 12.1.1
Table to store web conference details for an SR.