Get Started with Redwood for Oracle Cloud HCM Begin Now
Reporting SRs information
Summary
Report SRs informationContent
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
20BCode 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:
2