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 encrypt the bip report response with SOAP web serviceSummary: Hi Experts Currently the response from the SOAP web service returns the BIP report data in base64 encoded format but I want to encrypt the response in some othe… -
How to send large attachments in BIP email deliverySummary: How to send large attachments in BIP email delivery Content (required): Email delivery failed in BIP for large report output. Below is the error, 'emailOutbox r…
-
CASE WHEN Formula Not Displaying CorrectlySummary: CASE WHEN STATEMENT shows two different results pending the format export Content (required): I'm using the following CASE WHEN statement to label a value eithe…
-
Fixed assets OTBI cross-subject area reportingI have created a dashboard based on the Subject Area Fixed Assets - Asset Depreciation Real Time. My colleague is asking me to filter the records based on the asset stat… -
Is it possible to create a tile which will open a BI report?Summary: Is it possible to create a tile which will open a BI report? Content (required): Hello We would like to add a tile to the Procurement tab, that when you open th…
-
OTBI Analysis - How to pass only Date for column that is having date and timeSummary: Content (required): The below condition is failing as Application Creation Date is returning date with timestamp and Current_date is returning only date. Applic…
-
Delete BI Folder with permission set to OpenSummary: Delete option Enabled even when permission is set to Open Content (required): With admin user we created the following folder structure Shared Folders>Custom>Cu…
-
Need to perform YTD calculation over ap_checks_all for reportSummary: Hi Forum: my customer would like to insert a YTD column right after Payment_Amount (SQL is over ap_checks_all) but there is no seeded YTD in ap_checks_all table… -
Provision a Vision Demo Instance for Customer WorkshopSummary: We are going to conduct the initial round of the requirement gathering workshop for a customer. Can I know if there is option for us to provision a Vision demo …
-
Bursting To FTP server Not WorkingSummary: Bursting To FTP server Not Working Content (required): Hi All, I have developed one report where I want to place the file in the ftp server and for that i have …
-
How to work with Multiple selection and NVL function In ParameterSummary: How to work with Multiple selection and NVL function Content (required): Hi All, Hope everyone is doing well. I have a below requirement for which i need you he…
-
Fusion UI personalization not reflected immediatelySummary: Fusion UI personalization not reflected immediately Content (required): Hi Experts, We created one DFF for GST number and this field should be mandatory when th…
-
Need recommendation for Printer Model for Label Printing for a Manufacturing ClientSummary: Hi Team, we are trying to find recommendation for Printer Model for Label Printing for a Manufacturing Client. Any help you can provide would be really helpful.… -
Unable to view xml tags in RTF templateSummary: Content (required): Hello all, I'm facing difficulty in editing old custom reports and seeded reports since the XML tags are not visible as they should be. For … -
Unable to print from ERP cloud to on-premise Print serverSummary: We implemented in Integration between Oracle ERP Cloud and On-Premise print server as mentioned in Doc ID 1964157.1 and completed all steps mentioned in above d…
-
Would anyone with experience with OTBI be willing to serve on a panel with OATUG ERP CLoud SIG?Summary: I am the VP of the OATUG ERP Cloud SIG who is hosting a panel in September called " ERP / HCM Cloud: OTBI, Third Party – lessons learned / improvement opportuni… -
How to run seeded PO Dashboard from the Procurement iconSummary: How to run seeded Dashboard from the Procurement springboard icon Content (required): Hello There is one PO Dashboard and the users wants to run from the Procur…
-
Oracle ERP Cloud Financials and Oracle HCM Cloud seeded reports does not show up for usersSummary: We recently created a new user account for Oracle ERP Cloud 23A. The user can log in When the user goes to the Reports and Analytics tab and clicks the Browse C…
-
BIP Data format on group-sumSummary: Content (required): I'm trying to create a report in BIP (in a RTF file). So I have used table wizard to create a for each on the values I need. In the actuals …
-
Cross Receivable Subject Areas in OTBISummary: Cross Receivable Domain in OTBI Content (required): Hi, I would like to know if there is a way to link the domain "Receivables - Standard Receipts Application D… -
Data Removal Tool forSummary: We are doing a new ERP, HCM, Procurement, Supply Chain and Sales Cloud implementation. Our client has only one testing environment and would like to know if the…
-
Privilege required to get data for OTBI reports from General Ledger - Transactional Balance RealTimeSummary: Content (required): Hi, What is the privilege or duty role required to obtain data from General Ledger - Transactional Balance Real Time subject area for users …
-
AP Invoice Productivity ReportSummary: Hello, we are wanting to create a report that shows the productivity of our AP Specialists and wondered if anyone else has done something similar. The current s…
-
Project Manager project reportSummary: We would like to build an OTBI report parameter that defaults to the current user as a prompt. Content (required): If i am signed in, I would like the report to… -
Analysis/SQL Query behind Standard Purchase Order InfotilesVersion (include the version you are using, if applicable): Oracle Fusion Cloud Applications: 22D (11.13.22.10.0) Summary: How to Get the actual OTBI Analysis behind sta…
-
create pivot report with additional fieldsSummary: in fusion i want to create income statement report as pivot table , i know how i create pivot in template. but the first issue is i get some accounts the get su…
-
Moved: 2023SOC Reports and Bridge LettersThis discussion has been moved. -
update on subtemplateSummary: 1- i update on Award Approval Notification Report. 2- has template AwardApprovalNotificationBodyReport.rtf. 3- in this template i have multiple subtemplate like…
-
Privilege/Duty Role to be granted to view GL Transaction Balance Real Time SA reportsSummary: Content (required): Hi, We have a user that DOES NOT have the General Accountant or General Accounting Manager roles assigned. However, there is a requirement f…
-
Audit OTBI CatalogSummary: Audit OTBI catalog folder Content (required): Is there a way to find out who deleted a custom folder in OTBI? Version (include the version you are using, if app…