ORA-1403:No Data found in Task Manager form when Assignee name longer than 30 characters. (Doc ID 2014146.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Common Applications Calendar - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On :  12.1.3 version, TASKS

If the Assignee name is longer than 30 characters,  the following errors are seen in the Task Manager form:
 1. Opening the task page.
 2. then using the More (button)  > Assignment Audit(button) .

 ERROR
 -----------------------
 ORA-1403:no data found
 FRM-40735: POST-QUERY trigger raised unhandled exception ORA-6502.

STEPS
-----

Responsibility : CRM Administrator
Navigation:  Task and Escalation Manager - Tasks - Tasks

 Search for a Task with Assignee name more than30 characters
 Open this Task page , once returned, got the error
 Click More button
 Click Assignment Audit tab

 

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