Search Results csf_r_resource_results




Overview
Explore in AI Chat

Overview

The CSF_R_RESOURCE_RESULTS table is a core data object within the Field Service (CSF) module of Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. It stores the output of the resource filtering process — the persisted result set produced when the scheduling engine evaluates candidate resources against a set of eligibility criteria. The documented description identifies four such filters: Preferred, Territory, Geography, and Skills. Each row therefore represents a single candidate resource returned by that filtering exercise, retaining the context flags, distances, ranks, and window timestamps that explain why the resource qualified.

Because the table is owned by the CSF schema and is heavily referenced by downstream planning and spares options (see the FK relationships below), it functions as the durable bridge between the raw resource master and the subsequent planning decisions. From a Data Vault modeling perspective, the mined FK structure classifies this object as hub-leaning: it holds a stable surrogate key and is pointed at by multiple dependent tables, which suggests it is best modeled as a hub with associated satellites capturing the filter-specific attributes.

Key Information Stored

The table carries 21 documented columns. The surrogate primary key is RESOURCE_RESULT_ID, enforced by CSF_R_RESOURCE_RESULTS_PK; a unique index CSF_R_RESOURCE_RESULTS_U1 covers the same column and serves as the business-key candidate.

Common Use Cases and Queries

Typical reporting focuses on why a resource appeared (or did not appear) in a scheduling plan. A frequent pattern joins results back to the request task to explain candidate composition:

  • Candidate audit: SELECT r.RESOURCE_ID, r.DISTANCE, r.SKILL_FLAG, r.TERRITORY_RANK FROM CSF_R_RESOURCE_RESULTS r WHERE r.REQUEST_TASK_ID = :task_id ORDER BY r.GROUPING_ORDER;
  • Preferred-resource analysis: filter on PREFERRED_RESOURCES_FLAG = 'Y' to measure how often preferred picks were retained.
  • Geography reach: use DISTANCE and GEOGRAPHY_FLAG to profile the geographic spread of qualified resources.
  • Planning integration: join to CSF_R_PLAN_OPTIONS and CSF_R_SPARES_OPTIONS on RESOURCE_RESULT_ID to trace results into executed plans.

Related Objects

  • CSF_R_REQUEST_TASKS — parent task reference via REQUEST_TASK_ID.
  • CSF_R_PLAN_OPTIONS — references RESOURCE_RESULT_ID.
  • CSF_R_SPARES_OPTIONS — references RESOURCE_RESULT_ID.
  • FND_SECURITY_GROUPS — referenced through SECURITY_GROUP_ID for org-level security.