Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle Forms Quarterly Patch Availability News

Michael Ferrante-OracleFeb 9 2022 — edited Jan 23 2025

The latest Forms Quarterly Patch Release (QPR) contains all known fixes available for Forms and is planned to be updated each quarter on or about the same schedule as Critical Patch Update. Each new QPR will include the latest Forms fixes when available. Because these patches will be a cumulative set, you only need to install the latest unless documented otherwise.

Note that if no new updates are available for a given quarter, a new patch will not be released for that quarter.

Details and download links can be found in Note 2834458.2

https://support.oracle.com/epmos/faces/DocumentDisplay?id=2834458.2

ORACLE FORMS 14.1.2.0

RELEASE DATE   UPDATED       PATCH ID
21-JAN-2025                  ***

*** No patch this quarter

ORACLE FORMS 12.2.1.19

RELEASE DATE   UPDATED       PATCH ID
21-JAN-2025                  ***
18-OCT-2024                  37177724 
18-JUL-2024                  36808891
17-APR-2024                  36475988
17-JAN-2024                  ***
21-NOV-2023                  36009429
18-JUL-2023                  ***
18-APR-2023                  ***

*** No patch this quarter

ORACLE FORMS 12.2.1.4

Reminder: Forms/Reports 12.2.1.4 Error Correction Support is planned to end September 30, 2024. Upgrade to 12.2.1.19 or newer if you expect to need new bug fixes or security updated.

RELEASE DATE   UPDATED       PATCH ID
18-JUL-2024                  36808865 (LAST PLANNED QPR PATCH FOR 12.2.1.4)
19-APR-2024                  36475971
17-JAN-2024                  36138487
18-OCT-2023                  35877512
18-JUL-2023                  35516540
18-APR-2023                  ***
17-JAN-2023    23-JAN-2023   34907966
31-OCT-2022                  ***
19-JUL-2022                  34316706
26-APR-2022                  34051375
09-FEB-2022    09-MAR-2022   33909764

*** No patch this quarter

Patches for some platforms may not be available on the day of the release, but will be made available as soon as possible after the release date.

In order for a computer system to be as stable and secure as possible, it must be running the latest software along with any patches/updates that are available. Running outdated and/or un-patched software can be risky to the system, the data, and potentially to the entire organization. This new delivery process (QPR) will help to ensure you can obtain your Forms patches in a predictable and timely manner and keep your system running smoothly. We recommend that you apply the latest patch as it becomes available. As always, testing before moving to production environments is recommended.

This patch is for Oracle Forms only. Patches for other components can be found in MyOracleSupport.

Comments

The language shown in the Forms runtime is the result of your NLS_LANG setting in the runtime environment configuration (e.g. default.env). However, Forms can only change the language of labels it knows about. For example, the ones you highlighted. The column titles, in your example are labels that you elected to use (or column names from the DB). As a result, we cannot change them automatically because we would have no idea if that is what you wanted to do.

You would need to programmatically change those if desired. For example:

SET_LOV_COLUMN_PROPERTY ('LOV1', 2, TITLE, 'Nombre del empleado (Spanish)');

In this example, I am running a form in English but want one column to show in Spanish. So, I use the code above to make that change at runtime.

xu meng Feb 12 2025

Thanks for your reply, your example has inspired me a bit, but it still can't meet my usage needs.
I'm confused about:
When my system language variable is Chinese, I want to make the LOV component's Query/Confirm/Cancel button appear separately in other languages. As shown in the image above.
I don't know, but you can understand what I mean.

xu meng Feb 12 2025

As shown on the picture you provided. "查询" is displayed when the Chinese environment variable is used, and "FIND" is displayed when it is used in English. At present, I want to make the button of its LOV component window display "FIND" separately in the Chinese system, but I have not found the method in the help document and the network.

As I mentioned, strings built into Forms like “Find”, “Ok”, “Cancel”, and others can be translated into the language you choose in the runtime environment using the NLS_LANG settings. Unfortunately, this cannot be changed after the application has been started. So if the app is started with for example, Chinese-Traditional it cannot later be changed to French while the form is running. This means that you must either configure your server to support multiple languages and create modules for each language. This is often the best approach. There are other ways that customers have used, but what I described here likely would require the smallest effort.

You did not mention which Forms version you are using and therefore I cannot point you to the documentation for that version. However, here is the link to the related documentation for Forms 14.1.2. The concepts are basically the same for earlier versions, although some minor improvements have been introduced in the latest release (14.1.2).

https://docs.oracle.com/en/middleware/developer-tools/forms/14.1.2/working-forms/enabling-language-detection.html

But again, for strings that do not natively belong to Forms (you created them) you would need to programmatically change them as necessary.

xu meng Feb 12 2025

OH! I will try to implement your plan first. Thank you for your patience. My Forms version is 11.1.2.

As you are likely aware, but I feel it necessary to mention in case you are not, Forms 11.1.2 was desupported many years ago. I recommend you consider upgrading to the latest Supported version in order to ensure that you can get the latest bug fixes (including security fixes), the latest features, and improvements like what I mentioned about language support and others.

Details can always be found on the Forms product page.

https://www.oracle.com/application-development/technologies/forms/forms.html

xu meng Feb 12 2025

Thank you for telling me this news. I will consider your suggestion carefully and refer to it later. Thank you for your answer.

1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Pinned by Michael Ferrante-Oracle on Jul 5 2023
Locked on Mar 9 2022
Added on Feb 9 2022
0 comments
8,738 views