Invalid Packages CSM_TASK_ASSIGNMENT_EVENT_PKG and CSM_USER_EVENT_PKG After Applying <Patch:22757089>:R12.CSM.C (Doc ID 2121128.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Mobile Field Service - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

After applying <Patch:22757089>:R12.CSM.C "12.2:CSM: FEBRUARY 2016 ROLLUP" the following two packages are invalid:

  CSM_TASK_ASSIGNMENT_EVENT_PKG
  CSM_USER_EVENT_PKG


ERROR
-----------------------
Errors for PACKAGE BODY CSM_TASK_ASSIGNMENT_EVENT_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
768/6 PL/SQL: Statement ignored
768/112 PLS-00201: identifier 'P_USER_ID' must be declared


Errors for PACKAGE BODY CSM_USER_EVENT_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
69/11 PLS-00323: subprogram or cursor 'SPAWN_TIME_ENTRY_INS' is
  declared in a package specification and must be defined in the
  package body



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