You are browsing the archive for Oracle Field Service.

Find Invalid Address

 

NAME: Find Invalid Address
SHORT CODE: CSFFIA
MODULE: Oracle Field Service

Description: Find Tasks having an invalid Address
Navigation: Oracle Field Service Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • P_START_DATE : First day of the Date Range
  • P_END_DATE : Last day of the Date Range
  • P_UNSTAMPED_ONLY : Check for Non-Stamped Addresses

 

Oracle Field Service Tables

Database table information for Oracle Field Service modules:

  • CSF_ACCESS_HOURS_B
  • CSF_ACCESS_HOURS_TL
  • CSF_DC_QUERIES_B
  • CSF_DC_QUERIES_TL
  • CSF_DEBRIEF_HEADERS
  • CSF_DEBRIEF_LINES
  • CSF_EXT_LOCATIONS
  • CSF_GNTICONS_SETUP_B
  • CSF_LF_BLOCKS
  • CSF_LF_NAMES
  • CSF_LF_PLACES
  • CSF_LF_PLACE_NAMES
  • CSF_LF_PLACE_POSTCS
  • CSF_LF_POIS
  • CSF_LF_POI_NAMES
  • CSF_LF_POSTCODES
  • CSF_LF_ROADSEGMENTS
  • CSF_LF_ROADSEGM_NAMES
  • CSF_LF_ROADSEGM_PLACES
  • CSF_LF_ROADSEGM_POSTS
  • CSF_L_AGENDALAYOUTS
  • CSF_L_QUERIES
  • CSF_L_QUERYREQUESTS
  • CSF_L_SODS
  • CSF_L_SOTS
  • CSF_MAP_ACCESS_HOURS_B
  • CSF_MAP_ACCESS_HOURS_TL
  • CSF_MD_ADM_BOUNDS
  • CSF_MD_HYDROS
  • CSF_MD_INST_STYLE_SHTS
  • CSF_MD_LAND_USES
  • CSF_MD_LYR_METADATA
  • CSF_MD_LYR_STYLE_SHTS
  • CSF_MD_NAMES
  • CSF_MD_OM_ADMINS
  • CSF_MD_OM_HYDROS
  • CSF_MD_OM_POIS
  • CSF_MD_OM_ROADS
  • CSF_MD_POIS
  • CSF_MD_POI_NM_ASGNS
  • CSF_MD_RAIL_SEGS
  • CSF_MD_RDSEG_NM_ASGNS
  • CSF_MD_RD_SEGS
  • CSF_MD_THEME_METADATA
  • CSF_PARAMS
  • CSF_PHONETIC_VALUES
  • CSF_PLAN_TERRS
  • CSF_RATING_SCALES_B
  • CSF_RATING_SCALES_TL
  • CSF_REQUIRED_SKILLS_B
  • CSF_RESOURCE_SKILLS_B
  • CSF_R_FILTERS_ALL_B
  • CSF_R_FILTERS_ALL_TL
  • CSF_R_FILTER_PARAMS_B
  • CSF_R_FILTER_PARAMS_TL
  • CSF_R_HZ_LOC_EXTNS
  • CSF_R_MESSAGES
  • CSF_R_MESSAGE_TOKENS
  • CSF_R_PLAN_OPTIONS
  • CSF_R_PLAN_OPTION_TASKS
  • CSF_R_REQUEST_FILTERS
  • CSF_R_REQUEST_TASKS
  • CSF_R_REQUEST_VALUES
  • CSF_R_RESOURCE_RESULTS
  • CSF_R_SCENARIOS_ALL_B
  • CSF_R_SCENARIOS_ALL_TL
  • CSF_R_SCENARIO_FILTERS
  • CSF_R_SCENARIO_VALUES
  • CSF_R_SCHED_REQUESTS
  • CSF_R_SPARES_OPTIONS
  • CSF_R_TASK_ASSIGN_EXTNS
  • CSF_R_TDS_ROUTE_CACHE
  • CSF_SDM_CTRY_PROFILES
  • CSF_SKILLS_B
  • CSF_SKILLS_TL
  • CSF_SKILL_LEVELS_B
  • CSF_SKILL_LEVELS_TL
  • CSF_SKILL_TYPES_B
  • CSF_SKILL_TYPES_TL
  • CSF_TDS_BINARY_MAPS
  • CSF_TDS_BINARY_TILES
  • CSF_TDS_CONDITIONS
  • CSF_TDS_COND_SEGS
  • CSF_TDS_INTERVALS
  • CSF_TDS_NODES
  • CSF_TDS_RDBLCK_INTVLS
  • CSF_TDS_RDBLCK_SGMNTS
  • CSF_TDS_ROADBLOCKS
  • CSF_TDS_SEGMENTS
  • CSF_TDS_SEGM_NODES
  • CSF_TDS_TILES

Oracle Field Service Forms

Oracle Field Service Module Forms

FORM SHORT CODE ORACLE FORM NAME
CSFTESEL Select Territories
CSFCTMAI Control Tower
CSFFEDBF Debrief
CSFCTDBR Commit Schedule
CSFCMRSL Resources Subinventories Assignment
CSFSEPLT Assign Territories to Planner Groups
CSFCMLAY Agenda Layout
CSFCMPAR Configuration Parameters
CSFCMWFT Field Service Report Types
CSFCMWFM Field Service Report Manager
CSFCMQRY User Defined Queries
CSFCRSHF Create Trips
CSFDCGTR Read Only Scheduling Chart
CSFGCSTP Tooltip Setup Form
CSFACHRS Access Hours
CSFCTCON Customer Confirmation
CSFDCTKD Task Dependency
CSFDCPCM Parent Child Model
CSFGTSTP Scheduling Chart Setup Form
CSFQRYTO Task Owner Enforcement for Queries
CSFDCMAI Dispatch Center
CSFDCTER Select Territories(1)
CSFDCCMS Commit Schedule(1)
CSFDCHIS Service History
CSFSKMGT Skills Management
CSFSKASN Skills Assignment to Task
CSFTSKCL Task’s Custom Color Setup
CSFDCTRM Trip Management
CSFCGITA Change Invalid Address