OTBI
Discussion List
-
Crossing Subject AreasSummary Certain dimensions will not populate even though I have linked by measures.Content I have created this report and I have been having the hardest time populating …Deb Luisi 122 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Calculating the Number of Business DaysSummary Count the number of Business Days between 2 datesContent I constantly get requests to provide reporting based on Business Days rather than Calendar Days. Calcula…Rick P Klassen 449 views 1 comment 1 point Most recent by Prudence K Reporting and Analytics for HCM -
How to filter between Accounting Period Name in GL dashboard promptSummary How to filter between "Accounting Period Name" in GL dashboard promptContent Hi, I need to use "Accounting Period Name" in "General Ledger - Journals Real Time" … -
OTBI report to view worker performance detailsSummary Report for line manager/supervisorContent We have a requirement to create a report to view employee performance details including past performance history to the…User_2025-01-28-21-18-43-496 75 views 2 comments 0 points Most recent by User_2025-01-28-21-18-43-496 Reporting and Analytics for HCM -
Some Users cannot see Leavers despite Correct RolesContent Hi all, got a weird one! I developed some leavers reports a few months ago and they worked perfectly for me and for users when they tested them. The report is no…Aaron Leggett 38 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Talent data by Assignment Manager without a HR roleSummary Which additional duty do I need for a manager w/o a HR role to see his talent review data?Content Hey All, On our test boxes I have created a simple table with t…User_2025-01-23-22-38-50-675 36 views 1 comment 0 points Most recent by User_2025-01-23-22-38-50-675 Reporting and Analytics for HCM -
How to set Default Rows Displayed In Download in OTBI reportContent I need to set DefaultRowsDisplayedInDownload as " 65000" for my OTBI report. Is there a way to do it ? Already referred some oracle docs but I could not able to …User_2025-01-28-21-18-43-496 92 views 5 comments 0 points Most recent by User_2025-01-28-21-18-43-496 Reporting and Analytics for ERP -
Find all workers which are missing emergency contactSummary How to create a report which present the employees that missing an emergency contactContent Hi, Someone has an idea how to create a report in OTBI of all the emp… -
Custom Profile Content Types in OTBISummary Custom Profile Content Types in OTBI (Workforce Profiles - Person Profile Real Time)Content We have created some custom profile content types in HCM Cloud under …Ramesh Puligulla 52 views 4 comments 1 point Most recent by justin.field-Oracle Reporting and Analytics for HCM -
Issue with Bins and Case StatementSummary Issuing a CASE statement against hire and term bins from Action Name fieldContent Due to our decentralization I cannot utilize the assignment event measures when…User_2025-01-28-08-47-04-905 37 views 1 comment 0 points Most recent by User_2025-01-28-08-47-04-905 Reporting and Analytics for HCM -
Unable to use Organization field with person profileSummary Trying to use organization field with person profile data (education) in OTBIContent Hello I want to include Organization details (Organization Level 02 Name) in…Mohit Gupta-45440 55 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Employee Record in OTBI?Summary Which SA has Empl RCD?Content Hello All, Which Subject Area contains the Employee Record (Empl RCD) attribute? Thanks, Nikhil NelluriUser_2025-07-18-02-05-33-261 37 views 7 comments 0 points Most recent by User_2025-07-18-02-05-33-261 Reporting and Analytics for HCM -
HR Manager Name & Person Number in OTBI SA's?Summary HR Manager Name & Person Number in OTBI SA's?Content Hi All, I am trying to report the name of HR Manager & Person Number for a Worker. Is the HR Manager & Perso…User_2025-07-18-02-05-33-261 60 views 2 comments 0 points Most recent by User_2025-07-18-02-05-33-261 Reporting and Analytics for HCM -
Requester field blank on OTBI report from Procure to Pay Subject AreaSummary Requester field blank on OTBI report from Procure to Pay Subject AreaContent Hi All, In R13, we built a OTBI report based on "Procure to Pay" subject area. But R… -
R11 ERP OTBI Subject Area Mapping to Fusion Database TablesSummary Release 11 ERP OTBI subject area database table mapping spreadsheetContent This spreadsheet is published by Oracle OTBI Development. This spreadsheet documents F…User720640-Oracle 523 views 14 comments 9 points Most recent by Koteswararao Yenikepalli Reporting and Analytics for ERP -
OTBI Performance Tile Filter : How to get difference between 2 datesSummary OTBI Performance Tile Filter : How to get difference between 2 datesContent Hi, Currently, when I try to put a OTBI filter to get difference between 2 dates, it … -
Inactive Departments and Attrition Reporting ErrorSummary Issue once departments are made inactive we are no longer able to report on leavers.Content Following a restructure we have made a number of departments inactive…User_2025-01-23-20-43-34-115 40 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Do we have a separate 'Worker Number' field in any of the subject areas in Oracle Fusion HCM Cloud OSummary Do we have a separate 'Worker Number' field in any of the subject areas in Oracle Fusion HCM Cloud OTBI AnalysisContent Hi, Do we have a separate 'Worker Number'…User_MC37Q 158 views 16 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM -
Custom report tablesContent We have a requirement to create a custom report to get division wise PD tasks status for following details. Appreciate someone can let us know the tables to refe…User_2025-01-28-21-18-43-496 60 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Special caracter not displaying as expectedSummary In standard reports of notifications, the special caracter are not well displaying.Content Hello, Any ideas please how to display the caracter correctly in the s…User_I6AXL 45 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Report to record absence balancesContent I need to create an OTBI report to show absence balances. But I could not able to find correct subject areas. Both Workforce Management, Accural and absence real…User_2025-01-28-21-18-43-496 135 views 10 comments 0 points Most recent by User_2025-01-28-21-18-43-496 Reporting and Analytics for HCM -
Report for tobe PutAway ReceiptsSummary Report for tobe PutAway ReceiptsContent Hi All, How can we generate a report which shows all the Receipts pending for PutAway or all the Receipts pending for Ins…User_2025-01-31-00-09-19-397 32 views 1 comment 0 points Most recent by Sunny Todkari Reporting and Analytics for SCM -
Reporting on descriptive flexfields - BI Enabled checkbox not showingSummary Unable to use descriptive flexfield in OTBI - missing BI Enabled checkboxContent I need to create a new report using the Receivables - Customer Real Time subject…elenorh 189 views 2 comments 0 points Most recent by User_2025-07-18-02-05-33-261 Reporting and Analytics for ERP -
Connecting Goal Status Overview to Assignment Real Time Subject AreasSummary No fact table exists error when trying to connect themContent We have setup a flex field at the assignment level and are trying to report on goal campaign attrib…Rob F 41 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Fusion Role vs Reporting RoleSummary Is there a way to see what the reporting role is for someone's Fusion security role?Content Hi all - when I look at the Fusion roles for our employees, I would l… -
Contacts ReportSummary I would like to create a reports with contacts detailsContent Hi, I tried to create a report via OTBI that includes all the contacts with the following details -… -
Oracle Report Jam at OHUG 2018 in Vegas - 2 weeks to go!!!Content About half the slots are already taken, book now to secure your slot. Highlights Sign up to guarantee some in-depth 1:1 report building using Oracle Transactiona…Julian Challenger-Oracle 22 views 0 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM