Performance Issue With CSF_DEBRIEF_PUB.CREATE_DEBRIEF API
(Doc ID 1372370.1)
Last updated on JULY 14, 2020
Applies to:Oracle Field Service - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Debrief / Field Service Report -
There is a performance issue with the CSF_DEBRIEF_PUB.CREATE_DEBRIEF API.
Whenever this API is called, it consumes 100 % resource and whole system becomes very slow.
It may take up to 2 minutes just to create one debrief record.
Upgrade from 11i to R12.1.3
The trace displays the following :
FROM CSF_DEBRIEF_LAB_LINES_V CDL,
CSF_DEBRIEF_HEADERS CDH, JTF_TASK_ASSIGNMENTS JTA,
WHERE JTA.TASK_ID = :B1 AND
JTA.TASK_ASSIGNMENT_ID = CDH.TASK_ASSIGNMENT_ID AND
CDH.DEBRIEF_HEADER_ID = CDL.DEBRIEF_HEADER_ID AND
CDL.TRANSACTION_TYPE_ID = CTT.TRANSACTION_TYPE_ID AND
CTT.LINE_ORDER_CATEGORY_CODE = 'ORDER'
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