Tuesday, October 4, 2011

PLL compilation error after applying patch 9338767

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem: PLL compilation error after applying patch 9338767

On : 11.5.10.2 version, Installation and Configuration

After applying the Patch 9338767, pll compilation error occurs for the following pll's

ERROR
-----------------------
au resource POXPOREL.pll
au resource POXAPAPC.pll
au resource POXPOEPO.pll
au resource POXPOPOL.pll
au resource POXSCSI2.pll
au resource POXPOPOS.pll


/u02/auts/autsora/8.0.6/bin/f60gen module=/u02/auts/autsappl/au/11.5.0/resource/POXPOREL.pll userid=APPS/***** output_file=/u02/auts/autsappl/au/11.5.0/resource/POXPOREL.plx modul
e_type=library batch=yes compile_all=special

ERROR generating library "resource/POXPOREL.plx" from input file
/u02/auts/autsappl/au/11.5.0/resource/POXPOREL.pll

-------------------------------------------------------------------------
PDE-PLI038 Cannot open file for use as a PL/SQL library.
-------------------------------------------------------------------------

Symptoms:

The issue can be reproduced at will with the following steps:
1. Apply patch 9338767
2. Try to compile get the pll compilation errors

Apply patch 9338767 to fix "an issue in iProcurement(FRM 40654 Error) which occurs when user tries to save a Requisition line containing spaces at the end of the free text (E.g Note to Agent) entered while creating requisition". Patch fails with PLL compilation errors.




Solution:



compilation error is due to the corruption


Open each PLL associated with the form one at a time from the forms builder to identify which PLL is causing the problem.
It worked after replacing this pll with a non-corrupted one from our instance.

Note 862614.1 PDE-PLI038 Cannot Open File For Use As A PL/SQL Library

References:

Note 862614.1 PDE-PLI038 Cannot Open File For Use As A PL/SQL Library

Note 412963.1 Patch 4676589 Failed to Generate Libraries and Forms with Error PDE-PLI038
Note 761944.1 Troubleshooting PDE-PLI038 during patch application or execution of f60gen


Get Oracle Certifications for all Exams
Free Online Exams.com

No comments: