Field Service: View CSF_CT_TASKS is Invalid, Causing Forms and Packages Compilation Errors
(Doc ID 1960982.1)
Last updated on JULY 14, 2020
Applies to:Oracle Field Service - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
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
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.
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:
Due to that, the following forms may fail to compile:
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