OTBI
Discussion List
-
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 258 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 44 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 11 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 179 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…
-
Create BI report from supply planning tableSummary: Hello, I was looking for source tables to create OTBI report from Tables and Views for SCM > Planning common, My objective is replicate the table view attached …Diego Zegarra 31 views 4 comments 7 points Most recent by Diego Zegarra Supply Chain Planning and Collaboration -
performance tile DescriptionSummary: When we drag the mouse above some graphs we can see the analysis name description with more information. We would like to know how can we enable this feature to…
-
Error codes in OTBIWhen we want to view the OTBI report, I get this error: Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P State: HY000. Code: 10058. [NQODBC] [SQL_STATE…
-
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 33 views 2 comments 0 points Most recent by Lisa Marchand Reporting and Analytics for HCM