Fusion Financial reporting
Discussion List
-
FRS YTD HTD instead of Month/QuarterSummary: We are designing a new report with BU Assets and its balance. We see the dimension as Year, Quarter and Month. Is there any way we could use the option HTD (His…Ralex123 23 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Installment payment dateSummary: We would like to have the installment payment date on a report. Content (please ensure you mask any confidential information): We have a report with using the P… -
Are there out of the box reports for financial reporting studioSummary: We wanted to see the capabilities/use case for Financial Reporting Studio. When you browse through the catalogue there it appears to use the same catalogue as O…Renee Dinh 21 views 1 comment 1 point Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
can not find new option under file menu in FRS to create a batch in BI cataloguecan not find new option under file menu in FRS to create a batch in BI catalogue
-
Getting Error while calling US 1099 Payments reportSummary: Hi Team, We are getting Error while calling US 1099 payments report. Error Details : java.sql.SQLSyntaxErrorException: ORA-00904: "CPI"."CLEARING_CCID": invalid…SukaShah 77 views 1 comment 1 point Most recent by Dhaval Patel-Oracle Payables, Payments & Cash Management
-
customization of Payment process request WF notificationsSummary: customization of Payment process request WF notifications Content (please ensure you mask any confidential information): Hi All, Is it possible to customize PPR…Venkatesan 6 views 1 comment 1 point Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
FRS - To get the end date of the period selected at the report running parameterSummary: Content (please ensure you mask any confidential information): Hi All, Do we have any option to get the end date of the period which is selected while running t…Vipusha Chandrakumaran 12 views 1 comment 0 points Most recent by Anca A-Oracle General Ledger & Intercompany
-
Schedule FRS(Financial Reporting Studio) ReportSummary: Schedule FRS(Financial Reporting Studio) Report Content (please ensure you mask any confidential information): Can we know how to schedule FRS Report. The navig…
-
BI query as list of values for a dashboard promptHello, We have a request to create a prompt with the names of employees based on a given job title. To access the data in the subject area "Security - Roles and Privileg…Varun Dhondea 55 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Merge Two OTBI Subject AreaSummary Develop a OTBI report by Merging two OTBI Subject AreaContent I have a requirement to develop OTBI report using two OTBI subject areas. Following OTBI subject ar…
-
I am trying to run Modelo Verification report for code 340 spain. But it is not providing any data.I am trying to run Modelo Verification report for code 340 for spain implementation . But output is coming blank. I have created AP Invoices with all required parameters…
-
issue with the link between gl_code_combinations and ZX_ACCOUNTSSummary: I am creating a report to gather the taxes and all invoices related to this tax. Content (please ensure you mask any confidential information): I used the below…
-
scheduled report not getting data in output filewe have scheduled a report on daily basis to the SFTP folder using the destination while scheduling reports. Reports are scheduling but not showing data in the output ge…Dara Nagasai 92 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
How to we call multiple Standard Packages in Data ModelSummary: As part of our requirement we need club two standard FA report columns. Two report called two different Standard Default Packages and in Report triggers also. C…Sarala B-Oracle 54 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Digital Signature showing invalid for Adobe Acrobat ReaderSummary: Digital signature showing invalid when viewed in Adobe Acrobat Reader Content (please ensure you mask any confidential information): Digital Signature showing i…Abhishek Parmar 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Statement of Change in EquityHi, Can we generate Statement of Change in Equity in Oracle Cloud Financials, like refer to below link As per on Page 18, there is a pointer towards this report. Would l…SaurabhSinghal26 2 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Need Setup/Configuration changes Report for Oracle Finance, Procurement, HCM setupsSummary: I Need Setup/Configuration changes Report for Oracle Finance, Procurement, HCM setups. The report should show about the changes made in setups. Content (please …PratikL 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
OTBI -Costing Receipt Accounting Real Time - Cost Source ReferenceSummary: OTBI -Costing Receipt Accounting Real Time - Cost Source Reference We would like to have the information as per the attached print screen Which is the cost elem…
-
Licenses for Development ToolsSummary: Hello All, We are using the below development tools provided in Oracle Fusion and want to know if any additional licenses are required apart from Oracle Fusion …Sarthak Mohanty 41 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How can I replicate data from a pivot table in an RTF report (BI Publisher)?I have a report for transaction build using BI publisher what is giving is the customer X is shown just once with multiple transaction what i want is to have the custome…Omran Zeaiter 11 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to send excel output to legacy systemHi, We have a custom ESS job and generates the output in excel format and can't enable it in csv format as it's exporting all the columns which we don't want. We have a …Madhu A 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
In Event Triggers: Alternative solution for passing multiple values into a single parameterIn event triggers, I need to pass a multiple values to a single parameter and upon research I realized that oracle does not provide such feature. I need a alternative so…navya Nallamotu 13 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
general ledger journals via subledger to receivablesSummary: BI publisher → SQL → Journal General Ledger Journal Data joining to Receivables at distribution level of detail Content (please ensure you mask any confidential…Robert of STAU 55 views 8 comments 1 point Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
How to print "All" value in the output if BIP report is run for all parameter valuesHello Oracle Gurus, I have a requirement where the user is running the report with all parameter values. The parameter is Source. Currently if the user runs the report f…ShitalRamteke 717 views 8 comments 1 point Most recent by Sachin Dharmik Reporting and Analytics for ERP
-
What are the tables or SQL query to fetch ESS job name, Report name, Report path detailsHi Team, I have requirement to develop custom SQL query to fetch details like All ESS Job names, Display names, Report names, Report paths etc. I have used tables like E…anusha chunduru 3.1K views 6 comments 1 point Most recent by User_S6U3H Reporting and Analytics for ERP
-
Drill Down To Fusion Financial Applications from OTBI ERP ReportsSummary The purpose of this White Paper is to demonstrate how users can drill from Oracle Transactional Business Intelligence (OTBI) adhoc reports to transaction details…Veronica Dumitriu 9K views 168 comments 46 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for ERP -
Automatically create a prepayment invoice from POSummary: Is there a way to automate the creation of prepayment invoices in AP from a PO? We would like to be able to create a PO and somehow specify the PO is expected t…AndresGlz2109 200 views 4 comments 0 points Most recent by AndresGlz2109 Reporting and Analytics for ERP -
Ability to get the Payment Approval Rule details defined on BPM by queries in Reports and AnalyticsIdea Number: 707234…Thomas De Leeuw 11 views 2 comments 0 points Most recent by Thomas De Leeuw Reporting and Analytics for ERP
-
How do I get my OTBI Income Statement to default to the current GL period?Summary: My OTBI Income Statement is defaulted to January 2022, but we would like it to dynamically open to the current GL period. Content (please ensure you mask any co…
-
IC and GL Reports that capture DFF detailsDo we have any seeded report that can capture the details of DFFs configured in the following tables: IC- FUN_DIST_LINES GL- GL_JE_LINES If none, could you please sugges…