Field Service: View CSF_CT_TASKS is Invalid, Causing Forms and Packages Compilation Errors (Doc ID 1960982.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Field Service - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

 View CSF_CT_TASKS is invalid. When trying to compile, it results in the following compilation errors.

 

ORA-00904: "T"."CUST_IMP_LEVEL": invalid identifier

and/or

ORA-00904: "T"."CRITICAL_TASK_FLAG": invalid identifier

 

N.B. Others have reported similar issues where the APPS.CSF_TASKS_PUB package body is in 'invalid' status, and this package could not be re-compiled.

 

Changes

 applied any of these patches:

<patch 19533241:R12.CSF.B> - FDD_12.1.3+_CRM_CSF_DISPATCHCENTER_ENHANCEMENTS_NCRUSGOLIVE_V1.6
<patch 19618490:R12.CSF.B> - SCHEDULER NCR ENHANCEMENTS - NOV DROP - CSF CHANGES
<patch 19618462:R12.CSR.B> - SCHEDULER NCR ENHANCEMENTS - NOV DROP

currently these are known to cause this issue, but theoretically there could be others (released after authoring this note)

 

 After this, the following objects are invalid in the database:


CSF_CT_TASKS
CSF_DC_TASK_GRID_V
CSF_GANTT_DATA_PKG
CSF_PLANBOARD_TASKS
CSF_TASKS_PUB
CSF_TRIPS_PUB

 

Due to that, the following forms may fail to compile:


CSFDCSPA.fmx
CSFDCTER.fmx
CSFDCTRM.fmx
CSFDCGNT.fmx
CSFDCPLB.fmx
CSFSCGUI.fmx
CSFSKASN.fmx
CSPTRREQ.fmx
CSFDCTKS.fmx
CSFDCMAI.fmx
CSXSRISR.fmx

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms