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
-
https://cloudurl:443/fscmRestApi/resources/11.13.18.05/erpintegrations' failed:bad request (400)Summary: We have integration between ebs to scp cloud. we have schedule integration run on mulesoft. mulesoft site using Below one. https://cloudurl:443/fscmRestApi/reso… -
Can we submit ESS job using BIP Report ??Summary: Can we submit ESS job using BIP Report ?? Content (required): Can we submit ESS job using BIP Report by setting data set as Procedural call ? Version (include t… -
Syntax for referencing a user privilege in an EL ExpressionSummary: Content (please ensure you mask any confidential information): Hi, I am trying to build a custom menu to access OTBI reports from the Navigator / springboard . …
-
Fixed Assets - Entered PeriodSummary Is the "Entered Period" available in any of the Fixed Asset subject areas?Content I have been searching through the various asset-related subject areas for a fie…
-
Assistance Required for OTBI Reports in SCM (Inventory Module)Hi, We are developing a few OTBI reports for the SCM module, specifically on the inventory side. However, we are facing difficulty in identifying the correct subject are…
-
How can I schedule a BI Publisher report with dynamic date parameters for the previous 3 months?Summary: We have a report used by many business areas. One particular business area would like to schedule this report to pick up the previous 3 months of data. How can …
-
Import Oracle Fusion Data Extensions for Transactional Business Intelligence having an impact.Summary: There's an issue with HCM Reports having said that some columns were not available and the root cause of it was when Import Oracle Fusion Data Extensions for Tr… -
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…