OTBI
Discussion List
-
How to enable Report Job History to BI Consumer in Home page of BI Catalog?Summary: Please refer to the BI Catalog Home page of BI Author and BI Consumer. How to enable also Report Job History link in Home page of BI catalog to BI Consumer? Wha…CS Yuen-Oracle 121 views 2 comments 0 points Most recent by CS Yuen-Oracle Reporting and Analytics for HCM -
Can we display the count in the graph while creating dashboard?Hi Team, I was trying to create a dashboard so what happening is if u out the cursor in the graph the counts are coming. So is it possible to display the counts in the t…Abhisek Kanungo 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Capture in OTBI the Attachment field in a Person Profile Real Time subject areaSummary: Content (please ensure you mask any confidential information): hi there, There is a field "Attachment" out of the box field at the bottom of the Talent Profile …Bobby Jourdan 13 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
I need sql query for Consumed Allocation in GOP Review Supply AllocationSummary: I need sql query for Consumed Allocation in GOP Review Supply Allocation to create a BIP report Content (required): Business requirement to prepare a report tha… -
Generate a count of employee self service requests for certain employee data fieldsSummary: Is there a way in OTBI to generate a count of the number of times an employee changed personal information data in self-service over a period of time? My unders… -
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… -
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 11 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 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 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 12 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 12 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…