My Oracle Support Banner

Invalid Pricing Objects After Upgrade From RDBMS 11.2.0.4 To 12C (Doc ID 2613740.1)

Last updated on NOVEMBER 27, 2019

Applies to:

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

Symptoms

Customer has upgraded RDBMS from 11g to 12c
They 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. It seems that 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:  
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

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.