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: How to Ask for HelpSummary: How to ask for help in Reporting and Analytics for HCM Content: 1-Start by naming your subject area. If you don't know that, see: Common Question: In what parti… -
Common Question: How to Create a Table Style PromptSummary: The attached video shows how you can create a table style prompt. This is useful when you can't have a dashboard, but table prompts don't offer multi-select. Co…
-
Common Question: How to paste or copy an XMLSummaryExplains how to paste an XML ContentOften you may see sample reports in this forum, and this how you copy and paste the XML. 1-select new analysis 2-select a subj…
-
Common Question: How to Edit an Analysis in a DashboardSummary: Explains how to edit an existing analysis in a delivered dashboard. Content: In the relevant section on the xyz properties button, select Edit Analysis. Use Sav…
-
Common Question: In what particular subject area can I find these columns?https://community.oracle.com/customerconnect/discussion/40249/hcm-otbi-subject-areas-to-database-lineage-mapping-spreadsheet Typical Symptoms: you see columns on an appl…
-
OTBI Logical SQL complex query assembler - NOW 10 subject Areashttps://us.v-cdn.net/6034893/uploads/IRBUUHV044EZ/logical-sql-assembler-v5.xlsx Summary Now updated - Combine analyses from up to 10 different subject areas (V4) Content… -
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 … -
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…
-
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… -
Learning Records Real Time Subject AreaHi everyone, I am using the OTBI – Learning Records Real Time Subject Area to build an OTBI report and I am experiencing an unexpected behavior after updating the title …
-
"Workforce Profiles - Person Profile Real Time" no Legal employer dataSummary: Hello, Why is there no legal employer data in the "Workforce Profiles - Person Profile Real Time" subject area? All the other usual data are there (business uni…
-
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 …
-
Call a bi publisher report from redwood pageSummary: Hello, Recently we have transformed absence standard page in fusion to redwood, can I call a custom BI Publisher report from this page and pass specific paramet…
-
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…
-
Syntax Error in OTBI AnalysisSummary: Syntax Error in OTBI Analysis Content (please ensure you mask any confidential information): Hi, I'm trying to create a new OTBI Analysis. I selected "Workforce…
-
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 …
-
Assignment Category was Limbo (PRN) for entire yearSummary: I have a requirement to identify employees with an Assignment Category of Limbo (PRN) throughout the entire year 2025 or until their termination date in 2025. I…
-
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…
-
Error while downloading BIP Report in Excel FormatSummary: We are getting error while run a BIP report and try to export in Excel and other formats. When we do the same in Interactive mode no error is coming IO Exceptio…
-
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…