Field Service: View CSF_CT_TASKS is Invalid, Causing Forms and Packages Compilation Errors
Last updated on MARCH 08, 2018
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_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:
Due to that, the following forms may fail to compile:
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