Release 12 - Field Service Spatial Upgrading Document
Last updated on APRIL 07, 2017
Applies to:Oracle Field Service - Version 12.0.0 to 12.0.6 [Release 12]
Information in this document applies to any platform.
***Checked for relevance on 07-Apr-2017***
Beginning release R12, Customers using prior versions of the North American (or United Kingdom) Dataset will need to upgrade to the Q1 2005 North American (or United Kingdom) Dataset.
Though originally created for the 2005 dataset, the steps in this note apply to 2008 datasets too. The only thing different would be the number of records inserted in the tables by the navteq data. The script in step 1c of section 2 will work for all versions. Just the tablecounts mentioned after that are specific to 2005.
The benefits derived from upgrading to this new dataset include improved performance for Advanced Scheduler and the Map viewer and more comprehensive coverage.
This document is split up
Section 1: Navteq Spatial Data - Pre Installation Steps
Section 2: Navteq Spatial Data Installation
Section 3: Navteq Spatial Data - Post Installation Steps
Section 4: Mapviewer Implementation
This document outlines the procedures, steps and the relevant sections that need to be followed in order to:
- Migrate from Oracle Corp. apps release 11i using Navteq Datasets prior to the Q1 2005 NA (or UK) Dataset
a. In release 11i, the indexes are created as CSF user.
i. To upgrade to release R12, these indexes created as CSF user have to be explicitly dropped.
ii. To drop indexes from CSF schema, use the drop script csfgeoidxdo.sql which is located at $CSF_TOP/patch/115/sql.
iii. Then, follow the steps laid out in this guide.
- Migrate from Oracle Corp. apps release 11i using Navteq Q1 2005 North American (or United Kingdom) Dataset
a. There is no need to upload the Navteq Dataset
b. Drop and re-create the indexes
i. To drop indexes from CSF schema, use the drop script csfgeoidxdo.sql which is located at $CSF_TOP/patch/115/sql
ii. Please execute the Steps 2 & 3 in Section 3 and all the steps in Section 4.
- Complete new installation of release R12.
a. The entire guide needs to be followed.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms