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
-
Synchronize Person Assignments from Position process is not workingSummary: Hi Team, We have enabled position synchronize at enterprise level - 2/17/2026 and we have loaded the positions on 1/1/2026 and assignment load on 2/1/2026. I ha… -
Seeded Process/Report/Data Model customizationSummary: Once we did customization of seeded Process/Report/Data Model, after applied any patch/upgrade then the customization changes will override. Content (please ens…
-
Does anyone have a SQL Query or OTBI report that will list by employee hours worked for the year?We are needing 2024 Paid Hours. We tried running the Periodic Payroll Activity Report but because the data is so large when including hours, it will not complete. I need…
-
Organization Calendar Events with Coverage Area Data Extraction QuerySummary: Query to extract Organization Calendar Events with Coverage Area (Geography) Content (please ensure you mask any confidential information): Hi, We have a requir… -
Court Orders - Report on field called 'Order Reference'Hi all, I'm hoping this is a quick and easy question. I'm building a report to report on Court Orders and they've asked us to include the value from the field front end …
-
Salary not populating for some termed employees in Workforce Assignment Salary History Real TimeSummary: I am using Compensation - Workforce Assignment Salary History Real Time subject area and trying to build a report to populate all termed employees and their las…
-
Oracle Email Bursting QueriesHi Team,We have a requirement to develop a bursting report that should deliver only a long formatted email body without any attachments. The email body needs to include …
-
Report notifies manager when time reported by employee is less than 4.5 hoursSummary: I need to build a report that will have coloumns Emp name, number, manager name, department, and calendar days in recent time card on which date employee report…
-
Output Manager Hierarchy in OTBI with fixed column postionsSummary: Can OTBI output all employees with their manager hierarchy in fixed positions (consistent column data)? Content (please ensure you mask any confidential informa…
-
Dynamic Hyperlink/deeplink that is more user friendlySummary: I am looking to insert a dynamic hyperlink/deeplink that is more user friendly. The current URL at the bottom of the email is very long and not user friendly at… -
HCM Position HierarchySummary: Hi Team, We have a requirement to develop a new report as like "HCM Position Hierarchy" standard report, so please share code file or file path and report name …
-
How Would I Replicate These Infolets/Dashboards for LearningSummary: I am trying to replicate these infolets under the Analytics section of an employee and managers view in MyInfo. What would be the best route to go to achieve th…
-
Audit report For Tax Withholding Calculation cards and table for Association, Federal & RegionalSummary: Need to develop a report that captures any changes made to the employee’s Tax Withholding cards such as Association,Federal, Regional. This report will be run u… -
HY000. Code: 60009. The user request exceeded the maximum query governing executioContent We have created an analysis with BI Admin role. When we are running this analysis with BI consumer/author role. we are getting error: HY000. Code: 60009. [nQSErr…
-
There is time delay to display requested absence information in the tables.Summary: There is time delay to display requested absence information in the tables ‘ANC_PER_ABS_ENTRIES’ and ‘FND_BPM_TASK_B’, Is there any other tables can be used to …
-
Ability to disbale Score update from the UI for learning adminContent (please ensure you mask any confidential information): Hi , Is there any option to disble for learner score update option for leaning administrater. Version (inc…
-
Can we remove or hide the destination from Scheduling BIP ReportsSummary: We have users who run scheduled reports in BIP but we do not wish for them to be able reports using the email selector or send anywhere else. Is there a way to … -
Display manager and employees' phone numbers on a single row in OTBI analysis reportHi I try to display the manager and employees' phone numbers and email on a single row in otbi analysis table, but without any success. For the employee, I use this form…
-
Create Report from Tags and Experience sections in ConnectionsSummary: Content (required): Hello Experts, Is it possible to create a custom report for the fields in the Connections, more specifically for Tags, Experiences, Interest… -
Create Report from Tags and Experience sections in ConnectionsSummary: Content (required): Hello Experts, Is it possible to create a custom report for the fields in the Connections, more specifically for Tags, Experiences and Inter…
-
Unable to get the data from Workforce Management - Worker Assignment Real Time in OTBISummary Unable to get the data if we include Assignment Manager, Assignment Manager (Unsecured), Assignment Manager List, or Assignment Manager List (Unsecured) foldersC…
-
Job Requisition Approval Workflow Template – Approval Comments Not VisibleSummary: Hi Oracle Community, I am working on the seeded Job Requisition Approval Workflow Notification Template in Oracle Fusion HCM and have run into an issue with app… -
Redirection link to a report using environment variableSummary: #{header["host"]} variable in page entry Static URL no longer valid Content (please ensure you mask any confidential information): Hello, I used to use #{header…
-
Absence entrySummary: absence entry error Content (please ensure you mask any confidential information): While entering absence I am getting the error " You can't record this absence…
-
Report Query to Determine Subject Area UsageSummary: With the 26A release, the Workforce Management - Vacancy Real Time subject area is being discontinued. Is there a query that can be run in OTBI that will provid… -
Clicked metric is not available for reporting or data extraction in ORC CampaignsSummary of the Issue In Oracle Recruiting Cloud, the “Clicked” metric is visible and functions correctly at the campaign level in the user interface. However, this metri… -
Query to make audit on Document of RecordsSummary: Content (please ensure you mask any confidential information): Hello experts, is there a way to track who loaded document of record type and attachments, when t… -
How to find the Report path with the report nameSummary: I have the report received to one of the recipient. The recipient request to add another person name to the report scheduling. I do not have the information whe…
-
How can we track which users have executed an Oracle Fusion BI Publisher report from the catalogSummary: We want see the Report details who ran from catalog. is there any tables which stores that info to extract. Content (please ensure you mask any confidential inf…
-
OTBI issue issue,Workforce Management – Absence Real Time subject area.Summary: Hi , OTBI issue issue, calculated absence duration when using the Workforce Management – Absence Real Time subject area. Example: Employee submitted three conse…