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
-
Number format in oracle reportHello, when in a report we have #missingData, if i export the report in excel, we have 0 but not in number format. How can fix this, to have always number format? Thanks -
What reports are available for agent level productivity metrics?Summary: We are looking at agent level productivity metrics. What seeded reports are available in Oracle? Or are these custom created reports? This ask is across all the…
-
Some of the PDF attachments not appearing on printed AR Invoice in Print Receivables TransactionsHi Team, We are facing an issue where attachments in receivables transactions are not consistently getting attached or sometimes dropped during the printing of the invoi…
-
To connect Oracle Fusion database table with Oracle APEX to create oracle APEX ReportSummary: How to connect Oracle Fusion database table with Oracle APEX to create oracle APEX Report
-
How to create a Fusion Data Intelligence DV Report using OTBI Fusion TableI have an OTBI BIP Report which is sourced from Data model using OTBI Fusion database tables. I need to recreate the report under FDI DV. I am not sure how to find same …
-
Scheduling "report" based on column with user emailSummary: I developed an SQL report on OTBI and an EXCEL output should be delivered to corresponding users. There is a column containing email address of the user and use…
-
Searching in Reports and Analytics using the magnifying glass icon giving internal server errorSummary: In reports and Analytics, users wanted to search for some related reports and so by using the search option(magnifying glass icon), they entered some options an…
-
Can we data mask certain fields within BICCSummary: As Oracle provides BICC as a tool to extract data from Oracle Fusion Cloud through UCM for customers to further analyze or report this data. We have a legal req…
-
Seeking Innovative Solutions for Stale Dated Check Letter Report in Oracle Fusion ERP CloudSummary: Hi Team, We're developing a report to identify stale dated checks, specifically those exceeding 180 days from their issue date. Our goal is to automate the dail… -
List of Special character which cannot be loaded through FBDI file.Summary: We have around 50 Inbound integration from various sources for GL, AP, AR, PO, Receipts. We have observed that if special characters are present in the file lik…
-
FRS reporting - multiple cubes and concatenated segmentsSummary: Hi Team, We are trying to prepare balance sheet in FRS but have below questions. Can we use multiple Essbase cubes in the same report (as an example, can we pul…
-
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… -
Can you run a process and have the report/file generated from the process sent to a set folder?Hi Everyone, Is it possible to have a process run adhoc or scheduled and when the process finishes the report output is sent to a file/folder location? For example, if o…
-
How to fetch only current/latest updated eff data from EGO_ITEM_EFF_B table?Hi, We need to extract current item eff data. We are using EGO_ITEM_EFF_B for fetching the same. But this table is fetching all the values updated for effs till date. Bu…
-
Need BICC PVO to get per_location_details_f tables Additional attributesSummary: Need BICC PVO to get per_location_details_f tables Additional attributes Content (please ensure you mask any confidential information): Version (include the ver… -
How to get Column headings to repeat across multiple pagesSummary: How to get Column headings to repeat across multiple pages Content (please ensure you mask any confidential information): Hello all - I am struggling to setup m…
-
LSQL print first valueSummary: Moved to SCM Reporting and analytics -
error using data mode property: Optimize Query ExecutionSummary: Hello everyone, a few days ago I experienced a new situation. I have a report that extracts a large amount of data (over 100,000). I tried to optimize the execu… -
Validation Status from AP InvoiceSummary: I am creating the Data Model of our BIP Report and I need to find out which field from what table should I use as Validation Status. Content (please ensure you …
-
Need a report which lists all reports with roles required to run thoseIs it possible create a report that lists all reports in fusion Financials and the security role that is required to run each of these reports. Business is asked constan…
-
Creating a Headerless CSV File Using eText TemplateSummary: We are planning to develop a report in BI Publisher that generates a CSV file without column headers. Our understanding is that in order to exclude the header, …
-
how to extract data from a PVO using BICCCI need to extract data from FscmTopModelAM.FinGlJrnlEntriesAM.JournalHeaderExtractPVO to a file or at least to query this table. ( I need to do a count over a column to …
-
Browser is getting automatically refreshing when scheduling ESS job set in Oracle cloud ERPSummary: Hi All, I hope everyone is going well!. I need some help in resolving the ESS job set related problem. I have created the ESS job set with 10 Ess jobs inside of…
-
BIP Security - Need to restrict user from deleting the Folders from Shared FoldersSummary: Hello All We would like to restrict the users from deleting the folders from shared folders and user should be able to run and schedule the reports and data mod…
-
Line breaks in RTF template with Excel outputSummary: I have a report with two datasets. The first dataset is joined to the second dataset in the data model designer. The report used is an RTF template, and when ex…
-
Report and analytics icon is not visible on GL, EXPENSES, CASH MANAGEMENTWe want to know if it is possible to see the icon "report and analytics" displayed on the Invoice screen under Payables, On GL, EXP, and CM modules. Please let us know i…
-
"General Ledger Journal and Subledger Transaction Mapping Report"HI Team, is it possible to get sql behind report "General Ledger Journal and Subledger Transaction Mapping Report" /shared/Financials/General Ledger/Account Analysis Gen…
-
Exist a report that show all page composer in the ERP?Exist a report that show all page composer in the ERP?
-
how to see when a role was deleted from a user?Summary: how to see when a role was deleted from a user? Content (please ensure you mask any confidential information): how to see when a role was deleted from a user? a… -
Blank pages in my BIP ReportSummary: Student Statements with 0 balances printing blank page Content (please ensure you mask any confidential information): I have developed a custom student statemen…