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
-
Organisation Hierarchy treeSummary Organisation Hierarchy treeContent Hi, We have a requirement to pull the report of manger hierarchy in top and down. Suppose if I give employee number it should … -
How to count NULLS - OTBI Analysis reportSummary I have a basic employee extract and would like to count the number of nullsContent Hi, I have a basic employee extract report that has 12 columns from Workforce …User_2025-02-05-22-44-35-842 49 views 4 comments 0 points Most recent by User_2025-02-05-22-44-35-842 -
sql to use to find out if someone is a line a manager ?Summary sql to use to find out if someone is a line a manager ?Content What sql to use to find out if someone is a line a manager ? We dont use the manager flag at assig… -
Performance Document - Current ApproverSummary Need report for who is the current approver of a perfomance documentContent I have the report which shows the Next Performance task status. Which is great, but i…
-
Retrieving more than 500 rowsContent I have an analysis that may return more than 500 rows, however it appears 500 is the max. Is there a setting in my report, or someplace else that will increase t… -
OTBI Learning data incompleteSummary Data present on learning module not present in OTBI extractContent Hello all, Records present on the learning module not present on OTBI. Check the 3 screenshots…
-
Error: This folder is read only. You cannot create a Data Model here.Summary Error: This folder is read only. You cannot create a Data Model here.Content When saving a BI Publisher data model in a particular folder I get this error: This …
-
Report on Benefits GroupSummary BEN_BENFTS_GRPContent Hello. I am trying to link the table BEN_BENFTS_GRP (name field) back to the employees (person_id or person_number). I have tried linking i…
-
Incentive CodesSummary Incentive CodesContent Where can I find Incentive Code for reporting? I have looked in "Compensation - Salary Details Real Time" and I am able to return results … -
Report on employee careers of interestContent Hi, Has anyone built a report that indicates people and their careers of interest under career development in Oracle HCM Cloud? I am specifically looking to buil…
-
How to multiplicate two columnsContent Hello experts, I want to create a column equal to the product between other two columns. However; when I click on Edit formula I cannot successful create the for… -
Line Manager unable to view terminatedemployees in Line Manager DashboardSummary Line Manager unable to view terminated employees in Line Manager DashboardContent Hello, I am having issues with seeded 'Line Manager Dashboard / Workforce Event… -
Burst Report By Managers and Email to Individual ManagersSummary Burst Report By Managers and Email to Individual ManagersContent Hello everyone, I have a requirement where I want to create a BI Publisher report that groups em…
-
How to avoid duplicate values in reportingContent Hello experts, I have created a custom report where for each employee there is an assigned goal. Moreover, there is also a Bonus column but its value is duplicat…
-
Termination ReportSummary Termination report isn't show dataContent Hi Expert, i trying ti build a termination report that involving cross subject area between "Workforce Management - Wor…
-
Administrative Rights ListSummary List of employees with admin rights to OracleContent Hi, I need a report created for auditing purpose showing a list of all people with Administrative Rights to …User_2025-02-05-22-44-35-842 28 views 3 comments 0 points Most recent by User_2025-02-05-22-44-35-842
-
Regarding Compliance reportingSummary Regarding Compliance reportingContent Hi , I need to know if there are any seeded compliance reports available in HCM cloud for US like OFCCP ,VA and DOL reports…
-
Performance Goal weights not updated in OTBI when using performance documents.Content Hello experts I cannot find in reporting the correct weight field value about a goal that you can update from Performance Section. I can see the weight I assign …
-
Report for Identifying People ManagersSummary Looking to create a report identifying managers of people.Content Hello- We currently have the requirement to identify who are people managers/ supervisors. We d… -
Sorting in OTBISummary sorting incorrectlyContent I built a report in OTBI using the Recruiting - Recruiting Real Time subject area and I want to sort it by job requisition number so I…
-
Etext TemplateSummary How to check multiple conditions inside the square bracket?Content This condition checks only one value: SUM(Run_Results_Block/Result_Records[Run_Result_Base_Ele…
-
How to add a date promptSummary I would like to add an 'As At' date prompt to an existing basic employee analysis reportContent Hi, I'm relatively new to OTBI and unable to add a 'as at' date p…User_2025-02-05-22-44-35-842 145 views 14 comments 0 points Most recent by User_2025-02-05-22-44-35-842
-
Element Entries Report not runningSummary SQL query time exceeds the limit (500 sec). Stopped processing.Content Hi, I'm trying to run this report using just 1 legal entity on between dates: 01/08/2019 t…
-
Dashboards which Include a Date PromptSummary Dashboards which Include a Date Prompt and No Data ReturnedContent Hi, I have created a Dashboard with a Date Prompt and a BI Publisher Report. The BI Publisher … -
Dashboard with two Prompts: Selecting a value in the first Prompt changes the value in the second PrContent Hello All, In the dashboard “Performance Evaluation Comparison FCU Second Half”, there are two different Prompts, each Prompt uses the same field in OTBI "Perfor… -
My Dashboard > Not possible to print in PDF entire dashboardContent Hello All, In OTBI, we have configured the dashboard “Performance Evaluation Comparison” (PFA S1) which has 3 Sections (PFA S2 & S3): Section 1: Perf Eval Compar…
-
OTBI: Extra LOVs in FiltersSummary Example: When using filter country - all countries are shown but we only have data in the system for 7 countries.Content Hi all, Subject Area: Workforce Manageme…User_2025-02-05-05-51-12-049 29 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle
-
Missing Prompt ValuesContent I'm looking at a Manager Username Prompt, but not all the values are returning for the prompt/filter. Has anyone seen this before or know why all the options in …
-
Bursting report with two parameter is not workingSummary Developed a bursting report with two parameter. One is date and another is person number. When the report is running by selecting a date and an employee it is wo…User_2025-02-05-22-36-27-300 36 views 5 comments 0 points Most recent by User_2025-02-05-22-36-27-300
-
Tables behind transaction consoleSummary Trying to find database tables behind transaction consoleContent Hi Experts, I am trying to find tables for data shown on transaction console screen under tools.…