R12.1.3: frmweb Processes Exhaust CPU After Retrieving Large Number of Records
Last updated on FEBRUARY 09, 2018
Applies to:Oracle E-Business Suite Technology Stack - Version 12.1.3 and later
Information in this document applies to any platform.
Forms applet (FNDFFMSV) is opened for Forms export, and is closed abruptly. frmweb process is not terminated smoothly, resulting in rapid increase in CPU usage. Total CPU usage would get about 100%.
The issue can be reproduced with the steps below:
- Open Forms
- Search large number of records
- Run Export
- Export process go forward as below
a) Decision - 100 more records have been retrieved, and an unknown number of additional records remain.
b) Progress - Retrieving all records...
c) Progress - Exporting data...
- Click "Continue to End" when (a) and close browser when (b)
Frmweb processes are not terminated smoothly and, however at the timing that forms export obviously has been done, the process rapidly increase CPU usage highly again.
For example, under the session timeout setting mentioned in Cause below, 30 minute later when OC4J timeout comes after close browser, frmweb process begin to increase CPU again. And the process keep high CPU for another 30 minutes, then terminated at forms timeout timing.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms