ASOQTMAN.pll Faild To Generate During Patch Application (Doc ID 2243810.1)

Last updated on MARCH 14, 2017

Applies to:

Oracle Quoting - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

On Test:  11.5.10.2

Oracle EBS 11i ASOQTMAN.pll faild to generated during patch 16289505 application  

Current EBS 11i environment :  11.5.10.2. RDBMS : 11.2.0.3
Target : RDBMS 12.1.0.2
Followed below Document for the RDBMS upgrade.
Interoperability Notes EBS 11i with RDBMS 12cR1 (Doc ID 1524399.1)

One of the patches EBS patches 16289505 was unable to compile below Library and forms.

----------------------
The following Oracle Forms objects did not generate successfully:

au      resource        ARXTXSTD.pll
au      resource        ARXPLCOM.pll
au      resource        QLTTXN.pll
au      resource        ASTCORE.pll
au      resource        ASOQTMAN.pll
au      resource        JL.pll

The following Oracle Forms objects did not generate successfully:

ar      forms/US        RAXSTDTE.fmx
ar      forms/US        RAXSUDTE.fmx
inv     forms/US        INVIVCSU.fmx
inv     forms/US        INVIDITM.fmx
----------------------

ERROR
-----------------------
Compilation errors on ASOQTMAN_TRIGGERS:
PL/SQL ERROR 302 at line 1075, column 52
component 'VALUE' must be declared
PL/SQL ERROR 0 at line 1075, column 5
Statement ignored

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. In 11i with RDBMS version 11.2.0.3, apply patch 16289505
2. Check for ad_worker logs for the compilation errors for ASOQTMAN.pll

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Impacting DB upgrade.

Changes

 

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