Summary:
Content (required):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
Hi Abhishek,
Thank you for posting about reporting on organization hierarchy.
Please note that we have some out of the box analysis under /shared/Sales/Subject Area Contents/Saved Queries - OTBI under this folder you have some filters created and you can adjust accordingly.
Or you can also create an analysis based on Sales - CRM Resource and retrieve the hierarchy from Employee / Sales Resource Hierarchy folder. For further details about the subject area, please refer the doc https://docs.oracle.com/en/cloud/saas/sales/22c/faoec/Sales--CRM-Resource-SA-75.html#Sales__CRM_Resource_SA_75_d1e39084
If my response has answered your question, please click "yes" below to accept the answer or comment with any additional queries. You can also read the Cloud Customer Connect Guidelines for Accepted Answer.
Regards,
Priscila Terazawa
Hi @Priscila Terazawa-Support-Oracle
Thanks for your quick response.
Unfortunately, I don't see any out of box queries in given path: /shared/Sales/Subject Area Contents/Saved Queries - OTBI.. most probably, they are only available with an admin access levels.
Sales - CRM Resource and retrieve the hierarchy from Employee / Sales Resource Hierarchy folder: Apologies, but can I ask you where to look out for this folder, as when i try to look out for 'Sales Hierarchy folder', I am not exactly sure which subject area to look for.
I was using WF Management - Worker Assignment Real Time subject area in my report & would like to add the correct hierarchy fields. The report I am trying to build is a type of HC report.
Thank you in advance for your assistance.
Abhishek
Apologies for the delay.
The Organization Hierarchy I mentioned is the Sales/Service Organization that you setup in Resource Directory. I checked the mentioned subject area and I don't see it there.
Sorry about that.
Priscila
Hi @Priscila Terazawa-Support-Oracle -
No worries - thanks for your response & assistance.
We have built an OTBI report intended for Line Managers to view their subordinates’ emergency contact details. The report uses the Workforce Management - Person Real Time subject area. When a Line Manager runs the report, the emergency contact fields (e.g. EC Phone Type, EC Phone Number, EC Email Type and EC Email Address)…
Hi All, Good Day. We have created one custom OTBI report and it has "Business Unit" as of one of the parameter. The related list of values is showing all the business units and we want to restrict it to the user who has the related Business Unit data access set access. Please let us know how to achieve this in OTBI report.
I have a Leave Details Report with the condition below to restrict the report based on the logged-in user's AOR. However, the report is not returning any data for any legislation, when users run it under the 'About Me' context.
Our Requisition OTBI analysis is having many values Requisition Number Requisition Title Requisition Status Hiring Manager Full Name Recruiter Full Name am able to see values for all. When am passing Prompt(Hiring Manager Full Name or Recruiter Full Name) am not able to see the data. Am sure we have values/data for passed…