'ASO_QUOTE_HEADER_DEF_UTIL.CLEAR_QUOTE_HEADER_CACHE' must be declared (Doc ID 2023454.1)

Last updated on JUNE 09, 2017

Applies to:

Oracle Order Capture - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On Test: 12.1.3 version, Install

After applying below patches recommended by patch wizard for ASO,
20752067.ASO.B -ADDITIONAL OPTION FOR ASO: CONFIGURATION EFFECTIVE DATE
20816624.ASO.B -Order Capture Recommended Patch Collection (Apr 1st 2015)

Package Body ASO_DEFAULTING_INT could not recompile and remain in INVALID state.


ERROR
-----------------------
Errors for PACKAGE BODY 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


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply 20752067.B and 20816624.B
2. Check patch log or AppsCheck (Order Capture).

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Unable to deploy patches to Prod.

Changes

 

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