OTBI
Discussion List
-
No Results- The specified criteria didn't result in any data in WorkForce Manag.- Person Real TimeSummary: Hello Oracle Experts. We are trying to create an OTBI for generating the employees loaded in the Fusion ERP. We don't have HCM in scope, it is only SCM and Fina…Lokesh_619 85 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
How to Automate BACS file to be placed in UCM server?Summary: We have a requirement where BACS File generated using "Make EFT payments process" should be automatically sent to UCM(Oracle WebCenter Content). If anyone has f… -
Report a journey task status "not applicable"Summary: How can I report, via OTBI, the status "not applicable" if an employee clicked on it during the completion of a journey? It won't appear as a completed task on …Jacqueline GRANDIN 21 views 4 comments 0 points Most recent by Jacqueline GRANDIN Reporting and Analytics for HCM -
Infolets sampleHi Experts, Can someone share infolet samples/catalog files for employee and manager ? Thanks in advance. Regards, NivyaNivya Mathire 31 views 3 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
How can I optimize/simplify my KPI formula in order to reduce the time of the report to load?Summary: It takes 13mins to load my report using the formula since I have to add 2 values on my KPI formula before getting the percentage. Is there a way to optimize my …John Patrick Diaz 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Sql query in dashboard prompt for bi publisher parameterSummary: Hi All, I am developing one Absence report by BIP report. The requirement of this Absence report is to show the employee's absence details in his dashboard. For…Sai Krishna Chelikani 154 views 2 comments 0 points Most recent by Sai Krishna Chelikani Reporting and Analytics for HCM -
procurement work confirmatSummary: Subject Area for Purchase Order Work Confirmation Please i need to know if there's a subject area in OTBI which stores the data for work confirmation for procur…Mona_ahmed 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Report Hours Worked/Processed by PayrollSummary: I need to be able to report hours processed by payroll from beginning of the year to current. I cannot use the timecards. I thought it would be in the payroll r…Jessica D 21 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Does anyone have a EEO-4 that meets the layout specifications they would be willing to shareSummary: We are required to submit an EEO-4 report by December 5, 2023. Content (required): The EEO-4 report is a mandatory biennial data collection that requires all st…Emily Wilde 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How do add custom infolets in order-to-cash tab?Summary: Hi, we need to add custom infolets, but there is no add field in this option below. We able the sandbox, but I can't add new custom infolets Content (please ens…Alex Pagliarini - Ninecon 31 views 2 comments 0 points Most recent by Alex Pagliarini - Ninecon Order Management -
Unable to download Purchase Orders via Oracle Visual builderSummary: Content (required): error message received The requested resource could not be found. (VBAFE-00107) The remote server returned an error: (404) Not Found. Please… -
Time and Labor -- Calculated time card entries for a date range or pay periodSummary Calculated time card entries for a date range or pay periodContent Hi Friends I have been working on a report for Calculated Time Card Entries and so far i have … -
Learning - Reporting on Penetration RateSummary: We would like to be able to report on the penetration rate of our learning module. I think the idea is to report the percentage of people assigned to a learning… -
Person Real Time Subject Area and Future Hire DateSummary: I have a simple report/analysis using the subject area Workforce Management - Person Real Time. This report is used to extract 2 custom Extra Information fields… -
Report Usage Metrics OTBIContent Does anyone know how I can pull usage metrics of reports run by users in OTBI. I've searched for some time on this online, both here and Google. I see there was …User_2025-02-01-05-53-06-489 124 views 7 comments 0 points Most recent by erpexpert03 Reporting and Analytics for HCM -
OTBI Formatted and Data Export LimitWe are exporting OTBI reports that has more than 300k rows. We're able to export 75k rows in Formatted Excel and 300k rows in Data format options. Anyone has specific nu…CAMIL_Q 201 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Reporting Capability Maturity Matrix : Reporting Road MapSummary: I'm trying to develop a notion or framework for "Reporting Capability Maturity", as something organisations could use to assess how good they are at Oracle repo… -
Is it feasible to Print an Entire Dashboard (with multiple pages)?Summary: Is it feasible to Print an Entire Dashboard (with multiple pages)? Content (please ensure you mask any confidential information): I would like to print an Entir…Harish Malik 31 views 4 comments 0 points Most recent by Harish Malik Reporting and Analytics for HCM -
Headcount as of date - security scopeContent (required): I am working on a headcount dashboard for HR employees, so that they can see the headcount as of date (number of employees, FTE etc). I am facing an …Jacqueline GRANDIN 11 views 5 comments 0 points Most recent by Michael Grant Reporting and Analytics for HCM -
Areas of Responsibility data security not being pulled through to OTBISummary Areas of Responsibility data security not being pulled through to OTBIContent Hi all We are currently testing R12 and redefined our data security profiles using …User_2025-01-23-21-25-57-924 187 views 11 comments 2 points Most recent by BrittaniR Reporting and Analytics for HCM -
How to create a custom Infolet using a query example?Summary: Hi, we need to create a custom infolet by a query example Content (please ensure you mask any confidential information): There is a away to create a custom info…Alex Pagliarini - Ninecon 21 views 4 comments 0 points Most recent by Alex Pagliarini - Ninecon Order Management -
How to cancel scheduled reports?Summary Steps to cancel the scheduled custom reportContent Hi All, Can somebody please help me with the navigation to cancel the scheduled custom reports in Cloud? Thank…MAHESH TALWADE 42 views 4 comments 0 points Most recent by Erica Williams Reporting and Analytics for SCM -
How can we enable visibility on OTBI Absences for a user?Summary: Hi all, We have a user who as per their profile can access Absence Records, but cannot view Absence reports in OTBI - any idea how to get round that? Any privil…Cora_Stanciu 12 views 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Measuring the Completeness of Onboarding Task by EmployeeSummary: Measuring the Completeness of Onboarding Task by Employee Content (please ensure you mask any confidential information): In the Onboarding report use the Checkl…Thulasi Ram 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
We have to create an Custom field in sales order page.Summary: We need to create a custom column in Sales Order, That can be updatable at any point of time. Content (please ensure you mask any confidential information): Ver…KOTTHURI ASHOKBABU 11 views 1 comment 0 points Most recent by Sandeep Kurur-Oracle SCM Product Management-Oracle Order Management -
Report to get the list of employees with change in payroll groupSummary: Report to get the list of employees with change in payroll group Content (required): Hi Team, Greetings! The change in payroll group, especially from weekly to …Parag Hiremath 31 views 5 comments 0 points Most recent by Gail Wilmoth Reporting and Analytics for HCM -
Subject area changesSummary: Advanced notice of SA Changes. Content (please ensure you mask any confidential information): Document 2431130.1 provides guidance on subject areas that can be …Ms_Oracle 31 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM -
Returning information from the middle of the valueSummary: Hi our work location fields are in the format "UK-[city]-[street address]", but when I run an analysis I only want to return the city name. Is this possible? Is…