Fusion Financial reporting
Discussion List
-
Query for Approval DelegationContent Hello, I am looking to build a BIP Report which displays whenever someone has delegated approvals to someone of a lower job level - does anyone know where this i…Elliot Hall-Walker 309 views 3 comments 1 point Most recent by Gopi Krishna Pokuru Reporting and Analytics for ERP
-
QUERY TO GET ESS JOB AND SCHEDULE JOB HISTORYSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Mohan Gawade 57 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Can you share Expense Reports OTBI including Approver information ?Summary: Can you share Expense Reports OTBI including Approver information ? Thank you Content (please ensure you mask any confidential information): Version (include th…
-
User and Report Access ReportBusiness is requesting a report that have the following columns details: User username Report Name Period Inventory Valuation Report Source Of Report Scheduled Process o…
-
How restrict custom BI report data based on flexfield segment valueSummary: How restrict custom BI report data based on flexfield segment value Content (please ensure you mask any confidential information): Hi All, We want to restrict c…
-
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 11 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 11 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 21 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 11 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 61 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 21 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 11 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 204 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 11 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 671 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 11 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 11 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 11 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 1 view 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 23 views 5 comments 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP