Reports
Discussion List
-
Users with experience of using SQLConnect by BI SplashSummary: Users with experience of using SQLConnect by BI Splash Content (please ensure you mask any confidential information): We are reviewing the feasibility of granti… -
Is there anyway to extract Essbase cube data to connect with Powerbi beside smartview File?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
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 2.6K views 62 comments 9 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP -
How to Create a Report for Approval/Reject Notifications in Fusion?Hi Everyone, We have a requirement to generate a report for all email notifications sent from Oracle Fusion for Approval or Rejection actions. The report should include …Mohini soni 12 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
FDI create a custom subject area using the PVO'sWe have a requirement to print the AP invoice attachment URL and the attachment file name in the FDI report. Currently ap invoice subject area don't have these attribute… -
Will Oracle Fusion Cloud BIP report Bursting supports Dot Matrix PrinterSummary: one of the report needs to be printed in Dot Matrix Printer. So, We need below information 1. Will Fusion BIP bursting supports Dot Matrix Printer? 2. If so, in…
-
What are the considerations of enabling and disabling the global "SQL Pruning" setting in BIP?A customer enabled the global SQL pruning setting in production which caused various BI publisher report issues (primarily, missing columns from various CSV and RTF outp…Harrison Jacob 12 views 0 comments 1 point Started by Harrison Jacob Reporting and Analytics for ERP
-
How to perform drill-down directly within an Oracle PBCS report?Hi, I’m working on Oracle PBCS in the Reports section and I was wondering if it’s possible — and if so, how — to enable drill-down functionality directly within a report…
-
Is there a PVO (or combination of PVOs) that returns the accounting status of a Payables invoice?I need to return the accounting status (Accounted, Partially Accounted, Selected, Unaccounted) for a specific AP invoice but using PVOs. The column "ApInvoicesPostingSta…
-
PO PDF Report Showing Truncated “Text to Supplier” – Full Attachment Name/Text Not Printing CompleteHi all, We’re facing an issue with the PO PDF report where the Text to Supplier (or text from the URL attachment) is not printing completely. When we open the attachment…
-
Query or the table that contains columns of the Account Analysis ReportSummary: Content (required): Hello everyone, I have a requirement to make a custom report for the Account Analysis Report. I need to pick some of the columns in the seed…Sushan Peiris 540 views 8 comments 0 points Most recent by User_K7YG4 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…Vinay Gharge 139 views 5 comments 2 points Most recent by Abhisek Choudhury Reporting and Analytics for ERP
-
Query for Business Units and Legal Entities mapping for Payables.Summary Need query to fetch Business Units and associated Legal Entities mapping for Payables.Content Hi All, I am having requirement to fetch all the Legal Entities ava…User_SJJQT 6.3K views 5 comments 0 points Most recent by Tejeswar J E Reporting and Analytics for ERP
-
A SQL query of privileged resources in the role FSD sectionSummary: Hi All, Can anyone share a SQL query on how to retrieve privileged resources? inside the role of the FSD section oracle provides information about the privilege…Eliran Hadad 38 views 7 comments 0 points Most recent by Eliran Hadad Reporting and Analytics for ERP
-
Query to get Oracle GL COA Entity Segment, Oracle Legal EIN/TIN ,Oracle Legal Entity NameSummary: Hi Everyone, I need query to create a BIP report which fetches the Oracle GL COA Entity Segment, Oracle Legal EIN/TIN , Oracle Legal Entity Name. Thanks in Adva…
-
Unable to find the table and column in which "Grouped construction in progress" flag at project ExpContent Hi All, I am able to find the "Grouped Construction in Progress" flag at project expenditure level. please find the navigation attached. I'm unable to find the f…
-
R13 Financials OTBI subject area to database lineage mapping spreadsheetSummary This spreadsheet documents R13 Financials OTBI subject areas to database lineage mapping and subject area security. Content This spreadsheet is published by Orac…Noelle Bartlam-Oracle 33.7K views 93 comments 55 points Most recent by User_QY8JM Reporting and Analytics for ERP
-
For the customized Print receivable transaction report, the ess job fails with errorSummary: As part of the Run , our Print Receivable Transaction Report job is failing and the ESS log message provides us the below error message AR_ESS_PLSQL_WRAPPER_PKG…
-
Common Dimensions between Subject Areas in OTBIanyone has a list of Common Dimensions between Subject Areas in OTBI? at least 2 or 3 different Subject Areas?
-
Financial Reporting Studio Issue: 2025 Data Not Appearing CorrectlyDear Oracle Support, We are encountering an issue in Financial Reporting Studio (FRS) that is affecting the display of 2025 data in our reports. Problem Description: Whe…Patrick Chrabieh 48 views 6 comments 0 points Most recent by user10987169 Reporting and Analytics for ERP -
how to create subtotals in excell template for bipI had a requirement to create subtotals for each individual invoice_numbers , when i try to do sum function or subtotal selection it is not giving subtotal for each indi…Voladri Saikiran 23 views 0 comments 0 points Started by Voladri Saikiran Reporting and Analytics for ERP
-
How to create Custom ESS Job for a Schedule integration from FusionI am trying to create a Custom ESS job in Oracle fusion by creating report for a schedule integration. But not able trigger the integration with the Report. Please let m…Harsha Karanam 13 views 0 comments 0 points Started by Harsha Karanam Reporting and Analytics for ERP
-
Reporting on Payment ApprovalsSummary BI Publisher or OTBI Report to extract Payment ApprovalsContent Hi Community Are there are any BI Publisher or OTBI Reports available to report on Payment Approv…Kunal Daya-175386 186 views 5 comments 0 points Most recent by Marko Puskac Reporting and Analytics for ERP
-
Purchasing Documents Pending ApprovalSummary A Report showing purchasing documents which are currently pending approval and the person they are currently assigned to.Content - If you want a report that simp…Ifeanyi Katchy-Oracle 3.9K views 54 comments 20 points Most recent by User_48JZP Reporting and Analytics for ERP
-
Need Cleared check report in Oracle fusion without reconciliation processSummary: Hi, The business is using check payment method and issuing checks and they are using cash account when they issue payments. So there is no reconciliation proces…
-
Purge User RequestsSummary: Purge User Requests Content (please ensure you mask any confidential information): There is a way to purge a specific request? I'd like to purge some requests f…Luca Nobili PWC 34 views 3 comments 0 points Most recent by Luca Nobili PWC Reporting and Analytics for ERP
-
Invoice Payments querySummary: Create New Invoice Payments Reports Content (please ensure you mask any confidential information):I would like to create a new report in Oracle Fusion ERP to qu…
-
Control report-level permissions during migrationSummary: We have a custom folder ("Folder A") with 4 roles assigned: Role A, Role B, Role C, and Role D. When a new report is migrated into this folder, it automatically…
-
Is the 75000 row limit for OTBI reports just a limit on the output?For an OTBI report, the SQL automatically adds "FETCH FIRST 75001 ROWS ONLY." Is this only referring to the output of the report? Or is it also referring to the total po…
-
How to delete page entry which are created using structure toolSummary: How to delete page entry which are created using structure tool Content (please ensure you mask any confidential information): Hi All, We created page entry(Rep…