My Oracle Support Banner

Invalid Packages After Applying Certain Service Patches: CS_SERVICE_BILLING_ENGINE_PVT and CS_ERES_INT_PKG (Doc ID 1381462.1)

Last updated on JULY 14, 2020

Applies to:

Oracle Teleservice - Version 12.1.2 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

When applying patches as per <Note 1375765.1>, the following packages are invalid:

Errors:

* For PACKAGE BODY CS_SERVICE_BILLING_ENGINE_PVT:

LINE/COL ERROR
-------- -----------------------------------------------------------------
763/17 PL/SQL: Statement ignored
763/17 PLS-201: identifier 'X_DEST_DAY_TIME' must be declared
794/20 PL/SQL: Statement ignored
794/20 PLS-201: identifier 'X_DEST_DAY_TIME' must be declared


* For PACKAGE BODY CS_ERES_INT_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
714/2 PL/SQL: SQL Statement ignored
716/118 PL/SQL: ORA-904: "L_DEST_TZ_CODE": invalid identifier
716/118 PLS-320: the declaration of the type of this expression is incomplete or malformed

779/2 PL/SQL: SQL Statement ignored
819/123 PL/SQL: ORA-904: "L_DEST_TZ_CODE": invalid identifier
819/123 PLS-320: the declaration of the type of this expression is incomplete or malformed

Changes

 Apply patches as per <Note 1375765.1>

   . Patch  9901780:R12.CSC.B - CTI DIRECT: MEDIA_ID IS NOT POPULATED IN JTF_IH_ACTIVITIES
   . Patch 10042399:R12.CCT.B - ER: SINGLE TELEPHONY LOGIN FROM CONTACT CENTER/SERVICE REQUEST
   . Patch  9481963:R12.CSC.B - ER: SINGLE TELEPHONY LOGIN FROM CONTACT CENTER/SERVICE REQUEST
   . Patch  9970809:R12.CS.B  - ER: SINGLE TELEPHONY LOGIN FROM CONTACT CENTER/SERVICE REQUEST

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.