Forum Stats

  • 3,769,359 Users
  • 2,252,957 Discussions


System_client_idle in Oracle forms 12c

rgir Member Posts: 9 Blue Ribbon
edited Jul 22, 2021 10:04PM in Forms

I'd like to create an automatic user session timeout from forms after a certain period. I have successfully implemented the system_client_idle event in one of the forms; It is working as expected. Now my question is, we have 200+ forms. Do we need to implement this in every form? Because users could be on any form before they go idle.

Did anyone encounter this scenario?

Is there a better way to do it in a centralized configuration or through writing a centralized procedure?


Best Answer

  • Michael Ferrante-Oracle
    Michael Ferrante-Oracle Senior Principal Product Manager USMember Posts: 6,897 Employee
    Accepted Answer

    In order to use any of the System Events (or Database Event - AQ), each form where you want that behavior must be a component of that form. You can add the objects and code to each form programmatically using the Forms Java API (JDAPI). Information about using JDAPI can be found in the Builder Help and in several MyOracleSupport Notes (