Fusion Financial reporting
Discussion List
-
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 414 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 361 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 561 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 11 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 394 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 31 views 1 comment 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Receivables - Transactions Real Time OTBI is not showing data for sales repSummary: Within the Receivables - Transactions Real Time OTBI subject area, we need the sales rep's name to be populated. This column is available, but it shows blank in…
-
Receivables Sales VAT Register for Italy ended in error without outputSummary: Dear All, I ran Receivables Sales VAT Register for Italy and Purchase VAT Register for Italy but they ended in error Content (please ensure you mask any confide… -
Scheduled Jobs ErrorSummary: Hi Team, We have few scheduled jobs which will run on daily basis. Recently few system automated jobs and manual scheduled jobs ended in error without any log f…Sesha Sailini 21 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Trending FRS Report to exclude 13th Period?Summary: How to exclude 13th Period in Fusion FRS Report? Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snip…Prakash.Malmarugan 111 views 6 comments 0 points Most recent by Kenney Reporting and Analytics for ERP
-
Rest API to GET reports from BIP in Fusion Financials SAASSummary Is there a Rest API to get BI Publisher reportsContent Hi All Is there a Rest API to call BI Publisher reports from Fusion Cloud Financials within SAAS financial…
-
Republish option not enabled in scheduled BIP reportsIn some of the scheduled BIP reports with excel template, the 'Republish' option is not enabled. Even after checking Save Data for Republishing, clicking on 'Republish' …Sharmava 71 views 2 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
OTBI GL Subject Area: 'General Ledger - Journals Real Time' unable to find the 'Approval Date'Summary: Hi All, While developing OTBI report for General Ledgers, We are unable to see the 'Approval Date' for the journal in 'General Ledger - Journals Real Time'. Kin…Venkat_P-Oracle 101 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Inventory valuation Report (As of Date) - DepericatedWe had Oracle delivered Inventory valuation Report which used to run by parameter as of date. We were using it extensively. Unfortunately Oracle has depreciated this rep…Oracletechnofunctional 191 views 4 comments 0 points Most recent by Adarsh.Kumar Reporting and Analytics for ERP
-
FRS - Does RelativeMember Function work on Prompted AccountingPeriod?Summary FRS - Issue with period-to-period comparison on prompted valuesContent I am creating a Period-to-Period Financial comparison report, where Accounting Period need…
-
HFRS - How to generate Date Format for a report Dimension - Accounting Period on report HeaderSummary: We have a requirement where the HFRS Report header needs date format of the Accounting Period. Content: Our Accounting Period Format is MMM-YY and this is a Dim…Shefali Lakhani 151 views 3 comments 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Image in BI Publisher template spills into attachment when sent to e-mail outputSummary: Image in BI Publisher template spills into attachment when sent to e-mail output Content (please ensure you mask any confidential information): In BI Publisher …Robert of STAU 41 views 7 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Need Custom Advance Shipment Report fileSummary Need Custom Advance Shipment Report Sample fileContent Need Custom Advance Shipment Report fileNageshwaran1 28 views 1 comment 0 points Most recent by Mahmoud Abdulghany Reporting and Analytics for ERP -
Transactions coming from external systemsHi We are defining lets say a tax rate 20% and not mentioning whether its inclusive or exclusive at the setup level. If transactions are coming from interfaces, is their…
-
Query To Find Label Name For Each Node ValueSummary: Dear All, I need a Query to extract Label Name for each Node Value. Content (please ensure you mask any confidential information): Dear All, I need a Query to e…Elisa Riz 91 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
SQL query to get transaction date on statement lin, joining CE_BAT_TRANSFERS with CE_STATEMENT_LINESI'm trying to create a query where I want to find the transaction date of an Internal Bank Transfer. The goal is to create a report which is used for reconciliation of b… -
Can I change bip:AUTHOR on a saved BI report?Summary: Is it possible to change the bip:AUTHOR value on a saved BI report? Content (required): I want to make some reports public that I've exported to a .CATALOG file…JimCC 81 views 5 comments 0 points Most recent by Shanmugaraja_Karunamoorthy Reporting and Analytics for ERP
-
How to get data for Audit Reasons column in OTBI like the Expense Auditor Dashboard ?Summary: We are working on a custom dashboard for Expense auditors and one of the fields requested in 'Audit Reasons'. The subject area 'Expense- Expense Transactions Re… -
Etext template output file(.txt) is unable to print Arabic language in sequenceSummary: We have custom Etext template under disbursement payment file formats. In that Supplier name is required to show in Arabic language in output file. for testing …SireeshaJaladi 51 views 2 comments 1 point Most recent by SireeshaJaladi Reporting and Analytics for ERP
-
How to filter and sum positive or negative value only in FRS reportSummary: To see if FRS report could filter value of positive or negative and do summation against it. Content (required): We would like to know is there a way to filter …Chow Ka Ming Jason-Oracle 83 views 1 comment 0 points Most recent by Janitha Perera Reporting and Analytics for ERP
-
OTBI Analysis - General Ledger - Journal Real Time : No output after MigrationHi, I have migrated OTBI report to one of the demo environment but I am not getting any data in the output. There are no filters in the report and I have validated that …Karun Jain-Oracle 1 view 1 comment 0 points Most recent by Karun Jain-Oracle Reporting and Analytics for ERP
-
DTD and Index file for Germany tax reportingWe have a Legal Entities registered in Germany and we have to submit data to German tax authority. For this, I have followed the note id Oracle Fusion Cloud ERP: Germany…
-
SQL-How I get all the children/parent of account in GL ?Summary: SQL-How I get all the children/parent of account in GL ? Content (please ensure you mask any confidential information): Hello I am looking for a custom report t…Cesar Saveedra 31 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
Fixed Asset ReportingSummary Reporting from Fixed Asset Sub-LedgerContent Hello - I'm looking for the following information in a report from the Fixed Asset sub-ledger. I am looking for a re…User_2025-01-29-20-33-47-986 171 views 6 comments 1 point Most recent by Tim Sweeney-279789 Reporting and Analytics for ERP