Migrating Custom Form For Custom Reports from Windows To Linux -- Error: Can't Locate Run_report Err

(Doc ID 2327854.1)

Last updated on DECEMBER 01, 2017

Applies to:

Oracle Utilities Work and Asset Management - Version 1.9.1.2 and later
Information in this document applies to any platform.

Goal

On : 1.9.1.2 version, Systemwide

Migrating Custom Form For Custom Reports from Windows To Linux -- Error: Can't Locate Run_report Err

On windows, created a shortcut for forms builder and under properties pointed the start in value for the shortcut to the location of the forms, and the attached srpi.pll e.g. c:\synergen\WAMDEV\forms -- once this was done, when the custom .fmb was opened , it would load the run_report push button and it would appear on the canvas for the report.

Set the following environment variables:


export ORACLE_HOME=/u01/oracle/Middleware/Oracle_FRHome1
export ORACLE_INSTANCE=/u01/oracle/Middleware/asinst_1
export FORMS_BUILDER_CLASSPATH=$ORACLE_HOME/jlib
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORACLE_SID=WAMPROD
export FORMS_PATH=/u01/oracle/synergen/WAMDEV/forms
PATH=$ORACLE_HOME/bin:$PATH
export PATH

cd to $ORACLE_INSTANCE/bin - type to /frmbld.sh to start forms builder.

Open the rptmstr -- no errors.  When rpttmpl8.fmb's and rptneo.fmg are opened, received error's on both:
  'frm-18108 failed to load following objects
  SOurce Module:PRTMSTR.FMB
  SOurce object :ALL_BUTTONS: B_RUN_REPORT

This prevents from creating a usable custom rptneo.fmx file
 

Solution

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