OTBI
Discussion List
-
OTBI Report Subject Area for Document Delivery PreferenceSummary OTBI Report Subject Area for Document Delivery PreferenceContent I'm looking for a subject area that fetches the document delivery preference fields. Back end ta…Rajesh Kumar Bhagtani 250 views 12 comments 2 points Most recent by gclampitt Reporting and Analytics for HCM -
Recently updated data in an Org Tree is not displayed in OTBI reportsSummary: In mid December, I created about 20 new departments and tied them to existing Divisions in an Organization Tree. The departments were created with a 1/1/25 effe…
-
Sql query to get cost code effective start date and effective end dateSummary: Sql query to get cost code effective start date and effective end date Content (please ensure you mask any confidential information): Version (include the versi…Anup Karmankar 69 views 18 comments 0 points Most recent by Anup Karmankar Reporting and Analytics for HCM
-
adding different manager types to analysis reportsHello there, I have prepared a report from the analysis and in this report I would like to see the types of managers that people are affiliated with, such as head and ex…Sinem Kara 27 views 4 comments 0 points Most recent by Girish Kushibi Reporting and Analytics for HCM
-
Need a report to pull time change request details for time and laborSummary Need a report to pull time change request details along with manager comments for time and laborUser_2025-02-04-07-00-18-658 49 views 3 comments 0 points Most recent by Peeyush Chandel Reporting and Analytics for HCM -
Submitted Timecard and Web Clock Details ReportSummary: Need to SQL query for view the detail of submitted timecard and web clock's reported hours and schedule deviation with custom attribute. Content (please ensure …Melek Cinar 530 views 6 comments 0 points Most recent by Melek Cinar Reporting and Analytics for HCM -
Candidate Drop off ReportSummary: Hi - I am looking for an example candidate drop off report Content (please ensure you mask any confidential information): Version (include the version you are u…
-
How can the seeded compensation dashboards below for managers be customized?Can anybody suggest the right way to edit these seeded dashboards and do the customization based on our company needs. The need is to Add/ remove parameters Add/ remove …Sameeksha MN 20 views 3 comments 0 points Most recent by Sameeksha MN Reporting and Analytics for HCM
-
Position Occupancy ReportHi All, We have noticed that seeded Position Occupancy Report is not working as expected. Incumbent Headcount for all the positions is showing null though there are incu…
-
Logical SQL With Dashboard PromptSummary: Hi - I am trying to build a logical SQL report that displays paycheck information along with current salary as an outer join from Compensation subject area. The…
-
Best Practices: OTBI Compensation - Compensation Stock Details Real Time subject areaSummary: This is part of a series for best practice tips to use in your cloud environments, created by Oracle BI and Product Management. Roles and Privileges Compensatio…Gail Langendorf-Oracle 20 views 1 comment 2 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
To report performance document status related information and rating detailsSummary To report performance document status related information and rating detailsContent Hi , Planning to build a report to show performance document status of a pers…Phani S-Oracle 173 views 7 comments 1 point Most recent by Pavan Kumar Thummalapalli Reporting and Analytics for HCM
-
How to use "Combine results based on union, intersection, and difference operations?Summary: I don't understand how to use it. Whenever I add my 2 subject areas and then the fields, I don't know what to do after that. I need additional fields that are n…
-
Need to get distribution curve to work when count is 0I am trying to create a distribution curve for performance ratings. It looks good when there is a count >0 for each rating but when there is a 0 count for Unsatisfactory…
-
Where can I find the Specialization Description to add to my Specialization_Courses report?I can't find the description field to add to my report using the subject area Learning Records Real Time. Is this field in another subject area? Specialization Descripti…Lisa Marchand 40 views 2 comments 0 points Most recent by Lisa Marchand Reporting and Analytics for HCM
-
Consolidated List of OTBI and BI Publisher Reports Posted (9 December 2014)Content The following is the list of published OTBI and BI Publisher reports between 15 October 2014 and 9 December 2014: * Fusion Benefits: Dashboard for Costs and Tota…Julian Challenger-Oracle 283 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Analysis - How do you select the gross earnings for the max Date Paid per employee?Summary: We are able to get a list of gross earnings for each worker per pay date but we only want to SELECT the gross earnings associated with the max check date (Date …
-
Table / View for New Features and Opt In Features?Summary: Is there a table / view that can be queried via BIP which would allow us to create a report of all of the implemented and non implemented features as seen in th…Monica Fundak 45 views 6 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM
-
Performance Document Manager Overall rating doesn't apear within OTBI reportSummary: The issue arises with the rows displaying employee answers: the Manager Overall Score appears as “NA” instead of the actual score. Subject Area: Workforce Perfo…Peleg Puzaylov-Oracle 58 views 1 comment 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Supplier bank country field in OTBI reportSummary: Supplier bank country field not found in "Supplier-Supplier Real Time" OTBI Subject area Content (please ensure you mask any confidential information): Version …Sharmava 37 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Supplier Management
-
BI Reports are failing with error as Could not connect to OBI Presentation ServiceSummary: BI Reports are failing with error as Could not connect to OBI Presentation Service Content (please ensure you mask any confidential information): Hi Team, Greet…Parag Hiremath 97 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Total earnings inaccurate based on positions in Gross Earnings ReportI created an OTBI report include employees' 'Name', 'Position' and 'Gross earnings'. For prompt of time range, I use 'Pay period start date' and 'Pay period end date'. A…Yiming Xiong 17 views 4 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
How to display Active employees count month wiseSummary How to display Active employees count month wiseContent Is there any way on calculating employee count by month in OAC. The starting point is an Employees table …Saptadip 418 views 6 comments 1 point Most recent by Lakshmi Devi Bathala Reporting and Analytics for HCM
-
Position Grade Code and Position Grade Name not being populated in OTBIHi all, We have an issue that the Position Grade Code and Position Grade Name is not being populated in OTBI. The only field that is populated is "Valid Grades" and this…
-
Busting OTBI Myths - Reporting current and previous values side by sideContent Myth: You can't report current and previous values side by side One common example is reporting the current assignment values and the previous ones after an assi…Julian Challenger-Oracle 394 views 11 comments 5 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Copying OTBI reports in bulkSummary: Copying OTBI reports in bulk Content (please ensure you mask any confidential information): Hi Team, Greetings! There is a requirement to copy multiple OTBI Rep…Parag Hiremath 18 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Subject Area for Personal Payment Method DetailsSummary Subject Area for Personal Payment Method DetailsContent Hi All, Can any one please help me to find OTBI Subject area for personal payment method details. I have …nitin Sharma 217 views 13 comments 1 point Most recent by GopiKAutomus Reporting and Analytics for HCM
-
OTBI Analysis, Payroll - Calculation Cards Real Time - PAE - How do I show each linked assignment?Summary: I'm trying to create an analysis to report on employee Calculation Cards using Payroll - Calculation Cards Real Time and in the case of employees with multiple …Julie Searles 89 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Is there a way we can use embedded reports for custom error messagesWe have a requirement to have an error message to validate entries in a standard field in Learning module. As far as we have checked, there are no autocomplete rules ava…
-
Opportunity Marketplace Out of the Box ReportingSummary: Opportunity Marketplace Out of the Box Reporting Content (please ensure you mask any confidential information): Are there any out of the box reporting for Oppor…