Applied Patch Which Caused QP_DEFAULT_MODIFIERS To Become Invalid (Doc ID 2029170.1)

Last updated on JULY 25, 2017

Applies to:

Oracle Advanced Pricing - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.2 version, Pricing Installation

After application of <patch 17070407> , QP_DEFAULT_MODIFIERS is invalid.

ERROR
-----------------------

Errors for PACKAGE BODY QP_DEFAULT_MODIFIERS:

LINE/COL ERROR
-------- -----------------------------------------------------------------
2022/5 PL/SQL: Statement ignored
2022/24 PLS-00302: component 'SERVICE_DURATION' must be declared
2046/5 PL/SQL: Statement ignored
2046/24 PLS-00302: component 'SERVICE_PERIOD' must be declared
2523/5 PL/SQL: Statement ignored
2613/25 PLS-00302: component 'SERVICE_DURATION' must be declared

NOTES
--------

Issue can also occur when a different Advanced Pricing patch is applied.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
select object_name from dba_objects where status='INVALID';

OBJECT_NAME
--------------------------------------------------------------------------------
QP_DEFAULT_MODIFIERS

SQL> alter package QP_DEFAULT_MODIFIERS compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors;
Errors for PACKAGE BODY QP_DEFAULT_MODIFIERS:

LINE/COL ERROR
-------- -----------------------------------------------------------------
2022/5 PL/SQL: Statement ignored
2022/24 PLS-00302: component 'SERVICE_DURATION' must be declared
2046/5 PL/SQL: Statement ignored
2046/24 PLS-00302: component 'SERVICE_PERIOD' must be declared
2523/5 PL/SQL: Statement ignored
2613/25 PLS-00302: component 'SERVICE_DURATION' must be declared>


NOTES
----------
we already tried bounce and
recompile of all QP objects using adadmin
Neither action helped.
Getting several different errors while opening modifier screen after the patch,
Define Modifiers form shows :
  ORA-06508: PL/SQL: could not find program unit being called in package QP_Modifier_PVT Procedure Modifiers
  ORA-01426: numeric overflow in Package QP_Modifiers_PVT Procedure Process_Modifiers


file versions after the patch

QA File versions:

$Header: QPXDMLLB.pls 120.2.12010000.2 2013/10/29 09:08:10 jputta ship $ *

$Header: QPXDMLLS.pls 120.1.12010000.1 2008/07/28 11:51:35 appldev ship $ *

$Header: QPXSVATB.pls 120.10.12010000.5 2013/10/29 09:06:21 jputta ship $ */

$Header: QPXSVATS.pls 120.4.12010000.2 2013/10/29 09:01:34 jputta ship $ */


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