OTBI
Discussion List
-
OTBI analysis on duplicate expense linesSummary: How do you do this? I'm new to OTBI and Fusion ERP. I need to report on duplicate expense lines, meaning an employee accidentally submitted their expense twice … -
Restricting Person Type LOV on Line Manager Dashboard Without CustomizationWe are currently exploring options to restrict certain values from the Person Type LOV that appears on the Line Manager Dashboard. Since the Person Type Lookup is a syst…Shubham Kadam 14 views 3 comments 0 points Most recent by Shubham Kadam Reporting and Analytics for ERP
-
Can an OTBI report have a sub-total lines?Summary: I have created an LD Schedule OTBI report where I need to insert a sub-total by Employee the percentage of effort. Can someone share how I can add that in the A…Cris_Yee_Allenite 115 views 2 comments 0 points Most recent by Regie Mercado Reporting and Analytics for ERP -
Looking for PO Receipt Number and related data in OTBISummary Cannot find PO Receipt Number, Receipt Date and related date in OTBI Subject Area: Procurement: Procure to Pay Real TimeContent Cannot find PO Receipt Number, Re…Rona Jeongco 608 views 14 comments 0 points Most recent by Scott at Denovo Reporting and Analytics for ERP
-
How to know who delete some reports in OTBIA folder containing reports has disappeared from my environment, and we want to know if it was accidentally deleted by a user or where the folder is located.
-
SQL for all roles and it's inherited roles for BIP.Summary: Hi, I have a requirement to create a BIP report to fetch the details of all Roles and its inherited roles. I have seen that it can be achieved by OTBI but can't…Sameer Khan 29 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
OTBI 条件分岐Summary: I want to implement conditional branching in OTBI. What operations are required to achieve this? Content (please ensure you mask any confidential information): …
-
Enable custom reports centrally for all Job managers in PPM manage project financial plan analyticsWe are new to Oracle.. How can i enable list of custom report for all users/ or job manager role in the PPM manage project financial plan analytics pop up tab on the rig…
-
Which subject area can I use for procurement contract agreement deliverablesSummary: Which subject area can I use for procurement contract agreement deliverables? Content (please ensure you mask any confidential information): Version (include th…Cindi Jacobsen 35 views 4 comments 0 points Most recent by Yahya Khan Reporting and Analytics for ERP
-
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 26 views 1 comment 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
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…
-
Unable to proceed to create Dataset using webservice in Oracle BIP ReportSummary: Unable to create dataset with Webservice while creating custom BIP report Content (please ensure you mask any confidential information): below are the steps to …SireeshaJaladi 98 views 6 comments 1 point Most recent by Sri Prasanth Reporting and Analytics for ERP
-
Report Output data getting spit in two rows in excel file due to line breakageSummary: We have an OTBI report based on an Analysis where the Data Model is also using Analysis. In the data, there are line breaks within certain fields. When exportin…Nikhil Kubba 28 views 3 comments 0 points Most recent by Nikhil Kubba Reporting and Analytics for ERP
-
How to add page break in etext template (Fixed position based) in BIP reportHow to add page break in etext template (Fixed position based) in BIP report? Need to add page break after every 50 rows.Harshitha S Motagi 33 views 3 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
OTBI report timed out for specific Period onward even data count is similarWe are facing issue with a OTBI report that's part of a dashboard. The user runs the report exclusively through this dashboard. It has been working fine since last one y…Abhishek_Kumar_DTV 8 views 0 comments 0 points Started by Abhishek_Kumar_DTV Reporting and Analytics for ERP
-
Data Security not being applied to OTBIWe have a report created using the Subject Area- Expenses - Expense Transactions Real Time. As per Oracle documentation, this subject area access requires, Expense Trans…
-
difference balances xla_ae_lines and xla_ac_balancesSummary: difference balances xla_ae_lines and xla_ac_balances Content (please ensure you mask any confidential information): We created an OTBI report in the "Subledger …Francesca1 10 views 1 comment 0 points Most recent by Daniel Martin Subledger Accounting & Accounting Hub
-
What is the default size of calculated columns in BICC extracts, and is any documentation available?While generating metadata using BICC R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheet (Rel13_25C_BICC_FSCM_Database_Mapping_with_ViewOb… -
Can't inquire into Invoices in the system using Action Link in OTBISummary: Hi. I'm trying to create OTBI Report that will show outstanding Invoices (Unpaid after Due Date is already Due). I'd like to add Action Link, so user will be ab…Yftach Paschur-Oracle 7 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
OTBI Analysis: How to format Person Number as 6 digits with leading zeros?Summary: Hi experts, I have a business need that requires me to extract data from an OTBI analysis and format all Person Numbers as 6 digits with leading zeros when need…
-
A SQL query of privileged resources in the role FSD sectionSummary: Hi All, Can anyone share a SQL query on how to retrieve privileged resources? inside the role of the FSD section oracle provides information about the privilege…Eliran Hadad 31 views 6 comments 0 points Most recent by Eliran Hadad Reporting and Analytics for ERP
-
OTBI Report with Payments Disbursements and Invoices with Invoice distributionSummary OTBI Report with Payments Disbursements and Invoices with Invoice distributionContent I am trying to create a report that shows only the invoice expense account …User_2025-02-06-00-15-19-515 733 views 3 comments 0 points Most recent by J Dimond Reporting and Analytics for ERP -
Verification of User Login Status in ERP CloudSummary: I would like to know if there is a report in ERP Cloud that shows which users logged in and when. Content (please ensure you mask any confidential information):…
-
OTBI costing receipt accounting subject area -- project number is not populating for transfer ordersI have created an analysis in OTBI using the costing receipt accounting real time subject area. The report is working fine, balances to the general ledger and reflects a…Walter L Gess 5 views 1 comment 0 points Most recent by Walter L Gess Reporting and Analytics for ERP
-
LSQL print first valueSummary: Moved to SCM Reporting and analyticsVDM_IM 12 views 2 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Searching in Reports and Analytics using the magnifying glass icon giving internal server errorSummary: In reports and Analytics, users wanted to search for some related reports and so by using the search option(magnifying glass icon), they entered some options an…P.S.Nikhitha Muduliar 12 views 2 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
What reports are available for agent level productivity metrics?Summary: We are looking at agent level productivity metrics. What seeded reports are available in Oracle? Or are these custom created reports? This ask is across all the…VWollin 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How can i get currency report to show currencies and the exchange rate against a currency in OTBIIgnore- Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):ACDC 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to capture Tax Classification Code at Supplier Address level in OTBI report.Hello Experts, we want to capture the Tax Classification Code at Supplier Address level using an OTBI report. We are checking on Supplier Real Time subject area. Is ther…
-
Our customer needs to identify the report path in OTBI related to an Infolet.Our customer needs to identify the report path in OTBI related to an Infolet. Please see the attached document (Infolet-OTBI.docx and HELP-OTBI-PATH.docx) attached here.…Oscar Chahestian-Oracle 8 views 0 comments 0 points Started by Oscar Chahestian-Oracle Reporting and Analytics for ERP