Oracle Forms New Feature Ideas

Walid KHARRAT

1-possibility to enrich oracle forms pl/sql engine, for example having an equivalent of utl_http, parsing json , parsing xml... i know we can use a jvm in forms server, but with hundreds of users there's a performance downside. 2-possibility to have a dump of current session : user key to generate file with random name that contain every field,record value... this can help to open a user issue

Michael Ferrante-Oracle

@Walid KHARRAT

1-possibility to enrich oracle forms pl/sql engine, for example having an equivalent of utl_http, parsing json , parsing xml... i know we can use a jvm in forms server, but with hundreds of users there's a performance downside.

Unclear what you are asking here. Packages like UTL_xxx are from the database and in some cases directly from the language (PLSQL), which also is a component of the database. These have nothing directly to do with Forms. Also, in the case of PLSQL, there is a concept of client-side and server-side PLSQL. Forms uses "client-side" PLSQL. This means that some calls that might be possible directly in the database cannot be called and/or supported when called directly from a running form. If you want to do things like parse XML you can do that with PLSQL, but would be restricted to client-side PLSQL. If you wanted to use functionality that exists server-side then create a DB procedure that does the work and call it from Forms. You see similar limitations with LOB. For example you cannot really use a LOB datatype directly in a form, mostly because variables in client-side are limited to 32k, which LOBs tend to quickly exceed. Realistically, this request is more of an enhancement for the Database and/or PLSQL and not Forms.

Regarding json handling... stay tuned. 😉

2-possibility to have a dump of current session : user key to generate file with random name that contain every field,record value... this can help to open a user issue

This is mostly already possible in current Forms releases using Forms Tracing. Further, it can be restricted to specific users thereby not impacting everyone. Refer to the Troubleshooting section of the "Working with Oracle Forms" guide. Forms tracing can be enabled when an application is launched or even after it has already been running for some time. To enable it after it is already running, refer to the User Sessions page of Fusion Middleware Control. Again, refer to the same doc.

https://docs.oracle.com/en/middleware/developer-tools/forms/12.2.1.4/working-forms/tracing-and-diagnostics.html

TonyDv

Hi,

These could be really nice improvements:

* HTML5 client instead of legacy Java Client. Even allowing CSS and JS customization

* Support for aarch64 servers on Linux.(weblogic already support it)

* Remove frmweb C processes for each connection to forms and allow connections without session sticking to have a better session failover handling on clusters.

* Support for K8S and autoscaling. This support needs that config files can be auto created for each managed server

User_4N9IA

Hi, a few ideas for user experience at Forms Runtime:

1: Ability to scroll the screen using the mouse wheel instead of dragging it manually each time from the scrollbars.

2: Auto resize forms and assigning of scrollbars to improve the user experience.

3: Ability to apply auto-complete at runtime for text fields

4: List items should show the items as we type.

Thanks and Regards,

Rohit Dubey

Walid KHARRAT

https://community.oracle.com/tech/developers/discussion/comment/16833673#Comment_16833673

for the trace option, consider i have about 800 users, running forms application with shortcut of an fsal and javaw launcher. a user call for an exception in her form who blocked him to achieve a business process. how can we do to change her launcher with trace parameter...

Michael Ferrante-Oracle

@Walid KHARRAT

How the form is launched has nothing to do with tracing, so nothing needs to be altered on the user's machine.

Simply select the desired user (based on IP address, DB uname, or other attribute) then click on Enable Tracing. You can customize what specifically gets traced by changing the Tracing Configuration before beginning the trace. This can also be done in FMC.

https://docs.oracle.com/en/middleware/developer-tools/forms/12.2.1.4/working-forms/troubleshooting-diagnostics-and-performance-tuning.html

If you would like to discuss tracing further, please start a new thread, as this one if for new feature/enhancement ideas and not technical discussions.