Reports
Discussion List
-
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 2 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 5 views 0 comments 0 points Started by Harsha Karanam Reporting and Analytics for ERP
-
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?
-
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 185 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 33 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…
-
Report listing active users with current and past assigned roles (with start and end date)Summary: Report listing active users with current and past assigned roles (with start and end date). Content (please ensure you mask any confidential information): Clien…
-
Schedule ess job- Create Customer StatementsSummary: Hi, We have a requirement to schedule "Create Customer Statements" to run once every 3 months. How do we schedule this and pass parameters to ess job on each ru…Shireesha 33 views 7 comments 0 points Most recent by SrinivasaRao Davuluri Reporting and Analytics for ERP
-
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.5K views 60 comments 9 points Most recent by Andy Mack Reporting and Analytics for ERP -
Table/View for AP Invoice Approval History & Workflow (BPM Flow)We are in the process of creating a customized report to track the complete approval history of AP invoices in Oracle Fusion. The requirement is to fetch details of the …sailesh_cloudare 16 views 2 comments 0 points Most recent by sailesh_cloudare Reporting and Analytics for ERP -
Narrative ReportingSummary: In Narrative reporting, is it possible to display numerical numbers in other language numbers e.g Arabic numbers etc in reports. Content (please ensure you mask…
-
How to schedule BIP report with increment date and timestamp?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…Lalit Sinkar 135 views 5 comments 0 points Most recent by Angela Valcelli Reporting and Analytics for ERP
-
Accessing Usage Metrics Drill Through ReportsWe are using version 22B. I received an email about accessing a usage metrics report showing user license consumption. However, I fail to find how to locate / generate t…
-
Get Service Usage Metrics Drill Through report on demandSummary: Get Service Usage Metrics Drill Through report on demand Content (please ensure you mask any confidential information): Hi We need have the information about me…Jazmin Saldierna 1 view 0 comments 0 points Started by Jazmin Saldierna Reporting and Analytics for ERP -
Unable to add a new field to oracle seeded report "Payable Trial Balance Report"Summary: We have a requirement to add a new field "Vendor_name_alt" to seeded report (Payable Trial Balance Report), after added new field and ran ess job it is throwing…SireeshaJaladi 51 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesSummary SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesContent Trying to built a query to fetch Application Roles, Privileges, Data Security & …Amarnath 5.7K views 17 comments 0 points Most recent by Mostfa Shehata Reporting and Analytics for ERP
-
Audit Trail in Procurement and Self Service ProcurementSummary: Currently in Procurement its possible to see only Supplier Audit History. Requisiton and Purchase Orders don't have any detailed history data available. Content… -
Financial Reporting Center reports not showing in searchHello, We are having an issue with reports showing in FRC. When a user searches for a report in FRC they return no results, but if the user navigates to the BI Catalog r…bobby.hussey 124 views 10 comments 0 points Most recent by Florence Z Reporting and Analytics for ERP -
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 36 views 7 comments 0 points Most recent by dgeryol Reporting and Analytics for ERP
-
Can we have a multiple bursting in one reportSummary Can we have a multiple bursting in one reportContent Hello, Can we have multiple bursting in one report, I can create multiple burstings within the data model an…Koteswararao Yenikepalli 651 views 3 comments 2 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
Schedule job list wanted by name of schedule time interval by schedule process by status waitSummary: I need the Report that can show me all schedule process running on interval and because we have many schedule process running. We have no track of those schedul…JayaramK_yash 1 view 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Ability to load data into custom objects in file based using API similar to FBDISummary: We have a requirement to upload data into custom objects created using application composer file based, similar to FBDI approach. Has oracle exposed any service…Jepson Erattuparmbil 11 views 2 comments 0 points Most recent by Alex D-Oracle Reporting and Analytics for ERP
-
supplier bank accounts fusion querySummary: I am trying to retrive the supplier bank accounts loaded in fusion at supplier header level. I have loaded bank accounts with only BANK_ACCOUNT_NUM. I did not i…
-
Changing Fonts in PDF Forms within FinancialReportsWe are creating forms in FinancialReports and outputting them as PDFs. We wish to change the font used in these forms. We have confirmed that fonts can be changed on a c…
-
Can we customise notifications to users only if there is any data generated after an ESS job runs.Summary: We have a requirement for which we want the notifications/Emails to be sent to users after an ESS job runs every week and if it does not have any data we don't …