OTBI
Discussion List
-
Sick Leave Duration greater than XX days over a rolling periodSummary: We are trying to report on employees who have recorded more than 40 days of sick leave in a rolling 365 day period. Content (required): We have used Leave Durat…Emily Robinson 11 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Custom Project Role missing the ability to create a Report using Subject AreasSummary: Custom Project Role missing the ability to create a Report using Subject Areas Using this role when the Users tries to Create a report they can only create the …
-
Default Language in OTBI subject areasSummary: Hello, Do you know which subject area contains employee's "Default Language"? I've created a report presenting default languages in BIP, but it needs to be recr… -
OTBI Agent Sender Name ChangeHello Experts, Need your help & suggestions for the below issue that we are facing recently. We changed the OTBI Agent Sender Name by raising an SR to Oracle Support. It…Bhaskar Konar 51 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Need OTBI report showing all active employees AND whether or not they are enrolled in MedicalSummary: I have been asked to develop a report that shows all active employees (Assignment Status Type = Active) and include a column showing the medical plan name they …JHaden3 332 views 2 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM
-
Need help with CASE formulaSummary: I'm using this formula in an OTBI report (using WFM Worker Assignment Real Time subject area). The formula should do this: If an employee hire date is
-
Not able to add the BI report in View Analytic pageSummary: Content (required): Hi All, We have created a BI report and we want to add this report in the talent review meeting in View Analyst option, but when we are tryi…Faizan Rashid 21 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Serial numbering in the reportHello, In a notification I prepared, I would like to give a serial number to the document that will be sent to the people in that month. For example, document no;01 docu…Sinem Kara 21 views 1 comment 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM
-
Subject areas to make analysis of BPM Transactions in OTBISummary: Subject areas to make analysis of BPM Transactions in OTBI Content (required): I need to make an OTBI Report to show the detail of BPM Transactions, including t…Hameed 81 views 1 comment 1 point Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM
-
We need basic details of time card submission details in BI or OTBISummary: HI Team, We need basic details of time card submission details in BI or OTBI. person details. time card submission details, project name, etc. Thanks, Ajay Cont…AjayKumar Maddipati 21 views 1 comment 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM -
Consolidated List of OTBI and BI Publisher Reports Posted (10 February 2015)Content The following is the list of published OTBI and BI Publisher reports between 10 December 2014 and 10 February 2015: * Bradford Factor * Extract Manager Hierarchy…Julian Challenger-Oracle 319 views 8 comments 5 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need to calculate Age in BI AnalysisSummary What is the formula needed to calculate age within a BI Analysis?Content I am trying to complete a report to calculate the age levels of employees. I pulled in h…User_2025-01-28-20-43-56-568 206 views 6 comments 3 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need SQL Query to fetch the Advanced Mode Absence Duration in Absence RecordsHi Experts, Could you please help me on SQL Query to fetch the Advanced Mode Absence Duration in Absence Records. Thanks, Nagaraju.Naga raju Ibba 361 views 4 comments 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM
-
source table for last acceptable promised dateSummary: Unable to find details of last acceptable promised date (change from data) for PO schedule line . Content We have a requirement to present last acceptable promi… -
Export entire dashboard from a custom pageContent Hi Guys, I see that is possible export the entire dashboard from the OTBI by clicking on the Option export to excel. But, my question is: Is it possible export t…Giuseppe Iacono 217 views 18 comments 3 points Most recent by User_VLBBP Reporting and Analytics for HCM
-
Can we display DFF value in OTBI, Expense Transactions Real Time subject area?Summary: Display DFF value in OTBI Content (required): Hi, We have defined a contextual DFF segment in the standard Expenses DFF. This was setup as "BI enabled" (checkbo… -
Subject area which can be used to display the approval chain of RequisitionsSummary Subject area which can be used to display the approval chain of RequisitionsContent Hi, We have a requirement where we need to display the requisitions which are…Kalyan Reddy 45 views 3 comments 0 points Most recent by Fabiana De Arruda Reporting and Analytics for SCM
-
Customers real time not giving correct outputSummary: Not able to create Customer Master Report. Customer and accounts are not mapped. Is this correct subject area to get customer info? Single Customer to joined to…
-
BI Publisher Bursting Email from Company Domain IDSummary: Hello Experts, We have a requirement to trigger emails from our company domain ID (@companyname.com) while triggering emails from BI Bursting. We don't want the…Gourabh Choudhary 171 views 3 comments 0 points Most recent by Gourabh Choudhary Reporting and Analytics for HCM
-
Reporting the Career Development screenHi, I want to generate the data sql report on the My Team>>>Career Development screen. But I can't find the table where this information is kept. Can you help and share?…Cansel Karasoy 61 views 8 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Schedule Report to Run Prior Month/QuarterSummary: Currently, only a few HR members can run reports, no one outside of HR can. If they need a headcount roster or turnover, I would run the report for them. There …Ratha Sun 151 views 11 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
Compensation Approval Chain in OTBI ReportSummary: How to view all managers who approved a compensation change? Content (required): On the front end I can see for each compensation change, a list of managers who…s_b 61 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Is it possible to approve an order from a OTBI analysis?All orders are created directly in OM and they have a simple approval workflow. For the approval is critical to review the price components of each item. The problem tha…
-
Extracting Bookings History in Demand Mgmt - Customer Info requiredSummary: Hi All, I am trying to extract booking history details for a particular org for the last 3 years, along with the customer details. However, along with bookings …Ashish A Jha 51 views 8 comments 0 points Most recent by Avinash Erande Supply Chain Planning and Collaboration
-
Dashboard screen customizationI have a dashboard report that I have prepared with parameters and I want the parameters to look like the screenshot. I couldn't find how to make the background visually…Cansel Karasoy 21 views 7 comments 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for HCM
-
Overhead accounting rule at LOT levelSummary Overhead accounting rule at LOT levelContent Hi, We have overhead accounting rules at LOT level to include additional charges in the work order cost. We didn't h… -
Regular Temporary column from Workforce Management - Worker Assignment Event Real TimeSummary: There is no "Regular Temporary" column in the "Assignment Event Details" folder from the Subject Area "Workforce Management - Worker Assignment Event Real Time"…Chan Jun Yu 51 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Duplicate Departments when using Goal Status Overview Real Time Subject AreaSummary Duplicate Departments when using Goal Status Overview Real Time Subject AreaContent Hi Experts! Good day! We are having issues with duplicate departments. Is the…Raymund Jerome 43 views 5 comments 0 points Most recent by Nick Dorfner Reporting and Analytics for HCM