Reports
Discussion List
-
BI Fields used at Header in RTF template do not show input parameters value when there is no data.Summary: Hi All, In custom report, BI Fields are used at Header level in RTF template to display selected input parameters values. User use PDF extract and it works fine… -
How to split a single row into multiple rows in oracle fusionDear All, I got an requirement like need to split single row into multiple rows dynamically, but here that single row is having value like 99 so i need to split 99 rows …
-
SQL Statement for AR invoice including attachment line informationSummary Receivables Transactions ExtractContent Hello I am wondering if you can share with me any SQL to extract AR information, including attachment information. I have…gabriel kinovisques-163562 1.9K views 7 comments 0 points Most recent by JimCC Reporting and Analytics for ERP
-
COA Segment Values based on Security RulesSummary COA Segment Values based on Security RulesContent We have a requirement to get the Individual COA Segment Values based on the security rules defined for the Role…
-
OTBI reporting errors after 25B release - Error generating view. Error getting cursor in GenerateSummary: After the 25B release on May 17th 2025, many of our reports are now failing to run, and presents error below. Reports which are run return a mixture of differen…Ray727 273 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Adding BIP report to OTBI dashboardSummary: I am adding BIP report to OTBI dashboard. The BIP report runs fine individually, but when I add it to a dashboard and preview the dashboard. Nothing shows up. P…
-
Unable to run reports or view it's dataDears, we have a custom role called profile specialist to handle all the transactions of profile management and it's copied from human resources specialist seeded role t…Nariman.Moussa-Oracle 11 views 2 comments 0 points Most recent by Nariman.Moussa-Oracle Reporting and Analytics for ERP
-
Requisition Report data not match with fusion job requisition data(attached screenshot)Summary: Requisition Report not match with fusion job requisition Content (please ensure you mask any confidential information): In the below SQL code for requisition co…
-
Report on user activities in Oracle Fusion ApplicationsSummary: Report on user activities in Oracle Fusion Applications Content (please ensure you mask any confidential information): Our management is asking for a report tha…JoanB 24 views 5 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting and Analytics for ERP
-
Custom BIP report for Accounts payable trial balanceSummary: I am developing a Custom BIP report for Accounts payable trial balance. Here the paramters are legal entity, as on date and business unit. When I am trying to p…
-
How can we query the error message in BI Server's Report Job History?Summary: Error Log Report that will display the error message like in the Report Job History Content (required): Hi, We wanted to create a custom report that will output…Kristelle 340 views 16 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Shipment Details To Costing JoinsHello Team, i need to join the wsh_delivery_details with cst_cogs_details table but could not find a
-
Storing Oracle Fusion report outputs in document management systemSummary: We have a requirement for storing the output of various kinds of daily/weekly/monthly reports (BIP/OTBI/FRS) generated from Fusion ERP Cloud for audit purposes …
-
HSBC Pain.001.001.03Summary: We are implementing payments in Fusion cloud with HSBC as our bank. Bank has specific requirement to have the oracle payment file in 'pain.001.001.02' or 'pain.…
-
Unable to view the Export option while accessing the OTBI report via Performance TileSummary: Hi. I think I have a similar issue to https://community.oracle.com/customerconnect/discussion/561120/unable-to-view-the-export-option-while-accessing-the-otbi-r… -
AR Aging ReportSummary AR Aging ReportContent Hi all, I am doing a AR Aging Report using OTBI. For example: AR aging report has following columns: Customer Name, Transaction Date, Tran…User_2025-02-04-05-26-22-197 126 views 8 comments 1 point Most recent by Ayala01 Reporting and Analytics for ERP -
Update information in Financial Reporting when new accounts are addedI would like to update information in Financial Reporting when new accounts are added: I have a report built in Financial Reporting, but the new account I added isn't ap…Jorge Luis Gomez 34 views 1 comment 8 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Need to burst a book that will create one excel sheet with multiple tabsSummary: Need to burst a book that will create one excel sheet with multiple tabs, where each tab has the same report but is for a different cost center. Content (please… -
OTBI - ConcatenationSummary Is it possible to create a field that concatenates two or more text fields in an OTBI analysis?Content I am trying to create an OTBI Analysis using the Procureme…User_2025-01-28-20-11-21-100 826 views 3 comments 1 point Most recent by Ayala01 Reporting and Analytics for ERP
-
FRS- Need to display the output in excel in different tabs for different branch valuesSummary: There is a requirement for an FRS report (Income Statement with Budget). Currently, when a user selects a specific branch (e.g., Deloitte Delhi) in the paramete…
-
We need some assistance to create a report from the budgeting systemSummary: There is a requirement to create a report from the budgeting system with the fields 1.Budget year 2.IT Budget allocated by Business Unit 3.IT Budget - Actual vs…
-
Need a report with employee's default expense account and position informationSummary: I need a report with the employee's default expense account and position information so I can verify the account is correct. Is there a trick to connecting the …
-
Query/tables to find payment approved by final approver approved PPRSummary: Query/tables to find payment approved by final approver approved PPR Content (please ensure you mask any confidential information): Hi All, We got a requirement…Venkatesan 11 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
How to add security on custom BIP folderSummary: We want to implement security to a custom BIP folder to give restrict access of some users to it. How can we do that? Is there something we can do in permission…
-
What are the standard Smart View reports available in Oracle ERP Cloud?Hi, What are the standard Smart View reports available in Oracle ERP Cloud? Such as for Cash Management we have the Cash Forecast and Cash Position Report which could be…Janitha Perera 21 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to fetch amount delivered on PO through SQL QueryWe have a custom Purchase History BI report that gives entire PO history. This report also has columns named quantity_delivered and amount_delivered which are being fetc…Pranita S 989 views 7 comments 0 points Most recent by Rakesh Sreenivasa Reporting and Analytics for ERP -
Dyanmic Deep Link in OTBISummary Need to identify mechanis to have dynamic deep links in OTBIContent Hi There, We have developed around 15 reports in OTBI having a deep link embeded in each of t…
-
Is there a report to show users' roles and privileges or what's table of them?Summary: We want a report to show users' roles and privileges or we can customize a new if there's no statndard process, but we don't know the table for these infoematio…
-
what is the previlege for Workflow Transactions ListingSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…PUGALESWARAN PALANIVEL 22 views 6 comments 0 points Most recent by NarasimhaPalla Reporting and Analytics for ERP
-
Purchase Order Reports not showing line quantityWe have an OTBI (BIP) report for Purchase Order details using Procurement - Purchasing real time. The Quantity field for Quantity based POs is not populating, are any fe…Andy McIlroy 38 views 4 comments 1 point Most recent by Andy McIlroy Reporting and Analytics for ERP