Category 129
Discussion List
-
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 49 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 24 views 0 comments 0 points Started by Voladri Saikiran Reporting and Analytics for ERP -
issue with the link between gl_code_combinations and ZX_ACCOUNTSSummary: I am creating a report to gather the taxes and all invoices related to this tax. Content (please ensure you mask any confidential information): I used the below…
-
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
-
Highlight Duplicate String ValuesSummary: Content (please ensure you mask any confidential information): In an OTBI analysis, I would like to highlight duplicate string values. Is this possible? We're u…
-
Disability CategorySummary: We are building a report that displays a summary of Disability Categories Specifically the "Workforce Management - Person Real Time" subject area - Person Disab…Mark_R 19 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
What table contains the AP invoice source distribution transaction line number details?I'm trying to build a BIP report that contains the AP invoice source distribution transaction line number details, as shown in the screenshot below. What BIP table conta…
-
How to add Year to date activity in financial reportSummary: We are creating a financial report where we want to include current period activity and year to date (accumulated activity). How do you suggest that we include …
-
BIP検索条件についてSummary: Could you please tell me how to specify multiple search conditions for BIP? Content (please ensure you mask any confidential information): In the search screen …
-
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…
-
Alternative to Rank for Participant Details - ICSummary: Currently when creating a report that includes Participant Detail results, we need to use a Rank Participant Details Start Date by Participant ID. If we don't u…Justine Klemetson 2 views 0 comments 0 points Started by Justine Klemetson Reporting and Analytics for ERP
-
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 62 views 7 comments 0 points Most recent by SrinivasaRao Davuluri 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 28 views 2 comments 0 points Most recent by sailesh_cloudare Reporting and Analytics for ERP -
ERP Financials Custom Disbursement Positive Pay File FormatsSummary: I'm trying to add headers to a custom positive pay file, however when I run the process this return data but not headers. Could you please let me know if there … -
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 168 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 4 views 0 comments 0 points Started by Jazmin Saldierna Reporting and Analytics for ERP -
PO PDF Template Conditional Regions by Purchasing CategorySummary: We are trying to update the PO PDF template so that if 3 specific purchasing categories are used on the Purchase Order it renders some different text on the tem…
-
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 52 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Need to enable GL Date From and To as parameters in Account Analysis ReportSummary: Need to enable GL Date From and To as parameters in Account Analysis Report Content (please ensure you mask any confidential information): Account Analysis Repo…Deepa Lakshminarayanan 45 views 2 comments 0 points Most recent by Nathanieal General Ledger & Intercompany
-
Need Help on Source Table for Manage Common Options for Payables and Procurement:Summary: need to find table for Manage Common Options for Payables and Procurement. want value for default distributions -liability, prepayment Content (please ensure yo…Mayur Gangar 18 views 3 comments 0 points Most recent by Andres Celis-Oracle Reporting and Analytics for ERP
-
Join between xla_distribution_links and po_distributions_allHi, Can anyone tell me how to join from xla_distribution_links to the purchase order tables (po_distributions_all)? For example, for the receipt accounting accrual. In x…Rob Tempelman 18 views 1 comment 0 points Most recent by James McBride 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…