R12.2: Script $FND_TOP/bin/irep_parser.pl Fails With Error Can’t Locate Class/MethodMaker.pm When Attempting to Generate *.ildt File

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:

  1. 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

 

 

Recent Posts