Search Results csp_failure_rates_v




Overview
Explore in AI Chat

Overview

In Oracle E-Business Suite releases 12.1.1 and 12.2.2, CSP_FAILURE_RATES_V is an APPS-owned database view within the CSP (Spares Management) product family. Its documented purpose is to list failure rates for components of a product. The view is registered in the E-Business Suite Technical Reference Manual (ETRM) with a status of VALID, and it is exposed under the APPS schema as APPS.CSP_FAILURE_RATES_V.

The view serves as a reporting and integration layer over the failure rate data maintained for serviceable products and their constituent inventory items. Within the CSP module, failure rate information supports depots, spares planning, and component reliability analysis. Because the view applies rounding to the two numeric failure rate columns, it is well suited for read-only reporting, extracts, and downstream interfaces that require stable, presentation-ready values rather than raw storage precision.

Underlying Base Objects

The view is defined over a single base object: the synonym CSP_FAILURE_RATES. The documented referenced base object in the ETRM metadata is CSP_FAILURE_RATES (SYNONYM). The view text selects exclusively from this object:

  • SELECT ... FROM CSP_FAILURE_RATES, projecting all documented columns without joins, aggregations, or filters.

Consequently, the view is a straightforward projection and formatting layer. It does not consolidate multiple tables, and it introduces no additional business logic beyond applying ROUND(..., 5) to CALCULATED_FAILURE_RATE and MANUAL_FAILURE_RATE. This means row cardinality and key structure mirror the underlying CSP_FAILURE_RATES table, with FAILURE_RATE_ID functioning as the primary identifier for each row. Administrators should note that because the view is not defined with a security predicate, data visibility depends on the grants issued to the querying responsibility or user.

Key Columns

The view exposes the following columns, each corresponding directly to a column in the base table:

  • FAILURE_RATE_ID — Primary key identifying each failure rate record.
  • PRODUCT_ID — Identifier of the product to which the failure rate applies.
  • INVENTORY_ITEM_ID — Identifier of the component inventory item within the product.
  • CALCULATED_FAILURE_RATE — System-derived failure rate, rounded to five decimal places.
  • MANUAL_FAILURE_RATE — User-entered failure rate, rounded to five decimal places.
  • PLANNING_PARAMETERS_ID — Reference to the associated planning parameters record.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard audit columns recording the most recent modification.
  • CREATION_DATE, CREATED_BY — Standard audit columns recording row creation.
  • SECURITY_GROUP_ID — Legacy security grouping column retained for compatibility.

Common Use Cases and Queries

Typical scenarios include reporting component reliability for a product, comparing calculated versus manual failure rates, and feeding spares planning extracts. A representative query retrieves failure rates for a specific product:

  • SELECT failure_rate_id, inventory_item_id, calculated_failure_rate, manual_failure_rate FROM apps.csp_failure_rates_v WHERE product_id = :product_id;
  • SELECT product_id, COUNT(*) FROM apps.csp_failure_rates_v GROUP BY product_id; — summarizes the number of component failure rates per product.
  • SELECT * FROM apps.csp_failure_rates_v WHERE manual_failure_rate IS NOT NULL AND calculated_failure_rate IS NOT NULL AND manual_failure_rate <> calculated_failure_rate; — identifies records where the manual override diverges from the calculated value.

Because the view performs no joins, these queries execute efficiently against the base table and are appropriate for concurrent program extracts and custom reporting in both 12.1.1 and 12.2.2 environments.