Invalid ASO Objects After Applying CS Cumulative Patches: ASO_DEFAULTING_INT and ASO_QUOTE_LINES_PVT

(Doc ID 2071220.1)

Last updated on OCTOBER 26, 2017

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  CREATED                  LAST_DDL_TIME
----------- ------------------ -------------------------- ------- ------------------------ ------------------------
APPS        PACKAGE BODY       ASO_DEFAULTING_INT         INVALID 03-jan-2007 14:35:45     26-oct-2015 14:21:39
APPS        PACKAGE BODY       ASO_QUOTE_LINES_PVT        INVALID 15-may-2000 16:34:09     26-oct-2015 14:21:40


[ 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

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