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
-
How to create deep link for Items in Product Information Management module?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
Applying filter to report attribute but keep the rank as unfiltered.I am creating "Rank" function on a calculated measure. It works fine. But when I filter on a column value the rank changes. Is there a way I can apply filter on an attri…
-
How to embed financial report in html page?Summary: We have the following query, how can we embed a financial report in an html web page, as if it were a kind of "Iframe". Content (please ensure you mask any conf…
-
Function in FRS Webstudio report to go back on GL Average Daliy Balance Cube on an exact dateOur client wants to run Daily P&L built on GL Average Balance Cube using FRS and compare current date PATD balance to same day PATD balance for last month. This is also …
-
Why do I get an SQL timeout limit error after 30 mins after 24D upgrade.Summary: Why do I get an SQL timeout limit error after 30 mins for one of the custom BIP report even though one of the other custom report with same properties and setti…
-
Specific user cant extract data from xla_transaction_entities .Need to Know role for this XLA tableSummary: Specific user can't extract data from xla_transaction_entities .Need to Know role for this XLA table We have made one report where we are using this table but a…
-
How to keep search panel available when search result shows?Summary: How to keep search panel available when search result shows? Content (please ensure you mask any confidential information): Hi Experts, May I ask how to have th…
-
Does BIP allow additional static attachments, Word and Excel, to be added to a bursting email?Summary: We are customising the standard PO print BIP report and they will all be delivered via email, using the bursting functionality. The email will have a PDF attach…
-
default awards period type to inception to dateSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Inquiry: Attaching XSL-Based XML Output to PDF in Oracle Print Transaction ReportSummary: The Print Receivable Transaction seeded job is currently generating PDF output for customers. A new requirement has been raised to build an XSL-based XML output… -
How to embed a xsl based xml output in oracle Fusion Print Receivable Transaction PDF outputSummary: We have a requirement where the output of the Print Receivable Transaction should include both the generated file and the corresponding XML source file, based o…
-
OTBI Agent - Error Generating DocumentI have an OTBI report that I'd like to schedule to run and send the report via email. I've created an Agent to run the report, but when I receive the results via email, …
-
GL_FRC_REPORTS_B and Custom Folder and Report ListSummary GL_FRC_REPORTS_B is not listing all the reports that are created or modified; Should we run a process to populate the table or does the data in the table gets po…
-
Unable to view the Export option while accessing the OTBI report via infoletsSummary Unable to view the Export option while accessing the OTBI report via infoletsContent Hi Guys, I had created the independent OTBI Report with the report links and… -
Restricting a record if its already sent - Oracle Fusion ERP Cloud BI Report Requirement.Summary: We have a report requirement that once payments exceed $600 during a calendar year, we report to the downstream app within 20 days. Also, once a supplier has be… -
I cannot see bursting enabled in batch scheduler in FRSSummary: I cannot see bursting enabled in batch scheduler in FRS Content (required): I created a batch and added two reports. Next I created a batch scheduler and added …
-
EBS Analytics acceleratorSummary: EBS Analytics accelerator ? Is this still available or existing as a solution module from Oracle ? Content (please ensure you mask any confidential information)…
-
Tables to get the Project Budget by monthSummary: Can anyone help me with the details of the tables that have Project budget in PPM. I am looking for the budget data by month. Building a custom BIP report. Cont… -
Reports and Analytics - Catalog - usage numbersSummary: Need to identify usage nubmers of reports in the ERP Tools and Analytics catalog Content (required): We are trying to identify the frequency and usage of report…
-
Report in FRS showing different resultsWe created a report in FRS "Etat Balance interactive" so the client can check the balance of each account and interact with the data by clicking on drill-through so he c…
-
Need PVO details for PER_ROLES_DN? Not able to find one in BICC mapping to Finance/HCM listSummary: I am looking BICC Tag for PER_USER, PER_USER_ROLES , PER_ROLES_DN HAve found following for PER_USER and PER_USER_ROLES and not for PER_ROLES_DN HcmTopModelAnaly…
-
Is there a function to get lookup meaningsSummary: I am creating a report and the users require the displayed values for the lookups, I know I can do multiple links to the fnd_lookup_values_vl view (see code sni…
-
Creating BIP Reports via SOAP WebserviceSummary: Creating BIP Reports via SOAP Webservice Content (please ensure you mask any confidential information): 1)Can we create a BIP data model and report dynamically … -
Invoice History ReportSummary: Is there any report that shows payment information and the invoice number related? Version (include the version you are using, if applicable): Oracle Fusion Clo…
-
Is there a list of Essbase cubes and fields available for Cloud ERP?We are trying to find a list of all Essbase Cubes and the fields in those cubes so we can create reports more effectively in SmartView. Does anyone know where we can fin… -
Required Tables that stores min-max values for Replenishment planningSummary: As part of report development, we required min-max values for Replenishment planning. Please provide the details of tables that has to be used to derive the val…
-
Issue to get PO Lines accounting details from GL sideWe need to retrieve the PO Lines accounting details along with the net balances. But we are unable to obtain the PO Lines accounting details from the GL-level tables. We… -
Does the END_DATE field in PER_USERS table get populated when the user is made inactive?Summary: Does the END_DATE field in PER_USERS table get populated when the user is made inactive? Searched this filed and no values populated Content (required): Making …
-
How to View the Output of an ESS Jobs Submitted By Another User Based on Role?Summary How to View the Output of an ESS Jobs Submitted By Another User Based on Role?Content Hi Everyone, Can anyone please share your thoughts How to View the Output o… -
How to add a deep link to items ?I have attempted to use the Deep Link SCM document to create a deep link for Items, but unfortunately, it didn’t work as expected. Could you kindly assist me with a step…