OTBI
Discussion List
-
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…Lucas Maciel 2 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
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?Praveen Kadiyala 3 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
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. …Anita 17 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for 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…BeachDreamer 10 views 9 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
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…HROps17 18 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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…Deepak Bhatt Huron 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Checklist QuestionnaireSummary Provides the details of the questionnaire assigned to the worker, questions and responsesContent You can report on the questionnaire questions and responses from…Raghavendra Raghunath-Oracle 161 views 11 comments 3 points Most recent by Luciavw Reporting and Analytics for HCM -
Employee number along with Candidate numberSummary: Hi, My requirement is to extract Employee details like employee number, name etc. from Core HCM along with Candidate Number, Requisition Number etc. from ORC in… -
Where is the rate field for hours worked?Summary: Content (required): I have a report that uses the subject area Payroll - Payroll Balances Real Time, but it does not have a pay rate field. Below is an example …
-
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":…Vinay Gharge 15 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
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…Vinay Gharge 11 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
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…AjayKumar Maddipati 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
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…Emily Beattie 13 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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…nitin Sharma 16 views 3 comments 0 points Most recent by Banashri Biswas Reporting and Analytics for HCM
-
Active Profile QuerySummary: Looking for help on how to build a query that checks for active profiles within different environments Content (required): Hi all, I'm looking to see if anyone …
-
Query to Display the Roles with their Data Security Profiles NameContent Hi Team, Has anyone created any report to display the List of Roles along with their assigned Data Security Profiles. Regards, Harish Vummidi Version 21CHarishVummidi 24 views 10 comments 0 points Most recent by dschomber Reporting and Analytics for HCM -
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…Giuseppe Iacono 7 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Pulling Goal Success Criteria without the HTML TagsSummary Is there a way to pull goal information without the html tags?Content Hello, I am looking to report on the Goal Information from HCM Fusion Release 11. When we p…Carolyn Brown-792 81 views 9 comments 1 point Most recent by User_KHR7R Reporting and Analytics for HCM
-
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… -
Position Incumbent History reportContent Hi, Can someone help me with Position Incumbent History report ? We wanted to know how long the position was vacant at any point of time after creation and who a…Nivya Mathire 113 views 12 comments 1 point Most recent by Tristan Aquino Reporting and Analytics for HCM -
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…Nicolas Vahman 13 views 1 comment 0 points Most recent by User702053-Oracle Reporting and Analytics for HCM
-
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…Parag Hiremath 4 views 1 comment 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
Nested IFNULL and CASE StatementSummary: Hi All, I'm trying to write a CASE statement where if the Annualised salary is blank I need it to say 'Not Reported' Content (required): Below is what I am tryi…
-
Population Counts - Year over YearSummary: I am looking to create an analysis, which will be connected to a dashboard, to report population counts year over year. I have included an example below: August…
-
How to create Cross subject area analysis - real time (Checklist and Worker Assignment) - ErrorSummary: Error creating cross subject area analysis - Error View Display Error Odbc driver returned an error (SQLExecDirectW). Content (required): Error when joining sub…Luciavw 11 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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…Parag Hiremath 2 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM
-
Query to Display the employee and the supervisor chain bottom upSummary: Does someone have a query for the employment and Supervisor/Manager hierarchy ? Content (required): Hello , I have very little experience in HCM tables, hence I…Cesar Saveedra 11 views 5 comments 0 points Most recent by Cesar Saveedra Reporting and Analytics for HCM