OTBI
Discussion List
-
Inactive pending worker data is being pulled in the OTBI Pending worker report.I have created a pending worker report using the logical SQL. In pending worker report Rehires are being pulled onto the pending worker report where the candidate record…Nishu_Kumari 46 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM -
Manager not able to see the anything in reportHi Everyone, I have created 2 reports and deployed it for the Line managers to be able to run and self serve but when they run they cant see the results. Details of the …Girish Bhatia 24 views 3 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
How to find the BIP report name which is using a specific SFTP connectionI know the SFTP name that is being used to transfer a file to vendor. But I do not know which BIP report is using that SFTP connection. I have looked at the report jobs …
-
Length of Service calculation OTBISummary Calculation of LOS based on either Current Date or Termination Date for former employees.Content I am looking to calculate an individual's length of service base…Stephen Prentice 580 views 8 comments 0 points Most recent by Rahul K-Oracle Reporting and Analytics for HCM
-
OTBI Report Showing Which Cost Center Was Charged For Hours/EarnsSummary: I have a requirement to provide the YTD number of worked hours charged to a specific cost center regardless of the employee's home department cost center. What …JHaden3 41 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management
-
How to calculate number of continuous weeks of Submitted TimecardsSummary: For Casual workers who submit weekly timecards, I need to identify those that have worked 12 continuous weeks. Content (please ensure you mask any confidential …Richard Kemp-Eyre 22 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management -
Court Orders - Report on field called 'Order Reference'Hi all, I'm hoping this is a quick and easy question. I'm building a report to report on Court Orders and they've asked us to include the value from the field front end …MikeW 22 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
How do I report on all the phases and states a job requisition progresses through?Summary: I am currently trying to report on all the phases and states a job requisition progresses through, including effective dates. using subject area 'Recruiting - R…Paul Morrissey 230 views 2 comments 0 points Most recent by Paul Morrissey Reporting and Analytics for HCM
-
Is there any seeded OTBI Analysis for Person Seniority?I'd like to know if there's any seeded OTBI Analysis which can relate to Person Seniority?Welsey 12 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM -
Track approval workflow status for goal managementSummary: Track approval workflow status for goal management Content (please ensure you mask any confidential information): Hello experts, we have enabled an approval wor…Oriana L. 32 views 1 comment 0 points Most recent by Adriana Tudor-Oracle Reporting and Analytics for HCM
-
BI Publisher Handle No Data in RTF TemplateHello, I want to prepare a report that returns data that I call from the web service via OTBI. However, when I try to return this value in BI Publisher rtf template, the…Sinem Kara 62 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Deploy Reporting components from Bitbucket/Git to Oracle HCM and vice versaSummary: Deploy Reporting components from Bitbucket/Git to Oracle HCM and vice versa Content (please ensure you mask any confidential information): Currently the reporti…Akhil M 62 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
OTBI - Reverse geocode time events via sqlSummary: Hello, Is there an sql package available for cloud customer regarding reverse geocoding?. Content (please ensure you mask any confidential information): We are …Paul Buna 12 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM
-
dashboard parameter resetHello, I prepared a dashboard from a web service data model and this dashboard works with certain parameters. Dashboard consists of two tabs in total. When I select the …Sinem Kara 12 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM
-
Reporting on paper payslip flag from People GroupSummary: We require a report that gives me people who have a paper payslip flag ticket in People Group segments. This is to ensure employees out of business get their pa…MKuch 12 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Profile strength report for checking Talent profile completion status reportingProfile strength report for checking Talent profile completion status for the Organisation reporting? I am not able to find the field for profile strength in OTBI or BIRevanth.Rondla 31 views 1 comment 0 points Most recent by Adriana Tudor-Oracle Reporting and Analytics for HCM
-
How many reports are there in systemSummary: can we create a report with the followed fields Report Name, Folder or path where, creator, who has access/visibility to it Content (please ensure you mask any …
-
How to report on Recruiting Organization Description assigned in Job FormattingSummary: I am looking for the table / views that will pull in the Job Footer details assigned in the Recruiting Organization Description section in Job Formatting. Conte… -
Report Data is incorrect because Time zoneHello, we just recently faced an issue related to BI report on absence related data. It will give last one hour updated records of employees absences. (submitted/awaitin…Dara Nagasai 4 views 3 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
Duplicate Data Rows for EFF fields in Reporting (Data Issue?)Summary: Hello, We are noticing when we are building basic reports whenever we bring in Job or Department EFF fields in the criteria, we get duplicate rows for employees…CCannadayCTR 32 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
need query to get activities content type for all the courses along with offeringsHi we have requirement to get the Course names along with the offerings and their activites content type in the bi report. Can any one share me the sql for fetching all …
-
Can't get Scheduled Hours of employee that shows on OTL Time Card into OTBI ReportSummary I need to get field Scheduled Hours per week that shows on employee time cardContent Hello , I assigned a work schedule to worker and I need to get value of Sche…User_2025-01-30-17-46-10-378 351 views 12 comments 0 points Most recent by Sigrid B. Reporting and Analytics for HCM -
OTBI - Store Analysis or static Briefing booksSummary: Can we use OTBI to store month-end snapshots of static data to refer back to without exporting offline? Content (please ensure you mask any confidential informa…Clare Murtagh 2 views 2 comments 0 points Most recent by Clare Murtagh Reporting and Analytics for HCM -
Adding approval history information to the reportHi, I designed a report that works the same as the standard notification with custom parameters. I would like to add the following field to the report, which comes in th… -
Human Capital Management - Approval Notification Archive Real Time - Transaction ID missingSummary: Hi, I am trying to create a report using Human Capital Management - Approval Notification Archive Real Time subject area. I am unable to fetch transaction ID wh…
-
How to Restrict groupings with 0 from display in HR dashboard chartsSummary: Restrict groupings with 0 from display in HR dashboard charts Condition used in column Level: CASE WHEN "Workforce Trend"."Termination Headcount"Raman Singh 42 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
OTBI Payroll Reporting - How to Generate Employee Data as of Payroll Period & not Current DateWe currently have an OTBI report using the Payroll - Payroll Balance Real Time subject area. Currently, if we run this report it pulls in the employee Business Unit as o…Alex van Gulijk 201 views 14 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Community of a learning course - OTBIDear all, We would like to report the community in which a COURSE has been integrated to. In my following example : for my COURSE "English language training", I would li…Jacqueline GRANDIN 31 views 3 comments 1 point Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
Due Date dashboard prompt in OTBI gives precision_scale errorSummary: OTBI Learning Dashboard prompt for Due Date set to between gives a precision_scale error across all analytics Content (please ensure you mask any confidential i…Kevin Robertson 11 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM
-
Sequence NumberSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Rick Jason 2 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM