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
-
Candidate Drop off ReportSummary: Hi - I am looking for an example candidate drop off report Content (please ensure you mask any confidential information): Version (include the version you are u… -
SQL query to extract employee CVHow can I extract the employees with a CV, in a BI Publisher report? Which is the SQL query that can I use? Thanks in advance!
-
-
Absence calendar inc work patternSummary: Is it possible to report on work patterns/worker availability in OTBI Content (please ensure you mask any confidential information): Hello With the ability for …
-
How to print a prompted date selectionSummary: I have an analysis with a date range prompt on the field Work Relationship Start Date. I would like to display in the report the range that the user selected. W…
-
'Range Values' in calculation factor from element definition pageHello Experts, I have requirement to get all details of calculation factor , Please check below image to identify requirement. Thanks.
-
Termination report pulling last compensation of hourly associates but not salaried associatesSummary: Term report pulling last salary of hourly associates but not salaried associates Content (please ensure you mask any confidential information): Hi! I am in need… -
Index -1 out of bounds for length 10Summary: I have used Excel Template for the data model and getting following error: Index -1 out of bounds for length 10 Issue is there was already an excel template wit…
-
Schedule report to run based on Last Run DateSummary: Is there a way to schedule a report to run starting from last run date? Content (please ensure you mask any confidential information): Version (include the vers… -
Analysis showing projected absence accrual at year endSummary: Hi We have a periodic accrual scheme for annual leave which accrues monthly at the month end. However we give our employees their entitlement up front (e.g. Mr … -
How to suppress values in OTBI?I've created an analysis under User System Usage subject area. I'd like to suppress the values like on what I've drawn below: Though I've already configured it to the co… -
Hi do you have a sample query for sql oracle that will provide Hours ?Hi, We have a requirement from client that we need to provide the hours of an employee but this is the logic. If regular employee - Get the Hours from Element Entry If A…
-
How to get when candidate moved to next step or status - BI TaleoSummary: I have a report request to show list of submissions indicating submission date and date moved to next step or status. This data extract shall show the submissio…
-
Are there any jobs to schedule hourly/daily/weekly for OTBI?Summary: We have schedule jobs for various areas of HCM but nothing that runs hourly/daily/weekly for OTBI reporting. Are there any jobs that you can recommend to schedu…
-
Headcount is Overstated in Pie Charts when using EthnicityHello everyone! I would like to make a pie chart to show the percentage of each of our candidates by ethnicity. The problem is this: When candidates select multiple ethn…
-
Employee Advance details in oracle Fusion HCMSummary: Employee Advance details in oracle Fusion HCM Content (please ensure you mask any confidential information): Hi, Please help to identify table/query for Employe…
-
DNUSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Charts in bip how to use more value columns in oracle hcm fusionSummary: Issue: 1- When I create chart it maximum allows to add 5 values but I have more than that to be added. 2- Percent split inside the bars how to display ? How to …
-
MAX last modified date in Dev Goal Count Report returning blank fieldSummary: I am trying to create a report that will pull the entire employee population along with their Development Goal Counts and the most recent date they made a modif… -
Is the Revoke User Access field from HCM termination process available in BI Publisher?Summary: The field "Revoke User Access" stores option of revoking user access on Termination. We need to pull it in a BI Publisher report, but we have not been able to f…
-
CSV output in body and attachmentSummary: Is it possible to show data in CSV format in the body of the email bursting as well as in an attachment? Content (please ensure you mask any confidential inform… -
V3 seniority date column Mapping in OTBI Subject area??Could you please tell us anyone what is the exact column for seniority date using in the subject areas for v3 ? Workforce Management - Work Relationship Real Time Workfo…
-
How to create a report with full and part time EMP count as per department ?I have created a headcount report with basic employee info. I want to modify it such that it has Emp ID, Dept ID, Full time & Part Time Empl count. Basically I am lookin…
-
SQL Query Timeout is greyed outSummary: SQL Query Timeout is greyed out. I have logged into xmlpserver but is still unable to change the SQL Query Timeout. Is this field no longer updatable? Content (…
-
How to add a count column for employees aligned to a job in OTBI.Summary: I have created a report in OTBI to show all job names in our business. I need to create a column which does a count on the number of employees who have this job…
-
Please guide how to get audit trail report for "Add / Modify Reports" and "Modify Configuration".Please guide how to get audit trail report for "Add / Modify Reports" and "Modify Configuration". We want to check who is add a new report or modify any report in tools …
-
Table containing Attestation details for Activities - Oracle BI PublisherSummary: Need to know which tables store the Attestation details for the Learning module, which is available in the Activities section page. Content (please ensure you m…
-
Moved: How to Disable/Remove/Hide Inline Attachments in Attachments Category in HR Help DeskThis discussion has been moved. -
Changing Aggregation/Group of Column in OTBIHello, I have a Logical SQL report to combine data from the "Workforce Succession Management - Incumbent Plans Real Time" and "Workforce Succession Management - Plan Can… -
How do I add last salary and manager details in terminations report ?I am using Workforce Management - Worker Assignment event real time to pull the terminated employees. . I have joined the compensation real time salary details to pull t…