Search Results csf_r_plan_options_u1

Overview

CSF.CSF_R_PLAN_OPTIONS is a transactional table in the Oracle E-Business Suite 12.1.1 and 12.2.2 schemas belonging to the CSF product family, which underpins Oracle's Service and Field Service scheduling and planning functionality. The table stores individual plan options generated for resource results during the scheduling and optimization process. Each row represents a candidate plan generated against a resource result, including scheduling windows, associated spares options, calculated costs, and window-to-promise identifiers. The object resides in the APPS_TS_TX_DATA tablespace with ten percent PCTFREE, and its supporting indexes reside in APPS_TS_TX_IDX.

Within a Data Vault modeling framework, the mined relationship structure classifies CSF_R_PLAN_OPTIONS as satellite-leaning. It carries descriptive and metric attributes (cost, scheduled dates, shift context) that qualify an upstream transactional grain, rather than serving as a pure hub or link. The single unique index over PLAN_OPTION_ID provides the technical key, while the foreign keys to CSF_R_RESOURCE_RESULTS, CSF_R_SPARES_OPTIONS, and FND_SECURITY_GROUPS anchor the row to its parent context. Oracle Corporation intends that this object be accessed only through standard Oracle Applications programs; direct querying is not supported.

Key Information Stored

The most significant columns are:

• PLAN_OPTION_ID — Numeric primary key for the table and the column of the unique index CSF_R_PLAN_OPTIONS_U1. This is the surrogate identifier for each plan option.
• RESOURCE_RESULT_ID — Foreign key to CSF_R_RESOURCE_RESULTS; ties the plan option to the resource result being planned. This column leads the non-unique index CSF_R_PLAN_OPTIONS_N1.
• SPARES_OPTION_ID — Foreign key to CSF_R_SPARES_OPTIONS, identifying the spares option pertinent to the request task. This is the second column of CSF_R_PLAN_OPTIONS_N1.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, used for multi-tenant security partitioning.
• SCHEDULED_START_DATE — Scheduled start date of the task represented by the plan option.
• SCHEDULED_END_DATE — Scheduled end date of the task. Note that the source documentation labels this identically to the start date, which is likely a documentation artifact.
• COST — Calculated cost for the plan option, a primary driver when comparing competing plan candidates.
• WIN_TO_PROMIS_ID — Window-to-promise identifier linking the plan option to promise-date calculations.
• OBJECT_VERSION_NUMBER — Optimistic locking column, incremented by one on each update.
• SHIFT_START_DATE and SHIFT_END_DATE — Start and end date/time of the shift the plan option belongs to; both are flagged OBSOLETED and should not be used in new development.
• SHIFT_TYPE — Shift classification for the plan option.

SHIFT_START_DATE and SHIFT_END_DATE are retained for backward compatibility only. New reports should derive shift context from the scheduled dates or from related configuration objects. Business-key candidates are limited to the surrogate PLAN_OPTION_ID; no natural composite unique key is documented on this table.

Common Use Cases and Queries

Plan options are consumed during field service scheduling to compare alternative plans for the same resource result, typically ranked by COST or by scheduled window. A representative query retrieves all candidate plans for a given resource result, ordered by cost:

• SELECT p.PLAN_OPTION_ID, p.RESOURCE_RESULT_ID, p.SCHEDULED_START_DATE, p.SCHEDULED_END_DATE, p.COST FROM CSF.CSF_R_PLAN_OPTIONS p WHERE p.RESOURCE_RESULT_ID = :resource_result_id ORDER BY p.COST;
• Reporting on plan options joined to spares options to analyse the cost impact of alternative spares selections: SELECT p.PLAN_OPTION_ID, p.SPARES_OPTION_ID, p.COST FROM CSF.CSF_R_PLAN_OPTIONS p WHERE p.SPARES_OPTION_ID = :spares_option_id;
• Enumerating tasks per plan option through the child table CSF_R_PLAN_OPTION_TASKS, joining on PLAN_OPTION_ID to list scheduled task detail.
• Audit queries that select PLAN_OPTION_ID, OBJECT_VERSION_NUMBER, and SECURITY_GROUP_ID to detect rows updated after a given point in time.

Because the table is internal, all of the above should be executed only in a read-only diagnostic or reporting capacity, with the understanding that Oracle does not support them.

Related Objects

The following objects carry the most significant documented relationships:

• CSF.CSF_R_RESOURCE_RESULTS — Parent table of the RESOURCE_RESULT_ID foreign key; the resource result represents the outcome being planned.
• CSF.CSF_R_SPARES_OPTIONS — Parent of SPARES_OPTION_ID; holds spares configurations applicable to the request task.
• FND_SECURITY_GROUPS — Parent of SECURITY_GROUP_ID; determines the security context of the row.
• CSF.CSF_R_PLAN_OPTION_TASKS — Child table referencing CSF_R_PLAN_OPTIONS through PLAN_OPTION_ID; stores the individual tasks composing a plan option.
• APPS.CSF_R_PLAN_OPTIONS — The APPS synonym through which EBS forms and concurrent programs access the base CSF object.
• CSF_R_PLAN_OPTIONS_U1 and CSF_R_PLAN_OPTIONS_N1 — The unique and non-unique indexes supporting primary-key lookups and resource-result/spares-option access paths respectively.

The table references no other database objects beyond the three foreign keys listed above, confirming its position as a dependent satellite within the CSF scheduling model.