Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
Job Grade ReportSummary Report to connect Job Info to GradesContent I am looking for a way to pull on a single report Job Code, Job Name, Family, Function, Management Level, Job Level, …User_2025-01-23-23-44-45-599 171 views 6 comments 0 points Most recent by User_2025-01-23-23-44-45-599 -
AutomailerSummary There is a requirement to create an automailer to employees with pdf outputs of two different BI reports as attachmentContent There is a requirement to create an… -
How to display data in one row?Content I created a custom analysis to show performance ratings of employees but it shows manager ratings and employee ratings in two rows for the same performance docum…User_2025-01-28-21-18-43-496 77 views 2 comments 0 points Most recent by User_2025-01-29-23-59-58-976
-
BIP Report for Absences Taken & Absences EligibleSummary How do I report on taken absences vs eligible absences?Content Hi all - I have a customer request for reporting on the vacation an employee is eligible to take f… -
Term with RehireSummary When adding additional subject area, termination category is blank.Content I have a termination report with the Worker Assignment subject area, worked great. How…
-
Ability to report on historic versions of the Org Tree using OTBISummary Ability to report on historic versions of the Org Tree using OTBIContent Hello Team, Does OTBI has the ability to report on historic version of Org tree? I tried… -
Report on Work Schedule AssignmentsSummary Trying to find the subject area that includes the Work Schedule Assignment informationContent I need to create a report that shows any employee who does not have… -
Date format 'DD-Mon-YYYY' in OTBI Analysis PromptContent Can anyone please guide how to get the date format 'DD-Mon-YYYY' in the OTBI Analysis prompt. Please see the screen-shot attached, where I want to achieve it. -
how to get business unit name from assignments?Summary how to get business unit name of assignments in BI reportContent Hi, I'm developing BI report using SQL script on HCM Cloud. User requested to add business unit …
-
SQL Script for Worker's departmentContent Hi All, I am trying to get the worker's department along with his name, person number, manager etc. I use the following script to get the department; SELECT DIST… -
BI Publisher - inner joinContent Hello, I have 2 questions about bi publisher data model is there a way to create an inner join between 2 data set in Bi publisher? by default when we create a li…User_2025-01-25-01-33-46-269 63 views 0 comments 0 points Most recent by User_2025-01-25-01-33-46-269
-
How security works in case of custom report?Content Hello everyone, When we are using OTBI report it is following the security profile of the user logged in and in case of bip reports we have to use secured tables…User_2025-01-25-06-20-12-259 132 views 4 comments 2 points Most recent by User_2025-01-25-06-20-12-259
-
Tables and Views against OTBI Subject AreasContent Hi, Is there any resource available to refer Tables and Views against OTBI Subject Areas? Because referring OER is quite time consuming. Thanks and Regards Achala
-
Absence and assignment details as of an effective dateContent Hi, I'm building an anaylsis in the Absence Real Time Subject Area using fields from the Worker folder and some key information from the Assignment Absence Detai…
-
performance document - get date of transferContent Hello, I am trying to find when a performance document have been transferred to a new manager. Is someone know in with table (bi publisher or otbi) I can get the…User_2025-01-25-01-33-46-269 42 views 4 comments 1 point Most recent by User_2025-01-25-01-33-46-269
-
Limit Prompt Choice List Values by UserSummary I'd like the choice list values for my prompts to be only the values the logged in user should see.Content My dashboard prompts are Business Unit, Department Nam…User_2025-01-25-00-37-41-739 91 views 2 comments 2 points Most recent by User_2025-01-25-00-37-41-739
-
Using Two Subject Matter AreasSummary When I add the additional subject matter area (Workforce Management- Work Relationship) and then add rehire recommendation, I get an error.Content Hello All, I a…User_2025-03-07-21-07-25-805 53 views 4 comments 0 points Most recent by User_2025-03-07-21-07-25-805
-
OTBI Report in DashboardContent I need to build a graph for the person headcount for different actions and then embed that graph in the dashboard. I understand that the person having the HR spe…
-
Finding Active Assignments with Inactive ManagersContent I need to find Active Assignments where any of the Matrix Managers are inactive. (though I'd settle for line managers) I could create an analysis of Inactive ass… -
Effective Dated Headcount Report with SalaryContent Attempting to create an effective dated Headcount report with salary details that reports data as of a prompted point in time. Able to create the report to inclu…User_2025-01-28-08-31-49-398 138 views 3 comments 1 point Most recent by Raghavendra Raghunath-Oracle
-
Hierarchy Traversal in BI Data Model ReportContent Please refer to the images attached. Referring to IMAGE1. In column level we want to show business unit in level2(by default on opening the report) from the orga…
-
Report showing Employee's Line Manager and Business Unit DirectorContent Hi All, I am struggling to create a report showing an Employee's direct Line Manager and Business Unit Director. When I create it, I get the hierarchy for that e… -
Integrating Open Requisition Details from Taleo in Cloud HCM OTBI ReportsSummary Integrated Taleo and Cloud HCM Reporting in Cloud HCM OTBIContent We would like to be able to report the open positions along with the headcount and a basic leve…
-
Job Competency ReportContent Morning all, I'm looking to build a basic report that shows the competencies we have built against each job profile, but I'm struggling to find what subject area…User_2025-01-28-05-39-23-766 57 views 2 comments 0 points Most recent by User_2025-01-28-05-39-23-766
-
using OBIE analysis as a data model in BIPSummary using OBIE analysis as a data model in BIPContent Hello, We would like to distribute OBIE analysis using the BIP bursting mechanism. Can we used OBIE analysis as…
-
Date subtraction in eText templateContent Hi All, I am facing issues in date manipulation in the eText Template. Seeded date functions are not working and traditional date subtraction are not returning v…
-
Change report to automatically select records two months priorSummary Automation of report selecting records two months priorContent I have a report that I run each month which is then sent to another department. The purpose of the…
-
Reading file from Content ServerSummary Reading file from Content ServerContent We have a requirement to read a document/attachment from content server and display it on a report as either a link or to…
-
Bursting Name Changes Details to EmailSummary Name Changes Only Extract IssueContent Hi Team, We have a requirement to capture all the Name changes (Old and New) happening in the system for Active employees …
-
Pivot Table - adding a column to total values per sectionSummary adding a column to sum values in each sectionContent We have a goal plan which is sectioned by goal categories. I am creating a report for our goal admins for th…