FRM-92101 Flexfield Issue - Hidden Concurrent Program Parameter Defaulted To Null Crashes The SRS Form (Doc ID 2069136.1)

Last updated on MAY 04, 2024

Applies to:

Symptoms

R12.2.4

Standard Concurrent Program Submission Form (SRS Form) is crashing with the following error:

Error Message:
FRM-92101 : There was a failure in the forms server during start up.this may happen due to invalid configuration"

Steps to Reproduce:
-------------------------
BACKGROUND:
We have a concurrent Program with 3 parameters under discussion:
1. PARAM1 MODE: VISIBLE, MANDATORY. Uses TABLE TYPE Value set, returns 2 values M1 and M2
2. PARAM2 DUMMY: HIDDEN, NON MANDATORY uses Value Set of type None
  DEFAULT VALUE = 'Y' IF PARAM1 Value = M1 ELSE NULL
3. PARAM3 ID : Visible, no List of Value. The requirement is to have this Enabled If Mode= M1 and Disabled if mode = M2.
  Dummy parameter (Param2) is added to achieve this requirement.
  List Of Values : None, should be a free Text.
  FND PLSQL "BEGIN
  if ':$FLEX$.VS2' = 'Y' THEN
  NULL;
  end if;
  END;"
 

ISSUE:
This has been working fine in the 11i environment, then upgraded to 12.2.4 (Fresh Install) and have deployed the concurrent program.
As soon as the SRS form is opened, enter program name then press tab, before the parameter form opens, the form crashes and required to launch the application again.

OUR ANALYSIS:
If we make DUMMY as Visible, the SRS Form stops crashing. Parameter window Opens with DELIVERY ID as Disabled. This indicates that the setting of NULL default Value to Hidden parameter is causing this crash.

Changes

Upgrade 11i to 12.2.4.

Cause

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