OTBI
Discussion List
-
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 87 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 51 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 58 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 227 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 74 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 130 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] 66 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 144 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 96 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 137 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 69 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 40 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 567 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 89 views 3 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
OTBI: Adding 2 dates (Effective Start Date) and (Effective End Date) to the Dashboard PromptSummary OTBI: Adding 2 dates (Effective Start Date) and (Effective End Date) to the Dashboard PromptContent Hi, I have a scenario where I need to add 2 dates on to the d…
-
OTBI Analysis, Action Links in OTBISummary Not able to create link through Action Links in OTBI AnalysisContent Hi I am trying to create an analysis in which I am using two subject areas "Workforce Manage…User_MC37Q 86 views 1 comment 0 points Most recent by User_2025-07-18-02-05-33-261 Reporting and Analytics for HCM
-
OBTI Analysis Comparing DatesSummary I am not able to compare dates in analysisContent "Hi, I am trying to perform a query which i think should be easy but i'm suffering from just looking at it for …User_MC37Q 55 views 19 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Setting the As Of DAte in Compensation - Salary Details Real TimeSummary Looking for a list of Subject Areas where a Prompt may NOT be used to set the effective dateContent Hello, I have used the instructions that are attached to effe…Aaron Hager Associated Bank 59 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Delivering OTBI Analysis on a specific day to a specific person's dashboardSummary Delivering OTBI Analysis on a specific day to a specific person's dashboardContent Hi I want to fetch the details of the employees which have the end date of the…User_MC37Q 45 views 1 comment 1 point Most recent by User_2025-01-22-18-30-18-571 Reporting and Analytics for HCM
-
Display Bin even with zero resultsSummary Is there a way to still include a Bin in the analysis output with zero results?Content Hello, I have an analysis where I am using Bins to count employees by age …Susan Anderson 42 views 3 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM -
OTBI Analysis Error: A Drive Table join exceeded the limit of 10 backend database queries. (HY000)Summary OTBI Analysis Error: A Drive Table join exceeded the limit of 10 backend database queries. (HY000)Content Hi, I am getting error "A Drive Table join exceeded the…User_MC37Q 46 views 8 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Issue with month format to create Trend Analysis Report for Data ProgressionSummary Issue with month format to create Trend Analysis Report for Data ProgressionContent Hi All, We would like to create a dashboard to show data volume progression b…
-
Select_physical * fromVO_nameSummary Select_physical only works on some VO'sContent Hi, Looking to expand the capability to search VO's using "Select_physical" on all VO's. "Select_physical * from V…