OTBI
Discussion List
-
OTBI British Summer Time effecting dates in Payroll - Element Entries History Real TimeSummary: British Summer Time (GMT +1) is producing incorrect results from the date Prompt using Effective Start annd End Dates Content (please ensure you mask any confid…Kevin Robertson 1 view 0 comments 0 points Started by Kevin Robertson Reporting and Analytics for HCM -
Organization tree OTBISummary: We have an Organization Tree in Fusion HCM where: LE = Top Parent Node Division = Child Node under LE Departments = Child Nodes under that Division LE-->Divisio…charan_Gudla 56 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Missing project and data when reporting from Project- Performance Reporting Real TimeSummary: I am reporting from Project- Performance Reporting Real Time, but some projects (not closed yet) is missing from this data set compeletely.. We have run the Upd…
-
Issue is when we add termination date in two subject areas OTBI reportSummary: Hi Team, when we add the two subject areas it showing correctly but when i adding termination date it showing two rows as below ? one is with termination record…AjayKumar Maddipati 41 views 10 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Add Additional Columns in Review Customer Account Details ScreenSummary: We are looking to create an analysis based on customer account details. This includes information available in the seeded solution for customer accounts, such a…
-
Which Database table stores values entered from custom Editable measure?Summary: We have defined a custom editable measure for use in Supply Planning plans, but not getting the database table which stores the values of that measure entered b…Aishwarya Srivastava 11 views 1 comment 0 points Most recent by Arun K A-Oracle Supply Chain Planning and Collaboration
-
Populating the manager hierarchies for OTBI reportingSummary Provides the steps the populate the various manager hierarchies available in HCM OTBI Content This document provides details on the process that allows the custo…Raghavendra Raghunath-Oracle 1.4K views 14 comments 11 points Most recent by Ruvina Khan Reporting and Analytics for HCM -
Issue Using Two Subject Areas in a Single OTBI Analysis to Bring Budget and End Of The Day Balance.We are trying to build an OTBI analysis that contains Ending balances and End Of The Balance(EOD) related transactions within a period. To achieve this, we are using two…Sri Sai Kiran Tekumudi 21 views 0 comments 0 points Started by Sri Sai Kiran Tekumudi General Ledger & Intercompany
-
OTBI Report with SQL query filterSummary: Hi Team, We have a custom reporting requirement that involves applying complex, SQL-based filters. We are planning to implement this logic within an OTBI report…
-
Why cant we change the credit card charges notification templateSummary: When out visa upload takes place we have activated the automatic notification to be triggered and sent to the credit card holder to tell them they have new tran…
-
I am looking for the tables which stores IExpense item dispute date and dispute commentsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Volume of email notifications by typeSummary: I have a stakeholder who has requested the volume of emails by template sent by HCM to workers by Month. We have BI Burst, Alert Composer, and Seeded Notificati…SusanJ 11 views 2 comments 0 points Most recent by Andre Brown-Support-Oracle Reporting and Analytics for HCM
-
Getting errors UPDATING an Item in a Price List in Bulk using Import Price Lists Batch FBDIWhile trying to UPDATE an existing Price Lists' Items and Charges, getting the following errors: primary_pricing_uom_flag - Only one price list item record can be the pr…
-
Impact of import oracle fusion data extensions for transactional business intelligenceSummary: Hi, Please help us to understand if the program - Import oracle fusion data extensions for transactional business intelligence will impact in any of the current…SwapnilSurange1 44 views 1 comment 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Is there an API in Oracle that can extract the OTBI Analysis Criteria XMLSummary: We have lot of OTBI analysis which are being used for Learning initiatives/recommendations. These reports have filters on Organizational levels/Names. Whenever …
-
OTBI Analysis Report – Duplicate Rows Issue Even After Enabling DISTINCTSummary: I am working on an OTBI analysis where I am seeing duplicate rows in the output. For example, the same Person Number and Person Name (e.g., "101 – Ben") is repe…Manoj Muddineni 62 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Need to Extract Termination Transaction Approval DetailsSummary: Need to Extract Termination Transaction Approval Details Content (please ensure you mask any confidential information): Hello Experts, We have a requirement to …Vasanthakumar Ravi 21 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Check-Ins ReportContent We are considering implementing the Check-Ins feature in our 2021 performance reviews. We will need to be able to track completion rates. Perhaps I am overlookin…User_2025-10-31-00-57-47-193 79 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
BI report to extract GL Daily Rates table data for a range of corporate ratesSummary: Is there a report that can be schedules to export the GL Daily Rates table data out of Oracle Fusion? Content (please ensure you mask any confidential informati…
-
Want to fetch row values based on another column's value.I want to print mid salary values which are highlighted in screenshot, based on columns "overtime" and "grade rate name".Raja Subramanian-Oracle 13 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
how to fetch top 10 otbi reports that users access frequentlySummary: The request is to fetch the top 10 OTBI reports that users access frequently on their dashboard Content (please ensure you mask any confidential information): R…SivaNallagatla 41 views 7 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Functionality to print a label or report once the receiving is completedSummary: Business user is looking for the functionality to print a label or report once the receiving is completed against to the PO in Oracle. Is there a way to print i…Valencia Jonathan 21 views 1 comment 1 point Most recent by Adnan Siddiqui-Oracle Inventory Management
-
SQL query to get Bank Account Details at Supplier Header/ profile levelHello experts, I need SQL query to fetch supplier bank accounts details created at header/ profile level as below to check which bank account does not contain IBAN, Bank… -
Adding Count in OTBI which Uses Custom Logical SQL QuerySummary: I have created OTBI Report using Logical SQL Query using multiple table Subject areas and Outer Joins , Need to add Report Data Count in the report . Is there a…
-
OTBI Redwood Receiving CommentsWe have a requirement from users that they be able to see comments on RSSP Redwood Receipts (formerly before 24D in Notes). We are attempting to create am OTBI report wh…
-
What is the subject area of Project Definition DFF on OTBI on Projects module?Summary: We cannot find Project Definition DFF on OTBI. What is the subject area of this attribute on Projects module. DFF is BI enabled, we run "Import Oracle Fusion Da…
-
Trouble Querying For PO Delegation DetailsI am trying to query for delegation details of a PO. Currently only able to query for the approver name for each PO, but cant seem to join delegations table to properly …
-
Join XCC_BALANCES with PO tablesContent Hi all, I need to retrieve the budget available amount (see screenshot below) I found the amounts in the table XCC_BALANCES. But I can't find a way to join it wi…
-
we don't have access to OTBI report subject areaSummary: We don't have access to otbi report subject role with custom role, we unable find the exact privilege was missing. kindly help us on this. Thank you.
-
ESS JOB SHWOING DIFFRENT OUTPUTHi Experts! Greetings! Recently I Came across an issue in ESS JOB FOR BIP REPORT. When I run the ESS JOB then in the attachment (pdf) one part of the report is missing ,…Mainur-Oracle 55 views 2 comments 0 points Most recent by Crescentia David Reporting & Analytics for Fusion Service