Fusion Financial reporting
Discussion List
-
Calculated Measures issueSummary: Calculated Measures when null value exists Content (required): I have two measure. The one being invoice amount and the other being invoice paid amount. For bot… -
Is "EDI Location Code" available for Reporting in Customer Real Time Subject Area?Summary Is "EDI Location Code" available for Reporting in Customer Real Time Subject Area?Content Is "EDI Location Code" available for Reporting in Customer Real Time Su…Andrew_Schmitz 32 views 3 comments 2 points Most recent by Bhanu Gundala Reporting and Analytics for ERP -
Sending Reports to a Google DriveSummary: One of our customers is looking to have certain reports from ERP delivered to a Google drive location. Has anyone tried this and if yes how was it done? Any inp…Govind Srinivasan-Oracle 21 views 0 comments 0 points Started by Govind Srinivasan-Oracle Reporting and Analytics for ERP
-
SQL automatically changes to uppercase on user defined LOV query under Manage List Of Values SourcesSummary: SQL automatically changes to uppercase on user defined LOV query under Manage List Of Values Sources Content (required): I have entered below SQL on the Query b…Ajay Hareesh 51 views 6 comments 0 points Most recent by Ajay Hareesh Reporting and Analytics for ERP -
AR Transaction status in OTBII am creating a (crude) AR Aging report for a specific transaction type in OTBI, to include in in a dashboard. All columns I need are included in the subject area "Recei…MaartenDIF 21 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for ERP -
OTBI QuestionsSummary: Content (required): In "Payables Invoices - Transactional Real Time" subject area, why do we have so many invoice currency fields and why some of them are givin…
-
In Cash Management OTBI, is it possible to get the transactions reconcilied to a statement line?Summary: On the Manual Reconciliation Cash Management page, it is possible to see which system transactions (AP, AR, etc) are reconciled to a given bank statement line. …
-
Oracle Fusion Cloud - SQL script logic to calculate Period to Date (PTD), Quarter to Date (QTD) andSummary We are working on Custom Trial Balance Report development and need logic to calculate PTD, QTD and YTD Balances into Oracle Fusion Cloud.Content Hi Team, We are …Mahadev Salunkhe 283 views 2 comments 3 points Most recent by USER_BI Reporting and Analytics for ERP
-
How to add customer number field in Manage and create receipt screen?Summary: How to add a customer number field in Manage and create receipt screen? Content (required): How to add a customer number field in Manage and create receipt scre…Venkatesan 41 views 5 comments 0 points Most recent by CA Nirmal Choudhary Reporting and Analytics for ERP
-
Using rest api in fusion BI publisher data modelSummary: Is there any way to use rest api fusion BI publisher data model, I need to consume external data source and create a report in oracle fusion Content (required):…Shivaji Muttarapu HL 81 views 4 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Unable to suppress columns in Smart View retrieveSummary: Apologies if this is the wrong forum on which to ask this - I have created a Smart View retrieve to extract data from ERP, however in Smart View -> Options -> D…Danny Emmerton 71 views 3 comments 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP -
Payables Invoices by Cost Centre/SupplierSummary Dashboard & reports showing summary of AP invoice value by period/cost centre/supplier, with drill-down to invoice detailsContent Please see attached documents f…Andy Gough 692 views 10 comments 12 points Most recent by Sahil Makhiza Reporting and Analytics for ERP -
Is it possible to group pages members to create a new structure in Financial Reporting StudioSummary: Within Financial Reporting studio , I would like to create a balance sheet for different cost centres , but have a collection of cost centre grouped for each pa…
-
Grouping Columns into oneSummary: Is it possible to group different members into one column in financial reporting studio Content (required):Financial reporting studio Version (include the versi…Estar45 11 views 1 comment 1 point Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Report on Report Usage in FRSSummary: I am trying to gather information on which users run which reports in FRS. I have created an OTBI Usage report but that report does not include reports in the F…
-
Period name taken as a parameter tag display in a wrong format in excel outputSummary: Content (required): Hello Everyone, I recently created a BIP report using excel with the "xls" format and using the xml exported, I ,created the report in an ex…Sushan Peiris 32 views 3 comments 0 points Most recent by Sushan Peiris Reporting and Analytics for ERP -
Calculate difference between previous and current amountSummary: How to add a column for calculating the difference between yesterdays closing amount and todays opening amount Content (required): We have built a simple OTBI r…Stefan pettersson 11 views 1 comment 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
FRS 13 Month Rolling Reports Error Executing Query since 22C UpgradeSummary: Content (required): Hello: Is anyone having issues running FRS rolling reports since the 22C Upgrade? Our other reports are running fine, but we are getting an …
-
FRS Heading not Centering in Excel exportSummary: Content (required): I have an FRS report that has about 13 columns. The header is centered across the report with the ability to autosize. Looks great online bu…Cathy Watson Moore 1 view 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP -
Need to move Profit and loss FRS report from one instance to anotherSummary: Content (required): I have created a FRS report of profit and loss statement and I need to move it to another instance. Any suggestions on how to do this Versio…AeeTee 11 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
Need to report all journals and subledger activity (drilled data) on one reportSummary Currect reproting only allows reporting by one source at a time, need to see all for one account in single reprot.Version Fusion Cloud 20D -
Which database is used by Oracle Analytics Cloud?Summary: I wanted to understand if Oracle Analytics Cloud sits on the same Cloud Fusion ERP database or it uses a different database. Content (required): To be clear - I…Sumit Vijay 31 views 5 comments 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
COUNT Function to get specific valuesSummary: Hi Experts, I have created a report to get the sum of certain rows by specific values. For example, the column returns values as either "REC" or "UNR". So the r…
-
FRS - Selecting multiple values for Point of ViewSummary: Selecting multiple values for Point of View Content (required): Hi All, We have a requirement to selct multiple values for the POV when selecting the initial re…231094 11 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
OTBI Analysis: Is it possible to add a column that summarizes Invoice Amount by Supplier?Summary I'm building an analysis in OTBI and wanted to know if it's possible to have a calculated column that summarizes one of the other columnsContent I'm building an … -
How to change the logo dynamically in fusion home page?Summary: How to change the logo dynamically in fusion home page? Content (required): Hi All, Is it possible to change the logo based on the user login on the fusion home…
-
how to define a xml in rtf if there are multiple datasets with the same column nameSummary: Hi everyone, Recently I faced an issue with a seeded report that was customized. The report had two datasets with the same column on both, where when I try to l…
-
Error : Exceeded configured maximum number of allowed output sectionsSummary: Error : Exceeded configured maximum number of allowed output sections Content (required): Hi Experts, We are trying to run thr report " Payables Credit Memo Mat…231094 31 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
Getting error in FRS reportSummary: Getting errors in the FRS report Content (required): Hi All, I moved one FRS report from TEST instance to PROD. When I try to run the report in PROD, I am getti…Venkatesan 1 view 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
ERP BI and OTBI Reporting - Creating Custom RoleSummary: Hi Guys, Anyone has any idea how to go about creating a Reporting Role for Applications Internal Team for adhoc BI & OTBI reporting . Is there a delivered role …AshishERPCloud 31 views 6 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for ERP