OTBI
Discussion List
-
Creating an Analysis from Multiple Subject Areas - Using Measures Column from each subject area?Summary Creating an Analysis from Multiple Subject Areas - Using Measures Column from each subject areaContent I don't understand the logic of when creating an OTBI Anal…Ruzwan Akram 365 views 12 comments 2 points Most recent by User_2025-01-29-19-59-51-150 Reporting and Analytics for HCM -
Which table stores value set details used in fast formulaContent Hello everyone, Which table stores the information about the value set which is used in fast formula. if anyone knows which tabe defines the relationship between…
-
HCM infolets - include HC measures from records excluded from data role?Summary HCM infolets - can you include HC measures from records excluded from data role?Content We've put together a number of infolets showing basic HCM measures eg hea…User_0HYZ2 228 views 7 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Manager HiearchySummary Manager HiearchyContent Trying to get the Manager Hiearchy using CONNECT BY PRIOR on PER_ASSIGNMENT_SUPERVISORS_F. Noticed that there are flattened manager hiera…VijayaBaskar Ranganathan 104 views 4 comments 0 points Most recent by VijayaBaskar Ranganathan Reporting and Analytics for HCM -
OTBI - how to export historical dataSummary how to export department name freezed to hr plan extraction dateContent Hi guys, I need to export the department name based on assignment ID. The department name…User_2025-01-28-21-18-09-074 71 views 6 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
R13 Workforce Performance - Performance Rating Real Time subject Area issueContent Hi I am getting below error in R13 while running the OTBI report, but not in R12. ERROR : Runtime error for service -- ADFService11G - JBO-25002: Definition HcmT…User_7836 29 views 5 comments 1 point Most recent by User_2025-02-03-21-28-21-735 Reporting and Analytics for HCM
-
New OTBI Help Landing PageSummary Introducing a brand-new OTBI Help Landing PageContent This e-mail is sent by Oracle OTBI product management. Starting with Release 13.18.10, a brand-new OTBI Hel…User720640-Oracle 71 views 1 comment 3 points Most recent by Mark_Daynes Reporting and Analytics for HCM -
Tell us how you use OTBI to inform our future product directionContent https://oraclehcm.influitive.com/challenges/486 Please use the above link to provide us with feedback on OTBI to help us improve our product. The short questionn…Julian Challenger-Oracle 44 views 0 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Can I use one dashboard prompt parameter value as input in the SQL results query(choice list) of anoSummary OTBI : Can I use one dashboard prompt parameter value as input in the SQL results query(choice list) of another dashboard prompt parameterContent Hi, Please find…User_MC37Q 83 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
report show "no results" for specific roleSummary cant see results for person profile reportsContent hi, we created 2 reports from subject area "Workforce profiles: person profile real time" both report are work…User_2025-01-30-04-14-21-127 70 views 5 comments 1 point Most recent by User_2025-01-22-19-43-38-766 Reporting and Analytics for HCM
-
Adding Custom ColumnsSummary Adding Custom ColumnsContent Is it possible to add custom columns or custom logic to the existing subject area. If so, please share more detailsVijayaBaskar Ranganathan 55 views 4 comments 0 points Most recent by Mark_Daynes Reporting and Analytics for HCM
-
Custom Subject AreaSummary Custom Subject AreaContent Is it possible to create custom subject area with the custom columns. If so, please share more detailsVijayaBaskar Ranganathan 48 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Moving Filters in OTBISummary Is it possible to re-order filters in OTBI?Content Hello! When setting up filters in OTBI reporting, is it possible to move them up or down? In my experience I w…User_2025-01-29-23-59-58-976 40 views 4 comments 0 points Most recent by User_2025-01-29-23-59-58-976 Reporting and Analytics for HCM
-
OOTB Statutory Deduction Register - BI Pub Template Wrong SubTotals RowsSummary OOTB Statutory Deduction Register - BI Pub Template Wrong SubTotals RowsContent Hi All, The data in OOTB Statutory Deduction Register Report (Loc: /Shared Folder…User_2025-07-18-02-05-33-261 41 views 1 comment 0 points Most recent by Allen D'Souza-Oracle Reporting and Analytics for HCM
-
Leading zero in zip/postal codesSummary Can we protect postcodes when converting to csv?Content I'm running a report containing global postal address data and any countries with zip / postal codes with…User_2025-02-03-23-33-26-899 30 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
We'd love your feedback on using OTBI...Content https://oraclehcm.influitive.com/challenges/486 Please use the above link to provide us with feedback on OTBI to help us improve our product. The short questionn…Julian Challenger-Oracle 31 views 0 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Summation of worker category in OTBI ReportSummary Summation of worker category in OTBI ReportContent Hi Experts, I need a help. I have an OTBI report where I display the workers in each department, their job & w…Aloka Bhattacharya 51 views 15 comments 1 point Most recent by Aloka Bhattacharya Reporting and Analytics for HCM -
Report on Anytime FeedbackContent Hi All, Is there a delivered report for anytime feedback that we can leverage? If not, has anyone built one and how? Please share any information you might have.…PriyaPenugonda-SC 94 views 1 comment 0 points Most recent by Melanie Mahon-Oracle Reporting and Analytics for HCM -
Error in BI Publisher Report:oracle.xdo.servlet.data.DataException: java.lang.RuntimeException&Summary Error in BI Publisher Report:oracle.xdo.servlet.data.DataException: java.lang.RuntimeException: FO processing stopped at 128MB memory usage; Large table in page …Aloka Bhattacharya 91 views 4 comments 0 points Most recent by Aloka Bhattacharya Reporting and Analytics for HCM
-
Position Action Reason field is not showing in the Workforce Management - Position Real Time SubjectSummary Position Action Reason field is not showing in the Workforce Management - Position Real Time Subject AreaContent Hi All, I am trying to include position action r…Vijaya Kumar Komari 36 views 2 comments 0 points Most recent by Vijaya Kumar Komari Reporting and Analytics for HCM
-
Fact FTE is not extracting correct data based on BU and Contract TypeSummary Fact FTE count value is repeating for every contract type base on BU but it should show FTE different value for each contract typeContent Hi All, I tried to crea…Vijaya Kumar Komari 20 views 2 comments 0 points Most recent by Vijaya Kumar Komari Reporting and Analytics for HCM
-
HCM SchedulesSummary Schedules are not showing active days & hours for departmentsContent Hi guys, I've been trying to create an OTBI analysis that will show person's department shif…Pavel Kartuz 202 views 4 comments 0 points Most recent by Pavel Kartuz Reporting and Analytics for HCM
-
Direct reporters Compensation DashboardSummary Direct reporters Compensation DashboardContent Hi Team, I have requirement to build a dashboard, which shows the direct reporters details with compensation for t…User_2025-01-31-20-01-00-954 69 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI - Taken Absences - reporting from Jan - Dec and not from Employee PlanSummary I need to show taken holiday from employees but a lot of employees Annual Leave plan goes from May - AprilContent I am trying to report "Taken Absences" for all …User_2025-02-01-05-53-06-489 90 views 1 comment 0 points Most recent by User_2025-02-01-05-30-40-151 Reporting and Analytics for HCM
-
We want your feedback on OTBI!Content https://oraclehcm.influitive.com/challenges/486 Please use the above link to provide us with feedback on OTBI to help us improve our product. The short questionn…Julian Challenger-Oracle 61 views 4 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Compare 2 columns in OTBI report & apply conditional formatting ( (Colors) on one of themSummary Compare 2 columns in OTBI report & apply conditional formatting ( (Colors) on one of themContent Hi, I'm new to OTBI. I have a requirement to display the Column …Aloka Bhattacharya 422 views 13 comments 1 point Most recent by Aloka Bhattacharya Reporting and Analytics for HCM
-
Schedule Report JobSummary Adding Output destination typeContent I need to add a destination type like FTP and Web folder. Can someone let me know how to add values for it ? Also I need kn…User_2025-01-28-21-18-43-496 76 views 2 comments 0 points Most recent by User_2025-01-28-21-18-43-496 Reporting and Analytics for HCM
-
DFF Names Were Changed After UppgradeSummary All the dff names in the OTBI were changed back to their code name after the system upgradeContent Hi, We have DFFs we changed their names in the OTBI. After an …
-
Returning the most recent dateSummary Want to return only the most recent dateContent I have an analysis that I am doing in BI and trying to return just one record per person, with the date as the fi…Deb Luisi 93 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Compliance ReportingSummary Does HCM come with EEO-1 and Vets-100a Reports?Content Does HCM come with EEO-1 and Vets-100a Reports? I can't seem to find any, but it would surprise me if they…User_2025-01-23-21-30-59-936 69 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM