OTBI
Discussion List
-
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 11 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 2 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…
-
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 747 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 1 view 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 11 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 18 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 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 1 view 0 comments 0 points Started by Oscar Chahestian-Oracle Reporting and Analytics for ERP
-
Project Period Close Exceptions DashboardSummary Project Period Close Exceptions DashboardContent Project Period Close Exceptions Dashboard - Anybody created as shown in release document. Attached screenshot -
Report combining Subject areas Project Costing - Actual Costs and Project Costing - CommitmentsHi, Has anyone created an OTBI report that lists all costs related to a specific project and the tasks designated to that project? I was able to get almost all the field… -
How to use 2 subject areas in same formulaSummary: Using Analysis Report type, is it possible to have data from both subject areas in the same formula? Content (please ensure you mask any confidential informatio…Justine Klemetson 22 views 2 comments 0 points Most recent by Yves_Guyon-Oracle Reporting and Analytics for ERP
-
Create custom notification with Agents in OTBISummary: We are looking to create custom notifications utilizing Agents in OTBI. We have specific use cases where we need users to receive notifications (i.e. project co…
-
difference balances xla_ae_lines and xla_ac_balancesSummary: We created an OTBI report in the "Subledger Accounting - Supporting Reference Real Time" subject area, and it doesn't contain a value for a supporting reference…
-
How to calculate EOD balance for the last day of Previous month based on accounting date in OTBII'm trying to calculate the End of the day balance for the last day of previous month based on accounting date which I'm passing as a parameter in the OTBI Analysis. Sub…Sri Sai Kiran Tekumudi 53 views 2 comments 0 points Most recent by Sri Sai Kiran Tekumudi Reporting and Analytics for ERP
-
Need Sample and Confirmation of AnalysisSummary: Hi We have requirement to create analysis of procure to pay process (PR-PO-Receipt-Invoice-Payment). We need your help to give sample how to create analysis wit…
-
Fusion BI Report Time zone issues in report output related queriesOur users are in PST Timezone and has raised concerns about report outputs being in UTC Timezone. We are trying to update report code and wanted to clarify few queries b…Abhilash K - Deloitte USI 446 views 8 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
How to hide "set ownership of this item" from properties option in Report and Analytics ?We have a requirement where business is asking to hide "set ownership of this item" for users with specific roles. we tried to hide from "Manage Privileges" but some how…
-
In OTBI the table view window presented is too small. How to resizeSummary In OTBI the table view window presented is too small. How to resizeContent In OTBI the table view window presented is too small. How do I resize this preview win…User_2025-02-05-22-11-22-331 1K views 6 comments 5 points Most recent by otavio.teixeira Reporting and Analytics for ERP
-
Question about Infolet on ERPHi Team, Our client is currently undergoing a process to revalidate user privileges. During this process, we observed that simply accessing the pages and viewing the Inf…Oscar Chahestian-Oracle 22 views 4 comments 0 points Most recent by Oscar Chahestian-Oracle Reporting and Analytics for ERP
-
How to default a Prompts selection in OTBI dashboard from Lookup code based on logged in UsernameWould like to reach out to you on how to set the default value of a Prompt with a value from lookup code which is related to the logged in User name. We have an Analysis…Dinesh R 2 views 1 comment 0 points Most recent by Shradhanjali_Oracle-Oracle Reporting and Analytics for ERP
-
Is it possible to split a concatenated segment (accounting combination) in an OTBI reportSummary: I am trying to split the concatenated accounting combination into different columns, each column should be displaying a segment separately Content (please ensur…Eva Mirzoyan 115 views 5 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP -
Plsql procedure from a Saas Report or Saas page?Summary: Invoking pl-sql procedure from SaaS Report or through a SaaS link on a page Content (please ensure you mask any confidential information): We haven't OIC. We'd …Luca Nobili PWC 21 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to customize standard OTBI ReportSummary: How to customize standard OTBI Report Content (please ensure you mask any confidential information): I need to customize one of the standard OTBI reports in Fus…
-
Cost Center from subject area "Payables Invoices - Transactions Real Time"Content Hi. I'm struggling to figure out how to find the field, where I can see the cost center, outside the concatenated segment... Whenever I use the Cost center descr…Anders W. Langholm 79 views 13 comments 0 points Most recent by Piyush_Sinha Reporting and Analytics for ERP -
How to save an OTBI report into Reports and Analystics Favorites of Job Managers role in ERPI have developed some OTBI and BIP reports and I would like to centrally save this report in the Reports and Analystics Favorites for list of users / role. (Instead of e…