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 42 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 71 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 31 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… -
Oracle table name to fetch all Supplier Profile Change Request DetailsSummary: We have requirement to build report with below columns. 1. Supplier name 2. Supplier account number. 3. Date of account update- Initiated 4. Account update- Dat…
-
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 42 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 785 views 2 comments 0 points Most recent by User_AOTJG Reporting and Analytics for HCM -
OTBI Subject area for Candidate Extra Internal InfoSummary OTBI Subject area for Candidate Extra Internal InfoContent Hello team, I'm looking for OTBI subject area for Candidate job application extra internal info. Thank…Santhosh Bachu 459 views 20 comments 0 points Most recent by Denise Izzi 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 20 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 155 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… -
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