Generating or Compiling Advanced Pricing And Other Module Library or Report Fails In 12.1.x Upgrade with Adworker Internal Error [60603] (Doc ID 850262.1)

Last updated on FEBRUARY 11, 2016

Applies to:

Oracle Advanced Pricing - Version 12.1.1 and later
Oracle Inventory Management - Version 12.1.1 and later
Oracle Order Management - Version 12.1.0 and later
Information in this document applies to any platform.
Oracle Forms - Version: 10.1.2.3.0 to 10.1.2.3.0



Symptoms



On 12.1.1 in Production:
When attempting to generate Advanced Pricing libraries,
the following error occurs:

ERROR
ERROR generating library "resource/QPXQPQPQ.plx"

<>

adworker File shows:
internal error [60603]

Example from an adworker log file with this issue:


Compilation errors on PRICING_ATTRIBUTES_BLOCK:
PL/SQL ERROR 801 at line 0, column 0
internal error [60603]
PL/SQL ERROR 0 at line 646, column 9
Item ignored
PL/SQL ERROR 801 at line 0, column 0
internal error [60603]
PL/SQL ERROR 0 at line 647, column 9
Item ignored
PL/SQL ERROR 801 at line 0, column 0
internal error [60603]
PL/SQL ERROR 0 at line 651, column 9
Item ignored
PL/SQL ERROR 320 at line 687, column 42
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 687, column 13
Statement ignored
PL/SQL ERROR 320 at line 688, column 37
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 688, column 13
Statement ignored
PL/SQL ERROR 320 at line 689, column 32
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 689, column 13
Statement ignored
PL/SQL ERROR 320 at line 692, column 16
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 692, column 13
Statement ignored
PL/SQL ERROR 320 at line 730, column 37
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 730, column 14
Statement ignored

Failed to generate library.

FRM-30312: Failed to compile the library.



-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. compile all ont form libraries then all ont form using Adadmin utility

-- Business Impact:
The issue has the following business impact:
Due to this issue, cannot progress through upgrade process to R12.1.x


This issue can impact multiple products at the same time.  In addition, some files not compiling can result in other files not being able to compile. The solution provided in this note resolved the issue for all products.

For example, from one situation, all of the following files were not able to compile:

Advanced Pricing
au resource QPXCORE.pll
au resource QPXQPMLL.pll
au resource QPXQPPLL.pll
au resource QPXQPPLQ.pll
au resource QPXQPPRA.pll
au resource QPXQPQPQ.pll
qp reports/US QPXPRCST.rdf
qp reports/PTB QPXPRMLS.rdf
qp reports/PTB QPXPRCST.rdf
qp reports/US QPXPRMLS.rdf

Accounts Receivables:

au resource ARXRWLLC.pll

Human Resources:
au resource HR_SPEC.pll

Oracle Purchasing:
au resource PERWSEMA.pll
per forms/PTB PERWSEMP.fmx
per forms/US PERWSEMP.fmx
au resource POXCOMSG.pll
au resource POXAPAPC.pll
au resource POXDOCON.pll
au resource POXPOREL.pll
au resource POXPOEPO.pll
au resource POXRQDIS.pll
au resource POXRQLNS.pll
po forms/PTB POXDOFDO.fmx
po forms/PTB POXPOERL.fmx
po forms/US POXDOFDO.fmx
po forms/US POXPOERL.fmx

Oracle Costing:
au resource CSSRWKB.pll
au resource CSSRTAB.pll
au resource CSSRISR.pll
cs forms/PTB CSXSRISR.fmx
cs forms/US CSXSRISR.fmx


Oracle Order Management:
au resource OEXOEADJ.pll
au resource OEXPMVAL.pll

Oracle Inventory:
inv forms/PTB INVCCEOI.fmx
inv forms/US INVCCEOI.fmx

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