Search Results cct_middleware_values_id_u1

Overview

The CCT.CCT_MIDDLEWARE_VALUES table is a transactional configuration table within the CCT (Common Components and Technology) schema of Oracle E-Business Suite. It stores the parameter values associated with each defined middleware identifier, providing the runtime data that drives integration, messaging, and communication configuration across the EBS instance. The table holds one row per parameter value, where each row is anchored to a parent middleware definition and a specific middleware parameter. This structure allows administrators to configure communication endpoints, credentials, timeouts, and channel-specific attributes that the middleware layer consumes at runtime.

Following Data Vault modeling heuristics derived from the foreign key structure, this table is best characterized as a link object. It sits between the CCT_MIDDLEWARES master table and the CCT_MIDDLEWARE_PARAMS definition table, resolving the many-to-many association between a specific middleware instance and the parameters it requires. While it does carry descriptive content (the VALUE column and descriptive flexfield segments), its primary modeling role is to connect middleware identities to parameter definitions with concrete assigned values.

Key Information Stored

• MIDDLEWARE_VALUE_ID — Surrogate primary key enforced by CCT_CMV_PK and the unique index CCT_MIDDLEWARE_VALUES_ID_U1. This is the GUI-level unique identifier for each value record and is the documented business-key candidate.
• MIDDLEWARE_ID — Foreign key to CCT_MIDDLEWARES, identifying the parent middleware definition whose parameter value is being stored.
• MIDDLEWARE_PARAM_ID — Foreign key to CCT_MIDDLEWARE_PARAMS, identifying which parameter definition this record supplies a value for.
• VALUE — VARCHAR2(256) holding the user-supplied value of the parameter, such as a URL, port, queue name, or credential token.
• NAME — A descriptive label column included in the documented schema.
• CONTEXT — VARCHAR2(30) acting as the Descriptive Flexfields structure defining column.
• ATTRIBUTE1 through ATTRIBUTE15 — VARCHAR2(150) descriptive flexfield segment columns for customer-specific extensions.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, controlling row-level access across operating units.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the ORM layer.
• F_DELETEDFLAG — Soft-delete indicator preserved for archival and audit purposes.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY — Standard WHO audit columns.

Common Use Cases and Queries

Typical scenarios include auditing configured middleware parameters, validating that every parameter definition has an assigned value, and reporting on integration settings across environments. The composite index CCT_MWAREPARAMID_VALUES_N2 supports lookups by middleware and parameter together.

To list all values for a given middleware:

SELECT v.middleware_value_id, p.parameter_name, v.value
FROM   cct_middleware_values v, cct_middleware_params p
WHERE  v.middleware_param_id = p.middleware_param_id
AND    v.middleware_id = :middleware_id;

To find middleware definitions missing a required parameter, a NOT EXISTS subquery against CCT_MIDDLEWARE_PARAMS filtered by a known parameter set is effective. Reporting queries should always filter on F_DELETEDFLAG to exclude soft-deleted rows.

Related Objects

• CCT.CCT_MIDDLEWARES — Parent table joined on MIDDLEWARE_ID.
• CCT.CCT_MIDDLEWARE_PARAMS — Parameter definition table joined on MIDDLEWARE_PARAM_ID.
• FND_SECURITY_GROUPS — Security context joined on SECURITY_GROUP_ID.
• FND_DESCR_FLEX_COL_USAGE_TL / FND_DESCRIPTIVE_FLEXS — Flexfield metadata for the CONTEXT and ATTRIBUTE columns.
• CCT_MIDDLEWARE_VALUES_ID_U1 and CCT_MWAREPARAMID_VALUES_N2 — Indexes supporting unique lookup and composite access paths.