My Oracle Support Banner

Date Field Show Different Values in Oracle Service UI Vs OTBI Report (Doc ID 3037208.1)

Last updated on JULY 24, 2024

Applies to:

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

Symptoms

On : 11.13.24.04.0 version, Analytics

ACTUAL BEHAVIOR
---------------


Running report similar to below:

SELECT

   "Service - CRM Service Request Lifecycle"."Service Request Extension"."Extension Attribute LOV 027" s_1,

   "Service - CRM Service Request Lifecycle"."Service Request Extension"."Extension Attribute Timestamp 022" s_2,

   "Service - CRM Service Request Lifecycle"."Service Request"."Service Request Number" s_3

FROM "Service - CRM Service Request Lifecycle"

FETCH FIRST 75001 ROWS ONLY

Prompt is created on "Service - CRM Service Request Lifecycle"."Service Request Extension"."Extension Attribute Timestamp 022"

If Service requests are searched with this Date field, output results are different Oracle CX Sales Cloud & Services X OTBI

OTBI: Returns 5 rows

ORACLE CX: Return 6 rows


 

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.