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
-
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.9K 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… -
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… -
26D Error Running Multiple FRS Reports in the Same Session from Custom DashboardSummary: During 26D testing, we identified a potential regression affecting our custom reporting dashboard. The dashboard contains hyperlinks to multiple reporting tools… -
In an OTBI analysis, results are different for different usersSummary: In running an OTBI analysis, my manager and I get one set of full results. The user gets only the results that they created (expense reports). How can I see whi… -
BI Publisher Report Returns Data Manually but Outbound Report from OIC Is EmptyI am trying to generate an outbound report for recently imported invoices that were processed through the Import Payables Payment Requests job. I created a BI Publisher … -
Error after migrating FRS report between two lower environmentsSummary: When running report in target environment we get this error: Balance Sheet V1- Error executing query: Error: Internal Essbase JAPI error: [Cannot perform cube v… -
SQL Query to extract username along with roles, data access and security Context in oracle fusion .Summary: I need the table to get security context column values in oracle fusion tables. Currently I am using the table FUN_USER_ROLE_DATA_ASGNMNTS but in this table ins… -
How to create custom folders under General Ledger – Transactional Balances Real Time subject areaSummary: Hi All, There are custom folders created & included like '****_BANK' , '****_ACCOUNT' under the General Ledger – Transactional Balances Real Time subject area. … -
BI user licensing consumptionSummary: Can we provision named users with access exclusively to OTBI and BI Publisher for read-only reporting over Oracle Fusion Financials data, without those users co… -
Custom ESS job is erroring when there is no data to burst data to FTPCustom ESS job is erroring when there is no data to burst data to FTP. I want the job to be successful when there is no data to send. -
OAuth/JWT for BI Publisher web services before Basic Auth retirementSummary: We call Fusion BI Publisher web services from OIC Gen3: /xmlpserver/services/v2/SecurityService (login), then the ReportService, ScheduleService and CatalogServ… -
Purchase Order Deeplink does not work for some PO status - BIP ReportsSummary: We are implementing Purchase Order deep links in a BI Publisher report so that users with requester access can navigate directly from the report to the correspo… -
Requisition List ReportSummary: Requirement to have a report for the requisitions as the manage requisitions page doesn't show the full list of requisitions. Content (please ensure you mask an… -
Enhance GTAS Reporting to show Year of budget authority (NBC) values for carry forward balancesIssue: The challenge involves no-year and multi-year funds. The fund attribute is set to the year of budget authority (YOBA), which distinguishes outlays from new budget… -
Is there a field in otbi for the total invoiced amount against a POSummary: When trying to create an analysis in OTBI for Purchase orders, the Invoiced Amount field just brings back the total invoiced value for ALL invoices, not just th… -
Can the out of the box ESS Administrator role manage job set?Summary: I'm testing the out of the box ESS Administrator role and I can see that the role does not have access to setup and maintenance so cannot manage job definitions… -
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… -
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… -
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… -
Test1-ShivanandThis is temporary Descriptions for all the PDFs and Zip Files -
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… -
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… -
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… -
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… -
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, … -
Is event organization missing from subject area Project Billing - Event Real Time??I can't find it in the list of fields available, but it seems a bit odd for the event organisation to be missing. It also seems to be unavailable to add to View Columns … -
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…