Fusion Financial reporting
Discussion List
-
GL Segment Level security and OTBI Subject areasSummary: We have a requirement to secure data down to a legal entity/cost center level for dashboard built in OTBI with the GL Transactions real time subject area. How b…amy hardtke 31 views 2 comments 0 points Most recent by Madhavi Godbole Reporting and Analytics for ERP -
Table/Query to find the BPM work flow notification pending with particular personSummary: We are looking for Workflow notifications (Especially Expense report) pending with one particular person for approval. Do we have any table which stores this de…Thanigainathan R 111 views 1 comment 1 point Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP -
Payables Posted Invoice Register to show final approver doubles invoice line amountsSummary: I'm trying to modify the Payables Posted Invoice Register to show the final approver, but the output shows the invoice line multiple times. Content (required): …Niall McColl 31 views 3 comments 0 points Most recent by Niall McColl Reporting and Analytics for ERP -
Searching for table containing segment values and descriptionsSummary I'm writing the SQL in a data model where I need to display account value and descriptionContent I'm creating a data model where I want to display segments in th… -
Ago Function not working in OTBISummary: We trying to use AGO function for Previous Year Actuals Column in OTBI General Ledger - Balances Real Time. But report is showing null values in Previous Year A…FirozahamedSK 21 views 2 comments 0 points Most recent by FirozahamedSK Reporting and Analytics for ERP
-
REST API to run FRS reports in FusionSummary: Need to know REST API details if any to run FRS reports in Fusion Content (required): REST API to run FRS reports in Fusion Version (include the version you are…Sudha KOVURU 251 views 4 comments 0 points Most recent by Subbareddy Kandala Reporting and Analytics for ERP -
Taxable lines in journal entries not generating in the Deductible VAT Declaration Report for FranceHello, We are encountering an issue whereby taxable lines in journal entries are not being generated in the Deductible VAT Declaration Report for France. Taxable Purchas… -
PVO for GL Secondary Balancing Segment KFF?Summary: On a quest for chart of account segment descriptive labels (KFFs) for secondary balancing segment. Content (please ensure you mask any confidential information)…Josh Vincent 31 views 2 comments 0 points Most recent by Josh Vincent Reporting and Analytics for ERP -
FRS Batch Scheduler/Bundling does not have expand all capability when users click into HTML linkOracle Fusion General Ledger Cloud Service - Version 11.13.23.10.0 and later In Oracle Financial Reporting Studio, after creating a bundle and scheduling reports through…
-
Receivables OTBI report: Line level transaction report with payment informationSummary: I have created an OTBI report to show line level detail of AR transactions using the Receivables- Transactions Real Time subject area. I am looking for a second… -
Missing Access for a COA segment in a FRS report for a particular userSummary: Business user is missing access to Geography segment values (in parameter) in all the financial reports. Only able to see three values in the parameter. Content…Akash Verma 41 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
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 101 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Is there a way to hide a specific hierarchy from being available to users when they run FRS reports?Summary: Is there a way to hide a specific hierarchy from being available to users when they run FRS reports? Content (please ensure you mask any confidential informatio…
-
How to add Reports to Task Menu (Reports and Analytics) in UI?Summary How to add Reports to Task Menu (Reports and Analytics) in UI?Content Hi How to add Reports to Task Menu (Reports and Analytics) in UI? We have requirement like … -
How does SQL Pruning in the data model affects the report performance?Hello, We have a customized version of the AP Aging report. The report performance is slow compared to the standard one. To improve the performance we did some adjustmen…Kristelle 41 views 1 comment 1 point Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP
-
General Ledger - Balance Real Time OTBI Report IssueSummary: We have used below columns in the report, it is not giving the data with below combination. "Natural Account Segment"."Natural Account Segment Code" "Natural Ac…FirozahamedSK 31 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
PO Column for Receipt Accounting Source in Oracle Fusion. Which role or privilege needs to be added?Summary: PO Column for Receipt Accounting Source in Custom Account Analysis Report in Oracle Fusion. Which role or privilege needs to be added? Content (please ensure yo…
-
OTBI - Can we have one line per transaction with tax amount?Summary: We are looking to have only 1 line per transaction and when I add tax amount it splits the report to multiple lines per transaction. Is there a way around this?…Rahul Kumar Gupta.-Oracle 21 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Security feature for AR invoice print options available in view image button of transactionsSummary: Is any security feature for AR invoice print options available in the view image button of transactions Content (required): Users are saving(save as pdf method)…
-
Is there any formula to calculate the number of days in a financial year in FRS?Summary: We have a requirement where we need to apply a formula as [(Row 1)+(Row2)]/Number of days in a FY, so for that we need to automatically get no.of days calculate…Srishti Kedia-Oracle 81 views 2 comments 1 point Most recent by CathyK Reporting and Analytics for ERP -
create a net column on an analysis by subtracting two columnsSummary: I am trying to create a net column on an analysis using by subtracting two columns that are included on it. The Analysis is using the GL and AP subject areas. T…Tashi Temple-Wood 41 views 6 comments 0 points Most recent by Tashi Temple-Wood Reporting and Analytics for ERP
-
Remove ability for users to edit FRS reportsSummary: Users have the ability to view and edit FRS reports through the "Launch Financial Reporting Web Studio". Content (required): We would like to know how we can re…Joe B 121 views 2 comments 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
How to link PL and RL rows when parent_je_header_id is not populatedSummary: How to link PL and RL rows when parent_je_header_id is not populated Content (required): I need to write a query that will bring primary ledger details along wi…Jaeyshree Kumaran Kalpana 101 views 2 comments 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Financial Reporting Studio - prior yearsSummary Avoid hard coding year-end dates in reportsContent I am using Financial Reporting Studio with an Oracle Essbase connection and require dynamic date reporting so …Jill 135 views 3 comments 1 point Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
How to select multiple members in one of the dimension? FRS reportsTeam - how can I select multiple values of one of the dimension in FRS report(s)?Essmaeel 71 views 2 comments 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
How to compare Prior Year Month Revenue with Current Month's Revenue in OTBI?Summary: Comparison of current month's revenue with last year's same month's revenue in Oracle Fusion OTBI Content (required): We are trying to create a Dashboard which …Waqas Yousuf 241 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
Why is the PVO for project team members not appearing anymore in Oracle 23... versions?Hi, We noticed that the following PVO, used to extract data for project team members: FscmTopModelAM.PjfProjectDefinitionAM.ProjectTeamMemberPVO , does not appear anymor… -
Need to know the logic behind the seeded report parameters of Payables Trial Balance ReportSummary: Just wanted to know the logic behind seeded 'Payables Trial Balance Report' parameters which are mentioned below 1.Include Bills Payable 2.Negative Balances Onl…SireeshaJaladi 71 views 3 comments 0 points Most recent by SireeshaJaladi Reporting and Analytics for ERP
-
FRS scheduler how to pass current month or Date to PromptSummary FRS scheduler how to pass current month or Date to PromptContent We are scheduling FRS reports. When we create batch it requests to enter the prompt values. Thes…saravana maneeian subhramaniun 113 views 5 comments 1 point Most recent by Subbareddy Kandala Reporting and Analytics for ERP
-
what is EDI location in Banks, Branches and Accounts FBDI TemplateSummary: What is EDI Location in Banks, Branches and Accounts Template also guide me on how to update Bank code, Branch number etc., for existing bank accounts. Content …