My Oracle Support Banner

Invalid ASO Objects After Applying CS Cumulative Patches: ASO_DEFAULTING_INT and ASO_QUOTE_LINES_PVT (Doc ID 2071220.1)

Last updated on JULY 21, 2020

Applies to:

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

Symptoms

After applying a cumulative Service patch, two ASO objects are invalid:

OWNER       OBJECT_TYPE        OBJECT_NAME                STATUS 
----------- ------------------ -------------------------- -------
APPS        PACKAGE BODY       ASO_DEFAULTING_INT         INVALID
APPS        PACKAGE BODY       ASO_QUOTE_LINES_PVT        INVALID


[ 1 ] PACKAGE BODY APPS.ASO_DEFAULTING_INT
LINE/COL ERROR
-------- -----------------------------------------------------------------
612/4 PL/SQL: Statement ignored
612/4 PLS-00201: identifier 'ASO_QUOTE_HEADER_DEF_UTIL.CLEAR_QUOTE_HEADER_CACHE' must be declared
[ 2 ] PACKAGE BODY APPS.ASO_QUOTE_LINES_PVT
LINE/COL ERROR
-------- -----------------------------------------------------------------
1653/19 PL/SQL: Statement ignored
1653/33 PLS-00302: component 'VALIDATE_DURATION' must be declared
2241/19 PL/SQL: Statement ignored
2241/33 PLS-00302: component 'VALIDATE_DURATION' must be declared

Changes

 Applied one of the following Service cumulative patches:

   . Patch 21301645:R12.CS.B - 12.1.3:BUG FIXES FOR CS:AUG'15 RUP
   . Patch 21525667:R12.CS.B - P_RESERVATION_ID SHOULD NOT BE A REQUIRED PARAM IN CS_ESTIMATE_DETAILS_PKG
   . Patch 21823228:R12.CS.B - 12.1.3:BUG FIXES FOR CS:SEP REPLACEMENT CHECKIN'15 RUP
   . Patch 21768109:R12.CS.B - 12.1.3:BUG FIXES FOR CS:OCT'15 RUP
   . Patch 22981320:R12.CS.B - 12.1.3:BUG FIXES FOR CS:MAY'16 RUP.

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.