My Oracle Support Banner

Getting ORA-01722: Invalid Number While Clicking On Tasks Tab Of Service Request Form. (Doc ID 2198928.1)

Last updated on OCTOBER 15, 2018

Applies to:

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

Symptoms

Getting ORA-01722: invalid number while clicking on Tasks Tab of service request form.  
We are getting above error when we click on the Tasks tab. It happens with all Service Requests and Tasks.
 
Errors:

* SR Form:
         ORA-01722: invalid number
         FRM-40735: ON-INSERT trigger raised unhandled exception ORA-01722.

* Task Form:
         FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06502.

* FND Log:

[...]
wf.plsql.WF_EVENT.raise3.Begin Event Name:oracle.apps.fnd.system.exception Event Key:16820008Maximum nested raise count:100Nested raise count: 0
wf.plsql.WF_EVENT.dispatch.Begin Dispatching event oracle.apps.fnd.system.exception

CSM_HA_EVENT_PKG.TRACK_HA_RECORD Entering TRACK_HA_RECORD with JTF_TASKS_B-123456-I-N-
CSM_HA_EVENT_PKG.GET_HA_PROFILE_VALUE Current HA Profile value :
CSM_HA_EVENT_PKG.TRACK_HA_RECORD Leaving TRACK_HA_RECORD as tracking is switched OFF

[...]

wf.plsql.WF_OBJECT_CACHE.GetObject.Begin Getting {oracle.apps.jtf.cac.task.createTask} from cache {1}
wf.plsql.WF_OBJECT_CACHE.GetObject.Cache_Hit Object found in cache for {oracle.apps.jtf.cac.task.createTask}
wf.plsql.WF_BES_CACHE.GetSubscriptions.Load_Subs Subscriptions for {oracle.apps.jtf.cac.task.createTask} is not already loaded. Loading from DB for Source Type {LOCAL} Source Agt {}
wf.plsql.WF_BES_CACHE.Load_Subscriptions.active_subs Using cursor active_subs for event {oracle.apps.jtf.cac.task.createTask}
wf.plsql.WF_BES_CACHE.Load_Subscriptions.End Loaded {5} LOCAL subscriptions for event {oracle.apps.jtf.cac.task.createTask}


Steps:

(R) Service
(N) Service Requests > Create Service Requests

- Open Service SR
- Navigate to the Tasks tab:

Trying to create a new Task - mandatory fields are defaulted.

=> Error:
         ORA-01722: invalid number
         FRM-40735: ON-INSERT trigger raised unhandled exception ORA-01722.

Populated Subject
Updated Owner Type = Employee Resource
Owner  = < John Smith >

=> Same error.

Changes

 Issue started after applying patches recommended in SR 3-12946087111 - task auto notification is not working:

. Patch 12970976:R12.CAC.B: FWDPORT:9789911:12.1.1:12.1.1:NOTIFICATION OF TASK ASSIGNMENT IS ARBITRARY
. Patch 22951951:R12.CAC.B: TASK ASSIGNMENT AUDIT RECORDS ARE NOT DISPLAYED IN ORDER (BY DATE).

Cause

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
Symptoms
Changes
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.