Fusion Financial reporting
Discussion List
-
How to get only Month and year without days in otbi report Pivot table?Hi everyone, I'm working on an OTBI report and I'm stuck with a visualization challenge. I'm using an accounting date in a pivot table, but I want to display each year a… -
List of seeded reports & analyses for Procurement Contracts/ Enterprise Contracts module in oracle fSummary List of seeded reports & analyses for Procurement Contracts/ Enterprise Contracts module in oracle fusionContent Hi, Is there any way to get the list of all the …Aman Vasishtha-Oracle 515 views 2 comments 0 points Most recent by Bill McLarty55-Oracle Reporting and Analytics for ERP
-
ISO Format for the positive pay templateSummary ISO Format for the positive pay templateContent Hello All, We got a requirement for the positive pay in the ISO format but as of now we have only an etext seeded…Koteswararao Yenikepalli 186 views 6 comments 1 point Most recent by Ruthwij Reporting and Analytics for ERP -
Varalakshmi 31 views 4 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Italian AR E-Invoicing ProgressivoInvio NumberHi, As per Italian reporting requirement we are developing Italian AR E-Invoicing report with XML output. We have a tag called 'ProgressivoInvio', as per the customer re…
-
BIP Global Level Function Data not getting included in output after bursting.Summary Aggregate functions data show's up at report level which are involved in GLOBAL Level functions, but the same Data attributes wont show up, if we burst the file.…Kishan Dhongadi 195 views 9 comments 1 point Most recent by HarshithDarla Reporting and Analytics for ERP
-
Unable to view the data in data model with lexical parameterSummary: Unable to view the data in data model with lexical parameter Content (please ensure you mask any confidential information): Hi, We are trying to create a BI rep…JithendraKCV 37 views 1 comment 0 points Most recent by JithendraKCV Reporting and Analytics for ERP
-
How to join from Subledger Accounting (XLA) to transaction application entity code PJBACCOUNTINGSummary: Hi, How do we join to get transaction details in the subledger application from XLA_TRANSACTION_ENTITIES where SOURCE_APPLICATION_ID = '10036' (Project Accounti… -
Customization of 'Print Receivables Transactions' and 'Print Receivables Transactions: Invoices'Summary: Content (please ensure you mask any confidential information): Hi, This is regarding ESS Job 'Print Receivables Transactions' which in turn calls another ESS Jo…JithendraKCV 517 views 5 comments 0 points Most recent by JithendraKCV Reporting and Analytics for ERP
-
Subject Area to capture Employee detailsSummary: Content (required): Hi, Can someone please let me know the subject area to be used if the requirement is to capture the username, employee first name, employee …Sheneli98 983 views 12 comments 1 point Most recent by Nareshbabu Mallela Reporting and Analytics for ERP
-
FUSIONAPPSS_REQUEST_IDSummary: I'm trying to modify the ChartOfAccounts report in order to add new filters to the query, but as soon as I add the parameter :fusionapps_request__id the DM stop…Victor Bocardo Negrete 5 views 0 comments 0 points Started by Victor Bocardo Negrete BI Publisher Learning Center
-
Is there any functionality to have dynamic reporting parameters while scheduling FRS Reports.Summary: While we are scheduling FRS Reports, we need to add the ability to have dynamic reporting parameters for FRS reports. Recreating applicable schedules every mont…Abhishek khanduja 261 views 2 comments 3 points Most recent by Henry Pao Reporting and Analytics for ERP
-
Sql Query to get data security applied on Chart of AccountsHello, I need an sql query to get my user's data security on the chart of accounts values. Thanks,
-
Cash to General Ledger Reconciliation ReportSummary Cash to General Ledger Reconciliation BI ReportContent Hi Friends, Did anybody Customized " Cash to General Ledger Reconciliation Report" or developed new report…OraFusionworld 113 views 4 comments 0 points Most recent by Vicky Adwani Reporting and Analytics for ERP
-
Duplicate descriptions across summary vs postable valuesSummary GL_SEGMENT_HIER_INTERFACEContent Will it cause issues if there are duplicate descriptions on a Summary/Non Postable value vs a Non Summary/Postable value? I've m…
-
Issue with OTBI Subject Area "Installed Base - Meter Based Asset Usage Real Time"Summary: Our issue is with the OTBI subject area called “Installed Base – Meter Based Asset Usage Real Time”. We can’t figure out how to exclude the canceled readings fr…Ajeez K-Oracle 23 views 2 comments 1 point Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
date masking reverting date back a daySummary: We have customized the AP invoice approval report to add fields needed. Content (please ensure you mask any confidential information): Issue is that the date in… -
A report that tracks user access activity historySummary A report for security that tracks user login history what data or module was touchedContent Does anyone know how/where I can get this information together? This …Kimberly Nguyen 286 views 18 comments 0 points Most recent by Mayur_P Reporting and Analytics for ERP
-
Statement of Directions on FRS in Cloud ERP?Hi, Does anyone know if/when FRS is going to be retired in Oracle Cloud ERP and moved to Management Reporting like is being done in EPM? Trying ot understand if we wait …Hyperion_Junkie 23 views 1 comment 1 point Most recent by Hyperion_Junkie Reporting and Analytics for ERP
-
How to get output character set in ANSI for etext templateSummary: In Oracle etext template is set to "iso-8859-1", what value we need to provide to change it to ASCI. Content (required): Version (include the version you are u…SireeshaJaladi 469 views 2 comments 1 point Most recent by Yves Chanel Reporting and Analytics for ERP
-
How To get Cancelled Invoice Amount in AP Invoice in Oracle FusionIs there any ways to retrieve Cancelled AP Invoice Amount in Oracle Fusion Using SQL Script.EPNSLsupport 438 views 4 comments 0 points Most recent by EPNSLsupport Reporting and Analytics for ERP
-
Can I have a link for data lineage for 24 A versionSummary: Can I have a link for data lineage for 24 A version Content (please ensure you mask any confidential information): Version (include the version you are using, i…Prateek Dhawan 32 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Can we default a parameter with dynamic value in ESS Job definition?Hi, We have a custom ESS Job defined for a BIP Report with a parameter Period Name and attached a custom LOV data source defined which lists the periods from gl_periods.…Rajendra Kona 437 views 2 comments 1 point Most recent by Rajendra Kona Reporting and Analytics for ERP
-
How to Display Date and Time as per User Local Settings in Excel TemplateSummary We need to display the Date and Time as per the User Regional Settings. We need to know how to use the XDODEFDATE and XDODEFTIME in Excel TemplateContent Our Req…Balachander G-Oracle 400 views 4 comments 1 point Most recent by Abhiengine Reporting and Analytics for ERP
-
OTBI report is taking very long time to complete.I have built one Payroll OTBI report. I have been able to run it successfully from my private folder in the Prod environment, but when we load it to the Payroll Team fol…Chetana Pawar 279 views 2 comments 0 points Most recent by Saurabh Poddar-Oracle Reporting and Analytics for ERP
-
Schedule BIP report only when it has DataSummary Schedule BIP report only when it has DataContent We have one requirement for BIP report where we have schedule BIP report daily. so we need that if report data i…User_2025-02-07-23-45-47-870 486 views 7 comments 1 point Most recent by User_A19YQ Reporting and Analytics for ERP -
FRS with records exclusion for given company/PBSSummary: is it possible with FRS to exclude certain CoA records for one PBS value but include for other PBS value? Content (please ensure you mask any confidential infor…Roman Havrylyak 12 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP -
Financials Cloud OTBI Release 12: Subject Area Description DocumentSummary This document provides a comprehensive description of each subject area including the key business questions that can be answered using the same.Content Use this…Anand DN-Oracle 395 views 6 comments 3 points Most recent by Ajay Hareesh Reporting and Analytics for ERP
-
segregation of access within BI Reporting (Reports and Analytics)Summary: Requirement to segregate the access in Reports and Analytics such that user who can deploy the reports to PROD, user who can manage the reports (edit/delete) an…
-
How to merge customer names with transactions in a grouped SQL query?Hello, I have this customer ABC having multiple transaction i want to merge the cells that have the same customer name and make it appear one time, i am using select fro…Omran Zeaiter 32 views 1 comment 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP