Fusion Financial reporting
Discussion List
-
Oracle ERP > Procurement> Self Service Receipts tables to query for a reportSummary Self Service Receipts tables to query for a reportContent Hello Community, I am new to the topic, and I am trying to generate a report on Oracle Fusion ERP based…Robinson Antunez 9 views 3 comments 0 points Most recent by Robinson Antunez Reporting and Analytics for ERP -
Receivables - Customers Real Time subject area access issueSummary Results errors when adding multiple fields to analysisContent I created a Customer Detail Dashboard using one analysis and one prompt. It was built from the Rece…Mike Burnett 13 views 10 comments 1 point Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
How Can we import Gl Balances from legacy to Oracle Fusion?Summary How Can we import Gl Balances from legacy to Oracle Fusion?Content Hello All, Can you please let me know what are the ways to import GL account Opening Balances … -
Vendor name not available at source lines for assets in FAContent Hi all, I face an issue where I don't get the vendor name for the table FA_ASSET_INVOICES where I take invoice no, PO no for source lines of an asset. When I add…Sushan Peiris 9 views 3 comments 2 points Most recent by Sushan Peiris Reporting and Analytics for ERP -
Reports Failing after upgrade to 20BSummary Reports Failing after upgrade to 20BContent Does anyone experiencing these issues after the upgrade over the weekend? 1. Reports parameters are blank not display…
-
OTBI AP Report including approversSummary Can I access a field containing approvers in an OTBI Payables transaction report?Content We have a report that returns all payables transactions for the prompted…Mike Brown-242022 17 views 2 comments 1 point Most recent by Mike Brown-242022 Reporting and Analytics for ERP -
OTBI multi-language support Release 13Summary Multi-language support for OTBIContent Hi Has multi-language support been enabled for OTBI Release 13? ThanksNeena S-48254 55 views 7 comments 2 points Most recent by Hari Thyagaraj Reporting and Analytics for ERP
-
Supplier Profile syntax has been excluded from the most recent version of the "ERP OTBI Report to FuContent Supplier Profile syntax has been excluded from the most recent version of the "ERP OTBI Report to Fusion App Drill-Down Actions" white paper (which had most rece…Marybeth Snodgrass 16 views 1 comment 3 points Most recent by James Allen Reporting and Analytics for ERP -
Need to identify tables that contain BPM configurations - Application PreferencesContent Looking to identify the table(s) that contain Application Preferences for BPM Worklist. See screen shot below.Jeff Hare CPA CISA CIA 28 views 2 comments 2 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Procure to Pay dashboard not displaying invoice amount on Invoices tabContent We have just discovered the Procure to Pay dashboard and are very interested in the Invoices charts and metrics however every reference to a display which involv…
-
What is the risk of copy any seeded report, add two columns on a table already in the data model, keSummary What is the risk of copy any seeded report, add two columns on a table already in the data model, keeping in the custom folder with a new name and new ESS Job on…Sam Samaddar 18 views 4 comments 1 point Most recent by Sam Samaddar Reporting and Analytics for ERP -
How to display data of a column horizontally in RTF?Content Hi all, I have a requirement where I need to display some data that comes from a column horizontally on RTF.Hereby, I'm attaching a screenshot of the RTF and wha…Sushan Peiris 34 views 7 comments 2 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
Need a SQL Query For Segment Value Data SecurityContent Hi there Building a report that show the charts of account data security condition and value. Please advise. Thanks.User_DDXB9 39 views 10 comments 2 points Most recent by Kevin Fehskens Reporting and Analytics for ERP
-
"Procurement - Requsition real time" x "Workforce Profiles - Model profiles real time"Summary Relate procurement with workforce to get department nameContent Hi, We are trying to relate the procurement requisition real time subject area with the workforce…Yordan Oliveira 10 views 4 comments 0 points Most recent by Yordan Oliveira Reporting and Analytics for ERP
-
Can we call Lookup value in OTBI analysis?Summary Calling up Lookup value in OTBI analsyisContent We are setting up an OTBI analysis using 'Subledger Accounting- Journals real time'. We want to call look up valu…Yogesh Mhalgi 18 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
Query to check if an invoice have a prepayment included or notContent Hi all, I want a query that can provide me with a flag whether an invoice has an applied prepayment or not. I checked if a flag is available in the invoice table…Sushan Peiris 13 views 3 comments 2 points Most recent by Sushan Peiris Reporting and Analytics for ERP
-
OTBI Issue - Costing - Receipt Accounting Real TimeSummary OTBI Receipt Accounting -- Concatenated SegmentsContent Hi All, Appreciate your inputs or suggestions on the below issue. OTBI Report having timeout issue Subjec…Swapnil Kashid 14 views 4 comments 1 point Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Accounts Receivables Month end closing in Cloud 20 ASummary Accounts Receivables Month end closing in Cloud 20 AContent We want to close AR month end closing in Cloud 20A. I developed a query from AR tables withe invoice …Rama Pedamallu-193980 33 views 4 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for ERP
-
Use subject area tile missing for create reportContent Hello, Financial Analyst and Accounts Payable Manager do not have the excel or Use Subject Matter tiles when creating reports. Am I missing a role, as the implem…
-
Release 21BSummary xsl template for ACHContent Hi All, Did anyone worked on the Payables payment process with ACH template with xsl type in 21b.? need inputs on how to develop ACH …
-
Need a query to get Period name for asset addition transactions in FA in ORACLE FUSIONContent Hi all, Can someone provide me with a query in which I can take the period name relevant to the asset addition transaction? I want to get the name of the period …
-
OTBI Report for AP Invoice HoldsSummary Sample OTBI report for ERP Cloud providing a list of AP Invoices on HoldContent Sample OTBI Report for ERP Cloud: AP Invoices on Hold This report provides a list…Andy Gough 728 views 12 comments 17 points Most recent by Matt Luscombe Reporting and Analytics for ERP -
Need a query to derive current cost, Netbook value in Oracle Fusion Fixed assets module with the peContent Hello all, I need a query that gives me the current cost and the netbook value for a specific asset within a period range. Need a parameter too to run the query.…Sushan Peiris 14 views 7 comments 3 points Most recent by Sushan Peiris Reporting and Analytics for ERP
-
Convert OTBI analysis / report to BI Publisher reportSummary Convert OTBI analysis / report to BI Publisher reportContent At our company the OTBI reports are running slow and long. I am tasked to convert OTBI analysis / re…
-
How to implement Segment Value Data Security in BI Publisher ReportContent Hi All, Can someone provide insights on how to implement implement Segment Value Data Security (SVS) in BI Publisher Report. We have a requirement to create BIP …Himanshu245 30 views 2 comments 1 point Most recent by Matt Luscombe Reporting and Analytics for ERP
-
Join between FA_FUSION_SOAINFRA.WFCOMMENTS and FA_FUSION_SOAINFRA.WFTASKHISTORYContent Hi, We are trying to find comments on actions taken by approvers on expense report. We found these 2 tables : FA_FUSION_SOAINFRA.WFCOMMENTS and FA_FUSION_SOAINFR…Bhavik Shah 22 views 4 comments 3 points Most recent by Deepak Anand Reporting and Analytics for ERP -
OTBI Subledger Journals subject areaSummary OTBI Subledger Journals subject areaContent Hi, In OTBI Subledger Journals Subject area, We have a date supporting references in the format YYYY/MM/DD. Since sup…Vinod Kumar Mohanraj 21 views 2 comments 1 point Most recent by Vinod Kumar Mohanraj Reporting and Analytics for ERP
-
AR Docket generation - optionsSummary Business is looking to generate an AR Docket - from Oracle fusion - what options, extensions, enhancements are available for the sameContent Business is looking … -
Anyone has AR aging report logic for calculating aging as of a date. We would like to build an AR AgContent Anyone has AR aging report logic for calculating aging as of a date. We would like to build an AR Aging report from scratch but lot of logic is hidden in stored … -
Why can't I see the information for flexfields from subject areas in Results tab?Content Hi, We have Oracle Business Intelligence 11.1.1.9 and Oracle Cloud Application 21B (11.13.21.04.0) We are development an Analysis using Receivables - Bills recei…