OTBI
Discussion List
-
Customizing Maintenance Dashboard – Infolet with Drill‑Through to OTBI Work OrdersHello Team, We have a requirement to enhance our Maintenance Dashboard with a custom OTBI infolet. The requirements are: 1.Team/Resource Work Order Status Tracking Displ… -
Looking for a couple sample reports using the Subject - Learning Records Real TimeSummary: Hi there! All of our Learning Reports have been created using the Subject Learning Management Real Time. I understand this Subject will be going away at some po…NCourt 41 views 2 comments 3 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Learning -
Are there any sample obti analysis reports for assigning learning?Summary: I'm on the Reports and Analytics>HCM> I have looked at the HCM Reports sharing center and the Fusion OBTI HCM Analysis with no success cause filter doesn't work…Audra Edwards 73 views 5 comments 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Learning
-
OTBI column formula help - change days to working daysIn my report I need the following column formula to calculate 5 working days (not 5 days as it does now) and leave out Saturdays and Sundays. Any help would be great. CA…
-
Percentage of Employee With and Without Goals not showing properly in columnsSummary: Hello again, I need help to check my case statements. The % of employees with and without goals are not reflecting properly. CASE WHEN "Workforce Goals - Goal S…Marilyn O 32 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How can we display different Infolet tiles based on each page?Summary: Is it possible to display difference Infolet tiles based on page (e.g., Me, My Team, My Client Info)? Can EL expressions solve this problem? If so, please provi…Nipon 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to know the Reservation quantity from which sub inventory and locatorSummary: Business use case is to know the reserved quantities that is in specific sub inventory and locator. Currently for any sales order reservation, sub inventory and… -
Assigning Learners Automatically Based on OTBI ReportSummary Looking for a way to have an OTBI report automatically assign new learners to Learning InitiativeContent Hello Team. I was curious if there was a way to have new…
-
Is it possible to add a field to an OTBI analysis that uses sql to query the underlying oracle tableSummary: We have an existing OBTI Analysis that reports on candidate from ORC. We need to add that a field from the Extra Info section of the candidates profile, the Des… -
Column for reject/return reason for PO/ Requisition in OTBI Subject AreasSummary: Column for reject/return reason for PO/ Requisition in OTBI Subject Areas Content (please ensure you mask any confidential information): Hi Team, We are searchi…Nidhi Chhajed 1 view 1 comment 0 points Most recent by Nidhi Chhajed Reporting and Analytics for SCM
-
Where can we find the columns in OTBI for Work Order Notes from new My Maintenance Work?Currently with the Dispatch List, our technicians enter the completion notes when completing an operation. These notes are reviewed at the end of the week by a superviso…
-
Question about Infolet on ERPHi Team, Our client is currently undergoing a process to revalidate user privileges. During this process, we observed that simply accessing the pages and viewing the Inf…Oscar Chahestian-Oracle 21 views 4 comments 0 points Most recent by Oscar Chahestian-Oracle Reporting and Analytics for ERP
-
How to report Job Details > Action reason in OTBISummary: We use the 'Action Reason' field in Workforce Structures - Job Details to record why we created or updated a job. We would like to be able to report on this fie…Lachlan Tanner-283818 61 views 9 comments 0 points Most recent by Kayla Malecki Reporting and Analytics for HCM -
Which table is used to extract the offer price data?Hi all, does anyone know which table is used to extract the offer price? We need to retrieve this information for a report. I'm also attaching a screenshot of the data. …
-
User unable to run OTBI report but could in the pastSummary: All of a sudden this user is not able to run reports specific to ORC. I cleared the server cache but it's still not working. Any ideas prior to logging an SR? C…THawkins_LGI 43 views 15 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM -
Base table - Email Notifications Workflow approvalsContent Hi, I am looking for a table that holds emails sent out of the workflow mailer. I am specifically looking for details such as Transaction/Task id along with an e…Sriharsha Devraj 799 views 2 comments 0 points Most recent by User_AOTJG Reporting and Analytics for HCM -
Ability to create OTBi for Information TemplateSummary: Currently there is no option to enable BI for DFFs created as part of Information Templates. Reporting on these information template is highly desirable. Conten… -
How to default a Prompts selection in OTBI dashboard from Lookup code based on logged in UsernameWould like to reach out to you on how to set the default value of a Prompt with a value from lookup code which is related to the logged in User name. We have an Analysis…Dinesh R 12 views 1 comment 0 points Most recent by Shradhanjali_Oracle-Oracle Reporting and Analytics for ERP
-
What is the OTBI Subject Area to pull in Supply Planning assignment sets?looking to query our assignment sets (sourcing rules for items make and buy) in OTBI and cannot find the subject areaNicole Sievert 11 views 1 comment 0 points Most recent by Thejaswini Kamreddy-Oracle Supply Chain Planning and Collaboration
-
Is it possible to split a concatenated segment (accounting combination) in an OTBI reportSummary: I am trying to split the concatenated accounting combination into different columns, each column should be displaying a segment separately Content (please ensur…Eva Mirzoyan 152 views 5 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP -
📄 OTBI Report to Generate HDL File for Deleting Feedback RequestsSummary: This provides a custom OTBI report built on the Workforce Performance – Requested Feedback subject area. It helps companies generate HDL-formatted data to delet…Chase Wolfle 11 views 0 comments 0 points Most recent by Chase Wolfle Reporting and Analytics for HCM -
Does exist an official/unofficial presentation for OTBI reporting training?Summary: Looking for OTBI reporting training presentations. Content (please ensure you mask any confidential information): I need to teach the customer how to use OTBI r…Stefano_Mazzocca 21 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Unable to join Purchasing and Receipts subject areas in OTBIWe have a requirement where we need to create an OTBI report with Purchasing Order and Purchase Order Receipts information like Purchase Order Number, PO Line Number, PO…vikram khengare 31 views 2 comments 0 points Most recent by Teresa Meyerhoeffer Reporting and Analytics for SCM
-
Help Desk Data only role for access to reporting for HR Service Requests and Knowledge ManagementSummary: I am trying to provide access to a Help Desk and Knowledge dashboard for users that cannot access the Help Desk and Knowledge modules. The subject areas that th…