Customizing Shortcut keys in Oracle ebs r12

References-

1.    Customizing Keymapping and Resource Files for Forms on the Web -fmrweb.res, fmrpcweb.res (Doc ID 1367967.1)

Objective –

1.    One of the customer’s requirement is to change shortcut keys when using Oracle forms

2.    Typical example is using shortcut key “F10” instead of traditional “Ctrl+s” for saving/committing changes done in a form.

3.    This document applies to all version of Forms on the web from Forms 6i through Forms 11g.

4.    File fmrpcweb.res is something that needs to be studied and understood before modifying.

Understanding file fmrweb.res

Location – typical ebs r12 environment

/data/prod/apps12/apps/tech_st/10.1.2/forms/admin/resource/US

For 10gR2 (forms version)
UNIX -> ORACLE_HOME/forms/admin/resource/<country>/fmrweb.res

Windows -> ORACLE_HOME\forms\fmrweb.res

FMRWEB.RES is the key definition file for webforms. It follows below convention where every key is mapped to a number –

JFN : JMN : URKS : FFN : URFD

JFN    = Java function number

JMN  = Java modifiers number

URKS = User-readable key sequence (double-quoted)

FFN    = Forms function number

URFD = User-readable function description (double-quoted)

JAVA FUNCTION NUMBER

JAVA FUNCTION NUMBER
Number	Key	Remarks
33	PageUp
34	PageDown
35	End
36	Home
37	LeftArrow
38	UpArrow
39	RightArrow
40	DownArrow
65 - 90	Ctrl+A thru Ctrl+Z	These will always have the control modifier explicitly included, as well as any other modifiers that might be used.
112 - 123	F1 thru F12
9	Tab (Ctrl+I, without the control modifier)
10	Return (Ctrl+J, without the control modifier)

JAVA MODIFIERS NUMBER
Number	Key	Remarks
0	None	Equals to the sum of the values for the modifier keys
1	Shift
2	Control
4	Meta
8	Alt

FORMS FUNCTION NUMBER

The Forms function numbers match the function numbers found in a typical Forms key binding file.

USER-READABLE STRINGS

The double-quoted strings appear when users click [Show Keys] and are used for this purpose only. These strings can be translated as needed. Note that the strings do not affect what happens when end users press the key sequence.

Real-time sample Use-case

Before modifying and files, we need to first check value for profile –

Forms Keyboard Mapping File

Sometimes, a customized file can be used for mapping keys with form functions. This profile stores location of this custom file and will accordingly set mapping.

If the above file is blank, Oracle by default uses fmrweb.res file.

Using "F10” to save/commit changes instead of traditional "Ctrl+S". Below are original settings for saving/committing transaction/changes done in a form.

[applprod@clone US]$ cat fmrweb.res | grep "Ctrl+S"

83   : 2 : "Ctrl+S"         : 36 : "Commit"

[applprod@clone US]$

Decoding above and simplyfing –

83: “S”

2  : “Ctrl”

We first took backup of file fmrweb.res and modified it as follows –

[applprod@clone US]$ cat fmrweb.res | grep "Ctrl+S"

121   : 0 : "F10"         : 36 : "Commit"

[applprod@clone US]$

Decoding above and simplyfing –

121: “F10”

0  : “None”

After reconnecting and clearing web browser cache, we were able to use F10 for saving form changes.