Search Results csf_tds_tiles




Overview
Explore in AI Chat

Overview

CSF_TDS_TILES is a table in the CSF (Field Service) product schema within Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to define the result of spatial index creation, specifically the tiling operation. In the Oracle Field Service spatial data model, a spatial index partitions a geographic region into tiles: smaller rectangular cells that allow the application to locate and retrieve spatial objects efficiently. CSF_TDS_TILES stores one row per tile produced by that process, and it functions as the structural anchor to which spatial nodes and segments are assigned.

From a heuristic Data Vault modeling perspective, the FK structure mined from the schema classifies this table as hub-leaning. In practice, TILE_ID behaves as a durable business key around which descriptive and satellite-style attributes (geometry, bin assignment, successors) are grouped. This classification is offered as a modeling suggestion rather than a documented Data Vault implementation; EBS itself does not ship Data Vault constructs.

Key Information Stored

The documented physical schema for 12.2.2 shows eight columns. The most significant are listed below.

  • TILE_ID — the surrogate primary key, enforced by the unique index CSF_TDS_TILES_PK. Every other object in the tiling model references a tile through this column.
  • SUCC_TILE_1 through SUCC_TILE_4 — successor tile identifiers. These four columns encode adjacency relationships to neighboring tiles and are central to tile traversal and hierarchical spatial search.
  • BIN_INDEX — the bin assignment for the tile, supporting bucket-based partitioning and lookup strategies used during spatial queries.
  • GEOMETRY — the spatial geometry (tile boundary) associated with the row. The two system-managed LOB indexes SYS_IL0000083073C00013$$ and SYS_IL0000083073C00014$$ are consistent with geometry and related LOB storage; these indexes are infrastructure artifacts rather than business-key candidates.
  • SECURITY_GROUP_ID — the multi-organization security grouping. It is a foreign key to FND_SECURITY_GROUPS and determines which operating unit or security context can see the tile row.

Because the documented unique indexes are system-generated LOB indexes, the true business-key candidate is TILE_ID, surfaced through the primary key. No separate natural-key unique index is documented.

Common Use Cases and Queries

The primary use cases center on spatial index maintenance, neighbor traversal, and access-controlled reporting. Spatial index rebuild programs read and write this table when regenerating the tiling for a geographic region. Traversal logic follows the SUCC_TILE_* links to move from one tile to an adjacent tile, which is the mechanism behind range and proximity searches in Field Service dispatch.

Typical query patterns include locating a tile by primary key, resolving its geometry, and then retrieving dependent nodes and segments:

  • Point lookup: SELECT TILE_ID, BIN_INDEX, GEOMETRY FROM CSF.CSF_TDS_TILES WHERE TILE_ID = :p_tile_id;
  • Neighbor expansion: SELECT SUCC_TILE_1, SUCC_TILE_2, SUCC_TILE_3, SUCC_TILE_4 FROM CSF.CSF_TDS_TILES WHERE TILE_ID = :p_tile_id;
  • Dependent object counts for a tile: join to CSF_TDS_NODES and CSF_TDS_SEGMENTS on TILE_ID to count spatial features per tile.
  • Security-scoped reporting: filter by SECURITY_GROUP_ID to restrict output to the caller's operating unit.

Reporting scenarios include spatial coverage audits (tiles with no assigned nodes), balance checks on BIN_INDEX distribution, and validation of successor links to detect orphaned or broken adjacency chains after a re-tiling run.

Related Objects

The following objects are the most significant dependencies for CSF_TDS_TILES.

  • CSF_TDS_NODES — carries a foreign key CSF_TDS_NODES.TILE_ID referencing CSF_TDS_TILES.TILE_ID, so each spatial node is assigned to exactly one tile.
  • CSF_TDS_SEGMENTS — carries a foreign key CSF_TDS_SEGMENTS.TILE_ID referencing CSF_TDS_TILES.TILE_ID, mapping spatial segments into tiles.
  • FND_SECURITY_GROUPS — referenced by CSF_TDS_TILES.SECURITY_GROUP_ID, providing the multi-org security context for each tile row.
  • CSF_TDS_TILES_PK — the primary key index on TILE_ID that every dependent access path relies upon.
  • SYS_IL0000083073C00013$$ and SYS_IL0000083073C00014$$ — system LOB indexes supporting the large-object columns on the table.

Together these relationships place CSF_TDS_TILES at the center of the Field Service spatial tiling model, serving as the hub through which nodes, segments, and security context are connected.