My Oracle Support Banner

Request A SQL Query For Generation Of Open Case Report (Doc ID 2943261.1)

Last updated on APRIL 24, 2023

Applies to:

Oracle Financial Services Enterprise Case Management - Version 8.0.7 and later
Information in this document applies to any platform.


Our business department requested us to build a report to show below information:

Case ID
Case Type
Case Priority
Case Status
Case Created Date
Case Closed Date
Event ID
Event Score
Event Type
Event Triggered Reason
Event Created Date
Customer Name
Connected/Related Party Name

Can you please give us a SQL query for building this report?


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

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