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
-
Budgetary Control Balances OTBI with Deep Link Sample ReportSummary: Content (required): The Budget Balances OTBI with Deep Link Sample Report Kit contains a sample report embedded with a deep link to Review Budgetary Control Tra… -
NEW REPORT: Journal and Transaction Details ReportSummary: The Journal and Transaction Details report lists general ledger journals and subledger transactions activity along with header, line, and distribution-level det…Abhijit Dhakephalkar Gr Manager Financials Product Management-Oracle 3.8K views 87 comments 10 points Most recent by ERP & EPM Cloud -
Open-source fonts to replace licensed Monotype fonts in BIP and OTBI in 24AIn 24A, open-source fonts will replace the Monotype fonts currently available in Oracle Transactional Business Intelligence. You can use the open-source fonts available … -
Sample OTBI dashboard and reports for Joint Venture Management TransactionsSummary An OTBI dashboard with a detailed and summary report for Joint Venture Management Transactions. Content You can import the attached catalog file into a Cloud ERP… -
Test1-ShivanandThis is temporary Descriptions for all the PDFs and Zip Files -
ERP Period Close White Paper with Runbook Considerations (Doc ID 2506148.1)Summary Updated documentation availableContent Hi, Please note that we have posted an updated Period End document (21C) onto MOS 2506148.1 today. Also, based on customer…
-
R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 FSCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter Deve…
-
Custom ESS job not visible to all EmployeesContent Hello, We have created a custom ESS Job , but its not visible to all employees. We need it to be visible for all employees. We have referred the following docume… -
Redwood roadmap for Oracle FinancialsSummary: We would like to know Redwood implementation roadmap for Oracle Financials. It involves lots of planning and effort sooner we know the roadmap it will help cust…
-
How do I use SmartView to drill down to account activities from ERP online?Summary: SmartView can now be used for GL reporting from ERP online similar to FCCS. However, it does not support drill down to the journals and account activities from …
-
Customize Bill of Lading Report and Packing List ReportSummary: Hello. Has anyone here experienced customizing Bill of Lading Report and Packing List Report to add more fields? How do you get the XML for these two reports an… -
Is it possible to add bursting to a seeded Oracle Report?Summary: Hi. I want to ask if it is possible to add a bursting to a seeded Oracle report so that it would be sent to multiple emails? Currently, no bursting code is in t…
-
Adding Distribution Information to Payables Invoice InquiryYou can extend pages with custom OTBI reports, for example with budgetary control charge account and projects information is useful when viewing invoices. The Embedded I…
-
Unable to insert fields using BI Publisher add in for MS WordSummary: Hi Experts I have installed BI publisher add in for MS word but the menu looks some different and also clicking on insert field does nothing (i have loaded samp…
-
How to get data for Audit Reasons column in OTBI like the Expense Auditor Dashboard ?Summary: We are working on a custom dashboard for Expense auditors and one of the fields requested in 'Audit Reasons'. The subject area 'Expense- Expense Transactions Re… -
Smartview Essbase Error [1020098]: Duplicate name found in Grid, unable to resolve.Summary: I get the following Smartview error in report that used to work fine, adjusting the Account dimension values fails to resolve the issue, Essbase Error [1020098]… -
How to customise Requisition Approval E-Mail ReportSummary: We customized the “Requisition Approval E-Mail Report” to display the supplier name in the purchase requisition approval email and in the notification content. … -
OTBi for subject Payables Invoices>Transactions Real time>Distribution not showing correct AmountSummary: We are building OTBi report for Payables Invoices - Transactions Real time->Distributions->Invoice Distributions->Invoice Distribution Amount. In this when we a…
-
Requisition Approval E-Mail Report Template changes is not getting reflected in output file.Summary: I have customized the seeded report named "Requisition Approval E-Mail Report" but the changes is not getting reflected in the notification. It is taking the la…
-
Manage Receipt Page Customization issueSummary: Content (please ensure you mask any confidential information): Hi All, We have received the following business requirement to customize the Manage Receipts (Cla…
-
Missing Sequence Number in Account Analysis CSV formatSummary: Missing Sequence Number in Account Analysis CSV format Content (please ensure you mask any confidential information): Hi, There is a issue raised where the sequ…
-
subject area for getting open pick slip detailSummary: subject area for getting open pick slip detail for OTBI report Content (please ensure you mask any confidential information): Version (include the version you a…
-
ORA-01438: value larger than specified precision allowed for this column with BSO to BSOSummary: Hi Oracle Community, We are facing an issue while running a BSO to BSO data integration in Oracle Planning/PBCS. The data extraction from the source BSO cube co…
-
Bulk report to identify users and roles with access to custom BI Publisher reports.We have over 100+ custom BI Publisher reports across different folders under /Custom . We need an audit extract showing each report’s catalog path, directly assigned and…
-
Query to fetch the employee assignment history.We require a report that captures the complete assignment change history for employees, along with the associated action codes, details of the attributes that were chang…
-
BICC - Custom offerings migration Import / ExportSummary Dears, We created custom offerings and added PVOs in that custom offerings. BICC Job is created and the source is the PVOs with in that custom offerings. Now the…
-
SQL Query or table for User CategorySummary SQL Query or table for User CategoryContent I need to create a query that extracts the information of the user and the user category it's under
-
Budget balances not available in General Ledger subject areasSummary Can we query budget balances in General Ledger subject areas?Content Budget balances not available in General Ledger subject areas like 'General Ledger - Balance… -
Redwood Plan for Oracle Cloud ERPSummary: I haven't found clear discussion on how the Redwood would affect Oracle Cloud ERP. I see documentations and notices for EPM, HCM, and SCM, but I'm unclear on wh…
-
Job Set in Cloud Financials, how to copy report parameter values from one report to the next report?Summary: We defined a custom Job Set for two Cloud Assets reports, Asset Additions Report FAS420 and Journal Entry Reserve Ledger Report FAS400. When running the job set…
-
How to implement Segment Value Data Security in BI Publisher ReportContent Hi All, Can someone provide insights on how to implement implement Segment Value Data Security (SVS) in BI Publisher Report. We have a requirement to create BIP …
-
The expiry period for Email NotificationsSummary: Hi, I would like to understand the expiry period for email notifications received for approval requests in Oracle Fusion. When users receive an approval email, …
-
Need table name storing reporting period and status after "Finalize Transactions for Tax".We need to retrieve the final reporting status and reporting period in Oracle Fusion tables after running the "Finalize Transactions for Tax Reporting" ESS job. This ESS…
-
line managers are unable to view any data from my team - team skills centerSummary: line managers are unable to view any data from my team - team skills center although one of his directs has skills data be he is even unable to view his directs…