Fusion Financial reporting
Discussion List
-
Substitution Variables in FRSSummary Substitution Variables in FRSContent Can anyone please direct me to documentation on how to set and administer substitution variables for use in Financial Report… -
are there any SOAP/REST services available to Execute Report using JWT token instead of username andSummary are there any SOAP/REST services available to Execute Report using JWT token instead of username and password?Content Hi Team, Are there any SOAP/REST services a… -
Which table stores 'Transaction Number' in Project CostsSummary Looking for backend table that stores 'Transaction Number' in Project CostsContent Hi All, I'm looking for backend table that stores 'Transaction Number' in Proj…Sumanth Kunimakki-21932 308 views 7 comments 0 points Most recent by Rasu P Reporting and Analytics for ERP -
Reports with hardcoded parameters performing better then those with bind variablesContent Hello, We have a peculiar problem, we have a query for gl balances report which when run by hardcoding the Legal entity and period runs fine fetching all our dat… -
OBIEE 12c / Financial Reporting Studio usage with Oracle Fusion Financial CloudSummary Financial Reporting Studio for Customized Reporting needContent Hi, With earlier releases of on premise ERP products from Oracle we used OBIA for any seeded / cu…User_2025-01-29-01-36-29-977 133 views 4 comments 1 point Most recent by Andrew_Schmitz Reporting and Analytics for ERP -
ORDSSummary Ad Hoc Question on Oracle REST Data ServicesContent Is ORDS free if you use Fusion SaaS? I went to a presentation on Oracle Rest Data Services at Open World and …Hannah Dorman 47 views 4 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for ERP -
Financial Reporting Studio will not work after installationSummary FRS installed, but error message says it is not installed.Content FRS was installed according to Doc ID 2051105.1, and computer shut down and rebooted. Get the f…User_2025-01-31-00-03-48-847 49 views 3 comments 1 point Most recent by Arun Raj Reporting and Analytics for ERP -
ESS Jobs to be run to create Cube'sContent Hi Team, Can you please let me know the list of steps to be run to publish the data to cube, so that we can design FRS reports. I'm working on FRS reports, when …Sridhar Gupta 130 views 5 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP -
Expenses Overview Real Time subject areaSummary A summarization program needs to be run to gather information before data is available in this area.Content We are creating some test reports from the Expenses O… -
Balance Sheet totals different for different usersSummary Balance Sheet totals are different for two different users, same reportContent Two users in our office have opened the same Balance Sheet report, same parameters…User_2025-01-31-00-03-48-847 32 views 5 comments 0 points Most recent by User_2025-01-28-21-13-11-074 Reporting and Analytics for ERP -
Error while customizing BI Publisher ReportSummary We are trying to customize the Account Analysis Report (ESS Job Name - Account Analysis Report) but getting error while trying to modify the data modelContent Hi…Sudha KOVURU 100 views 10 comments 0 points Most recent by Sudha KOVURU Reporting and Analytics for ERP
-
Can we find all scheduled BI Reports instead of navigating to each reportSummary Can we find all scheduled BI Reports instead of navigating to each reportContent I was trying to find if we can find all scheduled BI Reports instead of navigati…User_2025-02-01-07-43-15-700 59 views 3 comments 1 point Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP -
Receiving Error When Prompting Values from Field Created from a Case StatementSummary Cannot function ship the following expression: EVALUATE. (HY000)Content I have created a Dashboard Analysis and Prompt from the following subject area: Subledger…User_2025-02-05-07-37-39-271 25 views 0 comments 1 point Most recent by User_2025-02-05-07-37-39-271 Reporting and Analytics for ERP -
Security setup for users who are creating BI reportsSummary What job role does an employee require to create and run BI reportsContent Morning everyone, We are currently implementing Oracle Expense Cloud. Our BI team has …Jennifer Wolfe 56 views 5 comments 1 point Most recent by Michael Cook Reporting and Analytics for ERP -
XML Structure of BIP reportContent Hi, I need to create a BIP report which is extracted as an XML. Below is the sample xml structure and sample XSD. How do I define an attribute of an element whil…User_2025-02-05-07-46-04-895 117 views 3 comments 2 points Most recent by Rasu P Reporting and Analytics for ERP -
Prompts is not showing in reporting analyticsContent While running reports in report analytics the defined prompt is not appearing but the prompt is showing under browse catalog page. can you please give me input t…Baskar.Chakravarthi 44 views 8 comments 0 points Most recent by User_2025-01-28-16-10-52-033 Reporting and Analytics for ERP -
Changes to BIP report are not reflectingSummary Changes to BIP report are not reflecting in the data. We have changed few columns in the Dataset but the report output displays old column data.Content Changes t…Thiru Vedantham 562 views 3 comments 1 point Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP -
Journal Entry Reserve LedgerSummary Customization of the Journal Entry Reserve LedgerContent I'm customising the Journal Entry Reserve Ledger report - I am trying to add new data columns and change…Elliot Hall-Walker 80 views 1 comment 1 point Most recent by Manish Pesswani Reporting and Analytics for ERP -
Access for General Ledger DashboardsSummary Cannot view data for seeded GL Analytics DashboardsContent Hello, What security role do I need to access the General Ledger Dashboards: Account Analysis, General…User_2025-02-05-07-37-39-271 55 views 4 comments 0 points Most recent by User_2025-02-05-07-37-39-271 Reporting and Analytics for ERP -
How to Add the Serial No Column in OTBI ReportsContent How to Add the Serial No Column in OTBI Reports.Baskar.Chakravarthi 142 views 8 comments 0 points Most recent by Baskar.Chakravarthi Reporting and Analytics for ERP -
Report Data Size exceeds limitSummary Report errors due to too many rowsContent I am creating an Oracle BI report to extract journal details however when I execute for a particular entity i get the e…Dave Sherrard 422 views 4 comments 0 points Most recent by Dave Sherrard Reporting and Analytics for ERP -
XML file for Disbursement Payment FormatsSummary XML file for Disbursement Payment FormatsContent All, I cannot see any Data model attached to disburse payment templates. how to get XML file for them if we need… -
FR Web StudioSummary FR Web Studio Too Slow To Build ReportsContent Hi, We are trying to build reports in our ERP environment(s). When we open FR Web Studio the lag is too slow; it t… -
BI Cloud Connector (BICC) White paper or DocumentsSummary Looking for Information on How to create Extract using BICCContent Hi, I need to send incremental feed of Data such as Customer , Supplier, GRN and POs to anothe…Prateek Parasar - GTUK, ACE Pro 238 views 6 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for ERP -
Custom BI Publisher Report SQL ErrorSummary SQL or ORA exceptions error.Content Hello, We are receiving the following error when running a custom built BI Publisher report. This report was functioning with…User_2025-02-05-07-37-39-271 92 views 14 comments 0 points Most recent by Tom Strudley Reporting and Analytics for ERP -
Cannot see HZ_GEOGRAPHY_IDENTIFIERS_VL view with Custom Geography Type in Data ModelSummary Cannot see HZ_GEOGRAPHY_IDENTIFIERS_VL view with Custom Geography Type in Data ModelContent Hi I have LACLS Colombia reports into Oracle ERP Cloud. However, they…User_2025-01-30-22-31-23-162 42 views 1 comment 0 points Most recent by User_2025-01-30-22-31-23-162 Reporting and Analytics for ERP -
Bank statement balances check reportContent Crossposting here from the Cash Management forum as per Oracle's suggestion. We want to have a report that shows bank statements for which the subsequent bank st… -
What is the Data Model that runs the 'General Ledger and Subledger Account Analysis' Report?Content Hi All, There is a report run via a scheduled process called 'General Ledger and Subledger Account Analysis'. The report is extremely useful and we would like to…Aaron Leggett 190 views 10 comments 2 points Most recent by Bharath Dondapati Reporting and Analytics for ERP -
Get the correct PO Number for an Invoice NumberContent Hi, We had some consultants in they wrote a large piece of SQL, of which the below is a small part. It's looking to get the correct PO number for a specific invo… -
How to set/enable the menu "Reports and Analytics" regardless of responsibilitySummary We’ve created the BI reports to General Ledger but is not possible see the “Reports and Analytics” option on the responsibility menu area, is possible enable thi…