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
-
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… -
Report Error: ORA-01438: value larger than specified precision allowed for this columnSummary: Hey, I am running a custom report in BI Enterprise and keep getting the error below. The report is failing for only a few circumstances and am able to run it fo…
-
Dynamic Pivot column in BI PublisherSummary Need the column of a pivot table to be dynamic in BI PublisherContent We have a requirement to display GL balances by BU hierachy and period. As the users can ru…
-
Reporting on Transaction Incidents per User?Summary: We would need to be able to report on transactions done by certain users (aggregation of all incidents/controls where the selected user has done possibly fraudu… -
Bursting feature in BI PublisherSummary Burst contents to email body than attachmentContent Hi - I have a requirement to send Dunning letters in BIP but the contents should be in the email body rather …
-
Fusion ERP REST APIs for China RegionContent I am looking for REST APIs for China w.r.to Fusion ERP. Is there a document ? Can anyone please point me to these documentation? Thanks, Aruna S
-
Issue running BI reportContent Some users are experiencing issues running report https://eeho.fa.us2.oraclecloud.com/analytics/saw.dll?bipublisherEntry&Action=open&itemType=.xdo&bipPath=%2FCus…
-
Refreshes P2T - Should BICC jobs be copied during a PROD to Test refresh?Summary Refreshes P2T - Should BICC jobs be copied during a PROD to Test refresh?Content Refreshes P2T - Should BICC jobs be copied during a PROD to Test refresh?
-
Oracle Cloud Planning Dashboard 2.0 - Waterfall chart and loading timeContent Hi everyone I am trying to build a dashboard by using Dashboard 2.0 function and having an issue here, wondering whether you have had same issue and how to solve…
-
Best Practices to load high volume dataSummary Best Practices to load high volume dataContent Hello All,We are working on a project in which we may get high volume data to be loaded through FBDI. Based on you… -
Role required to view Analytics section on Fusion Home PageContent Dear All, Could you please help me with the role required in Fusion to make the Analytics section visible on the home page. Regards, Mahesh
-
Report Using Procure to Pay Subject AreaSummary A new subject area called “Procure to Pay Real Time” has been added to Procurement’s Oracle Transactional Business Intelligence or OTBI. You can use this subject…
-
Customization using Application Composer - ERP and SCM ApplicationsContent Hi, We have made customizations using Application Composer. We have created 442 custom objects and 10000+ custom fields have been added across new object and sta… -
Procurement - Pending Change Orders Subject area does not correctly reportSummary The Change Order Creation Date is actually the PO Creation DateContent Has anyone else noticed that the "Change Order Creation Date" - a vital field in this subj… -
Oracle Fusion Financials - custom version of standard BI Publisher reportSummary Oracle Fusion Financials - custom version of standard BI Publisher reportContent I am following this guide; - https://docs.oracle.com/en/cloud/saas/financials/21…
-
Get Invoices API not working Fusion Financial CloudSummary 500 Internal Server ErrorContent I have managed to successfully test many Rest API's in Postman however the Invoices API returns a '500 Internal Server Error'. I…
-
'Create' Icon is missing from 'Manage Enterprise Scheduler Job Definitions and Job Sets for Human CaSummary 'Create' Icon is missing from 'Manage Enterprise Scheduler Job Definitions and Job Sets for Human Capital Management and Related Applications'taskContent Hi Team…
-
Unable to search Custom reports using Schedule New ProcessSummary Unable to search Custom reports using Schedule New Process. Reports are not coming in Search resultsContent Hi Team, Reports are not coming in Search results whe…
-
How to Handle Null or Not Present tags in xml file in BI Publisher?Content Hi all, I have an issue where I'm stuck at making an XML condition for a check print. I used this SQL query for the same condition, and now I want it to be imple… -
Need a query to get ending balances for current cost,impairment,depreciation for fixed assets for aContent Hi all, Can someone provide me with a query to get ending balances for current cost, impairment, depreciation for fixed assets category wise for a specific perio…
-
Unable to download Financial Reporting StudioSummary Unable to download Financial Reporting StudioContent Our customer has financial reporting report which needs to be opened through Financial Reporting Studio. I t…
-
I am looking for a way to get the value of a custom field (data type: NamedIDLabel) that I have creaSummary I am looking for a way to get the value of a custom field (data type: NamedIDLabel) that I have created in my contacts table.Content I am looking for a way to ge…User_2025-02-03-22-06-34-432 23 views 0 comments 0 points Most recent by User_2025-02-03-22-06-34-432
-
Why there is a delay in data loading for BI reports in fusion?Content Hi all,I found that some of the customs made BI reports in the fusion by me, has a delay in displaying data when a transaction or any change is done in the syste…
-
Post report Completion event for External SystemsSummary Post report Completion event for External SystemsContent Hi, There is a scenario wherein client needs an event once the report is completed successfully, an even…
-
COA Segment Values based on Security RulesSummary COA Segment Values based on Security RulesContent We have a requirement to filter BI Report PARAMETER for COA Segment Values based on the security rules defined …
-
Oracle ERP > Procurement> Self Service Receipts tables to query for a reportSummary Self Service Receipts tables to query for a reportContent Hello Community, I am new to the topic, and I am trying to generate a report on Oracle Fusion ERP based…
-
query to get item cost to secondary uomContent if i have an item has prinary uom and secondary uom. i need to get item cost for secondary uom.