OTBI
Discussion List
-
Security Roles - Country Role vs AoR RoleContent Hi experts - I am trying to understand how we can limit our view to reports based on the Area of Responsibility (AoR). Current State: We have a security role cal… -
Effective As-of-Date / Hire Date ProblemContent I am trying to create a report for HR to list all upcoming employees for our external payroll provider. Unfortunately I'm struggling with hire dates that are in …User_2025-01-31-17-16-46-301 142 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Logic Behind Calculated FieldsSummary Trying to find the actual logic behind calculated fields in OTBIContent We are trying to find the actual logic for calculated fields in OTBI. Some are self-expla… -
Mapping of OBI Subject area to HCM ExtractsSummary Document for mapping OBI Subject area to HCM ExtractsContent Hi We have been using OBI Subject areas to extract data dump from HCM fusion. Now that our databse h…Mohit Gupta-45440 94 views 4 comments 0 points Most recent by Mohit Gupta-45440 Reporting and Analytics for HCM -
Goal Counts Report by Goal PlanSummary Employee Goal CountContent I've been trying to create this very basic and most commonly asked for report for well over a year to no scalable avail. I've tried nu… -
Pulling All Rows of Data (All Effective Dates)Summary Has anyone found a way to easily pull all rows of data for an employee in an OTBI report?Content Has anyone found a way to easily pull all rows of data in an OTB…
-
Need to develop a BI Publisher report that will have filter mechanism in the output.Summary Need to develop a BI Publisher report that will have filter mechanism in the output.Content Need to develop a BI Publisher report that will have filter mechanism…Aloka Bhattacharya 61 views 4 comments 1 point Most recent by Sricharan Monigari Reporting and Analytics for HCM -
Join Grade Rate Real Time and Salary Details Real TimeSummary I want to create a report with information from Workforce Management - Grade Rate Real Time and Compensation - Salary Details Real Time but I can not join them p…Rogelio H 89 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Drill down to a specific part of the chart ?Content Hi Community, We noticed that in our reports, when we have a drill to details function enabled (eg headcount by country in this case), it sometimes drills to the…[Deleted User] 47 views 2 comments 0 points Most recent by [Deleted User] Reporting and Analytics for HCM
-
Lenth of Service or Tenure FunctionSummary I'm looking to create a column that will show length of service in years.Content I'm looking to create a column that will show length of service in years. Is it …User_2025-01-25-00-37-41-739 154 views 7 comments 2 points Most recent by User_2025-02-01-05-55-45-070 Reporting and Analytics for HCM
-
OTBI Analytic: 2 values in one column - share it to two columns or show meassures only once in one cSummary Behind one field there are two different values . Under the results the two values are summarized in one column. Would need each value in a separate column. How …User_2025-01-25-03-41-47-642 125 views 2 comments 0 points Most recent by Karen B Reporting and Analytics for HCM
-
Question about Worker -> Parent Manager fieldsSummary Question about Worker -> Parent Manager fieldsContent I have a question on how the data in the parent manager fields (Parent Manager 1, 2, etc.) gets populated. …David Villegas 90 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Reference Number in BI Publisher ReportSummary How to capture unique reference number for BIP report when you run each timeContent Hello Experts, We have BI publisher report (HR Letter) report like No Objecti…VinodKumar 52 views 7 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Assignment Status Reporting IssueSummary Assignment Status Reporting IssueContent Hi All, I am building a Global Payroll Transfers Report in OTBI with the SA "Workforce Management - Worker Assignment Ev…User_2025-07-18-02-05-33-261 59 views 4 comments 0 points Most recent by User_2025-07-18-02-05-33-261 Reporting and Analytics for HCM
-
make infolets available based on the user's roleContent Hello, We are using infolet in production but we don't have find a way to display those depending of the user's role. Most of the infolet (in example) are used t…User_2025-01-25-01-33-46-269 218 views 17 comments 3 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Last calendar day of the previous month as default promptContent Hi Oracle Community, We are trying to have a prompt with the date automatically set on the last calendar day of the previous month (which is our closing day), bu…[Deleted User] 46 views 3 comments 0 points Most recent by [Deleted User] Reporting and Analytics for HCM
-
Fields for day start week and end weekSummary Create 2 fields in OTBI report for start date of the week and end dato of the weekContent Hi, Sorry for the dummy question but I couldn't figure out how to do it…
-
BI Publisher: Is there a alternative view for per_all_people_f table?Summary BI Publisher: Is there a alternative view for per_all_people_f table?Content Hi, I am currently using per_all_people_f and per_all_assignments_m tables (which ar…User_MC37Q 75 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Has anyone built a report that lists all possible drop down menu option for HCM fields?Content Afternoon all, I was wondering if anyone has built a report that shows all configured data items for OOTB fields and DFF. We want to do an audit of all configure…User_2025-01-28-05-39-23-766 68 views 2 comments 0 points Most recent by User_2025-01-28-05-39-23-766 Reporting and Analytics for HCM
-
GL Costing Information for the Elements - OTBISummary Element Costing Configuration - OTBIContent Hi All, Where can i find GL Costing Information for the Elements? I need to report Costing account codes for all the …User_2025-07-18-02-05-33-261 131 views 12 comments 1 point Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Count of Workers With No Performance GoalsSummary Need for building a report with workers without any performance goalContent Hi community, We currently have the report attached in BI to count workers per # of g…[Deleted User] 67 views 2 comments 0 points Most recent by [Deleted User] Reporting and Analytics for HCM
-
Hire/Seniority DatesSummary How do I report on these dates in OTBI/BIP?Content Hi all - I know that Julian had a great post about what the individual dates are (https://cloudcustomerconnect…Prudence K 145 views 7 comments 0 points Most recent by User_2025-01-25-01-10-42-578 Reporting and Analytics for HCM
-
Future Dated RecordsSummary Future dated records/Inserted rowsContent I need to build a daily report for when managers/HR has entered a change when there are future dated records that need …User_2025-01-28-04-58-46-119 97 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Performance Management Comments in OTBISummary Performance Management: Competency comments and Overall comments in OTBIContent Hello, I have realized a custom report to extract Performance Management competen…Giuseppe 1234 127 views 3 comments 1 point Most recent by User_2025-01-28-07-43-08-025 Reporting and Analytics for HCM
-
Need inputs to fetch the Element Additional DetailsContent Hi All, While creating Element we need to provide required information in the Element additional details. Please suggest in which table (SQL) or Subject areas ho…
-
Turnover Formula AssistanceSummary Building a turnover % by termination typeContent Using a CASE formula I have identified and split out terminations by our company's preferred type, desired and u…User_2025-01-28-08-47-04-905 70 views 3 comments 0 points Most recent by User_2025-01-28-08-47-04-905 Reporting and Analytics for HCM
-
Can I use Dashboard Prompt in the individual Column Formula in my analysis?Summary Can I use Dashboard Prompt in the individual Column Formula in my analysis?Content Hi, I have a requirement where I need to use the dashboard prompt(Presentation…User_MC37Q 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Creating OTBI report with employee termination detailsContent I need to create a OTBI report to get employee termination details. I used Workforce Management - Work Relationship Real Time subject area but after release 13 c…User_2025-01-28-21-18-43-496 510 views 10 comments 1 point Most recent by User_2025-01-28-21-18-43-496 Reporting and Analytics for HCM
-
Salary Currency field causing error on reports in R13Summary Compensation Reports error out. Determined caused to be related to Salary Currency field.Content I have two Compensation Reports that error out. I determined the…User_2025-01-28-20-43-56-568 38 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Can I use Date Transformation function (TIMESTAMPADD , TIMESTAMPDIFF, CAST) on a Dashboard Prompt(prSummary Can I use Date Transformation function (TIMESTAMPADD , TIMESTAMPDIFF, CAST) on a Dashboard Prompt(presentation variable) before using it to compare in Analysis.C…User_MC37Q 90 views 3 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM