OTBI
Discussion List
-
Fusion analytics report - Oracle pre build columns not yielding correct dataSummary: We are trying to transition the existing OTBI report with subject area — Workforce Management to Fusion Analytics where the column under Fusion analytics - 'Ave…RachitSharma 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
BIP Report: How to auto scale a graph in percent to 100Hi everyone, I would like to ask if anyone has a similar report where you were able to plot column values as percentages and scale the graph to display 100%. Columns: - …CAMIL_Q 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Where to find OTBI subject area for Job responsibilityWe're creating a report in OTBI for Model Job Profiles, however we couldn't find "job responsibility" section in the subject areas of OTBI. 24AAnita Andrádi 22 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Unable to join the field Display Name in Requisition Preparer in Procurement-Requistions Real TimeSummary: Hi All, Requirement : To add the 'Entered By' field from the Manage Requisition Header UI to an existing OTBI report (Full PO Report - Purchasing) Subject Area … -
Salary pay rates are incorrect for some employeesSummary: The OTBI report is showing incorrect pay rate data for some employees for HRA EX and Notional Special Allowance components. We cannot identify why this data is …Ridma Karunanathan 31 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
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… -
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 15 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 12 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 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 34 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 32 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 91 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 92 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 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 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 168 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 412 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!