OTBI
Discussion List
-
Absence Management - Leave Donation RecipientsSummary: We unable to find new subject area in 24D released version in S1 and S2. Subject Area Name — Absence Management - Leave Donation Recipients Could you please pro…Anup Karmankar 1 view 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Modify a Delivered Email Template to Communicate Purchasing Documents by Procurement Business UnitSummary: Does anyone know if it is possible to modify the Purchase Document E-Mail BI Catalog object used to communicate purchasing documents to suppliers to send differ… -
User facing Issue while saving OTBI reportSummary: The user is getting the following error while saving an OTBI report: Catalog object privilege validation failed for user to path . You do not currently have suf… -
Did User System Usage SA changeSummary: I had a simple analysis to pull last activity date and it's not working. Has the User System Usage SA changed recently? Content (please ensure you mask any conf…David Boudreau 12 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Fetching Job Requisition with Sensitive Information in OTBIHi Team, We are fetching job requisition details from OTBI in the Recruiting - Recruiting Real-Time subject area. However, we also need to retrieve additional candidate-…Jeeva - Cloud Vantage 21 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
Since Jan - no more automated enrollments for initiatives ...Summary: Content (please ensure you mask any confidential information): hi there, We have a lot of initiatives that work with OTBI reports for years now. Starting in Jan… -
Analysis to catch employee with department chageSummary: We need to create a analysis that will be used to populate a Learning Initiative. some subjected area has historical data, like "Compensation - Workforce Assign…Lucas B Maciel 11 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Oracle Documentation missing Order Management Subject AreaSummary: Troubleshooting an issue when building a custom analysis in OTBI. When I navigate to the Subject Areas for Transactional Business Intelligence in SCM (link belo…Becca Edwards 11 views 1 comment 0 points Most recent by Anuradha - User352 -Oracle Order Management
-
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 261 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 71 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 21 views 4 comments 0 points Most recent by Girish Kushibi Reporting and Analytics for HCM -
Does the END_DATE field in PER_USERS table get populated when the user is made inactive?Summary: Does the END_DATE field in PER_USERS table get populated when the user is made inactive? Searched this filed and no values populated Content (required): Making … -
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 43 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 541 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 11 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… -
Expenses - Expense Transactions Real Time "The specified criteria didn't result in any data.I am facing same issue not able pull expense details from Expenses - Expense Transactions Real Time " Subject area. Only details from Employee folder are populating. if … -
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 13 views 1 comment 2 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to embed Analysis in Dashboard?Summary: Custom Analysis exits Dashboard after run Content (required): I have a custom analysis and a custom dashboard: When run from user side it appears like this: 2 q… -
Are the Information template DFFs used in Purchase Requisitions, reportable?Summary: Are the Information template DFFs reportable? We are using Information templates that are tied to Smart forms, and those smart forms are used to create requisit… -
OTBI Receivable transactions- Real Time- Trying to get the warehouse/ship from detailsHi Team, Trying to create OTBI Report using Receivables transactions Real time. We need to add warehouse/ship from organization details for each of the invoice line. Una…Garima Arora-Oracle 21 views 1 comment 0 points Most recent by Garima Arora-Oracle Reporting and Analytics for ERP -
Finding Special Handling field in FDISummary: I'm working on some reporting for a client, and one of the Metrics I need to create requires a filter on the Special Handling field. However, this field doesn't… -
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 180 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…