Search Results csp_failure_rates_pk

Overview

The CSP_FAILURE_RATES table resides in the CSP schema and belongs to the Spares Management module of Oracle E-Business Suite. It stores the failure rates associated with components of a product, providing the quantitative basis for spare-parts demand forecasting, criticality assessment, and maintenance planning across the enterprise asset base. In release 12.1.1 and 12.2.2 the object is documented as VALID with 12 columns and a documented physical schema consistent across both releases.

Each row captures a component-level failure rate for a given inventory item, product, and planning parameter set, supporting both calculated rates derived from historical usage and manually entered rates reflecting engineering judgment or OEM data. From a heuristic Data Vault modeling perspective, this table is classified as standalone; it does not serve as a hub or link in the mined FK structure, and it is best treated as a satellite-like descriptive entity keyed by its own surrogate identifier rather than as a relationship table connecting multiple business hubs.

Key Information Stored

The table is anchored by the surrogate primary key FAILURE_RATE_ID, enforced through the CSP_FAILURE_RATES_PK constraint and additionally covered by the unique index CSP_FAILURE_RATES_U1. Business-key candidates are captured by CSP_FAILURE_RATES_U2, a unique index on the composite of INVENTORY_ITEM_ID, PRODUCT_ID, and PLANNING_PARAMETERS_ID, which guarantees one failure-rate record per item/product/planning-parameter combination.

• INVENTORY_ITEM_ID — identifies the component (spare part) whose failure behavior is being recorded.
• PRODUCT_ID — references FND_DM_PRODUCTS, tying the rate to the product or product family in which the component is installed.
• PLANNING_PARAMETERS_ID — references CSP_PLANNING_PARAMETERS, associating the rate with the planning assumptions under which it applies.
• CALCULATED_FAILURE_RATE — the system-derived failure rate, typically produced by CSP forecasting or usage-history calculations.
• MANUAL_FAILURE_RATE — an operator-supplied override or estimate, useful where historical data is sparse or unreliable.
• SECURITY_GROUP_ID — references FND_SECURITY_GROUPS and enforces multi-org / data-security partitioning of the record.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN capture standard EBS WHO-column lineage.

Common Use Cases and Queries

Typical usage centers on extracting effective failure rates for spares planning, comparing calculated versus manual values, and auditing coverage gaps by product or item. A representative query joins the table to its planning-parameter parent and filters by security group:

• List all rates for a product: SELECT f.inventory_item_id, f.calculated_failure_rate, f.manual_failure_rate FROM csp.csp_failure_rates f WHERE f.product_id = :product_id;
• Compare manual overrides against calculated values to detect divergence: SELECT * FROM csp.csp_failure_rates WHERE manual_failure_rate IS NOT NULL AND NVL(manual_failure_rate,0) <> NVL(calculated_failure_rate,0);
• Join to planning parameters for context: SELECT f.inventory_item_id, p.planning_parameters_id FROM csp.csp_failure_rates f, csp.csp_planning_parameters p WHERE f.planning_parameters_id = p.planning_parameters_id;
• Reconcile against FND_DM_PRODUCTS for product-level rollups and coverage reporting.

Report consumers include spare-parts replenishment analysis, maintenance-criticality reporting, and data-quality dashboards monitoring records lacking either a calculated or manual rate.

Related Objects

The following objects are the most significant dependencies and references for this table:

• CSP_PLANNING_PARAMETERS — parent planning context, joined on PLANNING_PARAMETERS_ID.
• FND_DM_PRODUCTS — product definition, joined on PRODUCT_ID.
• FND_SECURITY_GROUPS — data-security partitioning, joined on SECURITY_GROUP_ID.
• MTL_SYSTEM_ITEMS_B — master item definition for INVENTORY_ITEM_ID.
• CSP_FAILURE_RATES_PK / CSP_FAILURE_RATES_U1 / CSP_FAILURE_RATES_U2 — constraints and unique indexes enforcing integrity.
• CSP Spares Management concurrent programs and planning APIs that read failure rates during forecasting.