Oracle Forms 12C - Run Report from Forms - Error FRM-41214 Report Jobid returns as report server name and _0

Symptom

Running a report from oracle forms fails. Report id returned will be the "{report serve rname}_0". Sometimes an error code FRM-41214 will be shown, sometimes not bother to show the error. In report server view jobs, this call to the report server will not be shown.

Cause

In Oracle 12 C, a new Environment variable named COMPONENT_CONFIG_PATH  is introduced. This needs to be added in your default.env ( or the env file you are using ) env file. If this variable is missing, report server will not be connected from oracle forms.

Solution

Make sure that the environment variable COMPONENT_CONFIG_PATH  is added in relevent env file.

How it is Done

1. Go to Forms Section in Enterprise manager

3. First Go to Web configuration and identify our environment file

In the bottom portion, configuration parameter details of your config section will be shown, find env file of yours.

4. Now Open Environment configuration and look for the env

In the Environment configurations file, select your env file at “show” list box on top. in the parameters, go to the bottom and check if COMPONENT_CONFIG_PATH is added. if not, add it with the add button at the top

C:\Oracle\Middleware\Oracle_Home2\user_projects\domains\base_domain\config\fmwconfig\components\ReportsToolsComponent\reptools1

This is the report tool path of mine. provide the tool path of your configuration and apply changes.

5. Now restart Forms service and try again.