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
Get Started with Redwood for Oracle Cloud HCM   Begin Now

Reporting SRs information

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!