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

Last updated on JUNE 29, 2017

Applies to:

Oracle Teleservice - Version 12.1.3 and later
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

ASO_QUOTE_LINES_PVT is invalid and cannot be re-compiled 

Error:
Body 1653 33 PLS-00302: component 'VALIDATE_DURATION' must be declared
Body 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

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