My Oracle Support Banner

11i Dispatch Center Error: JTF-210029 Unable To Schedule Task After Enabling Field Service Alerts (Doc ID 1363842.1)

Last updated on JULY 14, 2020

Applies to:

Oracle Field Service - Version 11.5.10.2 and later
Information in this document applies to any platform.
Form: CSFDCMAI.fmb - Dispatch Center

Symptoms

Users are unable to schedule a Task from the Dispatch Center after enabling field service alerts.

ERROR
-----------------------

APP-JTF-210029: -20002 ORA-20002: 3825: Error '-20002 - ORA-20002: Error '
-6502 - ORA-06502: PL/SQL: numeric or value error: character string buffer too small' encountered during execution of Rule function 'CSF_ALERTS_PUB.SENDNOTIFICATION' for event 'oracle.apps.csf.alerts.sendNotification' with key 'oracle.apps.csf.createTaskAssignment-<Assignment_id>
-RS_SUPPLIER_CONTACT-<supplier_contact_id>
'encountered during execution of Rule function 'CSF_ALERTS_PUB.CHECKFORALERTS' for event 'oracle.apps.hjtf.cac.task.createTaskAssignment with'


STEPS
-----------------------
1. Setup with the following profile options:

CSF: Default Accepted Task Status: Accepted
CSF: Default Rejected Task Status : Rejected
CSF: Alert Send Preference : Immediate
CSF: Alerts Task Priority Level : Medium (Low)
CSF: Alert Response Due Time in minutes:1440
CSF: Alert Reminder Response Due Time in minutes: 2880 minutes
CSF: Enable Alerts: Yes
CSF: Alert Auto Reject : Yes

2. As part of setup, scheduled a "Background Engine" request for a Item Type "Field Service Task Assignment Alerts" to run every 5 minutes

3. Steps to reproduce the issue

a. Open Service Request Form and query for an existing open SR.
b. Create a Task.
c. Go to the Dispatch Center and try to schedule a task to a Field Technician for whom the Field Service Alert is turned on.
Note that is is not possible to assign the task, and the above mentioned error is generated.

Changes

 

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


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