OTBI
Discussion List
-
How to avoid duplicate invoice number while performing the PO receivingWe have observed a scenario where a PO receiving was created twice using the same invoice number. Currently, the system allows entry of duplicate invoice numbers without… -
Reference number in system transactionsSummary: Could we change the reference in system transactions for bank reconcilliation? The reference column and transaction number is populating same data. Could this b…
-
PER_PERSON_EIT_EFF flex fields are not appearing in OTBI Subject AreaSummary: Some PER_PERSON_EIT_EFF flex fields are not appearing in OTBI Subject Area Content (please ensure you mask any confidential information): See screen shots of Fl…Al Darabaris 29 views 2 comments 0 points Most recent by Al Darabaris Reporting and Analytics for HCM
-
Audit Report - On Folder Permissions ChangesSummary: Content (required): We have a requirement on Auditing folder Permissions Changes on any OTBI folders This report in theory needs to show us When and Who and Wha…Clifford Trett 344 views 15 comments 4 points Most recent by Namrata_20 Reporting and Analytics for HCM -
I need to create an analytic in OTBI To identify what work schedule is assigned to employeesI am trying to create a simple analytic in OTBI to show all employee names, their assignment numbers and the names of the assigned Work Schedule for each assignment. It …
-
Scheduling of Assignment Profile based on analysis criteriaSummary: Scheduling of Assignment Profile based on analysis criteria Scenario: Whenever a new employee joins the organization, We have few courses to be assigned to them…
-
Get list of all BI Publisher reports that use a specific data modelSummary: Is there a way in BI Publisher to get a list of all BI reports that are using xyz data model as the DM, in order to understand the impact of making changes to a…Shant_Sarkissian_WJG 714 views 8 comments 0 points Most recent by Surya_TejaS Reporting and Analytics for HCM -
How to pass multiple values in a single parameter in OTBI agent?I have a requirement to prompt user while running an OTBI agent. But I don't see that option. Is there a way we can pass multiple values in a single parameter by using O… -
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 22 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. 71 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 … -
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 35 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 703 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 126 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 132 views 7 comments 0 points Most recent by Diana Mitrovski Reporting and Analytics for HCM -
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…