My Oracle Support Banner

Error FRM-40735 with When-validate-item Trigger When Entering a Serial Number on the Service Request Header If the Account Is Alphanumeric (Doc ID 1474735.1)

Last updated on FEBRUARY 06, 2022

Applies to:

Oracle Teleservice - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version,

When attempting to create a Service Request using an Account value that is alphanumeric, after enter the serial number in the SR header,
the following error occurs.


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

Steps to Reproduce

1. Open the Create Service Request form
2. Enter a serial number in the SR header
3. The customer information is populated but the reported error occurs.

The same issue can happen in the Contact Center Service Request tab.




To view full details, sign in with your My Oracle Support account.

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

In this Document

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