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

Last updated on MARCH 08, 2017

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

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