Reporting and Analytics for ERP
Discussion List
-
Procurement > Dashboards > Procure-to-Pay no 'Period' list of valuesSummary There is no value in the list of values for 'Period'Content Hi, I'm trying to open the seeded dashboard Procurement > Dashboards > Procure-to-Pay But with any us… -
Using BICC PVO in data model for BI publisher reportingSummary: is there way to configure data model to use BICC PVO? we need some custom reporting built and would like to leverage BICC PVO in data model Content (required): … -
Do BICC and OTBI have access to the same data?Summary Wondering if there any differences in what data can be accessed via BICC vs OTBIContent Am wondering if there any differences in what data can be accessed via BI… -
Schedule BIP in fusion in 1st 10 days of EVERY monthSummary: Content (required): Is there a way we can schedule a custom bi publisher report in fusion for the first 10 days of every month? Version (include the version you… -
Schedule BIP in fusion in 1st 10 days of EVERY monthSummary: Content (required): Is there a way we can schedule a custom bi publisher report in fusion for the first 10 days of every month? Version (include the version you…
-
seed report for intransit shipment (what id the tables ?)Summary: i need what a seeded report for intransit shipment ? and what is the tables to create this report ? Content (required): Version (include the version you are usi…
-
how to notify once multiple ESS jobs are completed through BI report?Summary how to notify once multiple ESS jobs are completed through BI report?Content We have a requirement of executing ESS jobs like Reevaluation and spot translation i…
-
query to get item cost for each dayContent i need to get a cost of item for each day , how i create a query for this ?
-
Need a query to get total of Current Cost, Accumulated Depreciation, Impairment for asset categoriesContent Hi all, Can someone give me a query that gives a total of : * Current Cost * Accumulated Depreciation * Impairment per asset categories in Fixed Assets Module. R… -
Analysis Report Prompt is not appearing when running from the InvoicesSummary: Prompt added to the analysis report is not appearing when running it using invoice window. Content (required): Hi, I have created a OTBI analysis report (Not fo…
-
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…
-
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…
-
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…