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
-
[FTPProcessor]Delivery to SFTP completed with failure oracle.xdo.delivery.ssh2.SshException: TimeoutSummary: [FTPProcessor]Delivery to SFTP completed with failure oracle.xdo.delivery.ssh2.SshException: Timeout waiting for response from server. Content (please ensure yo… -
Why BIP audit report missing data ?We have audit requirement that we know who and when report have been modified. When using the Audit report for Product: Oracle Business Intelligence Enterprise Edition, … -
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)…
-
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 SQL Query for Project Custom ReportSummary: Hi Please help us to answer the table and the column for this project budget information (all project not specific project): Version Status Project Number Task …
-
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… -
A SQL query of privileged resources in the role FSD sectionSummary: Hi All, Can anyone share a SQL query on how to retrieve privileged resources? inside the role of the FSD section oracle provides information about the privilege…
-
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…
-
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…
-
SaaS BIP reports in waiting for long timeWe have kicked off BIP Report in SaaS/Oracle Financials Cloud and its in waiting mode for 2 hours 40 mins before it started executing.
-
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…
-
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…
-
Apex to run bi reports and store files in DB tableSummary: We need Apex to call a SaaS BI Report and store the file report in a DB table. Content (please ensure you mask any confidential information): We need Apex to sc…
-
Need to generate and include a sequence number in custom BI publisher eText template for non paymentSummary: Need to generate and include a sequence number in custom BI publisher eText template for non payment Content (please ensure you mask any confidential informatio…
-
can I make a warning massage in report parametersHello community, Can I make the same warning message in the screenshot in the report for parameters? No specific field is required but must enter at least one thanks
-
OTBI Receivable transactions- Real Time- Trying to get the warehouse/ship from detailsHi Team, Trying to create OTBI Report using Receivables transactions Real time. We need to add warehouse/ship from organization details for each of the invoice line. Una…
-
PO PDF error printing attachments "Could not get data source connection for: FA_UCM_PROVISIONED"Summary: Getting error in PO PDF customization " "No such data source found in the data source config. Or you do not have access permission. Could not get data source co… -
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…
-
How to Insert/modify targets in main dashboard OTMSummary: Hi, I'm opening this ticket by suggestion from OTM CCC discussion: Is it possible to insert or update targets values in the main dashboard page? We have try to …
-
Privileges to view reports in BI Catalog without access to transactionsSummary: Requirement for custom role only to access reports in Business Intelligence Catalog for all Procurement Functional Area folders Content (please ensure you mask …
-
can we restrict/hide viewing few columns based on rolesIn custom reports, i want to hide few columns based on the roles. I want to restrict the access of columns to few employees only. Is it possible to achieve?
-
FND_FLEX_VALUE_NORM_HIERARCHY is not available in fusion. Please suggest the replica table in FusionSummary: We have DWH implemented and as part of cloud transformation we are migrating from EBS to Fusion Cloud ERP. Hence, from DWH perspective, we are in process of ana…
-
Display modification in SmartView ad hoc analysisIn SmartView ad hoc analysis, I want to display hierarchies in a way where the parent value appears first, followed by the child value. How can I change this setting?
-
ScheduleSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to attach the report output into the notification of document of records approval.How to attach the report output into the notification of document of records approval.
-
SQL script for job roles inherited by data rolesSummary: Trying to build a query to fetch users with their data roles and inherited job roles. I am able to fetch the data roles and job role assigned assigned directly …
-
User and Report Access ReportBusiness is requesting a report that have the following columns details: User username Report Name Period Inventory Valuation Report Source Of Report Scheduled Process o…
-
Can we restrict jobs based upon roles?Summary: Hi Team, We are looking for a possible solution which might help us to satisfy the below requirement Step 1: A Custom roles to be created and assigned to a user…
-
QUERY TO GET ESS JOB AND SCHEDULE JOB HISTORYSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to identify new lines in a PO through tables?Hello community, We are customizing the purchase order PDF, and in a requirement my client asks to show the new lines that have been included in a change order after the…