To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
Table which holds notification modeSummary: We need table name which holds notification mode Content (required): table to print notification mode Version (include the version you are using, if applicable)… -
Subject Area Security - Unable to view data from relative subject area despite having role assignedSummary: Subject Area Security - Unable to view data from relative subject area despite having role assigned Content (required): I am currently attempting to troubleshoo… -
No data in balances when using Natural Account SegmentSummary: When working with Subject Area General Ledger - Balances Real Time I cannot see any data in balances: Beginning Balance, Period Net Activity and Ending Balance … -
Is there any OTBI subject area where "associated collaboration documents fields" can be found?Summary: Fields details: Navigation: Supplier > Sites > General > Associated Collaboration Documents Service Provider Trading Partner ID Partner ID Type Document Associa… -
Manager Proficiency result for Competency Assessment ReportSummary i cant find the competency assessment column that shows assessment resultContent I wanted to compare target competency assessment and manager competency assessme… -
Newly created Financial Categories do not show in BI report list of valuesContent I'm looking to pull in 3 new Financial Categories into a BI report I created. I've created the lookup codes under GL and attached the categories to the account s…
-
OTBI Cost Centre lists all parent valuesSummary Cost Centre in OTBI returns all parent values as well as the lowest levelContent Hi all, Hoping someone could point me in the right direction. I am attempting to…
-
Analytic needs to work with Prompt in DashboardSummary Analytic needs to work with Prompt in DashboardContent Hi, I have a Dashboard include one analytic and one prompt. When i open the dashboard, analytic is searchi…
-
SQL for Period Close Exceptions ReportSummary: SQL that generates reports Content (required): Hello, I am new as report guy at my company, and I would need to extract the SQL that generates this report 'Peri…
-
Scheduling BIP Report in Fusion Financials (Cloud) - Conditional SendSummary: Is a trigger necessary on a data model to conditionally send or not send a report in BI Publisher or will a data model that returns rows or doesn't suffice? Con…User_2025-02-10-15-12-48-631 27 views 2 comments 1 point Most recent by User_2025-02-10-15-12-48-631
-
What table contains the Receipt Amount in Contract Billing Details screenSummary: Hi - what is the underlying table(s) that contain the Receipt amount in the contract billing screen Content (required): Where is the table containing this data … -
How to show Payment Amount by Fiscal Period?Summary: I have a requirement to write an OTIB report to show total payments by fiscal period and supplier. Content (required): I've created the report using the Payable…
-
All assets that have been created in projects but have not been capitalized yetSummary All assets that have been created in projects but have not been capitalized yetContent I need to create a report in Project Costing - Assets Real Time subject ar… -
Error Receive when View ReportSummary: Error Receive when View Report Content (required): User receive the error message below when generating dashboard Version (include the version you are using, if…
-
How to check/download the BI report output submitted by usersSummary: Content (required): This is from Support User perspective. If a user opens a report from BI Catalog, runs it, and downloads the output, then how can we check/do…
-
Spend Analysis - How to load historical data to compare with current SpendSummary: I would like to know is there any method available to load historical spend data to compare with current spend? Content (required): I would like to know is ther…
-
Expense Report - all expenses by cost centerSummary: Content (required): We have an analysis created using Expense - Expense Transactions Real Time. When a user runs the report, they get their own expenses. When a… -
Can we create a Prompt dashboard w.r.t. 2 different pillars say procurement nd PayablesSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Can BI Deep Link use variable to represent the servername in the URLSummary: Deep Links present an issue during P2T environment copy downs because after each refresh all Deep Links embedded in BI report definitions have to be modified, i… -
ERP – Procure to Pay Enterprise Structures Best Implementation Practices, 10 June 2020, 9 a.m. PT -Content Submit your questions for the ERP – Procure to Pay Enterprise Structures Best Implementation Practices session to have them answered during the live event. Post …
-
Invoice Not reflecting in OTBISummary: Invoice Not reflecting in OTBI Content (required): Invoices created are not reflecting in OTBI Payables Transaction Real Time. Is there a time limit that the in…
-
Unable to find PVOs in BICCContent Hello, We need PVOs of following tables in BICC but we couldn't find these in Lineage Sheet. If anyone has any idea on how to get those or any workaround would r…
-
Mismatch in ZX_LINES and Manage Tax Details in Invoice PageSummary: Hi All, We are trying to create a report to fetch invoices with tax point basis as "ACCOUNTING". When we try to open the invoice result in front end it shows th… -
Is it possible to have default prompt value specific for each user in an OTBI dashboardSummary: We have an OTBI dashboard for which each user is searching a specific account combinasion. Instead of always typing the account in the prompt of the dashboard, …
-
Queries behind ADF pagesSummary: Is there a way to inspect queries behind the ADF pages in Fusion ? Content (required): Is it possible to get access to the queries/view objects behind a Fusion … -
BI Publisher RTF Template AR Invoice : Grouping rowsContent I am required to create an AR Invoice report, where services are needed to be grouped based on what kind of service they are within a report. To be more clear, f…
-
Unable to open parameters page for any of the BI reportsSummary: Unable to open the parameters page for any of the BI report. When I click on any of the BI reports, I get a blank page that is visible. Not able to access any o…
-
How to add Project ID to OOB report?Summary: Add a column to OOB report "General Ledger and Subledger Accounting by Journal Lines" for Project ID Content (required): I really like the OOB report General Le…
-
ERP - OTBI Advanced Features event on Sep 22th 9am Pacific TimeSummary: After the record interest from this community on the previous OTBI event 'ERP - OTBI Made Easy' in May, and several requests for an advanced session, we decided…
-
SQL to query current BI Agents scheduled to e-mail / dashboard page etcSummary: I have written an sql query to extract all BIP reports currently scheduled, but want to do the equivalent with OTBI BI Agents - is it possible using sql and acc…