Fusion Financial reporting
Discussion List
-
how to exclude our custom application data from being picked by Account Analysis Report?Summary: Recently We has implemented a custom application. Data for this custom application flows through accounting hub. The data volume is huge (millions of data each … -
Report data size exceeds the maximum limit (524288000 bytes). Stopped processing.Summary: We were given a SQL query to pull journal entries for our auditors and it worked successfully for FY22. We tried to run the report again for 2023 and received t…hannah_barry 6.4K views 7 comments 0 points Most recent by Shankar-Oracle Reporting and Analytics for ERP
-
Created a BIP report from subject area Payables-Payments Disbursement Real to concatenate columnsSummary: Created a BI publisher report using Subject area from Payables. There is no option to concatenate two or more columns. I need to concatenate the payee address f…PSehgal2388 12 views 1 comment 0 points Most recent by James McBride Reporting and Analytics for ERP
-
Report to get employee's default expense accountSummary: Hi, Can you please suggest if OTBI report is possible to develop to get employee's default expense account? If Not can you please share any SQL query which can …Ninja 629 views 3 comments 0 points Most recent by Aravindkumar Shah Reporting and Analytics for ERP -
Shared SCM ReportsDoes anyone have a monthly total spend report that they might share? OTBI or SQL code? CoVicky P 13 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
can we do the page personalization on the invoice type lov in the create payment pageSummary: can we do the page personalization on the invoice type lov in the create payment page, in fact we want to remove two option from the default LOV that is Manual …Subrato Gupta-Oracle 15 views 2 comments 0 points Most recent by Subrato Gupta-Oracle Reporting and Analytics for ERP
-
How to change the output format of the JAVA type ESS Job from .csv to .xmlI have a ESS Job of JAVA Type in Oracle Fusion having output in .csv format, User want the .xml format anyone have any idea how could I change the format?Damoder Chitti 13 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Is it possible to use multiple letters in the 'begins with' filterSummary: We have some OTBI reports that we use an agent to schedule and they have gone over 25k rows so now they are not including the full data set (currently 44k rows)…CarolineH 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to print previous period in smart view reportsHello All, I need to print the account value for current period and previous period. In FRS we have the relative period function that helps us print the pervious period.…ShitalRamteke 2 views 1 comment 1 point Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Page is not available after Click Launch Financial Reporting Web StudioSummary: Page is not available after clicking Launch Financial Reporting Web Studio Content (required): I Went through the following path to do and adjustment in Grids a…Mohamed Ramees 26 views 5 comments 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP -
Is there a way to limit what tables a user can query in OTBI?We have a support team that's requesting access to write Data Model queries in OTBI. Our concern is restricting them to only the financial tables. Does anyone know if th… -
BI Reporting restricting by segment value depending on UserSummary: I am looking for a way of resticting a BI report by a segment value depending on the user accessing the reports. Ideally by assigning a segment to a user withn …JHould 15 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
how to get production instance name in BIP reportSummary: How to check via SQL in BIP report whether the instance is Production vs non Production ? we have a requirement to put a check in the BIP report so that emails …
-
using trigger for BIP reportSummary: I am trying to use a trigger for a BIP report and schedule. Content (please ensure you mask any confidential information): I only want to deliver the report whe… -
FRS - Option to get the 'Prompt' of the COA segment in the POV instead of the segment nameSummary: Hi All, We had a requirement to change the segment name of the Future segment. Since it had multiple implications as suggested in the forum we have only changed…Vipusha Chandrakumaran 13 views 1 comment 1 point Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
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 22 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 14 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 73 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 3 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 53 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 89 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 48 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