Forms 12c - Cancel Enter_Query (using Menu Not Keyboard) and Exit Form - Hang, FRM-93652 and Crash (Doc ID 2433980.1)

Last updated on MAY 31, 2023

Applies to:

Symptoms

1. The issue is specific to Oracle Forms 12.2.1.3.0.

2. The behavior is related to a number of scenarios involving call_form(), using a custom menu and cancelling a query as the subject of this note indicates. Here is one scenario:

a. Select "enter_query" in a called form
b. Cancel the enter_query using custom menu code. For example:

   if :system.mode = 'ENTER-QUERY' THEN
    EXIT_FORM;
END IF;

c. select key-exit (to exit the form)
d. The Forms runtime process crashes with an FRM-93652 error.

Note:  If the "enter_query" is cancelled from the keyboard rather than from the menu then the crash does not occur.

3.  Patch 26248143 (unix) or Patch 26550599 (windows) was applied

Changes

 Upgraded to 12.2.1.3.0 Forms.

Cause

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