Field Service: View CSF_CT_TASKS is Invalid, Causing Forms and Packages Compilation Errors
(Doc ID 1960982.1)
Last updated on FEBRUARY 06, 2022
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_USGOLIVE_V1.6
<patch 19618490:R12.CSF.B> - SCHEDULER ENHANCEMENTS - NOV DROP - CSF CHANGES
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |