Fusion Financial reporting
Discussion List
-
MISC code in OTBISummary: Is it possible to get the MISC code in OTBI? We need to build a report for 1099 since Oracle's 1099 capability is severely limited. Content (please ensure you m…Alex Glose 12 views 4 comments 0 points Most recent by James McBride Reporting and Analytics for ERP -
Custom Role to Run FRS Reports in OTBIHello, Is there a custom ERP Self Service role that can be created to allow users to be able to view and run FRS reports in OTBI? Or does it have to be a full ERP licens…Erik Nicholson1234 14 views 2 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP -
Payables Trial Balance ReportSummary: I've set up a role so GL Users can run this report but when they do it errors with a permissions issue. Is it right only Payables Managers can run this report, …JohnG 27 views 3 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Employee Location not visible in custom report output for certain usersSummary: We have created a program that extracts all the posted journals for a set of accounts. In our implementation, Employees are stored as parties for making payment…Anand Balasubramanian 12 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Can someone suggest me with respect to performance tuning of the query?Issue is with a BIP report for optimizing the report query FYI this is AR report for Aging bucket. please find my initial findings below, request you to please provide y…Shahid Qureshi 64 views 7 comments 0 points Most recent by James McBride Reporting and Analytics for ERP
-
sql query to fetch item number detailsSummary: We need a SQL query to fetch the item number, business unit, inventory item id, unit cost, total cost, sub inventory code, organization name. Kindly let us know…Dilip.Murugan-Oracle 2.7K views 11 comments 0 points Most recent by Harshitha S Motagi Reporting and Analytics for ERP
-
cashflow statement report querySummary: Hi All, Does any one have 'Cashflow Statement Report' query?? if you have could you please share. Thanks in Advance. Content (please ensure you mask any confide…Amarnath Podaralla 11 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
A report that will show the Fusion Role's last update dateGood afternoon. I wonder if there's a Fusion Report that will provide the date when the Fusion roles were last updated? Let's say a specific role was updated by Oracle d…
-
ERP BI Publisher - HTTP Data SourceWe are planning to use an external API as a data source in BIP within Oracle ERP Cloud. Can anyone confirm if "HTTP" as a data source will be de-supported in a future re…Rohit Varma - Architect 22 views 1 comment 1 point Most recent by MiaM-Oracle Reporting and Analytics for ERP
-
How to find out columns with empty value in Oracle fusion table through query ?Summary: Hello... I want to make a query to get all blank column names from a Oracle fusion table…Kindly help me in writing the query. Thanks. Content (please ensure you…I am a learner 21 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Include Dynamic dates in File Name for Scheduled Custom ReportSummary: We are scheduling a weekly custom report to run each Tues night for the previous weeks' data (ie. Jun-17 thru Jun-25) Is it possible to include the date paramet…
-
How to translate Amount in Words from English to Arabic language in rtf templateSummary: we have a requirement to print Payment amount in Words (English) to Arabic language in check template. The expectation is that, translate below given English te…SireeshaJaladi 506 views 9 comments 0 points Most recent by ArjunReddy88 Reporting and Analytics for ERP
-
RTFtemplate sorting data is there any limitWe want to sort the data in alphabetical order for “Payment Process request status report”. This is the seeded report provided by oracle when PPR is ran. Seeded report i…SivaRamaKrishna-Oracle 14 views 1 comment 1 point Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Error when generating report, unsupported output format XLSXWe've received an error on one of our reports. Error message is the following: "Output failed. [INSTANCE_ID=bip.bi_serverHA] [OUTPUT_ID=158261] oracle.xdo.servlet.data.D…Francisco Carrillo-Robles 206 views 3 comments 0 points Most recent by Ajay Sharma Reporting and Analytics for ERP
-
accounting asset inquirySummary: Hello everyone, I am making a report from which I need to obtain the following value from the box in red. I can't find the table in which I can locate those val… -
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.6K 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 666 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 14 views 1 comment 1 point Most recent by Andreea Brem-Oracle General Ledger & Intercompany