How to change Oracle forms and reports standalone configuration for custom directory???

Recently i encountered one issue to configure Oracle Forms and Reports Standalone to point to custom directory.

Below is the solution for that

Got to httpd.conf file which is located in ORACLE_HOME/Apache/Apache/conf directory.

Before changing anything in httpd.conf, take backup of httpd.conf.

Change DocumentRoot value to your directory as shown below

DocumentRoot "your custom directory"

Hope this helps!!!

How to run Oracle Forms 10g applications on vista???

To make Oracle forms Services to run on Vista you need to have Oracle forms version 10.1.2.3.0. For more information follow the below link for software matrix
http://www.oracle.com/technology/products/forms/htdocs/10gR2/clientsod_forms10gR2.html

To upgrade to Oracle Forms 10.1.2.3.0 and Webutil Version 10.1.2.3 follow the below steps:

Step 1:
--------
To upgrade Oracle Application Server to 10.1.2.3 .0 follow Note number: 329361.1 on http://metalink.oracle.com .
This note explains all the steps and patches needed to be applied to make Oracle Application Server 10.1.2.3.0.
Patch 4505133 to upgrade Database homes to 10.1.0.5.
Patch 5983622 to upgrade Middle and infrastructure tier to 10.1.2.3.0

Step 2:
--------
After that you need to follow Note Number 421930.1 on http://metalink.oracle.com .
This note explains how to obtain FRMWEBUTIL.JAR file from the IAS/IDS Patchset kit (10.1.2.x). This file is needed when you upgrade the IAS from 10.1.2.0.2 to 10.1.2.2/3 to fix the Webutil issues.
Current signature for frmwebutil.jar from 10.1.2.3 patch expires on January 2009. You can get a new frmwebutil.jar that is signed with a new certificate that is valid beyond January 2009 from Patch 7384879 . Please pay attention to the version you download 10.1.2.2 or 10.1.2.3.

Step 3:
--------
Configuration of your Application on the Application Server.
Jinitiator will not work with Vista so you have to change your application setting to use Sun JRE. You should use SUN JRE version 1.6 to make Application run to Vista.

Default.env file
Add “rt.jar” and “frmall.jar” paths in your CLASSPATH. Your CLASSPATH should look like below.

CLASSPATH=E:\10g_mid\j2ee\OC4J_BI_Forms\applications\formsapp\formsweb\
WEB-INF\lib\frmsrv.jar;E:\10g_mid\jlib\repository.jar;E:\10g_mid\jlib\ldapjclnt10.jar;
E:\10g_mid\jlib\debugger.jar;E:\10g_mid\jlib\ewt3.jar;E:\10g_mid\jlib\share.jar;
E:\10g_mid\jlib\utj.jar;E:\10g_mid\jlib\zrclient.jar;E:\10g_mid\reports\jlib\rwrun.jar;
E:\10g_mid\forms\java\frmwebutil.jar;
E:\10g_mid\jdk\jre\lib\rt.jar;E:\10g_mid\forms\java\frmall.jar

Formsweb.cfg
Your Application configuration should look like below

WebUtilArchive=frmwebutil.jar,jacob.jar
WebUtilLogging=off
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384
baseHTMLjinitiator=webutiljpi.htm
baseHTMLjpi=webutiljpi.htm
archive_jini=frmall_jinit.jar,frmwebutil.jar,jacob.jar
archive=frmall.jar
lookAndFeel=oracle
workingDirectory=E:\webutil demo
form=WU_TEST_106.fmx
userid=username/password@host string
pageTitle=Webutil Demo
jpi_classid=clsid:CAFEEFAC-0016-0000-0011-ABCDEFFEDCBA
# Parameter related to the version of the Java Plugin
jpi_codebase=http://java.sun.com/update/1.6.0/jinstall-6u10-windows-i586.cab#Version=1,6,0,11
# Parameter related to the version of the Java Plugin
jpi_mimetype=application/x-java-applet;jpi-version=1.6.0_11

After performing the above steps run your application on Vista with Admin Privileges for the first time as it will download some .dll’s from the Application Server to the Client Machine for webutil purpose. After that you can run the application as a Normal User on Vista.

Please leave comment if you still have any issues.

Code for calling oracle report and oracle form in oracle apps

The below is the code to call oracle report from oracle form in oracle apps.

DECLARE
v_order_imp_id number;
v_admno VARCHAR2(20);
begin
v_admno := :STD_PER_INFO_50448.ADMNO;
v_order_imp_id:= fnd_request.submit_request ('CUSTOM','EMP98','hi', NULL, FALSE,
v_admno,'','','','','','','','','','','','','','','','','','','',
'','','','','','','','','','','','','','','','','','','','',
'','','','','','','','','','','','','','','','','','','','',
'','','','','','','','','','','','','','','','','','','','',
'','','','','','','','','','','','','','','','','','','','');
COMMIT;
MESSAGE ('Your Request Id is'v_order_imp_id);
MESSAGE ('Your Request Id is'v_order_imp_id);
END;

The below is the code to call oracle form from oracle form in oracle apps.

FND_FUNCTION.execute(‘Function Name you want to call and function should exist in your menu’);

"Bean not found" error in webutil???

"Bean not found" bascially comes if you have not configured the formsweb.cfg and default.env file properly.

Solution:

Follow the below two steps:

1. In the default.env file add the path of "rt.jar" in the "CLASSPATH" variable like shown below:
CLASSPATH=E:\OracleDeveloper\j2ee\OC4J_BI_Forms\applications\formsapp\formsweb\WEB-INF\lib\frmsrv.jar;E:\OracleDeveloper\jlib\repository.jar;
E:\OracleDeveloper\jlib\ldapjclnt10.jar;E:\OracleDeveloper\jlib\debugger.jar;
E:\OracleDeveloper\jlib\ewt3.jar;E:\OracleDeveloper\jlib\share.jar;
E:\OracleDeveloper\jlib\utj.jar;E:\OracleDeveloper\jlib\zrclient.jar;
E:\OracleDeveloper\reports\jlib\rwrun.jar;E:\OracleDeveloper\forms\java\frmwebutil.jar;
E:\OracleDeveloper\jdk\jre\lib\rt.jar

2. In the formsweb.cfg file add ",frmwebutil.jar,jacob.jar" to "archive_jini=frmall_jinit.jar" like shown below:
Earlier :- archive_jini=frmall_jinit.jar
After Changing :- archive_jini=frmall_jinit.jar,frmwebutil.jar,jacob.jar

Hope this helps in solving your problem....

If you want to know how to configure webutil properly, refer to my previous post or click on the below link
http://planetofsolutions.blogspot.com/2008/12/steps-to-configure-webutil.html

How to use Client_Host to execute .exe???

In forms 10g to execute any thing on the client side we have to use client_host().

But now the question arises how to use client_host() to execute .exe on the client.

See below for the solution:

Client_Host('cmd /c START "" ' "your .exe");

Now one more thing is there,if you want to execute the .exe and want that it should wait for the .exe to complete execution before doing anything else.
Execute the .exe as shown below


client_host('cmd /c start "" /wait ' "your .exe");

Hope this helps.....

call_form not working in Oracle Forms???

When you are migrating the Oracle Forms Application to 10g, you may come accross a problem that call_form in the form code may not work.

Cause:
The problem is caused by the windows named ROOT_WINDOW.

Solution:
Rename the windows which have the ROOT_WINDOW name.