Sample Enterprise Capture Client Script to Force Keyed Alpha Characters to Upper Case while Retaining Numeric Keys (Doc ID 2101532.1)

Last updated on APRIL 18, 2024

Applies to:

Goal

How to force alpha characters in a field to upper case while still allowing digits and symbols?

Use Case:

A database lookup field is configured against a case-sensitive database and cannot be changed. The letters must be upper case when entered into the fields otherwise the database lookup reports no results.

The U mask for field input forces a fixed input length and prevents the entry of numbers and symbols. A regular expression does not transform characters, it merely prevents the lookup. A script appears to be the only option.

Please provide a script how to force keyed letters uppercase while retaining the ability to key numeric values.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.