Search Results csf_tds_roadblocks




Overview
Explore in AI Chat

Overview

CSF_TDS_ROADBLOCKS is a table owned by the CSF (Field Service) schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It defines a travel duration delay for a segment within the Oracle Field Service / Schedule Tracking infrastructure, specifically the travel duration and scheduling (TDS) component used when the application estimates technician travel times and schedules service visits. A roadblock in this context represents a discrete time-based impediment — such as a recurring congestion window, a crew shift change, or a mandatory break — that inflates the expected duration of traversing a segment between two points. Records stored here are joined by the scheduling engine to intervals and segments to produce accurate dispatch and arrival-time estimates.

From a Data Vault modeling perspective, the heuristic classification for CSF_TDS_ROADBLOCKS is hub-leaning. This reflects its role as a foundational entity keyed by a single surrogate identifier (ROADBLOCK_ID) that is referenced by dependent child tables. Analysts building a Data Vault layer should treat this table as a hub candidate, with the descriptive delay attributes (TRB_DELAY, BIN_INDEX) handled as satellite attributes, while interval and segment associations are modeled as links.

Key Information Stored

The physical schema documents nine columns. The most significant are:

  • ROADBLOCK_ID — Surrogate primary key, defined by constraint CSF_TDS_ROADBLOCKS_PK. It uniquely identifies each roadblock definition and is the column propagated into child tables.
  • TRB_DELAY — The travel delay value applied to a segment when the roadblock is active. This is the core business attribute of the table.
  • BIN_INDEX — A numeric index, typically used to bucket or order roadblock definitions relative to time bins or scheduling windows.
  • CREATED_BY, CREATION_DATE — Standard WHO-column audit fields recording the creating user and timestamp.
  • LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard audit fields capturing the most recent modification identity and session context.
  • SECURITY_GROUP_ID — References FND_SECURITY_GROUPS, enforcing multi-org / row-level security so that roadblock definitions are scoped to the appropriate security group.

The only documented unique business-key candidate is the primary key itself (ROADBLOCK_ID); the remaining columns are descriptive or audit-oriented, with SECURITY_GROUP_ID acting as a foreign-key discriminator rather than a business key.

Common Use Cases and Queries

Typical uses include auditing travel-delay configuration, reconciling scheduling discrepancies, and migrating roadblock definitions between environments. Practitioners frequently query roadblocks that carry an unusually large delay to validate scheduling overruns.

SELECT r.roadblock_id, r.trb_delay, r.bin_index
FROM   csf.csf_tds_roadblocks r
WHERE  r.security_group_id = :g_security_group_id
ORDER BY r.trb_delay DESC;

To inspect the intervals attached to each roadblock, join to CSF_TDS_RDBLCK_INTVLS on ROADBLOCK_ID. To determine which segments a roadblock affects, join to CSF_TDS_RDBLCK_SGMNTS on the same column. Reporting layers often aggregate total TRB_DELAY by segment to quantify scheduling impact, and security administrators join to FND_SECURITY_GROUPS to verify correct row-level scoping.

Related Objects

The following objects directly depend on or relate to CSF_TDS_ROADBLOCKS through documented foreign-key relationships:

  • CSF_TDS_RDBLCK_INTVLS — Child table; FK CSF_TDS_RDBLCK_INTVLS.ROADBLOCK_ID → CSF_TDS_ROADBLOCKS.ROADBLOCK_ID. Stores the time intervals during which each roadblock applies.
  • CSF_TDS_RDBLCK_SGMNTS — Child table; FK CSF_TDS_RDBLCK_SGMNTS.ROADBLOCK_ID → CSF_TDS_ROADBLOCKS.ROADBLOCK_ID. Links roadblocks to the specific travel segments they affect.
  • FND_SECURITY_GROUPS — Parent/referenced table; CSF_TDS_ROADBLOCKS.SECURITY_GROUP_ID → FND_SECURITY_GROUPS. Enforces security-group scoping.

Together with its two child tables, this object forms the roadblock triad used by the Field Service travel-time engine. Any change to a roadblock row propagates to interval and segment associations, so administrators should treat the three tables as a coordinated unit during data fixes, cloning, or purging exercises.