OTBI
Discussion List
-
How to fetch latest record in OTBI ReportSummary: Hello All, I am developing an OTBI report to fetch Person's Skills and development data. For this, i have used 'Workforce Management - Person Profile Real Time'…Amarnath Podaralla 41 views 3 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
DFF in termination under PER_PPS_DF which subject area can we report from?Summary: We have added a DFF to termination under PER_PPS_DF and would now like to report on it in OTBI, which subject area can we do this from? Content (please ensure y…Sharon Ferguson 20 views 1 comment 0 points Most recent by Joe Dorrian Reporting and Analytics for HCM
-
When we try to fecth the inactive employees data using OTBI we facing below the issueSummary: Hi Team, when we try create the inactive employees data we facing the issue that is suppose some of employees have mutlipule terimation relationships like 'X' e…AjayKumar Maddipati 54 views 8 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Error Codes: EKMT3FK5 Limitation of Pivot table in OTBISummary: I pivot 'Balance Name' (around 70 columns) and get this error message if I output too many records, I'm wondering how can I increase this limitation number for …Yiming Xiong 22 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How to add two subject areas event real time and performance real timeSummary: Hi Team, Any one help me on it's urgent requiremnt . How to add two subject areas workforce management—worker assignment event real time and workfroce performan…AjayKumar Maddipati 1 view 1 comment 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Globally Change User Timezone Preference in OTBISummary Is there a way to globally change users' timezone preference in OTBI?Content Hi! I am wondering if anyone knows if there is a way to globally change the OTBI tim…Lindsay Lamont 63 views 8 comments 0 points Most recent by SimonTomey Reporting and Analytics for HCM -
Chage Default Timezone for a Time columnSummary: There is a need to change the timezone of a time column in one of the OTBI analysis to reflect UK timezone. Currently it has default UTC timezone. Content (requ…User_2025-07-18-16-26-02-907 61 views 4 comments 0 points Most recent by SimonTomey Reporting and Analytics for HCM
-
Restricting Data for Direct reports of a Line ManagerSummary: Hi All, How do we restrict Line manager access to only his/her direct reportees Learning Items in OTBI Report. Can you let me know the steps ? Content (required…Veena P 63 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Adding a number format for OTBI reportSummary: I have created an OTBI analysis to get the grade related min, max and average values. Content (please ensure you mask any confidential information): The OTBI an…Ayesha Iroshani 169 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
We have long service award OTBI Report but need to show in performance tile viewSummary: Hi team, we have long service award OTBI Report but need to show in performance tile view chart by if we click the 5 years then need to show 5 years completed c…AjayKumar Maddipati 83 views 20 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
how to update position, job and location using hdlSummary: want to change employment data using HDL Content (required): I'm new to OTBI and want to change employment data for columns like Position, Job, Location. From w…
-
impact of scheduled HCM Extract and Reports during the maintenance or upgrade timeSummary: Customer has concern with scheduled BI, OTBI Reports and HCM Extract during the Maintenance window. What will happened with them. CRitika.ray-Oracle 12 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Phone numbers repeating instead of suppressing duplicatesSummary: Mobile phone and home phone number columns are repeating even though they are duplicates and the columns are set to repress. Content (please ensure you mask any…
-
Where is the LONG URL stored for candidate source tracking?Summary: I am trying to locate the LONG URL that is captured as part of Source information mentioned in the second paragraph of this oracle help document. Does anyone kn…MarkHodges 3 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
Response ScoreSummary: Hi, Does anyone know where can I find the Response Score (if it is the correct answer - 1 or the wrong answer - 0) in OTBI? I've tried under Questionnaire Respo…Vasco 12 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM
-
Workforce Performance - Performance Task Status Real Time showing incorrect assignment informationSummary: The Workforce Performance - Performance Task Status Real Time subject area seems to be displaying incorrect assignment information for employees that have had t…CClark30 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Dashboard prompt is not workingSummary: Hi, I have created an analysis using logical sql and passed parameter i.e. presentation variable inside logical sql. But when I am using dashboard and dashboard…Shreya Datir 43 views 5 comments 0 points Most recent by Shreya Datir Reporting and Analytics for HCM
-
Dynamic generation of URL (from OTBI) to Person's Person Management in HCM ApplicationContent Hello, Just wanted to check if anyone tried to generate a dynamic URL from an OTBI analysis that can go to Person's Person Management screen at HCM Application. …SantoshKumarBhairi 236 views 33 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
What is the OTBI Subject Area for State Wise Minimum Wage?Hi Team - Can anyone please let me know the OTBI subject area for State Wise Minimum Wage. The DB tables for the same are PAY_VALUE_DEFINITIONS_F and PAY_RANGE_ITEMS_F. …Ramya Rajendran 22 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to pull latest termination date AND/OR null term date based on Person Number & Latest AssignmentSummary: I'm using an OTBI report to pull a distinct count of # of employees at a specific location between two dates. This report includes fields like Job Name, Hire Da…CGardner01 207 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Selection Process Internal vs External - OTBISummary: Hi Expert, I have a requirement to show no application to the respective phase name and with the filter criteria month, year, and candidate Selection process na…
-
Duplicate lines of data for employee in Worker Assignment Real TimeSummary: I have developed an analysis export which brings all current assignment data for an employee based on the Worker Assignment Real Time subject area. However, the…Dan_Hinsley 11 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to use 1 common filter for graph and tableSummary: Hi Experts, I created an OTBI analysis and want to add one common filter for graphs and tables. Can someone assist me with how to use all filters for both? Than…
-
Need to edit the NewHireReport data model to include the SecurityFinal tableSummary: In the AssignmentChangeReport datamodel (EmploymentUpdateProcess), there is a table called "SecruityFinal". This table provides the following data (see below) o…
-
Job Change ReportSummary: I have a Job Change report that I was sent and I need to add a few fields to it. It was built in Logical SQL and I'm having trouble adding a few fields. Any hel…
-
Cross Subject Area join between Checklist and Helpdesk Request SummarySummary: There are Checklists created for certain Helpdesk Service requests. We need the data from both checklist and helpdesk on an OTBI Analysis **** Dashboard. Is it …Vibha Pandey - Oracle 2 views 4 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM
-
table/view to list all users with assigned role namesSummary: table/view to list all users with assigned role names Content (please ensure you mask any confidential information): I am looking for an Oracle Table/View name …Naved Khan 756 views 5 comments 0 points Most recent by RWMATTHE-Oracle Reporting and Analytics for HCM -
Need help to build a sql to get approval transaction historySummary: We have a requirement to capture approval transactions and the respective data like what changed in the transaction. For example If it is for Location Change,wh…Praveen D 136 views 5 comments 0 points Most recent by Hrushikesh Pentewad Reporting and Analytics for HCM
-
BI report paramters not working in DasboardSummary I attached BI report to dashboard and created date paramter in dasboard prompt with same name as BI parameter.But not getting ouputContent Hi, I attached BI repo…User_6I33I 29 views 4 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
REQUISITION_POSTED State Code Giving Strange ResultsHello, I have a need to find the most recent date a requisition was posted and unposted. For compliance purposes, we need to ensure our jobs are being posted for a minim…