Search Results csp_failure_rates_u2

Overview

CSP.CSP_FAILURE_RATES is a transactional table in the Oracle EBS Customer Service/Service Parts Planning schema (CSP) that stores failure rate statistics for components used to repair a product. Failure rates are calculated for a specific region, as configured through Oracle's Planner's Desktop, and drive service parts forecasting, repair yield analysis, and component demand planning. Each row associates a component inventory item with a parent product under a defined planning parameter set, capturing both the system-calculated failure rate and any manually entered override.

The table resides in the APPS_TS_TX_DATA tablespace with PCT_FREE of 10. Its two unique indexes, CSP_FAILURE_RATES_U1 and CSP_FAILURE_RATES_U2, reside in APPS_TS_TX_IDX and both carry the NORMAL type with UNIQUE uniqueness. From a modeling perspective, relationship analysis suggests this object behaves as a standalone structure — effectively a satellite capturing measurable facts (calculated and manual failure rates) keyed to a business combination of component, product, and planning parameters, rather than as a pure hub or link.

Key Information Stored

The table comprises 12 documented columns. The most significant are:

• FAILURE_RATE_ID — Surrogate primary key and the column backing unique index CSP_FAILURE_RATES_U1. Referenced by the CSP_FAILURE_RATES# dependency object.
• INVENTORY_ITEM_ID — Identifier of the component whose failure rate is recorded; part of the composite business key in CSP_FAILURE_RATES_U2.
• PRODUCT_ID — Identifier of the parent product being repaired; second component of the CSP_FAILURE_RATES_U2 unique key, with an FK to FND_DM_PRODUCTS.
• PLANNING_PARAMETERS_ID — Ties the failure rate to a specific planning configuration/region; third component of the U2 business key, with an FK to CSP_PLANNING_PARAMETERS.
• CALCULATED_FAILURE_RATE — System-derived failure rate, typically computed from historical repair or usage data.
• MANUAL_FAILURE_RATE — User-entered override value, used when planner judgment supersedes calculated statistics.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, used in hosted (multi-tenant) environments.
• CREATED_BY / CREATION_DATE / LAST_UPDATED_BY / LAST_UPDATE_DATE / LAST_UPDATE_LOGIN — Standard Who columns populated from FND_USER and audit context.

The distinction between FAILURE_RATE_ID (surrogate PK) and the INVENTORY_ITEM_ID/PRODUCT_ID/PLANNING_PARAMETERS_ID triplet (natural business key) is important: the U2 index enforces that a given component cannot have duplicate failure-rate rows for the same product and planning parameter set.

Common Use Cases and Queries

Typical scenarios include service parts demand forecasting, repair yield reporting, and validating planner overrides against calculated values.

• Component failure rate lookup for a product: SELECT INVENTORY_ITEM_ID, CALCULATED_FAILURE_RATE, MANUAL_FAILURE_RATE FROM CSP.CSP_FAILURE_RATES WHERE PRODUCT_ID = :product_id AND PLANNING_PARAMETERS_ID = :pp_id;
• Comparing manual vs. calculated rates: filter rows where MANUAL_FAILURE_RATE != CALCULATED_FAILURE_RATE to identify planner overrides requiring review.
• Trending failure rates across planning parameters or regions by joining to CSP_PLANNING_PARAMETERS.
• Audit extraction using the LAST_UPDATE_DATE and LAST_UPDATED_BY columns to track maintenance history.

Related Objects

• FND_DM_PRODUCTS — joined via PRODUCT_ID to resolve product attributes.
• CSP_PLANNING_PARAMETERS — joined via PLANNING_PARAMETERS_ID to obtain planning configuration and region context.
• FND_SECURITY_GROUPS — joined via SECURITY_GROUP_ID for hosted-environment access control.
• CSP.CSP_FAILURE_RATES# — internal catalog/index object that references this table.
• CSP_FAILURE_RATES_PK — primary key constraint on FAILURE_RATE_ID.
• CSP_FAILURE_RATES_U1 / CSP_FAILURE_RATES_U2 — unique indexes enforcing the surrogate and composite business keys.