Category 81
Discussion List
-
Reporting on count of incomplete/complete Journeys in OTBI?Summary: For OTBI analyses - our organization needs to be able to report on the following in the Workforce Management - Checklist Real Time subject area: 1) Total number…William_Johnson 464 views 2 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM -
Impact Rating Model column filter breaks analysisSummary: Subject Area: Workforce Profiles - Person Profiles Real Time Column: Impact Rating Model Content (required): Hi All, We run into an error under the Workforce Pr…William_Johnson 21 views 2 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
What is the best way to implement ECC200 data matrix in oracle reports?Summary: Need to add a 2d data matrix to report letters that will store a string of numbers. The ECC200 data matrix does not seem to be currently supported by Oracle so …KevinCochran 43 views 1 comment 1 point Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
OTBI Learning records report for a Line Manager including not only Direct but also IndirectSummary: Content (required): Hi there, i cannot find an answer to the above question. We have line managers who want to see the learning completions of the direct report…Bobby Jourdan 22 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
End Dated values no longer appear in OTBI reportsSummary: We have end dated a number of Sickness Reasons (sub reasons), which used to pull through on OTBI reporting, these no longer appear after being end dated Content…Luke Harrison-126889 41 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Learning Records Subject Area - How to remove duplicate linesSummary: In the new Learning Records Real Time Subject Area, I am trying to produce a report for the following data, but when I add the Activity Details start and end ti…Mark Stoker 101 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM -
Subject Area for Workflows & Approvals?Summary: I need to do a review of all of the Workflows & Approvals, and would like to be able to export them all, as is to avoid going through each one, one-by-one. Is t…Jessica D 327 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
What role or privilege controls the schedule functionality for OTBI analyses?Summary: How to enable the "Schedule" functionality for an analysis? Content (required): In OTBI there is the option of scheduling an analysis to be run, delivered etc. …Matti Bugge 159 views 4 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
From which table can I check the scheduled report job?Hi, Which hcm table can I query to view the history of my scheduled report? I want to get the last run date of the report job from this table. I will be grateful if you …Cansel Karasoy 793 views 4 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Is it possible to customize AbsenceApprovalEmailNotification report to get Absence Balance included?Summary: We need to somehow modify the data model so that the absence balance of the absence type from the absence request gets displayed on the report. Content (require…bervin13 52 views 2 comments 1 point Most recent by Michelle Juergens Reporting and Analytics for HCM -
How do you enable My Report tab for employees?Summary: How do you enable My Report tab for employees? Content (required): What is the privilige that you need to use in order to enable My Report tab for employees? Ve… -
Is there a query for fetching LinkedIn profile details in BIP report? Which is the table for that?Summary: To fetch linkedin profile details in BIP SQL report. Which table needs to used to achieve this requirement? Content (required): Version (include the version you…RithwikSivanand111111 32 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
How to get the termination action/reason for the report with benefit details?Summary: I have an OTBI report built with benefit details. I need to add employee's termination reason/action for that report. Content (required): I cannot find a benefi…Ayesha Iroshani 306 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Can anyone here post an HDL template for loading Benefits objects into the system?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):RithwikSivanand111111 32 views 6 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
How to enable My Reporting Tab to Access the HR DashboardHello How do I enable Mt Reporting Tab to access the HR Dashboard.Gail Wilmoth 248 views 1 comment 0 points Most recent by Mihaela Cojocariu-Oracle Reporting and Analytics for HCM -
How would we restrict the access of Hiring Manager to the other reports in a Dashboard?We have Dashboard A where Hiring Managers has access to. Inside the Dashboard A, we have a couple of reports (eg. Requisitions, Candidates, Hiring Manager requisitions).…
-
Removing blanks from questionnaire reportingSummary: I have created a questionnaire with some questions having a response type of Rating and some with Answers. When I bring the fields Response Answer and Response … -
Banner In BI reportHi Experts, Our client wants to add banner in heading like in homepage have., so is there any feasibility to add the banner asunder in report heading. Sample banner in e…Sujan Kumar Dash 35 views 3 comments 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM
-
How to make a drop down Prompt, in a Report based on an Analysis, work?Content (required): I've created the Analysis. Which is used as the Datasource for a Dataset in a Datamodell. The Datamodell is used in a Report. I want to create a Prom…
-
Not able to find "Show Selection Only" Option in the Configure Events for List Component.Summary: Not able to find "Show Selection Only" Option in the Configure Events for List Component in BIP Report (Interactive Report) Content (required): I was trying the…Sujeeth Chinta 51 views 1 comment 0 points Most recent by Sandeep S. Chauhan-Oracle Reporting and Analytics for HCM -
Area of Responsibility ReportSummary: Wondering if anyone has a working Area of Responsibility Report they can share? Content (required): We're struggling to get our AoR report working, created as a…
-
How do I suppress trailing zeros in my RTF template for comp statementSummary: How do I suppress trailing zeros in my RTF template for comp statement Content (required): I have tried both ’999.999999’ and ’D999999’. If a number has 6 decim…TerryM01 46 views 2 comments 0 points Most recent by Indra Sardana-Oracle Reporting and Analytics for HCM -
Allocated Checklist Status Code in Workforce Management - Checklist Real TimeSummary: Hi All, Is anyone aware of what/where information in this column would pull from in the system? What would value "WAI" represent? Subject Area: Workforce Manage…William_Johnson 51 views 4 comments 1 point Most recent by William_Johnson Reporting and Analytics for HCM
-
Division showing blank for Performance task status real time subject area in OTBISummary: Org tree columns showing blank value in OTBI due to new org tree version Content (required): We have activated our new tree version from 1st jan 2023, since the…
-
HR_6882_HRPROC_ASSERT errorSummary: HR_6882_HRPROC_ASSERT error Content (required): Hi Team, Greetings! We have run into error for the direct deposit process with error log summary as- BIP job pro…Parag Hiremath 94 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Salary Range Report ALL Jobs (Active and Inactive)Summary: I have a requirement to produce the below OTBI report but if I use the Compensation Salary Detail Real Time, it only shows data if an employee is assigned to th…JHaden3 103 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI Filter for Numeric using MAXSummary: Thinking of the approach how to apply Filter in OTBI to get the Max value of column where column is only numbers. Content (required): Data on DFF column is Varc…
-
Report on Job Openings as of Last MonthSummary: I need to report on how many job openings there were as of last month. When I use the sql for last day of last month, the numbers aren't accurate as it is live …Jessica D 33 views 3 comments 0 points Most recent by Dawn C-Support-Oracle Reporting and Analytics for HCM
-
Report showing previous month (starters, leavers)Summary: Is there a way to filter results for only a previous month - for example all new hires, terminations - regardless of the date the report is run? Content (requir…Gary Miller-39965 163 views 4 comments 0 points Most recent by Gary Miller-39965 Reporting and Analytics for HCM
-
Need to display complete History related Employeement changes for the previous and current valuesSummary: Need to display complete History related Employeement changes for the previous and current values Content (required): We need to display complete history employ…