Reporting and Analytics
Discussion List
-
How Did You Map Natural Accounts to Financial Categories in Oracle Fusion ERP for FDI?Good Day, I've reviewed some related posts but none that directly address my question, so posting below. Here at WellSpan we're implementing Oracle FDI this fall and end…Jared Custer 11 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle General Ledger & Intercompany -
How do we achieve this calculation to be implemented in FDI/OAC classic Report.Hi Team, There is this caculation requirement in P&L report. Please let me know if anyone has implemented a similar logic for %Calculations in FDI Classic Report. For ex…Rasagna Repaka-Oracle 22 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
Cannot successfully extract metadata using the Out of the box Oracle EPM connector in Oracle FDII have enabled the preview feature EPM Planning and Budgeting Data Export I have successfully created and tested connection to the EPM source. I cannot successfully crea…tismithhuron 41 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform -
How to fetch FA Approval details with BPM Worklist Task NumberHow to fetch Fa_Mass_Transactions and other FA additions,retirements,adjustment and transfer tables FA Approval details with BPM Worklist Task Number for Mass Transactio… -
Oracle BIP Report Excel template output displaying Number values as TextHi, We have created the new custom BIP Report with Excel template and when we download the report output into Excel, then all Number values are displaying as text, these…Nagaraju Vandavasi 61 views 5 comments 0 points Most recent by User_26T18 Reporting and Analytics for ERP -
Assistance Required to Identify Root Cause of Number Format Issue in Custom RTF TemplatesHi Team, We’re experiencing an issue with custom RTF templates where a predefined number format behaves inconsistently—working correctly for some users, but displaying i…Baswanth Kumar Reddy-Oracle 1 view 4 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
how to display the date set in the user preference date format in BIP reportUser has set date format in Oracle fusion "General Preferences: Regional" settings. The requirement is to print the date in excel output as per that setting. The setting…Munish Kumar Mittal-Oracle 41 views 2 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
Financial Reporting Oracle Fusion not able to view sum of Balance amountI have created a report in FRS studio, i can view all the data every time. But same report is run by any other user, they can only see left column account details. Accou… -
Request SQL to Extract All Agent Configuration DetailsHi Team, We would like assistance in building a SQL query that retrieves complete Agent configuration details from the backend tables in Oracle Fusion. Currently, we can…Gulab_Ansari 51 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service -
Unable to add security permissions for HCM seeded report folderWe need to give customized access to seeded HCM report folders in the Reports and Analytics page but unable to edit security permissions for the same. We have copied the… -
Dynamic Deep Link URL in BI Publisher Report not workingSummary: I have a RTF template that shows details of AR Invoices. I have inserted a link on Invoice Number to take the user to the transaction in the application using D… -
ESS JOB SHWOING DIFFRENT OUTPUTHi Experts! Greetings! Recently I Came across an issue in ESS JOB FOR BIP REPORT. When I run the ESS JOB then in the attachment (pdf) one part of the report is missing ,…Mainur-Oracle 51 views 2 comments 0 points Most recent by Crescentia David Reporting & Analytics for Fusion Service -
Unable to see the DFF attribute which are based on Table type value set in the OTBI subject areaHi All, We have created a few custom DFF attributes under Manage Customer Account Descriptive Flexfields. Few are based on independent value sets, and few use table-type…Gurujothi D 212 views 10 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP -
How to schedule an OTBI report using agent with effective date prompt?I have OTBI analysis where I have added 'Effective date' prompt. I want to schedule this analysis via agent. However, wants to select date in prompt under 'condition' se… -
Payables to General Ledger reconciliation report runs by business unit not legal entity instead?The Payables to General Ledger reconciliation report runs by business unit. Is there any possibility to run it by legal entity instead? There was a requirement to reconc…Pandeyujjwal007 11 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management -
Timecard not populating to HXT_TM_MTRX table .When we are submitting Time card through Redwood page one of the attribute value of timecard not populating to HXT_TM_MTRX table . Still, we are getting data once creati…Mazumder Sourav-Oracle 112 views 4 comments 1 point Most recent by David Boudreau Workforce Management -
How to display date in the format (like April 1st 2025) using RTF tags.The requirement is to display the date like April 1st, 2025 in the RTF Template using RTF Tags.Nalsoft Pvt Ltd 41 views 3 comments 0 points Most recent by Hari Haran Reporting & Analytics for Fusion Service -
While selecting parameters for custom ess job I am getting error.Hi Team, One of our client wanted to make a parameter mandatory while submitting Create Electronic Payment files ess job, which is seeded ESS job. We have duplicated the…Syamakalla_Venugopal 71 views 5 comments 0 points Most recent by Sai P Payables, Payments & Cash Management -
How to disable Approve Reject from workflow bell icon notification?Proposed Email template & resignation approval process to People Leader: 1. We are requesting to remove the ‘Approve or Reject’ button from the current resignation email…Nagendra Chitra-Oracle 974 views 22 comments 0 points Most recent by Rabia Hasan Human Capital Management -
Extract journal with debit and credit in the same lineSummary:Extract journal with debit and credit in the same line Content (please ensure you mask any confidential information): The client requested the extraction of acco…User_Q4SYX 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
I am trying to populate latest date record to be printed for BPA from PO tables in a custom BIPPer the business requirement, we need to print COO from BPA attached to the shipment, if the shipment lines having country of origin code is NULL, and since there maybe …Shahid Qureshi 01 1 view 0 comments 0 points Started by Shahid Qureshi 01 BI Publisher Learning Center -
How do we track / audit of the PVO customization in BICC?How do we track / audit of the PVO customization in BICC? We have multiple teams working on creating Jobs in BICC after doing some PVO customization. It is overriding th… -
the end date of assignment is 4712for the previous assignmentHi, Currently just Working on one requirement where i encountered a scenario is(Using Per_all_assignments_m) The person has four Assignments Active employee where the en…Kande Likhitha 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
The US Periodic Tax Filing ext- why New version does not work; Old version renamed to Obsolete work?Change title to The US Periodic Tax Filing ADP Quarterly Extract - New version does not work; Old version renamed to "Obsolete. This is a follow-up email to our conversa…Pamela Price-Oracle 31 views 3 comments 0 points Most recent by Faithe Chu-Oracle Payroll and Global Payroll Interface (GPI) -
Roles: Missing Report and Analytics in Home > Menu after Role ChangesSummary: Hi everyone, Can anyone clarify what exact privileges are required to display the Report and Analytics function under Home > Menu? I’ve created a new role by re…Yahya Khan 81 views 2 comments 0 points Most recent by Yahya Khan Reporting & Analytics for Fusion Service -
audit reportSummary: Requesting an audit report, which must contain the information listed in the attached images. It must be filtered by report name and the date the scheduled repo…ALFONSO JIMENEZ-Oracle 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service -
MICR line zeros showing too smallHi, We have created a cheque rtf template and to display the MICR line we have used MICRE13B font as per the bank suggested font and font size is 13. However in the MICR…Krishna Kishore 31 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service -
How To Remove Data Augmentation Column From Subject AreaSetup data augmentation to bring additional attributes to the subject area. Now I've deleted that data augmentation table from data augmentation screen, But still I can …Raghu_Nandan 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service -
How to display Header and line groups in EXCEL Template, line has two groups@Kevin M-Oracle I have 3 groups in xml , G_3 is master , and G_1 & G_2 are in line. G_2 =Sheet1!$A$16:$N$16 G_1 =Sheet1!$O$16:$R$16 G_3 =Sheet1!$A$2:$R$16 While I add G_…Dineshkumar.A-Oracle 21 views 1 comment 0 points Most recent by Lori W-Support-Oracle Reporting & Analytics for Fusion Service -
How do we get Customer detail(Party name, Party site name) based on the business unit.How do we get Customer detail(Party name, Account Number, Party site name) based on the business unit. Basically, I want the joining for FUN_ALL_BUSINESS_UNITS_V with hz…Ritu123 71 views 1 comment 0 points Most recent by Bodhisattwa Mukherjee-Oracle Receivables & Collections