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.
Hello, I'm trying my hand at creating some KPI's and Dashboard Visualizations for the Recruiting Activity Center (RAC) per the following documentation: Flexible Reporting in Redwood Dashboards Redwood Experience: Recruiting Dashboard When I add a session variable to my OTBI reports, I correctly see a value of 0 in my…
'Facility Name' exists in the Recruiting - Recruiting Real Time multiple times with varying usage. Job Requistion -> Job Requisition - Additional Details -> Facility Name Job Requistion -> Location -> Facility Name Is there any reason why these two Facility Names would not exist in the Recruiting - Real Time Events subject…
we have a requirement to fetch Worker Historic information like Current Job Title Previous Job Title Previous Department New Department Previous Manager New Manager Previous Location New Location which subject area stores this information in the OTBI?
Could you please provide an update on when the 26C Deprecated BI View Objects document will be available? As Oracle Cloud 26C is scheduled to roll out soon, with test environments expected to be updated on August 7, followed by the production release on August 21, we have a limited window to review and assess any potential…
Hi team, I would like to add the work order notes to my work order schedule calendar, but I'm unable to find where these notes are stored and what otbi subject to use to access them. Be great if I can be pointed in the right direction, thanks
