Search Results csf_r_spares_options




Overview
Explore in AI Chat

Overview

The CSF_R_SPARES_OPTIONS table belongs to the CSF (Field Service) product family within Oracle E-Business Suite, and is valid in both the 12.1.1 and 12.2.2 releases. Its documented purpose is to store the result set returned after the Spares API (the Field Service spares planning routine) is executed. Each row captures one candidate spares option produced for a given resource result, together with the associated planning attributes such as availability date, cost, warehouse, shipment method, and distance.

In Data Vault modeling terms, the metadata classifies this object as satellite-leaning. Read as a modeling suggestion rather than a constraint, this means CSF_R_SPARES_OPTIONS behaves less like a standalone hub of business entities and more like a descriptive, context-bearing satellite attached to a parent entity — in this case CSF_R_RESOURCE_RESULTS, which supplies the RESOURCE_RESULT_ID foreign key. The table records the outcome of a computation rather than a master business object, so its rows are typically regenerated when the spares API is re-run.

Key Information Stored

The table is documented with nine columns. The most significant are:

  • SPARES_OPTION_ID — the surrogate primary key, enforced through the CSF_R_SPARES_OPTIONS_PK constraint and mirrored by the unique index CSF_R_SPARES_OPTIONS_U1. This is the business-key candidate for the row.
  • RESOURCE_RESULT_ID — the foreign key linking each spares option back to its parent row in CSF_R_RESOURCE_RESULTS.
  • AVAILABILITY_DATE — the date on which the proposed spares option becomes available, used for scheduling and feasibility assessment.
  • COST — the monetary cost associated with the option, supporting least-cost selection and comparison reporting.
  • WAREHOUSE — the inventory organization or warehouse from which the spare would be sourced.
  • SHIPMENT_METHOD — the shipping method applied to the option, influencing lead time.
  • DISTANCE — the distance measure associated with the option, typically used to rank sourcing alternatives.
  • SECURITY_GROUP_ID — the foreign key to FND_SECURITY_GROUPS, enforcing Multi-Org / data security filtering.
  • OBJECT_VERSION_NUMBER — the standard Oracle EBS optimistic locking column.

The presence of SECURITY_GROUP_ID and OBJECT_VERSION_NUMBER confirms the table is an OA Framework / Forms-based transactional table rather than a pure interface or staging structure.

Common Use Cases and Queries

The primary use case is retrieval of spares options generated for a field service task, allowing planners to compare candidate warehouses by cost, distance, and availability date. A typical query joins the table to its parent:

  • SELECT s.SPARES_OPTION_ID, s.RESOURCE_RESULT_ID, s.AVAILABILITY_DATE, s.COST, s.WAREHOUSE, s.SHIPMENT_METHOD, s.DISTANCE FROM CSF.CSF_R_SPARES_OPTIONS s WHERE s.RESOURCE_RESULT_ID = :resource_result_id ORDER BY s.COST, s.DISTANCE;

Reporting scenarios include ranking options by cost within a resource result, identifying the nearest warehouse for a given availability window, and reconciling API output volumes against CSF_R_RESOURCE_RESULTS. Standard Oracle EBS security practice should be observed by filtering on SECURITY_GROUP_ID where the reporting layer does not already apply Org security.

Related Objects

The most significant related objects are:

  • CSF_R_RESOURCE_RESULTS — parent table; joined via CSF_R_SPARES_OPTIONS.RESOURCE_RESULT_ID.
  • FND_SECURITY_GROUPS — referenced via CSF_R_SPARES_OPTIONS.SECURITY_GROUP_ID for data security.
  • CSF_R_PLAN_OPTIONS — child table referencing this table through CSF_R_PLAN_OPTIONS.SPARES_OPTION_ID.
  • CSF_R_SPARES_OPTIONS_PK / CSF_R_SPARES_OPTIONS_U1 — the primary key constraint and unique index on SPARES_OPTION_ID.
  • Spares API (CSF Field Service) — the program that populates this table when invoked.