My Oracle Support Banner

Field Service Patching Error: "CSF_TRIPS_PUB PLS-00201: identifier 'APEX_APPLICATION_GLOBAL.VC_ARR2' must be declared" Yields Invalid Packages CSF_DEBRIEF_UPDATE_PKG And CSF_TRIPS_PUB (Doc ID 1927252.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

After applying patches the package CSF_TRIPS_PUB will not compile.


ERROR
-----------------------
CSF_TRIPS_PUB
PLS-00201: identifier 'APEX_APPLICATION_GLOBAL.VC_ARR2' must be declared
PL/SQL: Item ignored
PLS-00320: the declaration of the type of this expression is incomplete or malformed


STEPS
-----------------------
The package was invalid after applying these patches

Patch 18843305 12.1.3:BUG FIXES FOR CS:JUNE'14 RUP PATCH
Patch 18972429 FIELD SERVICE THIRD PARTY ADMINISTRATOR PORTAL GIVES ERROR AND DOES NOT OPEN
Patch 18115408 DIFFERENT PART REQUIREMENT STATUS IN OAF AND DC FORM
Patch 17399284 CSF.B 'CANNOT UPDATE ENGINEER SKILLS IN RESOURCE SETUP UI
Patch 18382810 CREATE PERSONAL TASK API CHANGES
Patch 18680065 FIELD SERVICE RECOVERY DEBRIEF SPORADICALLY NOT AUTO TRIGGERING INTER-ORG TRANSF

Changes

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.