Category 129
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 26 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 16 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 25 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 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…RAJAGANAPATHI 52 views 0 comments 0 points Started by RAJAGANAPATHI Payables, Payments & Cash Management -
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 5 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… -
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 197 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 5 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 55 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 43 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 22 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 47 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… -
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 241 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 38 views 7 comments 0 points Most recent by dgeryol 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 8 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP