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
-
Scheduling Dashboard with BIP ReportSummary: Content (required): I am trying to schedule a dashboard which contains a tab with a BIP Report. When I schedule or export the dashboard, all other tabs (that co… -
Filter to pull employees with anniversaries in the following monthSummary We need to build a report that is emailed monthly and pulls any employees that have service anniversaries in the following monthContent We need to create a repor… -
Unable to fetch the data for Calculation card in HCM Payroll Employee Deduction BI reportSummary: Hi all I am not able to get these data from the backend for Element Name, Value, Effective Start date inside the Calculation Card : Benefit and Pension in HCM. … -
How do I create an analysis that pulls most of the fields on the Element summary screen?Summary: When creating an analysis, the analysis either drops records or stops returning any records after adding certain fields that may not contain any data. I am curr… -
How to create a report for worker and theirs Individual CompensationSummary: Im trying to create a report to follow individual compensations for workers, but using the subject area i couldnt create any report, when combine the worker fou… -
Saved/Draft Rating Manager evaluationIs it possible to report on manager evaluation(saved) without employee submitting the rating? I am trying to create a report to pull manager evaluation with any status. …
-
Need to remove one measure column's grand total value in OTBISummary Need to remove one measure column's grand total value in OTBIContent We have Grand total value for two measure columns in OTBI Report. We need grand total value … -
Report to show where Referral payment due on completion of Probation periodSummary: We are trying to build a report which alerts us to employees who have now reached the end of their probation period and were referred by an employee during recr…
-
Adding additional information from add absence pageWe added a few input boxes on the add absence page, how can we see them in OTBI? Do we really need to develop custom BIP models for things this simple?
-
How do take End of the Month Prompt in OTBI?I am trying to fetching the count of Legal employers , total cost based on the categories and required prompt is end of the month as per selection should come count of L…
-
Request for a report on employee utilization of Oracle HCMSummary: I am looking to understand how the system is being used by the employees in my company. Content (required): I would like to be able to report on who is using th…
-
how to find the dff in headcount otbi reportSummary: I am unable to find the DFF called 'Worker's Comp Code' under the subject area Workforce Management:- Worker Assignment Real-time So , Can anyone help me how to…
-
Duplicate Data Issue : HcmTopModelAnalyticsGlobalAM.TimeRepositoryAM.ReportedTimeEntryPVOSummary: We have enabled BICC extract for HcmTopModelAnalyticsGlobalAM.TimeRepositoryAM.ReportedTimeEntryPVO for default column list, the extract data file has duplicate… -
Table/Views required which contains all the created data model ,report/analysis in the instanceSummary: Hi, I need table/view name which contains all the data model, report, analysis information created in the system and all the fields which are being used by that… -
Unable to get DFF and EFF fields in OTBI in Worker AssignmentSummary: Content (required): We are unable to get the following fields highlighted below in OTBI Subject Area "Workforce Management - Worker Assignment Event Real Time":…
-
Unable to get inactive or future dated employees in OTBISummary: Content (required): We are using the subject area "Workforce Management - Worker Assignment Event Real Time" and we are unable to get inactive or future dated e…
-
Duplicate Data Issue : HcmTopModelAnalyticsGlobalAM.TimeRepositoryAM.RptAbsTimeEntryPVOSummary: We have enabled BICC extract for HcmTopModelAnalyticsGlobalAM.TimeRepositoryAM.RptAbsTimeEntryPVO for default column list, the extract data file has duplicate d…
-
we have requirement of how extract person history detailsSummary: Hi Team, we need to create the report on history details of person like surname before marriage and after marriage , etc of person history details Content (requ… -
How to report the completion date for Journey questionnaires and or tasks?Summary: Is there a way to report on the specific completion date for when a journey questionnaire or general task is completed? Right now, I have noticed a completion d…
-
Employees Performance goal BI report not showing properly in excel outputSummary Employees Performance goal BI report not showing properly in excel outputContent Hi , We have requirement to create bi reports to fetch the below goal columns fo…
-
Is there a Subject Area with User Name and Email on it?Summary: Hello, I am new to OTBI and we are using it for Oracle's new Higher Ed module (Oracle Student Management) , but we do have the HCM and CRM subject areas accessi… -
Payment Method Bank Account Details is not available in OTBI Payroll Personal Payment details RealSummary: We have a customer requirement that we only need to use the Bank Account in ESS Personal Payment Method but when we try to create an OTBI using the Payroll Pers… -
Custom metric doesn't work inside dashboardSummary: Content (required): Hello, We realize a new custom analysis in order to calculate the #Avg Time To Fill (Days), we use this formula: AVG( CAST( TIMESTAMPDIFF( S…
-
Delete a Talent profile entrySummary: Content (required): Hi there We are trying to delete a talent profile certificate. We use the following lines. We get an error but no clear details of the error… -
Can hourly rates be reported on?Summary: Our workforce has both salaried and hourly associates and we have a requirement for an analysis to show hourly rates using the SA Compensation Salary Details Re…
-
Report on Structure (Quick Actions, Apps) with default seeded Expression Languages from Vanilla versSummary OTBI Report on Structure (Quick Actions, Apps) with default seeded Expression Languages from Vanilla version as old value and new value as custom expression lang… -
Can we create report for the data that we see on Person Management > Review page ?When we edit the existing data in update or correction mode and click on Review button , we see a page with changes that opens up. Can we create report that is present o… -
Time and Labor OTBI - Time card version numberSummary: Content (required): I'm creating a dashboard with different reports for Line Managers and department secretaries. And the report is working good and I get to se…
-
Need to find the oracle table name in BI reportSummary: Hi all I am not able to find the Oracle table name for "TID Upgrade Job" Can anyone help me to find the table name for "TID Upgrade Job" and see the data from t…
-
Reusable Data Model SQL QueriesSummary: Reusable Data Model SQL Queries Content (required): Hi Team, Greetings! Does any have Reusable Data Model SQL Queries for HCM modules (HR, Payroll , Benefits, O…