Service Request Form: Error FRM-40735: WHEN-VALIDATE-ITEM Trigger ORA-06502 When Installed At Address Contains a Dot (Doc ID 1960866.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Teleservice - Version 12.2.3 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.2.3 version, Service Request Form

When creating a new service request for a serial number/installed base instance that has a dot (.) in one of the Installed address fields, the Form throws the error

"FRM-40735: WHEN-VALIDATE-ITEM trigger raised an unhandled exception ORA-06502".

This error is shown in the Status area at the bottom of the screen when the user tries to leave the field Serial Number.
The Cursor jumps back to the Serial Number field and the user has to leave the field again.
The more serious problem occurs, when the user then tries to to choose a Caller (Person first name or Last Name).
In this case the same error appears again and the user is not able to leave the Caller field anymore.

This error occurs after applying patch 19318513.

ERROR
-----------------------
"FRM-40735: WHEN-VALIDATE-ITEM trigger raised an unhandled exception ORA-06502".

STEPS
-----------------------
Steps to reproduce the Problem:
1. Create or find an Installed base with only a dot (.) in one of the Address fields (for example address1 or postal code) of the installed base current address
2. Open the Service Request form and go to the Field "Serial Number"
3. Enter the serial number of the Instance
4. Press tab or click into another field. The error will appear in the status bar.
5. go to the one of the fields "First Name or "Last Name" and choose any Caller.
6. Press tab or click into another field. The error will appear again, and the entered field cannot be left.


Changes

 patch 19318513 has been applied

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms