My Oracle Support Banner

Invalid Pricing Objects Such as QP_BUILD_FORMULA_RULES After Database Upgrade (Doc ID 2613740.1)

Last updated on MARCH 11, 2022

Applies to:

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


Symptoms

Customer has upgraded the database and found the following objects invalid after the upgrade

QP_BUILD_FORMULA_RULES1
QP_BUILD_FORMULA_RULES2
QP_BUILD_FORMULA_RULES3
QP_BUILD_FORMULA_RULES4
QP_BUILD_FORMULA_RULES5
QP_BUILD_FORMULA_RULES_TMP

They tried to recompile manually. QP_BUILD_FORMULA_RULES1
package body took approximately 9 hours to compile.

As of now below package bodies are invalid .

   QP_BUILD_FORMULA_RULES2
   QP_BUILD_FORMULA_RULES3
   QP_BUILD_FORMULA_RULES_TMP

As per the document Database PL/SQL Language Reference:  

https://docs.oracle.com/database/121/LNPLS/limits.htm#LNPLS018

Approximately 6 million lines of code is allowed.
The above invalid packages have ~  77k lines of code.
 


Changes

upgrading database 11g to 12c
or
upgrading database 11g to 19c
or
upgrading database 11.2.0.4 To 12C

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.