My Oracle Support Banner

During R12.2.3 Upgrade on Patch 17020683 the pll Recompile Failed Showing That Object APPS.QP_UTIL_PUB Is Invalid (Doc ID 1683318.1)

Last updated on FEBRUARY 17, 2019

Applies to:

Oracle Order Management - Version 12.2 and later
Oracle Advanced Pricing - Version 12.2 and later
Information in this document applies to any platform.
au resource OEXOEADJ.pll
au resource OEXOEGWY.pll
au resource OEXOEBSO.pll
au resource OKSAUDET.pll
au resource OEXOEHDR.pll
au resource OEXOELIN.pll
au resource OEXTRTYP.pll
au resource POXPOPOL.pll
au resource QOTLNDET.pll
au resource QOTPRDTL.pll
au resource OEXOEBSE.pll
au resource QOTLNSVI.pll
au resource QPXQPDEB.pll

Symptoms

On :  12.2.3 version, Pricing, Discounting & Charges

R12.2.3 Upgrade pll recompile failed <Patch 17020683>

Problem Description
---------------------------------------------------
R12.2.3 upgrade below pll files recompile failed

The following Oracle Forms objects did not generate successfully:

au      resource        QOTLNSVI.pll
au      resource        QOTPRDTL.pll
au      resource        OEXOEBSE.pll
au      resource        OEXTRTYP.pll
au      resource        QOTLNDET.pll
au      resource        QPXQPDEB.pll
au      resource        OEXOEGWY.pll
au      resource        OEXOEADJ.pll
au      resource        OEXOEBSO.pll
au      resource        OKSAUDET.pll
au      resource        OEXOEHDR.pll
au      resource        OEXOELIN.pll



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

1) Received error message when compiling OM pll


-bash-4.1$ frmcmp_batch module=$AU_TOP/resource/OEXOEBSE.pll userid=apps/   output_file=$AU_TOP/resource/OEXOEBSE.plx module_type=library batch=no compile_all=special
Forms 10.1 (Form Compiler) Version 10.1.2.3.0 (Production)

Forms 10.1 (Form Compiler): Release  - Production

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    With the Partitioning, Real Application Clusters, Oracle Label Security, OLAP,
    Data Mining and Real Application Testing options
PL/SQL Version 10.1.0.5.0 (Production)
Oracle Procedure Builder V10.1.2.3.0 - Production
Oracle Virtual Graphics System Version 10.1.2.0.0 (Production)
Oracle Multimedia Version 10.1.2.0.2 (Production)
Oracle Tools Integration Version 10.1.2.0.2 (Production)
Oracle Tools Common Area Version 10.1.2.0.2
Oracle CORE 10.1.0.5.0 Production
Compiling library OEXOEBSE...
 Invalidating Package Spec OE_BSA_WORKFLOW......
 Invalidating Package Spec OE_BSA_SPECIAL......
 Invalidating Package Spec OE_BSA_PRICING......
 Invalidating Package Spec OE_BSA_FIND......
 Invalidating Package Spec OE_BSA_ACTIONS_LIST......
 Invalidating Package Spec OE_BSA_ACTIONS......
 Invalidating Package Spec FORM_VERSION......
 Invalidating Package Body OE_BSA_WORKFLOW......
 Invalidating Package Body OE_BSA_SPECIAL......
 Invalidating Package Body OE_BSA_PRICING......
 Invalidating Package Body OE_BSA_FIND......
 Invalidating Package Body OE_BSA_ACTIONS_LIST......
 Invalidating Package Body OE_BSA_ACTIONS......
 Invalidating Package Body FORM_VERSION......
 Compiling Package Spec OE_BSA_WORKFLOW......
 Compiling Package Spec OE_BSA_SPECIAL......
 Compiling Package Spec OE_BSA_PRICING......
 Compiling Package Spec OE_BSA_FIND......
 Compiling Package Spec OE_BSA_ACTIONS_LIST......
 Compiling Package Spec OE_BSA_ACTIONS......
 Compiling Package Spec FORM_VERSION......
 Compiling Package Body OE_BSA_WORKFLOW......
 Compiling Package Body OE_BSA_SPECIAL......
 Compiling Package Body OE_BSA_PRICING......
ERROR 905 at line 166, column 19
 object APPS.QP_UTIL_PUB is invalid
ERROR 0 at line 166, column 19
 Statement ignored
 Compiling Package Body OE_BSA_FIND......
 Compiling Package Body OE_BSA_ACTIONS_LIST......
 Compiling Package Body OE_BSA_ACTIONS......
 Compiling Package Body FORM_VERSION......
Closing library OEXOEBSE...
Compilation errors on OE_BSA_PRICING:
PL/SQL ERROR 905 at line 166, column 19
object APPS.QP_UTIL_PUB is invalid
PL/SQL ERROR 0 at line 166, column 19
Statement ignored

Failed to generate library.

FRM-30312: Failed to compile the library.


2) Manually compiled QP_UTIL_PUB and it had compilation errors.

SQL> select text from all_errors where name = 'QP_UTIL_PUB' ;


TEXT
--------------------------------------------------------------------------------
PLS-00905: object APPS.QP_NPREQ_LINES_TMP is invalid
PL/SQL: Declaration ignored
PLS-00905: object APPS.QP_NPREQ_LDETS_TMP is invalid
PL/SQL: Declaration ignored
PLS-00905: object APPS.QP_UTIL_PUB is invalid
PLS-00304: cannot compile body of 'QP_UTIL_PUB' without its specification
PL/SQL: Compilation unit analysis terminated


NOTES
=======
1) The upgrade source EBS version was 11i that was being upgraded.
2) Target has one node database and one node middle tier for 12.2.X.
3) Database is not RAC enabled?
4) The database version is 11.2.0.3.7

 

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
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.