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
-
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… -
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…
-
Ability to do a SQL Query with Oracle Visual Builder Excel Add-in ?Summary: Hello, I would like to know if it is feasible to pass a SQL Query through the Oracle Visual Builder Excel Add in Content (required): There are not REST API to r… -
Report to have budget transfers (Control budget)Summary: Content (required): We have a requirement to have a report to include the Budget transfers. We tried to get it from the standard reports however, there is no re…
-
Moved: FRS- How to replace Period Name with Calendar Date in Column HeadersThis discussion has been moved.
-
UCM Bursting not working for Fixed Assets Seeded ReportSummary: Issue in UCM Bursting for Seeded FA report Content (required): Hi, We are trying to create bursting for seeded FA What-If Depreciation Analysis Report to push o…
-
SOAP - Internal Server Error 500Hi Team, Can you please help in the below context SOAP - Internal Server Error 500 Thanks, Saurabh Singhal.
-
AP_Invoices joins for Supplier Detail where vendor_id is negativeSummary: Sql question, I am looking for ap_invoices_all joins where vendor_id is negative, for the following scenarios; - expense (vendor id = -10016), one time supplier…
-
How to create a custom tab in oracle fusion UI page?Summary: How to create a custom tab on the oracle fusion UI page? Content (required): Hi Experts, We got a requirement to add a custom tab to enter supplier details. Is …
-
How to fetch customers having multiple sitesSummary: How to fetch customers having multiple sites Content (required): We need to fetch all the customer accounts which are having more than 1 site associated with th…
-
Moved: Historical Depreciation & Total Accumulated Depreciation from Depreciation Real time Sub…This discussion has been moved.
-
How can we get GL accounting date for budgetary control ?Summary: Hi Team, We have requirement to build a report which will have accounting date for each line in budgetary control. How can we link budget and GL tables to fetch…
-
Invoice Filter does not work. Please review and provide any suggestion for this OTBI code.Summary: Invoice id Filter does not work. Please review and provide any suggestion for this OTBI code. Content (required): OTBI Version (include the version you are usin…
-
How can we get the Ess job 'Approval Groups Report' output files as attachments on email?Summary: We were trying to run the ess job on ERP cloud called 'Approval Groups Report' and get the output files on mail as attachments. But we were not able to see the …
-
Where I Can find Financials OTBI database mapping with ViewObjectsSummary: I am unable to find spread sheet of Finacial OTBI OTBI database mapping with ViewObjects excel. For earlier versions, I have downloaded through docs.oracle.com-…
-
Is it possible to combine the Payables - Invoices and Budgetary Control subject areas?Hello, I am trying to create deep links to the different expenditure transaction types in my budgetary control report and one of the transaction type is for Invoices. Th… -
OTBI Report for General Ledger - Journals Real Time Not Displaying Correct AmountsSummary: Entered Credit & Debit Amounts and Accounted Credit & Debit Amounts are not displayed correctly in the OTBI Analysis using the General Ledger - Journals Real-Ti…
-
Data migration from fusion to fusionSummary: Data migration from fusion to fusion Content (required): Hi All, Our customers having two different entities. In that one of the entity wants to move separately…
-
Duplicate lines in Fixed Asset Depreciation reportI've created a simple analysis that pulls the depreciation details from the application and presents it in an overview. Here is the analysis XML: There's an issue where …