My Oracle Support Banner

When Using otherparams Parameter, Either FRM-90926 Error Occurs, or otherparams Gets Overridden (Doc ID 283023.1)

Last updated on MAY 05, 2022

Applies to:

Oracle Forms - Version 12.2.1.3.0 and later
Information in this document applies to any platform.
 
 




Symptoms

The problem occurs with the usage of the otherparams parameter in formsweb.cfg.

Parameters can be defined in the .htm files (like base.htm), in formsweb.cfg (general or in named configurations), and on the URL. The otherparams parameter can contain multiple other parameters/values.

The problem is when otherparams is used multiple parameters, e.g. query_only=yes as well as for par_deptno. Here, query_only=yes is static for many forms, but par_deptno is a forms specific parameter, which changes for every form. So the goal would be to specify the varying parameter (par_deptno) on the URL, and the static parameter (query_only) in formsweb.cfg.

However, otherparams cannot be specified twice. How can this be solved?

Trying different solutions, multiple problems occur, like an FRM-90926 error, or otherparams specified on the URL overriding the entire otherparams values in formsweb.cfg.

Cause

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
Symptoms
Cause
Solution
References

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