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 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…
-
Moved: FRS- How to replace Period Name with Calendar Date in Column HeadersThis discussion has been moved.
-
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 … -
Warm ComplianceSummary: Is Oracle Cloud ERP Warm Compliance? Content (required): As per SEC all public companies need to have Warm complaint system? Is Oracle Cloud ERP Warm Compliance…
-
Are there a Financial statements reclassified according to the 4th CEE Directive available in ERP?Summary: Are there a Financial statements reclassified according to the 4th CEE Directive available in ERP? Content (required): Dear All, I would need to know if a Finan…