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 220.127.116.11 and later
Information in this document applies to any platform.
Form: CSFDCMAI.fmb - Dispatch Center
Users are unable to schedule a Task from the Dispatch Center after enabling field service alerts.
-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>
'encountered during execution of Rule function 'CSF_ALERTS_PUB.CHECKFORALERTS' for event 'oracle.apps.hjtf.cac.task.createTaskAssignment with'
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.
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