My Oracle Support Banner

Work Order Is Still Associated With Case After Deletion. (Doc ID 2973733.1)

Last updated on FEBRUARY 01, 2024

Applies to:

Oracle Fusion B2B Service Cloud Service - Version 11.13.23.04.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.23.04.0 version, Service Request

ACTUAL BEHAVIOR
---------------
Work order is still associated with Case after deletion.

We have an object validation script written on Case (Service Request) object which checks the following on the case record:
When the Status field is populated to 'Closed Resolved' & if any of Work orders associated to case has the following status:
'ORA_SVC_WO_ENROUTE','ORA_SVC_WO_PENDING','ORA_SVC_WO_STARTED','ORA_SVC_WO_SUBMITTED','ORA_SVC_WO_SUSPENDED', an error message is thrown to the user thereby preventing them from marking the Status field on case to 'Closed Resolved'. Else if there are not Work Orders for the case, the Status can be marked as 'Closed Resolved'.

Scenario: We have a case record with one Workorder, we have deleted the WorkOrder via Postman. However when we mark the case as Closed resolved it gives us the error. Somehow it seems the Work Order is still associated with the case, but the WO does not show up in Postman or UI.

Attached the file containing object validation script for reference.

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
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.