Search Results csf_r_plan_option_tasks_n1

Overview

CSF.CSF_R_PLAN_OPTION_TASKS is a transactional table within the Oracle E-Business Suite CSF (Service/Field Service) schema. It stores the association between a resource plan option and the individual tasks affected by that plan option, together with the calculated schedule adjustments produced by the planning engine. In practical terms, the table records which tasks belong to a given plan option and what the planning process determined for each one: an adjusted start date, an adjusted end date, and a computed travel time to the task. This makes the table an execution-level detail store sitting beneath the plan option header maintained in CSF_R_PLAN_OPTIONS.

The object is documented as VALID in the ETRM 12.2.2 physical schema, with ten columns and two indexes. Note that Oracle classifies this object as Internal Use Only; it is not supported for direct customer access except through standard Oracle Applications programs. The Data Vault classification heuristic mined from the foreign key structure is satellite-leaning. In modeling terms, this suggests treating the table as a satellite surrounding a plan option hub or link, holding descriptive and calculated attributes keyed by a surrogate identifier rather than acting as an independent hub or an associative link between two hubs.

Key Information Stored

The table is keyed by PLAN_OPTION_TASK_ID, a NUMBER column that serves as the surrogate primary key (constraint CSF_R_PLAN_OPTION_TASKS_PK). A unique index, CSF_R_PLAN_OPTION_TASKS_U1, exists on this same column; because the unique index and the primary key cover the same column, PLAN_OPTION_TASK_ID is the sole documented business-key candidate, and no separate composite natural key is exposed in the metadata.

The most significant columns are:

• PLAN_OPTION_TASK_ID — surrogate primary key for the row.
• PLAN_OPTION_ID — foreign key to CSF_R_PLAN_OPTIONS, identifying the plan option that owns this task assignment. Indexed non-uniquely by CSF_R_PLAN_OPTION_TASKS_N1, which supports the common access path of retrieving all tasks for a plan option.
• TASK_ID — foreign key to the task affected by the request's schedule action.
• TASK_ASSIGNMENT_ID — foreign key to JTF_TASK_ASSIGNMENTS, denormalized into this table to simplify Form-level queries that would otherwise need to resolve assignment from task and resource.
• SCHEDULED_START_DATE and SCHEDULED_END_DATE — the calculated or adjusted start and end dates produced by the scheduling process.
• TRAVEL_TIME — the calculated or adjusted travel time to the task.
• OBJECT_CAPACITY_ID — foreign key to CAC_SR_OBJECT_CAPACITY, linking the row to the trip/object capacity record.
• SECURITY_GROUP_ID — security group identifier, a foreign key to FND_SECURITY_GROUPS supporting multi-tenant data separation.
• OBJECT_VERSION_NUMBER — optimistic locking column, incremented by one on every update.

Common Use Cases and Queries

Typical use cases center on schedule analysis and task-level reporting for field service plans. A frequent pattern retrieves every task row for a plan option and joins to the task definition to describe what was scheduled:

• Listing scheduled tasks for a plan option: select from CSF_R_PLAN_OPTION_TASKS where PLAN_OPTION_ID equals a given value, ordering by SCHEDULED_START_DATE.
• Computing planned travel and duration: aggregate TRAVEL_TIME and the difference between SCHEDULED_END_DATE and SCHEDULED_START_DATE grouped by PLAN_OPTION_ID.
• Resolving assignment details without a second lookup on task and resource, by joining TASK_ASSIGNMENT_ID directly to JTF_TASK_ASSIGNMENTS.
• Auditing changes: inspecting OBJECT_VERSION_NUMBER to detect rows that have been updated since a prior extract.
• Security-scoped extracts: filtering by SECURITY_GROUP_ID to honor responsibility-level data access.

The canonical extraction statement documented for the object selects all ten columns directly from CSF.CSF_R_PLAN_OPTION_TASKS; report authors should treat this as the reference column list.

Related Objects

The following objects are the most significant relationships for this table, based on the documented foreign keys and dependencies:

• CSF.CSF_R_PLAN_OPTIONS — parent of PLAN_OPTION_ID; the plan option header that this detail row belongs to.
• JTF_TASK_ASSIGNMENTS — referenced by TASK_ASSIGNMENT_ID; provides assignment and resource context for the scheduled task.
• CAC_SR_OBJECT_CAPACITY — referenced by OBJECT_CAPACITY_ID; represents the trip or capacity object associated with the row.
• FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID; defines the security grouping applied to the row.
• Task definition tables accessed via TASK_ID — the underlying task affected by the plan option's schedule action.
• CSF_R_PLAN_OPTION_TASKS_U1 / N1 — the unique and non-unique indexes that govern access paths on PLAN_OPTION_TASK_ID and PLAN_OPTION_ID respectively.

Consumers should restrict access to this object to Oracle Applications programs, consistent with its Internal Use Only designation.