OTBI
Discussion List
-
Report on Training Hours for each learnerSummary: Hi all, We are trying to report on each learner's hours during one year - has anybody been successful in building this in OTBI? Thank you in advance for your re…Cora_Stanciu 32 views 3 comments 0 points Most recent by Emily Robinson Reporting and Analytics for HCM -
CAGR(Compound Annual Growth Rate) Calculation in OTBISummary: Creating an OTBI analysis to calculate CAGR of the joiners in my org in last 3 years. Content (required): I am trying to calculate CAGR of the joiners in my org…Dinky Dudeja 52 views 2 comments 0 points Most recent by Dinky Dudeja Reporting and Analytics for HCM
-
How to generate employee listing report in Oracle fusion?Summary: Content (required): Employee Listing report Version (include the version you are using, if applicable): Oracle Fusion Cloud Applications 23A (11.13.23.01.0) Cod…Radha, Rangu 543 views 7 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
OTBI->Cloud Benefits Sample for 401k, 403B, etc. Enrollments by Gender, Ethnicity, Participant CostsSummary: This is part of a series of sample reports created by Oracle BI and HCM Product Management. You can copy the setup for this report and add it to your Oracle HCM…Adam Gates-Oracle 34 views 0 comments 0 points Started by Adam Gates-Oracle Reporting and Analytics for HCM -
Can the parameter affect both the row and the column in the Matrix report prepared from the analysisI have a matrix report that I use on the Dashboard screen, and the column information consists of job name information. The row information is also from the locations. a…Cansel Karasoy 23 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Error Code U9KP7Q94Summary: Path not found - Check input path entered Error Codes: U9KP7Q94 Content (required): Hi All, Has anyone run into this problem before? We archived and unarchived …William_Johnson 235 views 2 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
Best practices for Journeys reporting in Workforce Management - Checklist Real Time subject area?Summary: Subject Area: Workforce Management - Checklist Real Time Need: Leverage best reporting practices to drive adoption rates and system monitoring for allocated jou…William_Johnson 105 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Subject Area for Override LocationSummary: We have a requirement to query 4 different types of address for employees. HOME, US Resident Tax, Work Location and Override Location addresses. I am able to qu… -
OTBI Analysis - No results using subject area "Workforce Management - Worker Assignment Real Time"Summary: No results when creating simple analysis in OTBI using the subject area "Workforce Management - Worker Assignment Real Time" Content (required): Hello, I tried …Hazel De Castro 1.3K views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Analysis error - Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65PSummary: Analysis of 3 Subject areas, if no prompts are selected, produce report, when selecting a prompt, analysis result in error Content (required): Analysis of 3 sub…
-
Reading SQL Error CodesSummary: Hi All, Does anyone have any documentation/point me in the direction of resources that would help us read standard SQL error codes when working in OTBI? Include…William_Johnson 33 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How do I show all completions for same Course Title in OTBI report?Summary: OTBI report to show completions only shows first completion if title is the same. Need to get OTBI report to show the same data as the View Transcript (which ca…Aaron Reynolds 72 views 6 comments 0 points Most recent by Aaron Reynolds Reporting and Analytics for HCM -
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
-
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 23 views 1 comment 0 points 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 329 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 -
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 310 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
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 … -
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 48 views 2 comments 0 points Most recent by Indra Sardana-Oracle Reporting and Analytics for HCM -
Values appearing in alternate lines when exported to excelSummary How to have just one line of valuesContent Hi, The Risk of Loss and Impact of Loss fields are not aligned on a single line of data, instead there is a NULL inclu…User_2025-02-05-22-44-35-842 36 views 4 comments 2 points Most recent by William_Johnson 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
-
SQL prefix for 'As of' Date getting ADFS errorContent Hello, I have a sql prefix set as SET VARIABLE PARAM_EFFECTIVE_DATE = '@{AsOfDate}'; I'm all of a sudden getting this error: State: HY000. Code: 77031. [nQSError…Susan Anderson 51 views 2 comments 0 points Most recent by Harpreet Shergill Oracle 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…
-
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 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…
-
Arrears report with Current Deduction And Total ArrearsSummary: Hi, I am trying to create a report that will show current deduction taken for Med, Dental, Vision Arrears along with how much the total is and if the full amoun…