OTBI
Discussion List
-
OTBI report on Purchasing subject area triggers additional licenseSummary: The Project Financial Management user creates the PR and the PO for their subcontractors on their project. A report that tracks the PO and remaining quantities … -
Table for Assign Learners to a Catalog Learning ItemNavigation :- On the Enrollment Details page> On the Select Learners page, Add menu, select the method to use to identify learners Can anybody point the table associated… -
Migrate custom objects/page created via application composerSummary Need steps to migrate custom objects/page created via application composer (in a sandboxContent Hi Everyone, We need steps to migrate custom objects/page created… -
Report on Alerts Composer Notification ReportingSummary: I'm looking to see if there are any OTBI subject areas that can be used to report on the various event notifications that are sent out using the Alert Composer …Rohan Fernandes 241 views 8 comments 2 points Most recent by Unknown Reporting and Analytics for HCM
-
Custom Expense Approval Notification template is not working correctly.Wyoming customized our approval template to include funding information directly on the approval notification in the UI and in the email. When we run the example from OT… -
OTBIWe are working on OTBI in report and anlytics in Fusion, and in that there is a requirement to create below reports through OTBI analysis. PR cycle time Rate of emergenc…Priya Ranjan Jamuar 31 views 2 comments 0 points Most recent by Priya Ranjan Jamuar Reporting and Analytics for SCM
-
How to query the latest pdf contract from purchase agreements after a change orderSummary: Content (please ensure you mask any confidential information): Hi Everyone, I currently have a query where I am selecting the Contract Number, Description, Star…Steph96 12 views 1 comment 1 point Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Missing the Attribute Column in FLEX_BI_ItemBaseDFF_VISummary: Content (please ensure you mask any confidential information): using (FscmTopModelAM.EgpItemsPublicModelAM.ItemBaseDFFBIAM.FLEX_BI_ItemBaseDFF_VI) I'm attemptin…Waleed Fetoh 11 views 1 comment 0 points Most recent by Cornel Melinte-Support-Oracle Reporting and Analytics for SCM
-
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 72 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 42 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 31 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 31 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 169 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 382 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 71 views 2 comments 0 points Most recent by Nagaraju Godasi Reporting and Analytics for HCM