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 MAY 12, 2016

Applies to:

Oracle Advanced Pricing - Version 12.2 and later
Oracle Order Management - 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) What was the source EBS version that you are upgrading from? 11i, 12.0, 12.1.3 etc
11i

2) Describe the target 12.2 system architecture. How many application and database nodes? What services are running on each node?
1 Node DB and 1 Node MT

3) Is the database RAC enabled?
No

4) What is the database version including PSU version
11.2.0.3.7

5) ### 12.2 Exadata ###
No

6) What is the StartCD Version used?
12.2.0.0.47

7) Customer has file qpttab.odf version 120.8.12020000.7



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
They are still in the middle of upgrade from 11i to R12.2.

They are at the last 10 jobs of 100,000 jobs.

 

 

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