Serial Number Field Length Mismatch in CSF_DEBRIEF_UPDATE_PKG and CSP_TRANSACTIONS_PUB
(Doc ID 2917623.1)
Last updated on DECEMBER 27, 2022
Applies to:
Oracle Field Service - Version 12.2.6 and laterInformation in this document applies to any platform.
Symptoms
In CSP_TRANSACTIONS_PUB package, SERIAL_NUMBER is defined as VARCHAR2(25) in Trans_Items_Rec_Type, while in CSF_DEBRIEF_UPDATE_PKG it is defined as VARCHAR2(30).
This will lead to debrief errors if a serial number with more than 25 characters is used for the transaction.
STEPS TO REPRODUCE
-----------------------
The issue can be reproduced at will with the following steps:
1. Log in with Field Service Manager responsibility.
2. Navigate to Service Requests/Create Service Requests.
3. Query for Service Request and go to Task tab and click Debrief Button.
4. Enter a debrief line with a serial number with more than 25 characters.
6. Submit the debrief.
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 |