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
-
Report shows no results for certain usersHello, We are facing an issue regarding the ability to view a report of the subject Area of Workforce Management - Checklist Real Time. Here is the report that we have c… -
BICC PVO HcmApprovalsTaskP1 Missing Pending Approval Tasks (Learning Requests / HCM Approvals)Hello Team, We have a query from Oracle to retrieve approval details for a Learning Request. We are working in OBICC (Oracle Business Intelligence Cloud Connector Consol… -
Additional Information from Accrual Plan BalanceSummary Require Table and column name for additional information fieldContent Hi Team, I need to extract the additional information field description for the Absence Pla… -
What Caused the seeded Payroll Activity report to be updated on 11/27/2025?Summary: Want to understand why the seeded Payroll Activity Report has a Last Modified Date of 11/27/2025? and Owwner is System Account Content (please ensure you mask a… -
Talent Review Meeting Real Time - In Holding Area (Yes/No) and Box Assignment Valuehttps://us.v-cdn.net/6034893/uploads/DTQXBK9OTENZ/talent-review-xml.txt Trying to recreate the Table view of the 9 Box in OTBI (My Client Groups > Talent Review > 3 Dots… -
Unable to open the DM after UnachiveSummary: We successfully Unarchive Data model but unable to Open the Data Model Content (required): We Archive the Data Model from one instance and successfully Unarchiv… -
sql query to get job level in oracle fusionSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
Agents used to Schedule Analyses not working since 25DSince the 25D update, we can no longer edit or create new Agents for our Analyses. Everything was working normally before 25D. It looks like the update disabled the “Ena… -
Sql query or Table for Worksheet Display and Default Worksheet Display assigned to compensation planHi team, Sql query or Table where the information stored for Worksheet Display and Default Worksheet Display assigned to workforce compensation plan in HCM compensation … -
Creating Multi sheet in Excel template based on Assignment action codeSummary: We are in need of generating multi sheets in which HIRE/REHIRE records are in one sheet and Assignment changes and Termination records are in different sheet(Wh… -
Audit Report - On Folder Permissions ChangesSummary: Content (required): We have a requirement on Auditing folder Permissions Changes on any OTBI folders This report in theory needs to show us When and Who and Wha… -
Query to get Deleted users and rolesSummary Need query to get deleted users and role data from FusionContent Is there any table that will provide us the list of deleted users and roles from Fusion. We were… -
Report on responses from learning assessments and observation checklistsSummary: Report on responses from learning assessments and observation checklists Content (please ensure you mask any confidential information): Can you report on respon… -
How to customize the sub template for Termination Report?Summary: How to customize the sub template for Termination Report? Content (required): Hi All, How to customize the sub template for Termination Report? Where I can find… -
25D - Text Object "Contains HTML/Javascript/CSS Markup" Option remvoedHello, We've recently upgraded our DEV environment to 25D. We're now finding that the option to include text that contains HTML has been removed. Was this documented any… -
Where to Find Extract Data Stores Documentation for HCM related PVO'sSummary: Hello, We are unable to find the documentation for the Extract Data Stores for HCM . The same is available for Financials, Procurement and SCM. Can you please a… -
How do we add the self-paced learning items to our custom reports on user's learning?Summary: We created reports to pull the employees and their learning assignments, completions, etc. based on the course. Now with self-paced learning, these new items ar… -
BI Publisher Emergency Contact ReportSummary Building Emergency Contact Report in BI PublisherContent Hi Everyone, I am currently struggling in producing a BI Publisher report for emergency contacts, i know… -
OTBI Performance and Timeout Errors For End UsersHi all, I'm wondering if anyone has any suggestions on how to work out some issues with some analyses we're using for a dashboard our business uses. We've built several … -
How to identify if a goal has been added from the goal library?Summary: I have created two basic reports showing employee performance and development goals. I want to know how many of those goals have been added from the goal librar… -
How to perform conditional formatting on Excel template when old value is not equal to newSummary: I have built a Changes only extract to get the employee Demographic information and getting data in Excel format in separate sheets. First sheet contains new hi… -
TimecardApprovalNotificationReportSummary: I am getting the below error when i try to view the data model of TimecardApprovalNotificationReport HCM folder. Can anyone please suggest the solution. ORA-009… -
Unable to report on Guided Journey QuestionnaireSummary: We've created a guided journey questionnaire as part of the requisition process for hiring managers, however we are unable to report on the data. We've had an S… -
Excel Export Limit Differences Between Prod and CTN (Dev Environments)Hi all, Would anyone happen to know why we appear to have different limits set for exporting OTBI analyses between our production and CTN environments? We're looking to … -
Logo not displaying in HTML format in seeded Performance Document Worker and Manager Rating ReportThere was an error rendering this rich post. -
Query required to fetch the fields - Resident PSD Code, Resident School District, Work PSD Code.Hi, Does anybody have a query that will fetch the fields - Resident PSD Code, Resident School District, Work PSD Code, Work School District. These fields are present in … -
table/view to list all users with assigned role namesSummary: table/view to list all users with assigned role names Content (please ensure you mask any confidential information): I am looking for an Oracle Table/View name … -
oracle.xdo.template.online.dms.common.XDODmsException: IO Exception was thrown! nullSummary: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.template.online.dms.common.XDODm… -
Restrict user to go to Analytics pageIs there a way to restrict user to access to Reports & Analytics page. From Structure i have disable the Report & analytics page from Navigator and springboard. But we a… -
Problem with scheduling OTBI reports - error messagesContent I've set up loads of scheduled OTBI reports in the last few months. Although they are still coming through by email when they should, if I try to set up any new …