This blog is intended for Oracle Application DBA’s who have issues generating Integration Repository loader file (iLDT). Exposing Oracle E-Business Suite PL/SQL packages a web services requires the creation of iLDT file, but iLDT generation was failing with error: Can’t locate Class/MethodMaker.pm.
ISSUE:
iLDT file generation using the below command fails:
$IAS_ORACLE_HOME/perl/bin/perl $FND_TOP/bin/irep_parser.pl -g -v -username=sysadmin xxdmf:patch/115/sql:XXDMF_INC_APEX_ADMIN_PKG.pls:12.09=XXDMF_INC_APEX_ADMIN_PKG.pls
|
|
| Error:
Can’t locate Class/MethodMaker.pm in @INC (@INC contains: /ebsapp01/oracle/VIS12/fs1/EBSapps/appl/fnd/12.0.0/perl /ebsapp01/oracle/VIS12/fs1/EBSapps/appl/fnd/12.0.0/xml/orc115 /ebsapp01/oracle/VIS12/fs1/EBSapps/appl/fnd/12.0.0/perl/FND/irep/repo /ebsapp01/oracle/VIS12/fs1/EBSapps/appl/fnd/12.0.0/bin/ /ebsapp01/oracle/VIS12/fs1/FMW_Home/webtier/perl/lib/5.10.0/x86_64-linux-thread-multi /ebsapp01/oracle/VIS12/fs1/FMW_Home/webtier/perl/lib/5.10.0 /ebsapp01/oracle/VIS12/fs1/FMW_Home/webtier/perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi /ebsapp01/oracle/VIS12/fs1/FMW_Home/webtier/perl/lib/site_perl/5.10.0 /ebsapp01/oracle/VIS12/fs1/EBSapps/appl/au/12.0.0/perl /ebsapp01/oracle/VIS12/fs1/FMW_Home/webtier/ohs/mod_perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi /ebsapp01/oracle/VIS12/fs1/FMW_Home/webtier/perl/lib/5.10.0/x86_64-linux-thread-multi /ebsapp01/oracle/VIS12/fs1/FMW_Home/webtier/perl/lib/5.10.0 /ebsapp01/oracle/VIS12/fs1/FMW_Home/webtier/perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi /ebsapp01/oracle/VIS12/fs1/FMW_Home/webtier/perl/lib/site_perl/5.10.0 /ebsapp01/oracle/VIS12/fs1/FMW_Home/webtier/perl/lib/5.10.0/x86_64-linux-thread-multi /ebsapp01/oracle/VIS12/fs1/FMW_Home/webtier/perl/lib/5.10.0/x86_64-linux-thread-multi /ebsapp01/oracle/VIS12/fs1/FMW_Home/webtier/perl/lib/5.10.0 /ebsapp01/oracle/VIS12/fs1/FMW_Home/webtier/perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi /ebsapp01/oracle/VIS12/fs1/FMW_Home/webtier/perl/lib/site_perl/5.10.0 /ebsapp01/oracle/VIS12/fs1/FMW_Home/webtier/perl/lib/site_perl .) at /ebsapp01/oracle/VIS12/fs1/EBSapps/appl/fnd/12.0.0/perl/FND/irep/repo/Rep/Parser.pm line 24.
BEGIN failed–compilation aborted at /ebsapp01/oracle/VIS12/fs1/EBSapps/appl/fnd/12.0.0/perl/FND/irep/repo/Rep/Parser.pm line 24.
Compilation failed in require at /ebsapp01/oracle/VIS12/fs1/EBSapps/appl/fnd/12.0.0/bin/irep_parser.pl line 37.
BEGIN failed–compilation aborted at /ebsapp01/oracle/VIS12/fs1/EBSapps/appl/fnd/12.0.0/bin/irep_parser.pl line 37. |
|
CAUSE:
Required Perl Modules not installed.
SOLUTION:
- Install Perl Modules:
Download Patch 13602850 (p13602850_R12_GENERIC.zip) into a temporary directory.
Run the following command:
perl $FND_TOP/patch/115/bin/IREPParserSetup.pl
|
|
|
$ perl $FND_TOP/patch/115/bin/IREPParserSetup.pl
Enter patch 13602850 location (<Patch location>/p13602850_R12_GENERIC.zip file should exist and the default location is /home/applvis12):
/tmp/R/p13602850_R12_GENERIC.zip [Step 1/3] Modify Perl configuration
[Success] Locating Config.pm file
[Success] Backing up Config.pm file
[Success] Modifying archlibexp
[Success] Modifying privlibexp
[Success] Modifying sitearchexp
[Success] Modifying sitelibexp [Step 2/3] Set environment variables
[Success] Set PATH
[Success] Set PERL5LIB
[Success] Set LIBPATH
[Success] Set ORACLE_HOME
[Success] Set LD_LIBRARY_PATH
[Success] Set JAVA_HOME [Step 3/3] Install Perl modules
[Success] Creating installation directory
[Success] Changing permissions
[Success] Copying the patch
[Success] Extracting the patch
[Success] Copying module Compress-Zlib-2.009
[Success] Copying module Compress-Raw-Zlib-2.009
[Success] Copying module Class-MethodMaker-1.12 [Info] Module Compress-Raw-Zlib-2.009
[Success] Writing Makefile
[Success] Compiling module
[Success] Installing module [Info] Module Compress-Zlib-2.009
[Success] Writing Makefile
[Success] Compiling module
[Success] Installing module [Info] Module Class-MethodMaker-1.12
[Success] Writing Makefile
[Success] Compiling module
[Success] Installing module [Success] Removing temporary files
[Success] Post-install cleanup done successfully [Final Status] Integration Repository parser setup completed successfully [Info] For more information check /home/applvis12/IREPParserSetup.log |
|
2.export the following environment variables in the APPL_TOP environment and regenerate ildt file:
Add $FMW_HOME/webtier/lib to LIBPATH if it is not present
Set JAVA_HOME to the JDK top directory
Prepend PERL5LIB with $FND_TOP/perl and $APPL_TOP_NE/perl in that order.
|
|
| export LIBPATH=$LIBPATH:$FMW_HOME/webtier/lib
export JAVA_HOME=$COMMON_TOP/util/jdk32
export PERL5LIB=$APPL_TOP_NE/perl/lib/5.10.0:$APPL_TOP_NE/perl/lib/site_perl/5.10.0:$FND_TOP/perl:$PERL5LIB
$IAS_ORACLE_HOME/perl/bin/perl $FND_TOP/bin/irep_parser.pl -g -v -username=sysadmin xxdmf:patch/115/sql:XXDMF_INC_APEX_ADMIN_PKG.pls:12.09=XXDMF_INC_APEX_ADMIN_PKG.pls |
|
