My Oracle Support Banner

Applying Latest RDBMS 19C RU Patch Causes Invalid Service and Depot Repair Objects (Doc ID 2970786.1)

Last updated on AUGUST 30, 2023

Applies to:

Oracle Depot Repair - Version 12.1.3 to 12.2.12 [Release 12.1 to 12.2]
Oracle Teleservice - Version 12.1.3 to 12.2.12 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

After applying RU 19C patch 35042068 the following objects become invalid. This can happen on any release and any 19C RU patch.


OBJECT_NAME                   OBJECT_TYPE           STATUS

CSD_PROCESS_PVT             PACKAGE BODY        INVALID
CSD_RETURNS_UTIL             PACKAGE BODY        INVALID
CS_SERVICEREQUEST_PVT    PACKAGE BODY        INVALID

ERRORS
--------------

Errors for PACKAGE BODY APPS."CSD_PROCESS_PVT":
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0      PLS-00907: cannot load library unit APPS.CS_SERVICEREQUEST_PUB
         (referenced by APPS.CSD_PROCESS_PVT)


Errors for PACKAGE BODY APPS."CS_SERVICEREQUEST_PVT":
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0      PLS-00907: cannot load library unit APPS.CS_SERVICEREQUEST_PUB
         (referenced by APPS.CS_SR_EXTATTRIBUTES_PVT)


Errors for PACKAGE BODY APPS."CSD_RETURNS_UTIL":
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0      PLS-00907: cannot load library unit APPS.CS_SERVICEREQUEST_PUB
         (referenced by APPS.CSD_PROCESS_PVT)

 

Changes

 Applied latest 19C RU patch

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.