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
-
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… -
Oracle BIP or OTBI reports output in Non-English languages in Oracle Fusion Financials (SaaS)Summary: Oracle BIP or OTBI reports output in Non-English languages Content (required): Hi Team , We are looking for the Oracle BIP or OTBI reports output should be in H…
-
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.… -
A fresh environment with no dataSummary: A fresh environment with no data Content (required): Dear all, I would like to ask if a test or production instance can be refreshed, but not as p2t or t2t, so … -
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 …
-
Oracle Fusion Cloud - Fields/recordsSummary: Hi, I am new to using Oracle Fusion Cloud and coming from Peoplesoft. Is there any kind of view or extension on a page in Fusion where I can find field names an…
-
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… -
Smart view - OBIEE - ExcelSummary: When working with multible excel workbooks and connected to OBIEE in one of them, when shifting to another workbook the OBIEE extension tab always open. Content…
-
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. -
A guide to Custom Roles in Oracle ERPSummary: In this discussion, we shall know: What is custom role and why it is needed? What are components within a custom role? How to create Custom Role? How to delete/… -
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…
-
Is there an option to update Oracle or Vision logo once to reflect in all seeded reports?Summary: Client is asking for one single update of oracle or vision logo so the users doesnt see Oracle /vision logo in out of the box report when run. Client requests t…