My Oracle Support Banner

Service Requests With Status = Closed Being Displayed In The User Interface When Querying For Status <> 'Closed' (Doc ID 3018673.1)

Last updated on APRIL 24, 2024

Applies to:

Siebel CRM - Version 23.4 and later
Information in this document applies to any platform.

Symptoms

When running a query for All Service Requests View where Status <> Closed, Closed SRs are showing up in the SR screen.

The SR_STAT_ID in S_SRV_REQ_BU has a value of Open even though the  SR_STAT_ID is Closed in S_SRV_REQ

The issue can be reproduced at will with the following steps:

1. Navigate to Service Requests > All Service Requests
2. Run a Query where Status <> Closed
3. Note that a couple of records where Status = Closed are displayed

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


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