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
-
Extra blank line in Excel output from BI Publisher RTF template due to using page break to get multiSummary Extra blank line in Excel output from BI Publisher RTF template due to using page break to get multiple tabsContent Hi Experts, I have a problem. There is a BI R… -
Learning Subject Area and Organisation Structure Reporting PerformanceSummary: Hi, we have an issue where trying to filter on Org Structure for Learning reporting results in the reports either timing out or taking 10+ minutes to run for a … -
How to test Enhanced BIP Notifications to Display Assignment Notes in Redwood Employment ProcessesHi Team, Has anyone tested Feature 26A: Enhanced BIP Notifications to Display Assignment Notes in Redwood Employment Processes? Oracle’s release notes say this change “a…
-
Report on Parent Position's Current Incumbent when Position is vacantContent We need a way to report on the parent position's current incumbent when the position itself is vacant. The report that we created shows the incumbent name for bo…
-
Retrieving learner-submitted attachments through the BI reportSummary: I need to fetch learner-uploaded attachment details via the BI report from the specified path below. UI Path - Edit Assignment > Related Materials > Learning As…
-
Oracle BI Report bursting throwing errorHi Team, I created 5 reports and all 5 are scheduled in Prod. Only 1 report is getting failed while bursting. Getting below error. Detail Message: ::JOB_WAIT_TIME_SECOND…
-
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…
-
Need query to get the list of all users for a given roleSummary: Need query to get the list of all users for a given role Could you pleaes provide me the query to get list of all users for a given role. attached the screen sh…
-
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…
-
HCM OTBI subject areas to database lineage mapping spreadsheetThis spreadsheet documents HCM OTBI subject areas to database lineage mapping and subject area security. Content This spreadsheet is published by Oracle OTBI Development… -
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…