My Oracle Support Banner

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

Last updated on MARCH 31, 2020

Applies to:

Oracle Quoting - Version to [Release 11.5.10]
Information in this document applies to any platform.


On Test:

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

Current EBS 11i environment : RDBMS :
Target : RDBMS
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


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

The issue can be reproduced at will with the following steps:

1. In 11i with RDBMS version, apply patch 16289505
2. Check for ad_worker logs for the compilation errors for ASOQTMAN.pll

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




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.