Search Results csf_r_spares_options_u1

Overview

CSF.CSF_R_SPARES_OPTIONS is a transactional table within the Oracle E-Business Suite 12.1.1 / 12.2.2 schema owned by CSF, the schema associated with field service and spares planning functionality. The table stores individual spares options evaluated against a resource result, forming the bridge between a scheduling outcome and the specific spare parts and logistics details required to satisfy it. Each row captures availability, cost, and shipping characteristics for one spares option, allowing the planning engine and cost calculation routines to compare alternatives during the construction of a service or maintenance plan.

The object is documented as VALID and carries the warning that it is Oracle Internal Use Only; Oracle Corporation does not support direct access to application data through this object except from standard Oracle Applications programs. Under a heuristic Data Vault classification mined from its foreign key structure, the table is satellite-leaning. It extends a parent resource result with descriptive and contextual attributes (availability date, cost, warehouse, shipment method, distance) rather than introducing new business keys or resolving many-to-many relationships on its own.

Key Information Stored

The table contains nine documented columns. The most significant include:

• SPARES_OPTION_ID — the surrogate primary key for the table and the single column underlying the unique index CSF_R_SPARES_OPTIONS_U1. This is the primary business-key candidate and the column referenced by dependent planning tables.
• RESOURCE_RESULT_ID — foreign key to CSF_R_RESOURCE_RESULTS, tying each spares option to the resource result that produced it. Indexed by the non-unique index CSF_R_SPARES_OPTIONS_N1.
• AVAILABILITY_DATE — the date and time at which the spares become available to the engineer, a key input for scheduling feasibility.
• COST — the cost amount associated with the spares, used in calculating the cost of the plan option.
• SECURITY_GROUP_ID — the security group identifier, referencing FND_SECURITY_GROUPS and enforcing multi-tenant or organizational data separation.
• OBJECT_VERSION_NUMBER — optimistic concurrency control column, incremented on every update and checked at write time to detect conflicting changes.
• WAREHOUSE — the stocking location from which the spares would be drawn.
• SHIPMENT_METHOD — the transportation mode used to move the spares.
• DISTANCE — the logistical distance associated with the option, supporting cost and time evaluation.

Common Use Cases and Queries

Typical usage focuses on identifying available spares options for a given resource result and comparing their cost and logistics characteristics. A common query pattern retrieves all options for a resource result ordered by cost or availability:

• SELECT SPARES_OPTION_ID, AVAILABILITY_DATE, COST, WAREHOUSE, SHIPMENT_METHOD, DISTANCE FROM CSF.CSF_R_SPARES_OPTIONS WHERE RESOURCE_RESULT_ID = :resource_result_id ORDER BY COST, AVAILABILITY_DATE;
• Joining to CSF_R_PLAN_OPTIONS on SPARES_OPTION_ID to report which plan option consumed a particular spares option.
• Aggregating COST by RESOURCE_RESULT_ID to establish the total spares cost component of a plan.
• Filtering by SECURITY_GROUP_ID to restrict reporting to the appropriate security context.

Reporting use cases include spares cost analysis, warehouse utilization for service parts, shipment method effectiveness, and availability-driven scheduling exceptions. Because the object is unsupported for direct access, production integrations should rely on standard Oracle Applications programs where possible.

Related Objects

• CSF.CSF_R_RESOURCE_RESULTS — parent object joined via RESOURCE_RESULT_ID; the resource result that the spares option serves.
• CSF.CSF_R_PLAN_OPTIONS — child object referencing this table via SPARES_OPTION_ID; plan options that consume a spares option.
• FND_SECURITY_GROUPS — referenced through SECURITY_GROUP_ID for data security segregation.
• APPS.CSF_R_SPARES_OPTIONS — the APPS synonym through which the table is normally referenced.
• The unique index CSF_R_SPARES_OPTIONS_U1 and non-unique index CSF_R_SPARES_OPTIONS_N1, both in APPS_TS_TX_IDX, support primary-key lookup and resource-result access respectively.