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/View for AP Invoice Approval History & Workflow (BPM Flow)We are in the process of creating a customized report to track the complete approval history of AP invoices in Oracle Fusion. The requirement is to fetch details of the … -
BI Report Pulled Into a Dashboard Displays the Parameters in TEST Environment but not PRODIn our Production environment I pulled a report into a dashboard and I can’t view the report parameters when I open the dashboard. However, when I create this report and… -
OTBI reports: The currency symbol always defaults to dollar $ symbolSummary: We have always used 'User's Preferred Currency' for the Currency symbol under 'Data Formatting' in OTBI reports. We are rolling out reports to EMEA and APAC use… -
How can I write a SQL query in Oracle Fusion Cloud to identify unapproved requisitions?Hi everyone, Please see the full question below. How can I write an SQL query in Oracle Fusion Cloud to identify unapproved requisitions where a specific approver (e.g.,…
-
CMK Message Processing RulesSummary: CMK Manage Message Processing Rules Description: We are working on Collaboration Messaging Framework process PO Inbound (EDI 850) to create sales order in Oracl…
-
There is a image placed in Custom/Image folder. How to access this image in the BI report template?Unable to access images from Custom folder in BI report template. We have placed the test image in Custom/Image folder and tried to access this image in the template but…
-
How can I join the hz_parties table to a project number or contract number table using sql.Hi everyone, I'm creating a work-in-progress report that tracks project costs and needs your help joining several Oracle tables efficiently. I'm working with: PJF_PROJEC…
-
Print receivables transaction process different default parameters for different usersI noticed that different users have different default parameters when running print receivables transaction process in scheduled process. Our configuration user access h…
-
Need to know the logic behind the seeded report parameters of Payables Trial Balance ReportSummary: Just wanted to know the logic behind seeded 'Payables Trial Balance Report' parameters which are mentioned below 1.Include Bills Payable 2.Negative Balances Onl…
-
Financial Tax Register is not picking receivable invoices created using REST APISummary: Financial Tax Register is not picking receivable invoices created using REST API Content (please ensure you mask any confidential information): Tring to create … -
BI Cloud Connector (BICC): ElementEntryPVO vs ElementEntrySummary: Both ElementEntryPVO and ElementEntry are sourced from the same view PAY_ELEMENT_ENTRIES_VL. However, when performing a full extract with the Effective Date Fil… -
Customization of Standard Trial Balance Reportwe have a requirement to create custom trial balance report using customize option from the standard Trial Balance report. The same time we want to keep both the reports…
-
Can we import data via API to be included in OTBI dashboardSummary: Is there a way to import data via an API and have this data be available on a OTBI dashboard? MJ
-
BI Publisher Packages in Datamodels for ReportsSummary: In Fusion ERP, several BI Publisher reports use packaged procedures within the data model. For example, the Fixed Assets Reserve Summary and Detail reports refe…
-
Can't show Saving column amount in FRSSummary: So we have a question for creating the report via FRS. So there's Total of Allocation and Allocated amount type in the FRS. Can you explain the meaning and the …
-
Receive Expected ShipmentsSummary: which table / tables store the data for this screen? Receive Expected Shipments Content (please ensure you mask any confidential information): 24b Version (incl…
-
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…
-
SKIP ROW based on an attribute in one sheet of a multi sheet excel templateSummary I have a summary and detail excel template. I need to suppress rows which have a value of zero on one particular attribute of the row.Content I have inserted the… -
Conditional Region for Pictures on BI PublisherSummary: Difficulty Applying Conditional Region for Displaying Different Logos in BI Publisher Word Add-In Content (please ensure you mask any confidential information):…
-
Does Oracle Fusion Allow a Link to Microsoft Power BI?Summary I'm looking to see if Fusion would allow Microsoft Power BI to link to the Servers In Order to Build ReportsContent My company uses Microsoft Power BI for alot o…
-
Oracle Fusion (HCM) Allow a Link to Microsoft Power BI to get dashboards?We are currently implementing Oracle Fusion HCM and the client has several dashboards already developed in Microsoft Power BI. These dashboards are published in Power BI… -
Smart View handled an unknown exception thrown by Microsoft OfficeSummary: Smart View Error - Smart View handled an unknown exception thrown by Microsoft Office Content (please ensure you mask any confidential information): Steps to re…
-
BI table for AR transaction approvalHi Team, Please help to get table that stores AR transaction approval History. I am not able to find any dedicated table like AP Invoices (AP_INV_APRVL_HIST_ALL). Also t…
-
R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 FSCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter Deve…
-
Can I change the date format in the BI Publisher data model to 'DD/MON/YYYY'?Summary: In the Fusion, publisher reporting → data model→ SQL Query "select to_char(to_date('12/09/2024','DD/MM/YYYY'),'DD/MON/YYYY') from dual;". It always returns 12/0…
-
Looking for report that list active and inactive responsibilies of a userSummary: My client needs to be able to extract current and historical responsibilites of a user in order to verify that compliance rules has been followed. So far I've o…
-
OTBI does not generate all lines.Hi everyone. I'm generating a report in OTBI and not all the lines that should be generated are being returned in the report. Is there a limit to the number of lines tha… -
The Multiple Natural Accounts selected in Single row But Data showing in multiple Rows in FRS OutputCreated FRS Report , One Row We selected Multiple natural account in output data Showing Multiple rows, Expectation Is : Should be appear In Single Row
-
OTBI 'Can't load models - Restore your models' issueIn our TEST environment we are seeing the following issue is all users: As far as we are aware nothing has changed in the back end. We have done the following: Purged th…
-
how to add the hyperlink to Dash board AnalysisWe have created an OTBI dashboard with an analysis that includes a graph based on suppliers and their purchased item categories. We need functionality that allows users …