Search Results apps_ts_media




Overview
Explore in AI Chat

Overview

CSF.CSF_TDS_BINARY_MAPS is a VALID table owned by the CSF schema within Oracle E-Business Suite, registered under FND Design Data as CSF.CSF_TDS_BINARY_MAPS. The table stores TDS (Transportation Data Server) binary maps — digital roadmaps persisted as binary large objects upon which route calculations are performed by Oracle's transportation and logistics scheduling engines. Each row defines a discrete binary map, combining metadata (name, version, driving side, average speed) with CLOB and BLOB payloads holding the geospatial and routing data required to compute driving routes, roadblock conditions, and time-interval constraints.

Because the table's LOB segments are physically stored in the APPS_TS_MEDIA tablespace — the user search term for this object — the table is closely associated with large media and binary content storage in EBS. The table carries a foreign key from SECURITY_GROUP_ID to FND_SECURITY_GROUPS, which supports hosted or multi-tenant deployments through Oracle's security group filtering model. From a Data Vault modeling perspective, the metadata indicates a hub-leaning classification: BINARY_MAP_ID is the stable business key around which descriptive attributes are grouped, though the presence of version, config, and binary payloads gives the table satellite-like characteristics as well.

Key Information Stored

The table contains ten documented columns. The most important are:

  • BINARY_MAP_ID (NUMBER, mandatory) — the surrogate primary key, enforced by CSF_TDS_BINARY_MAPS_PK. Uniquely identifies each binary map.
  • NAME (VARCHAR2(120)) — the descriptive name of the map, used for identification in scheduling and setup screens.
  • VERSION (VARCHAR2(10)) — version string for the map, allowing multiple revisions of the same roadmap to coexist logically.
  • DRIVING_SIDE (VARCHAR2) — determines whether the map assumes left- or right-hand driving, affecting route computation.
  • CONFIG (CLOB(4000)) — TDS configuration data for the map.
  • ROADBLOCKS (BLOB(4000)) — binary roadblock data used to exclude or restrict routing segments.
  • CONDITIONS (BLOB(4000)) — binary driving condition data affecting route calculation.
  • TIMEINTERVALS (BLOB(4000)) — condition time-interval data associating conditions with time windows.
  • MAX_AVG_SPEED (NUMBER) — the calculated average of segment maximum speeds, usable as a performance baseline.
  • SECURITY_GROUP_ID (NUMBER) — foreign key to FND_SECURITY_GROUPS, used for hosted-mode filtering.

The four LOB columns (CONFIG, ROADBLOCKS, CONDITIONS, TIMEINTERVALS) each have associated unique LOB indexes (SYS_IL0000083081C00005$$ through SYS_IL0000083081C00008$$), all stored in APPS_TS_MEDIA. These LOB indexes are infrastructure artifacts, not business-key candidates; the true business identifier is BINARY_MAP_ID.

Common Use Cases and Queries

Typical use cases include verifying that a required binary map exists before initiating route scheduling, auditing map versions and driving-side configuration, and monitoring average segment speeds for performance tuning. A basic lookup returns map metadata without loading heavy LOB payloads:

SELECT BINARY_MAP_ID, NAME, VERSION, DRIVING_SIDE, MAX_AVG_SPEED
FROM CSF.CSF_TDS_BINARY_MAPS
WHERE NAME = :map_name;

Reporting queries commonly join to FND_SECURITY_GROUPS on SECURITY_GROUP_ID to confirm the owning security group, or join to CSF_TDS_BINARY_TILES on BINARY_MAP_ID to enumerate the tile coverage of a given map. Storage monitoring queries target the APPS_TS_MEDIA tablespace to track LOB growth, since binary map payloads can become large and affect tablespace capacity planning.

Related Objects

  • CSF.CSF_TDS_BINARY_TILES — references this table via BINARY_MAP_ID, holding the individual tiles that subdivide a binary map.
  • FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID for hosted-mode security filtering.
  • APPS.CSF_TDS_BINARY_MAPS — the APPS synonym through which applications and reports query the CSF-owned table.
  • CSF_TDS_BINARY_MAPS_PK — the primary key constraint on BINARY_MAP_ID enforcing uniqueness.

The table does not reference any database object other than FND_SECURITY_GROUPS, and it is referenced externally only through the APPS synonym and the tile table. Its central role in the TDS routing model makes it a foundational object for any analysis of binary routing data in Oracle EBS 12.1.1 and 12.2.2.

  • TABLE: CSF.CSF_TDS_BINARY_MAPS 12.1.1

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_TDS_BINARY_MAPS,  object_name:CSF_TDS_BINARY_MAPS,  status:VALID, 

  • TABLE: CSF.CSF_TDS_BINARY_MAPS 12.2.2

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_TDS_BINARY_MAPS,  object_name:CSF_TDS_BINARY_MAPS,  status:VALID, 

  • TABLE: FRM.FRM_REPOSITORY_LOBS 12.1.1

    owner:FRM,  object_type:TABLE,  fnd_design_data:FRM.FRM_REPOSITORY_LOBS,  object_name:FRM_REPOSITORY_LOBS,  status:VALID, 

  • TABLE: QP.QP_DOCUMENTS 12.2.2

    owner:QP,  object_type:TABLE,  object_name:QP_DOCUMENTS,  status:VALID, 

  • TABLE: CSF.CSF_MD_OM_POIS 12.1.1

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_MD_OM_POIS,  object_name:CSF_MD_OM_POIS,  status:VALID, 

  • TABLE: CSF.CSF_MD_OM_ADMINS 12.2.2

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_MD_OM_ADMINS,  object_name:CSF_MD_OM_ADMINS,  status:VALID, 

  • TABLE: CSF.CSF_MD_LYR_STYLE_SHTS 12.2.2

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_MD_LYR_STYLE_SHTS,  object_name:CSF_MD_LYR_STYLE_SHTS,  status:VALID, 

  • TABLE: CSF.CSF_TDS_BINARY_TILES 12.2.2

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_TDS_BINARY_TILES,  object_name:CSF_TDS_BINARY_TILES,  status:VALID, 

  • TABLE: FRM.FRM_REPOSITORY_LOBS 12.2.2

    owner:FRM,  object_type:TABLE,  fnd_design_data:FRM.FRM_REPOSITORY_LOBS,  object_name:FRM_REPOSITORY_LOBS,  status:VALID, 

  • TABLE: CSF.CSF_LF_ROADSEGM_PLACES 12.1.1

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_LF_ROADSEGM_PLACES,  object_name:CSF_LF_ROADSEGM_PLACES,  status:VALID, 

  • TABLE: CSF.CSF_MD_OM_POIS 12.2.2

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_MD_OM_POIS,  object_name:CSF_MD_OM_POIS,  status:VALID, 

  • TABLE: CSF.CSF_MD_OM_ADMINS 12.1.1

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_MD_OM_ADMINS,  object_name:CSF_MD_OM_ADMINS,  status:VALID, 

  • TABLE: CSF.CSF_MD_OM_ROADS 12.2.2

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_MD_OM_ROADS,  object_name:CSF_MD_OM_ROADS,  status:VALID, 

  • TABLE: CSF.CSF_LF_ROADSEGM_PLACES 12.2.2

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_LF_ROADSEGM_PLACES,  object_name:CSF_LF_ROADSEGM_PLACES,  status:VALID, 

  • TABLE: CSF.CSF_MD_HYDROS 12.2.2

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_MD_HYDROS,  object_name:CSF_MD_HYDROS,  status:VALID, 

  • TABLE: CSF.CSF_MD_HYDROS 12.1.1

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_MD_HYDROS,  object_name:CSF_MD_HYDROS,  status:VALID, 

  • TABLE: CSF.CSF_MD_OM_ROADS 12.1.1

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_MD_OM_ROADS,  object_name:CSF_MD_OM_ROADS,  status:VALID, 

  • TABLE: CSF.CSF_MD_OM_HYDROS 12.1.1

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_MD_OM_HYDROS,  object_name:CSF_MD_OM_HYDROS,  status:VALID, 

  • TABLE: CSF.CSF_MD_OM_HYDROS 12.2.2

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_MD_OM_HYDROS,  object_name:CSF_MD_OM_HYDROS,  status:VALID, 

  • TABLE: CSF.CSF_MD_LAND_USES 12.1.1

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_MD_LAND_USES,  object_name:CSF_MD_LAND_USES,  status:VALID, 

  • TABLE: CSF.CSF_MD_ADM_BOUNDS 12.1.1

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_MD_ADM_BOUNDS,  object_name:CSF_MD_ADM_BOUNDS,  status:VALID, 

  • TABLE: CSF.CSF_MD_ADM_BOUNDS 12.2.2

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_MD_ADM_BOUNDS,  object_name:CSF_MD_ADM_BOUNDS,  status:VALID, 

  • TABLE: CSF.CSF_MD_POIS 12.2.2

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_MD_POIS,  object_name:CSF_MD_POIS,  status:VALID, 

  • TABLE: CSF.CSF_TDS_BINARY_TILES 12.1.1

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_TDS_BINARY_TILES,  object_name:CSF_TDS_BINARY_TILES,  status:VALID, 

  • TABLE: CSF.CSF_MD_RAIL_SEGS 12.2.2

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_MD_RAIL_SEGS,  object_name:CSF_MD_RAIL_SEGS,  status:VALID, 

  • TABLE: CSF.CSF_MD_RAIL_SEGS 12.1.1

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_MD_RAIL_SEGS,  object_name:CSF_MD_RAIL_SEGS,  status:VALID, 

  • TABLE: CSF.CSF_LF_ROADSEGMENTS 12.1.1

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_LF_ROADSEGMENTS,  object_name:CSF_LF_ROADSEGMENTS,  status:VALID, 

  • TABLE: CSF.CSF_MD_LYR_STYLE_SHTS 12.1.1

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_MD_LYR_STYLE_SHTS,  object_name:CSF_MD_LYR_STYLE_SHTS,  status:VALID, 

  • TABLE: CSF.CSF_LF_ROADSEGMENTS 12.2.2

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_LF_ROADSEGMENTS,  object_name:CSF_LF_ROADSEGMENTS,  status:VALID, 

  • TABLE: CSF.CSF_TDS_NODES 12.1.1

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_TDS_NODES,  object_name:CSF_TDS_NODES,  status:VALID, 

  • TABLE: CSF.CSF_TDS_NODES 12.2.2

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_TDS_NODES,  object_name:CSF_TDS_NODES,  status:VALID, 

  • TABLE: CSF.CSF_LF_POSTCODES 12.1.1

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_LF_POSTCODES,  object_name:CSF_LF_POSTCODES,  status:VALID, 

  • TABLE: CSF.CSF_LF_POSTCODES 12.2.2

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_LF_POSTCODES,  object_name:CSF_LF_POSTCODES,  status:VALID, 

  • TABLE: CSF.CSF_LF_POIS 12.2.2

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_LF_POIS,  object_name:CSF_LF_POIS,  status:VALID, 

  • TABLE: CSF.CSF_LF_POIS 12.1.1

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_LF_POIS,  object_name:CSF_LF_POIS,  status:VALID, 

  • TABLE: CSF.CSF_MD_LAND_USES 12.2.2

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_MD_LAND_USES,  object_name:CSF_MD_LAND_USES,  status:VALID, 

  • TABLE: QP.QP_DOCUMENTS 12.1.1

    owner:QP,  object_type:TABLE,  object_name:QP_DOCUMENTS,  status:VALID, 

  • TABLE: CSF.CSF_TDS_TILES 12.1.1

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_TDS_TILES,  object_name:CSF_TDS_TILES,  status:VALID, 

  • TABLE: CSF.CSF_TDS_TILES 12.2.2

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_TDS_TILES,  object_name:CSF_TDS_TILES,  status:VALID, 

  • TABLE: CSF.CSF_MD_POIS 12.1.1

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_MD_POIS,  object_name:CSF_MD_POIS,  status:VALID, 

  • TABLE: APPLSYS.FND_LOBS 12.1.1

    owner:APPLSYS,  object_type:TABLE,  fnd_design_data:FND.FND_LOBS,  object_name:FND_LOBS,  status:VALID, 

  • TABLE: APPLSYS.FND_LOBS 12.2.2

    owner:APPLSYS,  object_type:TABLE,  fnd_design_data:FND.FND_LOBS,  object_name:FND_LOBS,  status:VALID, 

  • TABLE: CSF.CSF_MD_RD_SEGS 12.1.1

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_MD_RD_SEGS,  object_name:CSF_MD_RD_SEGS,  status:VALID, 

  • TABLE: CSF.CSF_MD_RD_SEGS 12.2.2

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_MD_RD_SEGS,  object_name:CSF_MD_RD_SEGS,  status:VALID, 

  • TABLE: CSF.CSF_TDS_RDBLCK_INTVLS 12.2.2

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_TDS_RDBLCK_INTVLS,  object_name:CSF_TDS_RDBLCK_INTVLS,  status:VALID, 

  • TABLE: CSF.CSF_MD_THEME_METADATA 12.2.2

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_MD_THEME_METADATA,  object_name:CSF_MD_THEME_METADATA,  status:VALID, 

  • TABLE: CSF.CSF_LF_PLACE_NAMES 12.1.1

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_LF_PLACE_NAMES,  object_name:CSF_LF_PLACE_NAMES,  status:VALID, 

  • TABLE: CSF.CSF_LF_POI_NAMES 12.2.2

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_LF_POI_NAMES,  object_name:CSF_LF_POI_NAMES,  status:VALID, 

  • TABLE: CSF.CSF_TDS_SEGM_NODES 12.2.2

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_TDS_SEGM_NODES,  object_name:CSF_TDS_SEGM_NODES,  status:VALID, 

  • TABLE: CSF.CSF_TDS_COND_SEGS 12.2.2

    owner:CSF,  object_type:TABLE,  fnd_design_data:CSF.CSF_TDS_COND_SEGS,  object_name:CSF_TDS_COND_SEGS,  status:VALID,