Service Error: 'FRM -40735 :WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA -06502' When Entering Unit Price With Thousand Separator On Service Request Charges Line
(Doc ID 2038978.1)
Last updated on MARCH 25, 2019
Applies to:Oracle Teleservice - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
On : 12.1.3 version, Charges UI, APIs, and schema
Unit price with thousand separator not accepted on service request charges line
When inserting an override unit price on a charge line on a service request, if the user has a number format with thousand separator then following error is seen
FRM -40735 :WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA -06502
If the thousand separator is removed by hand then the value is accepted
The issue can be reproduced at will with the following steps:
1. Create Service Request
2. Charges tab
3. enter charge line and insert an override unit price with thousand separator
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