My Oracle Support Banner

Understanding Reports Execution from Forms Under High Availability (Doc ID 363699.1)

Last updated on FEBRUARY 14, 2023

Applies to:

Oracle Reports Developer - Version to [Release 10gr2]
Oracle Forms - Version to [Release Oracle10g to]
Information in this document applies to any platform.


Understanding Forms Reports Integration Under High Availability (HA), clustered midtiers.

The hardware load balancer with/without webcache has been setup to balance the load between two Midtiers
-- Mid1 and Mid2:

- Mid1 with server rep1 and Mid2 with server rep2.
- Consider old server name (or cluster name) is repsrv.

* You are migrating forms/reports from older version ( or older) to
* In the older version, the report server name is hardcoded (assume report server name as repsrv.)
* Under HA, Forms requests can go either to Mid1 or Mid2 and it is suppose to get executed to the report server that is running locally to respective midtiers (either in-process or standalone report servers.)


This document will help developers who are creating new forms/reports or migrating older forms/reports where the Forms code includes run_report_object and/or web.show_document.

It will discuss all the changes are that need to be done so that Forms calling reports to the hardcoded
older report server can be executed to any of the midtiers in the cluster without any issues.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.