OTBI
Discussion List
-
Bare minimum roles required to view infotile dashboards for Procurement?what are the bare minimum roles required for the user to access an infotile dashboard in "Procurement Area" (Purchase Requisitions and Purchase Orders) I created a intof…mayankthakur 21 views 1 comment 1 point Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
LRU Registration ReportSummary: LRU Registration Report Content (required): Hi Team, Greetings! We have the details for LRU (Legal Reporting Unit) Registration defined under "Manager Legal Rep…Parag Hiremath 71 views 11 comments 0 points Most recent by Chris Carloff Reporting and Analytics for HCM -
Dashboard access and rolesSummary: To start with, big thanks to all who reply. So went live with Fusion on January 2024. I have put together a dashboard using "Receiving - Purchase Receipts Real …Than0s 41 views 1 comment 1 point Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Requirement: Receipt report that gives the end user the ability to download a PO or PR attachmentSummary: Customers have provided us with the requirement to develop a receipt BI or OTBI report that gives the end user the ability to download a PO or PR attachment if …Shashikanth Kumar P-Oracle 33 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Can I compare archived versions of supply plan in OTBI?Summary: I am trying to build analytics/ reports in OTBI, where I can compare different versions of the same supply plan. Content (required): does that work similar to A…User561715 33 views 1 comment 1 point Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
In what table can I find Box_Assignment Column from Talent Review?Summary: In the Oracle Fusion Cloud HCM Talent Review module, wherein the Tables and Views for HCM can I find the value for the Box Assignment? Content (please ensure yo…
-
OTM-How to get dump of tables periodicallySummary: How can we get dump of followinbg tables on regular basis into our reporting environment which is outside of Oracle OTM? This is needed for reporting purpose. W…Hitesh Vashishtha 92 views 9 comments 0 points Most recent by Hitesh Vashishtha Transportation Management
-
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 405 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 204 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 75 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 82 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