Run Oracle Reports Web without Single Sign On (SSO)

By default Oracle Web Reports (Oracle Reports Server 9i, 10g) run Single Sign On enabled. It is possible to bypass this feature. Just follow the procedure:

Using a text editor, open the following file:

%ORACLE_HOME%\reports\conf\rep_%YOUR_SERVER_NAME%.conf
(i.e. D:\Oracle\AppServer\reports\conf\rep_oxygen.conf)

Locate the following lines:

<job jobType="report" engineId="rwEng" securityId="rwSec"/>

<job jobType="rwurl" engineId="rwURLEng" securityId="rwSec"/>

And replace by the following lines:

<job jobType="report" engineId="rwEng"/>

<job jobType="rwurl" engineId="rwURLEng"/>

Save file and Restart Application Server

Enjoy!

List Items Default Value from Database

If you want to provide a default value for Poplist you just set its initial value property to the desired value. But if you want to retrieve the value from database then what is the procedure?

Long days have passed I’m trying to solve this problem. I’ve search on the internet but no article or forum said exactly what I want. Today I’ve solved the puzzle. I’m describing the procedure bellow:

1. Create a Item and change its Item Type property to List Item
2. Set its List Style property to Poplist
3. Give a dummy value to its Elements in List property
4. Give its Initial Value property by a global Variable (i.e.:GLOBAL.VAR_NAME)
5. Create form level trigger WHEN-NEW-FORM-INSTANCE and write a query to retrieve the initial value from database and store it to the global value
6. Populate the list from database query.
7. Enjoy!

Compile Oracle Forms at Command Line

Oracle Forms 6i
ifcmp60 module=<<form_name>>.fmb userid=<<username>>/<<password>>@<<dbalias>> batch=yes

Oracle Forms 10g
frmcmp module=<<form_name>>.fmb userid=<<username>>/<<password>>@<<dbalias>> batch=yes