Results for “css_def_def_platforms”

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

Overview

CSS_DEF_DEF_PLATFORMS is a legacy association table within the CSS - Support module of Oracle E-Business Suite, encountered in both the 12.1.1 and 12.2.2 release lines. Its documented purpose is to record the operating system platform (or platforms) associated with a defect or an enhancement record. The ETRM metadata states that a defect or enhancement may have multiple operating system versions associated with it, while each association row itself resolves to a single platform version. This makes the table a resolution/aggregation structure that links a defect header to one or more platform descriptors.

The module designation "CSS - Support (obsolete)" indicates that the object belongs to a decommissioned or superseded support-tracking schema. The metadata explicitly notes "Not implemented in this database," meaning that in the target environment the table is absent; it survives only as documented metadata, historical DDL references, or in legacy instances that have not been fully purged. Practitioners should treat any dependency on this table as a migration risk.

Under the heuristic Data Vault classification mined from the foreign key structure, CSS_DEF_DEF_PLATFORMS is described as satellite-leaning. In Data Vault terms, this suggests the table behaves as a descriptive satellite attached to a parent hub, where the parent hub is represented by CSS_DEF_DEFECTS_B. The presence of a surrogate primary key (DEF_PLATFORM_ID) alongside a single foreign key to the defect table reinforces that the table carries descriptive attributes contextual to a defect rather than acting as a pure many-to-many link between independent hubs.

Key Information Stored

The documented metadata identifies a small set of structural columns, which is consistent with an obsolete association table that has been largely stripped from public documentation. The most significant columns are:

• DEF_PLATFORM_ID — the surrogate primary key, defined by the constraint CSS_DEF_DEF_PLATFORMS_PK. It uniquely identifies each platform-association row.
• DEFECT_ID — the foreign key column referencing CSS_DEF_DEFECTS_B. This is the business-key linkage that ties each row back to the owning defect or enhancement.

The metadata does not enumerate additional non-key columns, nor does it document any unique index that would elevate another column to business-key status. Accordingly, DEFECT_ID functions as the principal business-key candidate through its participation in the parent-side relationship, while DEF_PLATFORM_ID remains the surrogate identifier. The platform descriptor itself — the value that names the operating system version — is implied by the table's purpose but is not itemized in the provided metadata, so it should be verified against the physical DDL in any legacy instance where the table still exists.

Common Use Cases and Queries

Reporting scenarios for this table center on reproducing, for a given defect or enhancement, the full set of affected operating system platforms. A typical join traverses from the defect header outward:

• Platform-impact reporting — listing every platform associated with a defect to assess regression scope.
• Enhancement compatibility matrices — enumerating the platforms an enhancement was validated against.
• Migration audits — identifying legacy rows that must be mapped to a successor support schema.

A representative query pattern joins the association table to its parent:

• SELECT d.defect_id, p.def_platform_id FROM css_def_defectS_b d, css_def_def_platforms p WHERE d.defect_id = p.defect_id;

Because the metadata records that the table is not implemented in the reference database, any such query should be guarded by an existence check against ALL_TABLES before execution in a production upgrade or conversion script.

Related Objects

The foreign key relationship data identifies the following dependencies:

• CSS_DEF_DEFECTS_B — the parent table referenced by CSS_DEF_DEF_PLATFORMS.DEFECT_ID. This is the primary and documented relationship, forming the defect-to-platform chain.
• CSS_DEF_DEFPLATFORMS_PK — the primary key constraint on DEF_PLATFORM_ID that governs uniqueness within the table.

Given the limited documented relationships, other related objects such as platform lookup tables, defect activity views, or CSS public APIs are not specified in the metadata and should be confirmed empirically in any legacy environment. The dominant and reliable join remains DEFECT_ID to CSS_DEF_DEFECTS_B.