OTBI
Discussion List
-
user unable to expand filter section in dashboardSummary: User unable to expand the filter section in a custom dashboard to enter his search criteria Content (please ensure you mask any confidential information): hi, I…Catherine Abi Samra 21 views 11 comments 0 points Most recent by Catherine Abi Samra Reporting and Analytics for HCM -
OTBI Payment Dashboard ErrorsSummary: Error Codes: OAMP2OPY:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P:OI2DL65P Error during query processing (SQLExecDirectW). State: HY000. Code: 10058. [NQODBC] …larachalak 156 views 1 comment 0 points Most recent by Lucy Cui-Oracle Payables, Payments & Cash Management -
OTBI-Learning-Is there a way to report on who specifically took the action to Withdraw the learner?Summary: OTBI - Learning Module - Is there a way to report on who specifically took the action to Withdraw the learner or who assigned the Learning item to the learner? …Harish Malik 41 views 3 comments 0 points Most recent by Harish Malik Reporting and Analytics for HCM -
Home or Work email address depending on termination statusSummary: Hi I'm building an analysis which contains both current employees and employees who have left within the last 60 days (established using a filter on termination… -
Termination count is not showing correctly in OTBI reportSummary: Termination count is not showing correctly in OTBI report Content (please ensure you mask any confidential information): Hi All, We are developing a HR dashboar…Venkatesan 21 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
Floater Days not updated with Absence Calendar Details Real TimeHello, I built a report with 'Workforce Management - Absence Calendar Details Real Time' subject area to include Vacations, Floater days; xml attached. I completed Float… -
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 21 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… -
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 11 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 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 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 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 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…