Search Results csf_r_plan_options




Overview
Explore in AI Chat

Overview

CSF_R_PLAN_OPTIONS is a Field Service (CSF) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the planning options generated against a resource result. In the Scheduling and Assignment workflow, the resource planning engine evaluates resources against service demands and produces one or more candidate plan options per resource; this table persists those candidates along with their scheduling windows, associated spare parts options, and costs. Its role is therefore that of a transactional work table within the Field Service resource optimization stack, feeding downstream task generation and cost evaluation.

From a modeling perspective, the mined foreign key structure suggests a satellite-leaning classification. The table carries descriptive and temporal attributes — scheduled start and end dates, shift windows, cost — attached to parent entities such as the resource result and the spares option. It is neither a pure hub (its identity is surrogate and internal) nor a strong link, but it does behave as a dependent child in an integration-style pattern, hanging off CSF_R_RESOURCE_RESULTS and CSF_R_SPARES_OPTIONS.

Key Information Stored

The primary key is the surrogate column PLAN_OPTION_ID, enforced by the CSF_R_PLAN_OPTIONS_PK constraint and mirrored in the unique index CSF_R_PLAN_OPTIONS_U1, making it the documented business-key candidate. The most significant columns include:

  • PLAN_OPTION_ID — surrogate identifier for each plan option row.
  • RESOURCE_RESULT_ID — foreign key to CSF_R_RESOURCE_RESULTS, tying the option to a specific resource's planning result.
  • SPARES_OPTION_ID — foreign key to CSF_R_SPARES_OPTIONS, linking the plan to a specific spare-part availability configuration.
  • SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, used for multi-org and data security enforcement.
  • SCHEDULED_START_DATE and SCHEDULED_END_DATE — the proposed scheduling interval for the option.
  • SHIFT_START_DATE and SHIFT_END_DATE — the working-shift boundaries applicable when the option was generated.
  • SHIFT_TYPE — classification of the shift (for example, regular, overtime, or exception).
  • COST — the projected cost of executing this plan option.
  • WIN_TO_PROMIS_ID — identifier relating the option to a win-to-promise obligation.
  • OBJECT_VERSION_NUMBER — optimistic locking column standard to Oracle EBS 12.2.2 and above.

Common Use Cases and Queries

Typical uses include reviewing planning candidates for a resource, comparing option costs before dispatching a task, and auditing shift/date windows. A representative query joins the table to its parent resource result:

  • Retrieve options for a resource result: SELECT plan_option_id, scheduled_start_date, scheduled_end_date, cost FROM csf_r_plan_options WHERE resource_result_id = :p_result_id;
  • Lowest-cost candidate: SELECT plan_option_id, cost FROM csf_r_plan_options WHERE resource_result_id = :p_id ORDER BY cost ASC;
  • Options constrained within a shift: SELECT plan_option_id FROM csf_r_plan_options WHERE shift_type = :p_shift AND scheduled_start_date >= :p_from;

Reporting typically feeds scheduling dashboards, SLA cost analysis, and security-group-scoped extracts; always include SECURITY_GROUP_ID filtering where multi-org or secured views apply.

Related Objects

  • CSF_R_RESOURCE_RESULTS — parent of the RESOURCE_RESULT_ID foreign key.
  • CSF_R_SPARES_OPTIONS — parent of the SPARES_OPTION_ID foreign key.
  • FND_SECURITY_GROUPS — parent of SECURITY_GROUP_ID for data security.
  • CSF_R_PLAN_OPTION_TASKS — child table whose PLAN_OPTION_ID references this table, holding generated tasks.
  • CSF_R_PLAN_OPTION_TASKS.PLAN_OPTION_ID — join column linking tasks back to each option.

Together these relationships define CSF_R_PLAN_OPTIONS as the central planning record bridging resource results, spares options, and generated tasks.