OTBI
Discussion List
-
Supplier Recon reportSummary: We are importing the suppliers,address,site details using FBDI.Is there a specific report that we can access or generate to reconcile the imported data with the…User_2025-10-31-01-02-51-214 91 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
View Expense report receipts for approversSummary: Has anyone created a report or option to view (without download) Expense report receipts for approvers? Currently only option for approvers is through Expense r… -
Are there any out of the box reports that would tell me if a Second Pass email was triggeredSummary: Looking for an out of the box report that would tell me if Second pass emails are being sent to applicants. Content (please ensure you mask any confidential inf…
-
Query or report to show B2B Communication details for each supplier siteSummary Query or report to show B2B Communication details for each supplier siteContent Is there a query/analysis/report/data model, etc. available in OTBI to show which…Jennie Wortman 263 views 3 comments 3 points Most recent by Ruthvik Ramesh-IH Reporting and Analytics for ERP
-
How to Stop Duplication of Billed Amount in AnalysisSummary: I am attempting to build a report which will combine corporate card data and expenses data. The goal is to track corporate card transactions to the expense repo…Ashley Dore 11 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
Missing PJF Tables/Views (i.e PJF_TASKS_V) In BICC PVO Data Lineage RepositorySummary: Hi Team, We need to extract data from Oracle and send it to our downstream systems. We're using BICC for this data extraction process. Our current challenge is …
-
Unable to access Recruiting - Recruiting Real-Time OTBI report using the custom roleSummary Unable to access Recruiting - Recruiting Real-Time OTBI report using the custom roleContent Getting below error while accessing Recruiting - Recruiting Real-Time…Venkatraman G 170 views 10 comments 0 points Most recent by Aishwarya_15 Reporting and Analytics for HCM -
Report for a Salary basis of the type "Salary amount is determined by simple components"Summary: We have a Salary Basis defined of the type "Salary amount is determined by simple components" and we have hired an employee with this salary basis. There are 5 …Sachin_Shirke 403 views 4 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Headcount is Overstated in Pie Charts when using EthnicityHello everyone! I would like to make a pie chart to show the percentage of each of our candidates by ethnicity. The problem is this: When candidates select multiple ethn…
-
SQL query for Work Order to Customer DetailsIs there a query that can be used to join Work Order details (WIE_WORK_ORDERS_B) to customer details (HZ_PARTIES)? Thank you!
-
Benefit analysis with benefit plan decline detailsSummary: I have created an analysis following the steps provided by the below post to get details of a benefit plan if any one declines the benefit enrollment. The analy…Ayesha Iroshani 11 views 3 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Query to Display the Roles with their Data Security Profiles NameContent Hi Team, Has anyone created any report to display the List of Roles along with their assigned Data Security Profiles. Regards, Harish Vummidi Version 21CHarishVummidi 202 views 15 comments 1 point Most recent by Mohit_Pal Reporting and Analytics for HCM -
Does anyone have a Procurement Purchase Order dashboard they could share?Summary: Wondering if anyone has a (more recent) Procurement / Purchase Orders OTBI Dashboard they could share. Content (please ensure you mask any confidential informat…Greg Aulson 11 views 1 comment 0 points Most recent by Bharat Agrawal Reporting and Analytics for ERP
-
Table for Additional Statuses (Timecard)We have a requirement to get Earned Date, Value, Unit of Measure, Payroll Time Type , Absence Type , Payroll Transfer Status & Payroll Processing Status. We are trying t…Manoharan 73 views 2 comments 0 points Most recent by Nagaraju Godasi Reporting and Analytics for HCM
-
Transpose rows to columns in OTBISummary I need to build a report that shows every employee as a column. Convert all rows to Columns in OTBIContent Hi I hope you can help me. I need to build a report th…
-
How to remove Blank Rows in a report?Summary: Once we export the report there are a few Blank rows at the bottom, is there a way to remove them? Content (please ensure you mask any confidential information)…THawkins_LGI 91 views 8 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Bank account Reconcile OTBI reportSummary: Content (required): when I make a cash transfer from bank to bank .there are two numbers one of these is a transaction number on the manage transaction page and…salma_essam 111 views 2 comments 0 points Most recent by Truptesh Solanki Payables, Payments & Cash Management
-
Embed OTBI in Requisitions responsive PageSummary: Hi, We are trying to embed an OTBI report that will pull in the Job Code for a particular job requisition into the job requisition page. The attempt was to have…
-
Using 2 different subject areas (Salary and Performance Rating) - Getting split/merged cellsSummary: Hi Experts, I'm pretty much a beginner with reporting. My client wants an OTBI report that can pull salary details as well as latest performance ratings (overal…S Shree 81 views 9 comments 0 points Most recent by Reddykrishna Chidella-Oracle Reporting and Analytics for HCM
-
How do I see all scheduled recurring jobs & detailsI have come into a situation where folks have been allowed to schedule recurring jobs under their own IDs. This creates a handful of issues (in my mind at least): No one…Matt Mossman 391 views 12 comments 1 point Most recent by Bharat Agrawal Reporting and Analytics for ERP
-
Analysis to retrieve total element amount per month and yearly trendSummary: Good afternoon, I'm trying to build an analysis to get the total amount of elements (e.g., variable pay) + salary that is valid in a specific month in some coun…ammiano 21 views 2 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Where is the Overdue Status in OBTI Analysis?Summary: Making my own version of a Compliance Report that was in a webinar teaching and I cannot find the Overdue Status Content (required): Best criteria for showing a…
-
Do analyses run with Agents log to "OTBI Usage Real Time" subject area?Summary: Do analyses run with Agents log to "OTBI Usage Real Time" subject area? Content (required): Version (include the version you are using, if applicable): Code Sni…Andrew_Schmitz 41 views 3 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales -
Elements - balance feed "as of" date promptSummary: We are using SQL data model to report on various balance feed items for elements. We have hundreds of elements and need to be able to compare configuration as o…Michelle Hughes 21 views 3 comments 0 points Most recent by Michelle Hughes Reporting and Analytics for HCM
-
Is there a place we can go to get a daily usage statistics for each module showing the persons loggeSummary Management needs this information to make a decision about licence renewal.Version 21BDavid Sakeye 118 views 10 comments 1 point Most recent by Rory Fielding Reporting and Analytics for HCM
-
Reporting Prior Month Data SQLSummary: Can we add SQL to the formula to look at the Prior Month data? So tell it to look at the System date - 1(for prior month) and pull 1st to last date of that prio…THawkins_LGI 41 views 12 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM
-
Using Workforce Management - Worker Assignment Real Time Can't view own record in OTBISummary: we have one OTBI report with SA "Workforce Management - Worker Assignment Real Time". When admin user(non employee) runs this report it pulls all the records. w…User_7A1QO 76 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Workforce Learning - Learning Records Real Time not able to fecth minimum capacitySummary: With Subject Area: Workforce Learning - Learning Records Real Time, we are able to get the maximum capacity of the offering "Offering Assigned Learning Item Inf…