Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Reporting SRs information — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Reporting SRs information

Accepted answer
37
Views
3
Comments
edited Jun 12, 2020 7:13PM in Work Life Solutions 3 comments

Summary

Report SRs information

Content

Hi, I am currently creating an analysis to report on the SR status (Using subject area Service - CRM Service Request Real Time). I am having trouble locating the "Location" of the person that submitted the SR. I am able to find the person (contact) but cannot find the actual location.
I was told that location is a formula field so cannot be reported. I'd like to understand this a bit more and maybe find an alternative solution.
I have added the code snippet.

Thanks

Version

20B

Code Snippet

SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT
   0 s_0,
   "Service - CRM Service Requests Real Time"."Contact"."Full Name" s_1,
   "Service - CRM Service Requests Real Time"."Employee"."Employee Name" s_2,
   "Service - CRM Service Requests Real Time"."Service Category"."Base Service Category Name" s_3,
   "Service - CRM Service Requests Real Time"."Service Request Queue"."Queue Id" s_4,
   "Service - CRM Service Requests Real Time"."Service Request Queue"."Queue Name" s_5,
   "Service - CRM Service Requests Real Time"."Service Request"."Channel Type" s_6,
   "Service - CRM Service Requests Real Time"."Service Request"."Creation Date" s_7,
   "Service -
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!