Reports
Discussion List
-
Client requesting data to be not split into multiple sheets in excel or rtf templateSummary: Our client is requesting that the output does not be split into different sheets if the count of records are more than 65K in Excel and 1M in RTF while generati…Abhilash K - Deloitte USI 1 view 0 comments 0 points Started by Abhilash K - Deloitte USI BI Publisher Learning Center -
Is there an excel template based report delivered by Oracle in FusionHas Oracle created any report with excel template inside Fusion Applications?Abhilash K - Deloitte USI 2 views 0 comments 0 points Started by Abhilash K - Deloitte USI BI Publisher Learning Center
-
Unable to see the Goal Plan Approval status in the Employee Goal Plan OTBI ReportUnable to see the Goal Plan Approval status in the Employee Goal Plan OTBI Report. Only the 'Approved' status is displayed under the 'Approval' Status Column. The Subjec…Chaitanya Sai 41 views 1 comment 1 point Most recent by Jacqueline GRANDIN Reporting and Analytics for ERP -
Custom report using BIPSummary: Can BIP be still used for custom report creation in ERP cloud. Should BICC be leveraged for custom reports? Content (please ensure you mask any confidential inf…Sajeena 81 views 8 comments 0 points Most recent by Hitesh Jasuja-Oracle Reporting and Analytics for ERP
-
Table name for auto provisioning data access setsWe have configured data provisioning rules for data access sets. While trying to download all the auto configured data sets rules, its downloads only 10% of the rules an…Vijay Ramani VJ 61 views 3 comments 0 points Most recent by lsriramakumar Reporting and Analytics for ERP -
Need to find Parameter details which is used while running report in Audit TablesHi Team, I am trying to build an audit report for BI Reports but I am unable to get the column for parameters in the audit tables. Can you please confirm if this is stor…Shubham Khandelwal - Accenture 42 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Issues running csv reports after 24A updateSummary: After 24A update, reports built using analysis can't be run, created, or edited. Workaround is to create new data set based uopn the SQL from original analysis,…
-
Need a Solution to restrict Parameters with respect to a Date RangeSummary: In the specified business scenario, users are restricted from selecting dates in the "GL Journal Date From" parameter between the 1st day of the month at 12:00 …
-
-
SKIP ROW based on an attribute in one sheet of a multi sheet excel templateSummary I have a summary and detail excel template. I need to suppress rows which have a value of zero on one particular attribute of the row.Content I have inserted the…User_2025-02-05-18-28-58-388 174 views 11 comments 1 point Most recent by Pinky Mukherjee Reporting and Analytics for ERP -
Pros/Cons of creating an ESS job for a custom bi report versus not create a ESS job?Hi Community, Are there any advantages or disadvantages for creating an ESS job for a newly created custom bi report versus not creating a ESS job for it?Abhilash K - Deloitte USI 41 views 4 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for ERP
-
Bhavani Rikkula 31 views 2 comments 2 points Most recent by Nagaraju Upputuri Reporting and Analytics for ERP
-
Is there a way to identify deleted journals so that we can exclude them from reporting?Summary: Is there a way to identify deleted journal entries so that we can exclude them from reporting? Content (please ensure you mask any confidential information): We… -
How to hide compatibility checker in Excel while opening excel template based outputs in Fusion?Users are complaining for showing the below message while opening the excel report outputs.How to hide this?Abhilash K - Deloitte USI 11 views 3 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
unable to get data for the following fields(Quote Price,RFQ Number,Line Awarded,Lines responded) ?Hi ALL, We have a requirement for the fields(Quote Price,RFQ Number,Line Awarded,Lines responded) in OTBI report. we tried with the following subject area but no date is…Prathyusha pari 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to exclude weekends and holidays from calculation in OTBI Report?Hi We have a requirement to not include weekends and holidays in calculation for one of the metrics in OTBI report. Kindly suggest some steps to archive Thank you Prathy…Prathyusha pari 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Why is barcodes not getting scanned in RF-Smart handheld scanner ?We have modified the standard Print Pick Slip report to add a custom template, type RTF and output PDF, and added barcodes to it with IDAutomationC128S as the font style…Prathyusha pari 87 views 4 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Download the zip file (Authorized Hosted Named Users.zip) does not workSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Manisha Rajupeta 41 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
How to Join Multiple Subject Area in OTBISummary: Hi All, Need suggestion on OTBI report. Content (please ensure you mask any confidential information): We have requirement to build an OTBI report to show trans…Akansha 120 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
How to find the BI reports that are using Excel TemplateHi, Referring to Doc ID 2990643.1, the BI reports that are using Excel Template are getting the corrupted output while scheduling it. Could anyone please let me know is …Vigneshvaran KJ 41 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
OTBI Asset Depreciation Report with Pivoted Accounting DateI'm trying to create an asset depreciation report in OTBI using a pivot table. My goal is to have the accounting date itself be a pivoted column (displaying depreciation…
-
how to fetch current schedule process start time of any Oracle Fusion scheduled reportSummary: I have a requirement to fetch incremental data. I am using below query. but due to frequent transaction. Few transactions are getting picked by 2 consecutive sc…Grab.saurabh 71 views 2 comments 0 points Most recent by Grab.saurabh Reporting and Analytics for ERP
-
How to join 2 different tables using query builderHi Oracle Community, I m new SQL and took help of query builder to select few columns from payroll tables and would like to join with HR tables. The next few columns I, …
-
Incomplete information in the dashboard Customer Listing ReportSummary: Site Purpose Source Reference field does not always display record information Content (please ensure you mask any confidential information): In the dashboard C…SERGIO BARRETO 11 views 0 comments 1 point Started by SERGIO BARRETO Reporting and Analytics for ERP -
Excel Bursting issues with Payables Payment Register reportSummary: Strange behavior in custom Payables Payment Register report Content (please ensure you mask any confidential information): I have customized the seeded 'Payable…
-
Arabic text not displaying properly when generating pdf outputSummary: Arabic text not displaying properly when generating pdf output Content (please ensure you mask any confidential information): Hi Experts, In Invoice Print Templ…Venkatesan 63 views 3 comments 1 point Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for ERP
-
which table stores the information of Fusion Middleware Error Messages ReferenceWe wanted to find oracle Fusion Middleware Error Messages Reference code and thier meanings from backend tables. While performing any transaction in our fusion instance …Opkey PA 22 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Executing dynamic queryHi, We have a requirement to execute dynamic query using BIP in oracle ERP Saas and was going through this (Doc ID 2636492.1) which says passing dynamic query as paramet…JayK 21 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
How we get difference of two sum from the same table?Summary: Content (please ensure you mask any confidential information): Hi, We would create a column in a report who get a difference of two sum from the same table. Wha…Ylenia Gentile 21 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
How can I join General ledger and ExpensesHow can I join General ledger and Expenses I am precisely looking to join below tables gl_je_lines gl_ledgers exm_expense_types Much appreciate your help on this