OTBI
Discussion List
-
OTBI report has increased massively since 26BHi, A report that was taking 9 seconds to run is now taking 706. This is since 26B came in on Monday. I will attach the report xml, and I have run a Performance check us… -
Requisition Life-cycle report (OTBI)Summary Simple report showing creation date, approval date, PO creation date etc for purchase requisitionsContent See attached screenshot for details. Unarchive the atta… -
Unable to Get Cost & Bid Details Agent Output in Design to Source WorkspaceI am currently testing the Agentic AI capabilities in the Design to Source Workspace and facing a few issues. When we provide a prompt such as: “Shift focus to Item ABC … -
Unable to get OTBI column value for 'Request to Resubmit' Approval actionSummary: We are unable to fetch OTBI column value for 'Request to Resubmit' Approval action on Supplier Registration Request page which is impacting us to develop one ne…AnuragGandhi 11 views 4 comments 0 points Most recent by Sai Krishna Reddy Gurram-Oracle Reporting and Analytics for ERP -
BIP Vs OTBI What is the practicality of moving BIP reports to OTBI?Summary: I am recommending that my client investigates the possibility of using OTBI in preference to BIP for their reports (including whether this is just for new repor… -
Front-Loaded Accrual BalanceContent I've been trying to create an Absence Balance OTBI Report that reports both the Incremental and Front-Loaded Balances (for the Incremental Accrual Balance, I use…
-
Account Holder field not available in OTBISummary: Account Holder field not available in OTBI Content (please ensure you mask any confidential information): Hi experts, we are creating an OTBI report to retrieve…Oriana L. 31 views 6 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
CST_TRANSACTION_COSTS pvoSummary: What is the PVO for CST_TRANSACTION_COSTS Content (please ensure you mask any confidential information): Version (include the version you are using, if applicab…
-
Joint Venture Setup and Contributions AnalysisSummary: It seems there is only an OTBI subject area for the Joint Venture module Transactions and Distributions details. There does not seem to be a way to report on an… -
Cannot commit OTBI report on Purchase Orders (Redwood) pageSummary: OTBI report added on Purchase Orders (Redwood) page 'vanishes' after 'Exit Edit Mode' view. Content (please ensure you mask any confidential information): I am … -
SQL query or table for Project Cost Transaction AccountingSummary: Hello, Please help to have query or table to get the accounting details from Project Cost Transaction where we know the transaction number. Content (please ensu…
-
AR Transaction Register Report erroring as too many records. how have people got round thisSummary: AR Transaction Register Report erroring as too many records (trying to run for full quarter as needed for external audit). how have people got round this? Conte…Jill Stanton 31 views 8 comments 0 points Most recent by Rinku Gautam Reporting and Analytics for ERP
-
Missing time cardWe would like to see missing time cards. We have specified Compliance also and existing report related to compliance OTBI gives time entry is missing if anyone creates a…
-
Hierarchical Prompt for dep tree with OTBISummary: Hierarchical Prompt for dep tree with OTBI Content (please ensure you mask any confidential information): Hello experts, we have configured in OTBI a report wit…
-
ORA-00920: invalid relational operator when using Menu parameter with multiple selection enabledSummary: Hi Team, I'm unable to use Menu type parameter in where clause in SQL query in a DataModel when 'Multiple Selection' enabled. Below is the screenshot of the whe…Shashidhar Goud 604 views 12 comments 0 points Most recent by Naveen_CCC Reporting and Analytics for ERP
-
Guidance for copying seeded report for customizationSummary: As someone new to OTBI, I'm hoping to copy a seeded report (Payables Trials Balance Report) to run for specific vendors. I've copied the report, but don't know …
-
Deep Link/table for each task notification?Hi all, I need an SQL query or a deep link to get the link for the tasks in the BPM worklist like this: thanks.Mohammad Borghol 93 views 4 comments 0 points Most recent by Kristy Fung Reporting & Analytics for Fusion Service
-
Issue with Month-wise Active Headcount Count in Workforce Real time Trend Subject Area - OTBI ReportHello All, I am working on a report using the Workforce Trend - Real Time subject area in OTBI. The requirement is to show month-wise new joiners, attrition, and total a…KetanChavan 123 views 7 comments 0 points Most recent by Diana Mitrovski Reporting and Analytics for HCM -
Query or report to print approver hierercy once the Invoice approval initiatedSummary: We need to know a report name or query so that we can run this report or build a report from the query which will provide al approvers name list which we genera…Sam Samaddar 1 view 1 comment 0 points Most recent by Sam Samaddar Payables, Payments & Cash Management
-
Can OBTI “Payment History Real Time” & “Disbursement Real Time” have fields like payment DFFCan below fields like Payment File Reference and Payment DFF extract into OBTI report like “Payables Payment - Payment History Real Time” & “Payables Payment - Disbursem…
-
Can OBTI “Payment History Real Time” & “Disbursement Real Time” have fields like payment DFFCan below fields like Payment File Reference and Payment DFF extract into OBTI report like “Payables Payment - Payment History Real Time” & “Payables Payment - Disbursem…
-
Inputs Needed for BIP Folder Setup.Summary: Inputs Needed for BIP Folder Setup. Content (please ensure you mask any confidential information): By mistake, we removed My Folders in the lower environment. W…
-
Process learning records is not fetching the OTBI analysis reportSummary: Created learning initiative with analysis report and scheduled the Process learning records. But it is not assigning the specialization to the new hires. Showin…
-
What is the required privilege to access and run an existing report?Summary: We created a role to view suppliers, but now I can't access a report I previously created. Which privilege allows me to run this report? I see the report and an…
-
Oracle table name to fetch all Supplier Profile Change Request DetailsSummary: We have requirement to build report with below columns. 1. Supplier name 2. Supplier account number. 3. Date of account update- Initiated 4. Account update- Dat…
-
How to capture Tax Registration Number at Supplier Address level in OTBI reportSummary: Requirement is to populate Tax Registration Number from Supplier Address level in OTBI report Content (required): I have created an OTBI report for Supplier Mas…