OTBI
Discussion List
-
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 264 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 13 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 373 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 190 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)https://us.v-cdn.net/6034893/uploads/59HOTVHRD3TK/timecard.txt We have a requirement to get Earned Date, Value, Unit of Measure, Payroll Time Type , Absence Type , Payro…Manoharan 72 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 94 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 112 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 330 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 43 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 71 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…
-
OTBI Report Issue with Candidate Inclusion and ExclusionI'm facing a challenge with the OTBI report. I'm trying to incorporate two sets of logic: Requisitions with candidates. Requisitions without candidates. However, when I …Ranjith Antony MPC 11 views 0 comments 0 points Started by Ranjith Antony MPC Reporting and Analytics for HCM
-
Unable to get the proper count for Assignment Count when I am using two subject AreasSummary: Hi Team, we have requirement to get the count for Nationality to get this column we are using 'Person Real time' Subject Area. and we also have to filter this c…Ashok Dhara 11 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Privileges/Duty roles required to extract Absence data via OTBI AnalysisSummary: Hi Team, Could some one kindly help us on the below requested issue. We are unbale to extract Absence related data from the Subject Area: Workforce Management -…User_2025-02-07-03-03-32-616 204 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM