Fusion Financial reporting
Discussion List
-
What data security policies are required for each financial Transaction Analysis Duty?Summary: I am trying to create a custom role that allows the user to run a custom OTBI report but I don't know what data security policies are required for the report. I… -
Is there a lag period before OTBI displays new invoices/data?Summary: Hi everyone, I am running the Payable Withholding Tax report from Reports and Analytics. Navigation: Shared Folders/Financials/Payables/Income Tax and Withholdi…
-
How to remove ability to Create Shortcut in Reports & Analytics pageSummary: Within the Reports & Analytics page, we do not want users to be able to create shortcuts. How can we remove this ability from users? Content (required): Is ther…Akbar Ahmed 91 views 2 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
How to modify a seeded dashboard?Summary: Hi. We need to modify some elements of a seeded dashboard according to client requirements. Grateful if someone could provide standard procedures for modifying …ShailenS 98 views 2 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
When we reassign an account to different collector - tasks do not moveWe are implementing advanced collection and noticing that when we reassign an account - to a different collector , strategy tasks do NOT MOVE to the new collector - they…Dhruvjoshi23 61 views 1 comment 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
Data Persistency in Oracle Cloud - how long will Request Ids, Output/log files be available?Summary: is there any time period for which the request ids, output/log files of Oracle ERP Cloud Process/Job/ESS requests are made available? Or Will these be available…
-
Calculate revenue % distribution for each project with in Business unitSummary: We have the below requirement Project1 Revenue amount-20 project2 Revenue amount-30 project3 revenue amount-16 Total BU revenue amount 66 (this is achieved by e…
-
List of All Tables for Oracle Fusion ERP in PDF FormSummary: We need to have a List of All Tables for Oracle Fusion ERP in PDF Form along with its corresponding descriptions Content (required): We need to have a List of A…Gene Garcia 1.6K views 13 comments 0 points Most recent by Agnes.Ramos Reporting and Analytics for ERP
-
Does OTBI report follow Data Security enabled for usersSummary: Does OTBI subject areas enforce the Data Security Context values that have been assigned to users. For example, a user has been assigned one BU and One ledger, …
-
Unable to join Invoice and Procurement Subject Area in OTBI AnalysisSummary I have a requirement to fetch the Purchase order details with corresponding invoice details. Therefore i need to connect two subject areas to fetch the required …Santosh V-228136 617 views 8 comments 0 points Most recent by Khassham Khan Reporting and Analytics for ERP
-
How quickly does Oracle make updates to federal reports?Summary: When the federal government makes changes to a federal form, such as the Federal Financial Report (FFR), how quickly does Oracle make this change to the report …
-
Open FRS report using a URL link from BI Tile or similar?Summary: Fusion Financials: How to open a FRS report via a URL link from a BI reporting tile or similar? Content (required): Is there any way to open a FRS report via a …Robert of STAU 82 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Historical Depreciation & Total Accumulated Depreciation from Depreciation Real time Subject areaSummary: I am trying to calculated the Historical Depreciation & Total Accumulated Depreciation from " Fixed Assets - Depreciation Real Time" subject area. There seem to…
-
OTBI login based data will display but user id not matchedSummary: OTBI dash board /analysis based on login user name data will display if user name/display name not matched still they want data using custom session variable to…SivaRamaKrishna-Oracle 31 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Join Subledger Tables to AP_INVOICE_DISTRIBUTIONS_ALLSummary: I'm not sure if this belongs more in the Reporting forums, however I am looking to join any of the following Subledger accounting tables to the AP_INVOICE_DISTR…
-
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 193 views 6 comments 2 points Most recent by Pallavi S Reporting and Analytics for ERP -
OTBI Dashboard Record Count MismatchHi Team, We have built a dashboard and that has a record count to count the number of rows. We could see the record count shows different numbers for people with differe…Swapnil Kashid 81 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
What is SQL Receipt Accounting join to source_id_int_1 column from xla_transaction_entities?Summary: Trying to go from GL through Subledger Accounting to Receipt Accounting in Data Model SQL. Didn't find any documentation or hints on this. Content (required): V…huronstevesmith 947 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
How to make a dashboard prompt work with a custom logical sql?Summary: Hi I have created a custom logical sql, because I needed an outer join between two Subject Areas(Payables Invoices - Transactions Real time and Payables Payment…Anders W. Langholm 185 views 5 comments 0 points Most recent by Julia Looi Reporting and Analytics for ERP -
Access to Vertex Tax Error reports - not displaying in scheduled processesWe use Vertex for tax calculations and in the document referenced below, there is an error report that should be available via Scheduled Processes. I'm on the admin team… -
Setup dynamic column from analysis in subject line of email sent using AgentSummary: Setup dynamic column from analysis in subject line of email sent using Agent For ex: Email subject should include " Project Name: needs renewal" Any inputs on …Santhi Sree 103 views 11 comments 0 points Most recent by Santhi Sree Reporting and Analytics for ERP
-
Suggest Some Price List table in oracle fusionSummary Please suggest some price list table in oracle fusion and where can we find themContent Please suggest some price list table in oracle fusion and where can we fi…Nageshwaran1 40 views 3 comments 0 points Most recent by Waleed Fetoh Reporting and Analytics for ERP -
Missing data in some columns in FscmTopModelAM.FinExtractAM.GlBiccExtractAM.CodeCombinationExtractPVSummary: Hi We can see all our columns in our COA, but there is only data in segment1. What do we need to do in order to see more data? Content (required): Version (incl…Bo Tøpgaard 63 views 4 comments 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for ERP
-
Unable to pull data from FA_BALANCES_REP_GT table in the seeded Reserve Summary reportSummary Unable to pull data from FA_BALANCES_REP_GT table in Reserve Summary report due to this in an Oracle only internal reportContent I'm trying to find a table/table…User_2025-01-30-23-52-10-842 157 views 2 comments 0 points Most recent by Mirela Tomoiu-Oracle Reporting and Analytics for ERP -
Bursting To FTP server Not WorkingSummary: Bursting To FTP server Not Working Content (required): Hi All, I have developed one report where I want to place the file in the ftp server and for that i have …Pritam Das 256 views 8 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Customizing data model in BI Publisher (Cost Detail Data Model)Summary: I would like to add some fields to the data model "Cost Detail Data Model" in Assets Balances. Content (required): I have copied the file to the custom folder, …Anders W. Langholm 139 views 3 comments 0 points Most recent by Akshay Acharya-Oracle Reporting and Analytics for ERP
-
Payables Multi-Period ReportSummary: HI, Anybody have AP multi-period invoice reports with amortizations? Content (required): Version (include the version you are using, if applicable): Code Snippe…
-
Bank Return Records BIP queryHi All, I m new to fusion finance module, we have a requirement to fetch all the bank return records through BIP query, Can anyone help us with SQL query or the table na…Yuvraj S-Oracle 32 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
Is there any way to add Item number in seeded account analysis report?Summary: Customer is interested to see Item number in Account analysis report so that he/she can perform GRNI reconciliation Content (required): Version (include the ver…Naga Hari Krishna P-Oracle 41 views 1 comment 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
Database connection in FRS reporting studioSummary: New COA is not available when trying to create new database connection FRS reporting studio Please advise Content (required): Version (include the version you a…El1a 42 views 6 comments 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP