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
-
Common Question: In what particular subject area can I find these columns?Typical Symptoms: you see columns on an application page and you want to know where they are in OTBI. Content: navigate to and download the latest database lineage mappi… -
Common Question: I didn't get any rows in the subject area, what's wrong?Typical Symptoms: you selected columns and didn't see any results, or once you added certain column/s, then you didn't see any results. Content: Q: "I didn't get any row…
-
OTBI Workforce Trend: For better performance, use equi-filter on Calendar Month End Date columnSummary: This is an announcement to provide guidance to improve response time of Workforce Trend reports and dashboards. Content (required): 1- Response time of reports … -
OTBI Logical SQL complex query assembler - NOW 10 subject AreasSummary Now updated - Combine analyses from up to 10 different subject areas (V4) Content It was already posted on OBIEE forum, but I figured HCM would be a demanding th… -
Is it possible to add a field to an OTBI analysis that uses sql to query the underlying oracle tableSummary: We have an existing OBTI Analysis that reports on candidate from ORC. We need to add that a field from the Extra Info section of the candidates profile, the Des… -
Week Number calculation for OTL Overtime report if week starts from saturday and end on fridaySummary: Hi Team, We need to calculate the weeknumber for a overtime card report. Week will start from saturday and end on friday We need to pass "from week" and "to wee… -
Mass Download of Document Records errorsSummary: Can you get details on the skipped downloads or those with errors? Content (please ensure you mask any confidential information): This is in the log file: Total…
-
Can I speed up the search for people who successfully completed a course?Summary: I need to generate a list of who's completed a specific course. I don't care how often they've completed it - I just need to know if they've got at least one su…
-
📄 OTBI Report to Generate HDL File for Deleting Feedback RequestsSummary: This provides a custom OTBI report built on the Workforce Performance – Requested Feedback subject area. It helps companies generate HDL-formatted data to delet… -
Processing Bar Not Visible During Report Generation – Needs Left Alignment or Fixed PositionSummary: When running a wide report, the Processing bar appears centered on the report, making it not visible unless the user scrolls horizontally. This causes confusion…
-
Oracle Fusion BI Publisher - Excel Template - Generate Multisheet Report Excel OutputSummary: Hi Team, We have a requirement where we need to generate an excel output with 3 tabs in the output file. Sheet1 name: Static value as "Parameter" and it has to …
-
SQL query to fetch the Candidate university name from Academic qualification section in ORCHi Team, Need assistance, we are trying to fetch the university name from the candidate education qualification section. But not getting the data from this table IRC_PRO…
-
Help Desk Data only role for access to reporting for HR Service Requests and Knowledge ManagementSummary: I am trying to provide access to a Help Desk and Knowledge dashboard for users that cannot access the Help Desk and Knowledge modules. The subject areas that th… -
Why IRC_HTTP_REQUESTS is having blank when there is a data in Recruiting Messaging ConfigurationSummary: Hi Team, The SMS communication information is stored in IRC_COMM_ACCOUNTS but We are not getting anything in these tables IRC_HTTP_REQUESTS, IRC_HTTP_BODY_TOKEN…
-
BI Publisher – Is it Possible to Reposition the 'Processing' Notification for Wide Reports?Summary: In BI Publisher, when running a report that is horizontally wide, the "Processing" notification only appears near the center of the report layout. This requires…
-
User unable to run OTBI report but could in the pastSummary: All of a sudden this user is not able to run reports specific to ORC. I cleared the server cache but it's still not working. Any ideas prior to logging an SR? C… -
Issue with dependent parameters of report in fusion HCMHi Team, We have a requirement to create a report which would fetch the latest extract flow name w.r.t Legislative data group. Currently we have two parameters of LDG an…
-
Under Payroll relationship, end date is not updating when reverse termination payroll performedSummary: When we performed reverse terminate payroll under Payroll relationship> Payroll Association, End date is not reverted . Post Reverted , End date is not changed …
-
Can I hide Add Assignee button in the Assign Journey page through Visual builder StudioSummary: Can I hide ‘Add Assignee’ button in the Assign Journey page through visual builder studio in redwood?. Kindly let me know, Attaching one document for the refere…
-
Is full HCM testing required before Prod update?Summary: Seeking Oracle’s official guidance on whether full regression testing is mandatory before promoting a quarterly update to the Production environment for HCM Clo…Mohamed Yousif Mohamed Gadalla 11 views 0 comments 0 points Started by Mohamed Yousif Mohamed Gadalla -
How to get average years of service by company and gender in OTBI?Summary: I need to create an OTBI report to calculate years of service by company and gender. Content (please ensure you mask any confidential information): This is my s… -
OTBI Report isn't showing all employees' dataSummary: OTBI Report isn't showing all employees' data. shows only Person number and name. Content (please ensure you mask any confidential information): When creating O…
-
Does exist an official/unofficial presentation for OTBI reporting training?Summary: Looking for OTBI reporting training presentations. Content (please ensure you mask any confidential information): I need to teach the customer how to use OTBI r…
-
Birthday In Next 7 Days (Birthday THIS WEEK)Summary: Could someone please share an OTBI Birthday report that can be scheduled to run every Monday, showing Birthdays that week (Monday thru Sunday). For example, whe…
-
Is there a table that store calculated time in time cardHello, I would like to ask whether this information is stored directly in a specific table or if it is derived through a calculation. Kindly advise. I've seen this view …
-
How to connect to Oracle HCM Cloud to Power BI using CDataSummary: We are trying to connect to Oracle HCM Cloud to Power BI using CData ( https://www.cdata.com/drivers/oraclehcm/powerbi/ ) So, our PowerBI developers can utilize…
-
Tables Containing Approval History with Approver Names and Statuses in Oracle HCMHi! Which tables contain the information from the Approval History section, including the names of the approvers and their statuses? Do you have an example query?
-
Did oracle will allow to trigger bursting email to 60K candidates at once?Hi Team, We have requirement to trigger bursting email notifications to 60K candidates. Did our fusion application will allow to send notification to the 60K employees a…
-
How to attach custom layout in BPM Task for Workflow Notification for Document of RecordsSummary: We have created a Document of Record to submit Time Anomalies. When user submits Time anomaly request, it goes to the line manager. User is submitting the time …
-
How to join Transaction ID with Assignment IdentifierSummary: We are trying to join "Compensation - Individual Compensation Real Time" with "Human Capital Management - Approval Notification Archive Real Time". This is so t…
-
Headcount is different across Line Manager Dashboard and reportingSummary: Hi, I am having an issue at the moment where the Line Manager Dashboard is showing me 5.8k Headcount and 5.1k FTE, but my OTBI report is picking up 6159 active …
-
UI End-Date and Database Records for Bank AccountsSummary: Hi everyone, I recently inactivated a bank account using the checkbox, and now I see a mismatch with the end date. The UI shows it as 01/07/2025, but the tables…
-
Additional details needed on Recruiting – Candidate Tracking Real Time subject area.We are developing a report in the Recruiting – Candidate Tracking Real Time subject area. Objective: Our goal is to extract a report that shows candidates activities per…
-
BIP Parameters Not Working Correctly with SQL in Data Model and ReportHi all, I'm hoping someone can possibly take a look and help me out with an issue we're having with our BIP Data Model and SQL. We're needing to build an OTBI based repo…