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: 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… -
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…
-
Bursting sending one consolidated email instead of multiple emailsSummary: Needs to send one email to Manager with consolidated notifications of all the employees instead of sending one notification for each employees. Content (please … -
Infolet Section says Refresh to Load after LoginSummary Infolet Section does not load Infolets by DefaultContent We are on 19C and on news feed. I have enabled HCM infolets and infact made couple of infolets. But What… -
ORC report to show the most progressed candidate phase for every open requisitionHello - We want to create a report to provide recruiters a list of all open requisitions and the phase of the most progressed candidate for the respective requisition. W… -
I want SQL query to fetch data from talent review meetings , employee view potential assessmentSummary: below question and answers i need to fetch against the employee. (navigation talent review meeting in progress → select any employee in meeting → Actions tab→ v…
-
Need PVO name to fetch additional attributes from Assignment DFFSummary:We have additional attributes populated in Assignments and they are visible in Fusion OTBI BIP table per_all_assignments_f can you please let us know from which …
-
BI Publisher - Bursting - Email Delivery Channel - HTML Message BodySummary BI Publisher - Bursting - Email Delivery Channel - HTML Message BodyContent All, Able to burst BI Publisher Reports and deliver them via email using: Email PARAM… -
OTBI New Calculated Measure Formula for Age at End of the Month from report run dateI need a formula that would provide me with the dependents age as of the end of the month from the report run date. If the report is scheduled to run on the 1st day of t…
-
How to get data in oracle fusion hcm country vise which HCM offering they using in oracle fusion hcmSummary: Hi Team I am looking for how to get data in oracle fusion hcm country vise which HCM offering they using in oracle fusion hcm Could you help me on this Content …
-
Illinois "Equal Pay Registration Certificate" reporting requirementSummary: Any suggestions or experience on how companies can best extract this data to meet this state requirement? Content (required): Good afternoon! Has anyone had to … -
Visualization ConfigurationsSummary: After selecting the OTBI analysis in Source type , Search for the analysis is /Shared/Custom folder This is coming blank nothing coming up. Is there any search … -
HCM Custom Extract Guide for Payroll ReportsSummary Sample extract with modularized UEs for customized payroll reportsContent Change Notes Date Version Change Reference 16-May-2018 v1 First Version 18-Sep-2018 v1.… -
Which privilege gives access to employee abstract role view own data in OTBI reportSummary: Currently employee not able to view their own data in OTBI analysis with custom employee role. But when I used the seeded employee abstract role it gives too ac… -
User Login Activity QuerySummary: We have a contractor and would like to measure his level of effort within our company. Is there an existing query or report that shows how many times a specific…
-
OTBI Subject area for Candidate Extra Internal InfoSummary OTBI Subject area for Candidate Extra Internal InfoContent Hello team, I'm looking for OTBI subject area for Candidate job application extra internal info. Thank… -
Need Guidance/References: Reporting Post-Approval Timecard Edits in OTLSummary: Hello Everyone, We have a requirement to build an OTL BI report that captures post approval timecard edits. Specifically, when an employee updates a timecard af…
-
Personal Payment MethodSummary Is it possible to report on personal payment method when this is blankContent Hi, please can someone confirm if it is possible to identify in a OTBI report when …
-
Time Entry report to get updates and deletion of time entrySummary: Need a report for time entry to pull all new creation, updated and deleted records. Content (required): We have a requirement for integration where we need to g… -
oracle cloud hcm bi publisher absences error handling reportHas someone written or found documentation for the steps to write an oracle cloud hcm bi publisher absences error handling report (or similar) that writes error messages…
-
HCM subject area "Workforce Profiles - Library Objects Real Time" join questionHello. Any advice on how to join the HCM subject area workforce profiles - library objects real time to workforce profiles - person profile real time ? Not finding commo…
-
Calculating average headcount and turnoverSummary Calculating average headcount and turnoverContent We'd like to be able to calculate the average turnover rate for rolling 12 months by using Period End Headcount…
-
Bi report changes are not reflecting on ORC offer preview pageSummary: Bi report details with recent changes are not reflecting on candidate's application preview offer Page. Content (please ensure you mask any confidential informa…
-
Absence Accrual Report is getting Timeout error.Summary: Absence Accrual Report is getting Timeout error. Error Code: SQL Query execution time exceeds the limit (500 sec)..stopped processing We have reproduced the iss…
-
Agentic AI Usage tokens consumption reportsSummary: Hello. Any advice on where to find the catalog contents for the Agentic AI Usage tokens consumption reports? I believe there are some catalog files in customer …
-
Sql query for employment term numberSummary Does someone have a query for the employment term number?Content Hi, I'm really need an sql query for that shows the person number, person f.name, person l.name,…
-
Customize / add new options to Selection Process Diversity delivered reportSummary: I'm hoping someone can help me understand how to modify delivered Selection Process Diversity analysis (I know I have to make my own copy to edit) that is part …
-
Approver Name of a transaction with OTBISummary: Create an OTBI report with Transaction details, the initiator and approver Content (please ensure you mask any confidential information): Hello experts, is it p… -
BIP report layout hyperlink works with hard-coded parameter, but not with dynamic field valueSummary: I am trying to create a drill-through from one BIP report to another. The source report is a report created with the Layout Editor, and the layout file ends in …
-
An unresolvable error has occured. Please contact your administrator for more InformationSummary: Getting unknown error as "An unresolvable error has occurred. Please contact your administrator for more Information" While clicking on Start Synchronization fo…
-
Same element is showing in Pretax and voluntary deductions in Payroll register reportSummary: Individual 401k element is showing up in pretax deductions and voluntary deductions in payroll register report. It should show up only under Pretax deductions n…
-
Learning Table Details to fetch Learning Access Group related fields along with access group membersSummary: I have requirement create BIP report to fetch all learning item along with access group related details like Access Group selection method, Access group Run as,…