Fusion Financial reporting
Discussion List
-
Table which captures the User-Defined Fiscal Classification CodesSummary I am looking for the back end table which captures the Manage Transaction-Based Fiscal Classifications Task DetailsContent Setup and Maintaince > Search Manage T…SandeepPaspunuri 195 views 1 comment 1 point Most recent by SandeepPaspunuri Reporting and Analytics for ERP -
Getting data from a Data Model to test it (Ad Hoc)Content After the direct SQL query was removed, I am now forced to create a report for my data model when I want to see the data in any other format than XML or more tha…MaartenDIF 60 views 6 comments 1 point Most recent by User_2025-02-06-06-17-13-684 Reporting and Analytics for ERP -
From which customer table can we find order_type fieldSummary From which customer table can we find order_type fieldContent Please suggest from which customer table can we find order_type fieldNageshwaran1 53 views 6 comments 0 points Most recent by Pradvin Prabhakar Reporting and Analytics for ERP -
ESS Administrator / Monitor / Operator rolesContent Hi I'm trying to find information on what exactly entails the roles: * ESS Administrator Role * ESS Monitor Role * ESS Operator Role Trying to give a user access… -
Report needed for default expense accountSummary Report needed for default expense accountContent Hi I am trying to get a report of all users on oracle and their default expense account on OTBI but cannot find …User_2025-01-29-02-09-34-137 163 views 9 comments 1 point Most recent by User_2025-02-05-23-22-15-856 Reporting and Analytics for ERP -
Can we create a multiple selection paramter in the custo ess job?Summary Can we create a multiple selection paramter in the custo ess job?Content Hello , We have create a one custom job for the BIP report and now the users are excepti…Koteswararao Yenikepalli 55 views 1 comment 0 points Most recent by Vikas Tiwari Reporting and Analytics for ERP -
How to get invoice_number against transaction in RA_CUSTOMER_TRX tableSummary How to get invoice_number against transaction in RA_CUSTOMER_TRX tableContent Please help us to get invoice_number against transaction in RA_CUSTOMER_TRX tableNageshwaran1 94 views 5 comments 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP
-
Display The Limited Values Only On LOV Through User POV SettingSummary User would like to control the values that can be selected in the user POV of Financial Reporting StudioContent User would like to display the limited values on …TOITO USER-Oracle 26 views 0 comments 0 points Most recent by TOITO USER-Oracle Reporting and Analytics for ERP -
Comprehensive Reporting Role in Fusion CloudSummary Role that has Access to all the Subject Areas/Dashboards/Reports. (Object Level as well as Data Level)Content Do we have a role other than BI Administrator that …Senthilrajan V 59 views 9 comments 0 points Most recent by Senthilrajan V Reporting and Analytics for ERP -
Need JAI_OM_OE_RMA_LINES table and its references in oracle fusion cloudSummary Need JAI_OM_OE_RMA_LINES table and its references in oracle fusion cloudContent Need JAI_OM_OE_RMA_LINES table and its references in oracle fusion cloudNageshwaran1 20 views 1 comment 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP
-
EBS to Fusion Migration - Impact on BI ReportingSummary Re-map EBS interfaces with FusionContent We have build DWH from Oracle EBS which has several reports on top of it. We are migrating to fusion and want to retain …Naeem Khan 48 views 3 comments 0 points Most recent by Sahil Makhiza Reporting and Analytics for ERP
-
Need to extract all OTBI/BI reports in custom folderSummary Can we use sql to extract OTBI/BI reports metadata?
-
How to idenitfy attached expense at line levelSummary Need to find query for attached expense at line levelContent Hi, I am trying to create a table which shows the expense line and it's attachment. Currently I have…
-
GL Journal Workflow notification template customizationSummary GL Journal Workflow notification template customizationContent In latest release oracle allows editing the workflow notification template. We are trying to custo…saravana maneeian subhramaniun 32 views 1 comment 0 points Most recent by Gergana Radoutcheva-Oracle Reporting and Analytics for ERP
-
Monthly Scheduled report did not runSummary Monthly Scheduled report did not runContent Hi Experts We have a monthly scheduled report scheduled in March and has run fine for first 3 months. The report has …Murthy Kodavati 27 views 3 comments 0 points Most recent by Sahil Makhiza Reporting and Analytics for ERP -
Subject Area - Payables Invoices - Transactions Real TimeSummary Not able to find taxes - Transaction Tax section under Subject Area - Payables Invoices - Transactions Real TimeContent Hi All i was building OTBI report for bus…User_2025-02-07-08-55-07-914 75 views 4 comments 0 points Most recent by User_2025-02-07-08-55-07-914 Reporting and Analytics for ERP
-
Column returning no value when combining Payables Invoices and Payment History subject areasContent Hi all, I have created a summary analysis for AP with a pivot table view that users can drill through to a detailed analysis and then drill down into the manage …
-
Page Entry For OTBI DashboardsSummary How to Create page Entry for OTBI DashboardsContent Hi There, We have a requirement where in we want to have the page entry created for our dashboards. We dont w…Sahil Makhiza 60 views 2 comments 1 point Most recent by Sahil Makhiza Reporting and Analytics for ERP
-
How can I either hide or remove columns easily in a data model?Summary data model bi publisher reportContent I have a data model that I have copied this over. I am trying to remove and/or hide some of the columns, and then move some…User_2025-02-08-08-55-02-564 150 views 8 comments 0 points Most recent by User_2025-02-08-08-55-02-564 Reporting and Analytics for ERP
-
Drill Down from the Master to Detail via Action Link using case formula columnSummary I am trying to drill from the Master report to the detail report, I am fetching the count of rejected invoices with respect to each statusContent Dear Friends, M…SandeepPaspunuri 52 views 3 comments 0 points Most recent by SandeepPaspunuri Reporting and Analytics for ERP
-
How to control the folder permissions in Reports and Analytics to user levelSummary Need to control users to access the folders within the permissions provided and controlled at the user level, Please provide the details how to control this fold…
-
Financial Reporting Studio Install not available in WorkspaceSummary Financial Reporting Studio Install not available in WorkspaceContent I am trying to download the installation for FRS following the instructions (Implementing En…Cathy Watson Moore 38 views 6 comments 0 points Most recent by Cathy Watson Moore Reporting and Analytics for ERP -
Show Declaration while running BI ReportSummary Show Declaration while running BI ReportContent Hello Experts Is there a place where we can show declaration before running/scheduling a report ?A checkbox will …Murthy Kodavati 35 views 4 comments 0 points Most recent by Murthy Kodavati Reporting and Analytics for ERP
-
Need SQL join to show bank assignment to supplier siteSummary We assign bank accounts to supplier sites, I need the table joins to allow me to create a data model to show which bank account is assigned to each supplier site…User_2025-02-04-14-03-09-386 289 views 2 comments 0 points Most recent by User_2025-02-04-14-03-09-386 Reporting and Analytics for ERP
-
what is the role of ar_receivable_applications_all.display columnContent ar_receivable_applications_all.Display = 'Y' or 'N' what will happen in each case. Can anyone explain? BR LuckyLucky Sharma 71 views 6 comments 1 point Most recent by Nishanth B Jain Reporting and Analytics for ERP -
Tables in which Printer name and details are savedSummary Tables in which Printer name and details are savedContent Whenever any Customer facing document/report is sent through a BIP report to the printers, is there any…
-
Need help getting drill to detailed analysis from pivot table to workContent I'm trying to create a dashboard which contains some prompts and a pivot table. When a value in the pivot table is clicked, I want the detailed report to open. T…
-
How to create custom XML output formatSummary How to create custom XML output formatContent Hi All, We have to generate a custom .xml output file from ERP cloud . How can we generate XML output file from BIP…Najeeb_ACN 266 views 5 comments 0 points Most recent by Sahil Makhiza Reporting and Analytics for ERP
-
How to call oracle functions from BI Data model ?Summary How to call oracle functions from BI Data model ?Content Hi, In EBS i used to build custom functions and i was using it in discoverer. i am looking for function …Shlomo Elnekave 171 views 3 comments 0 points Most recent by Sahil Makhiza Reporting and Analytics for ERP -
R13 Query Open AR InvoicesSummary AR Cloud ReportContent Hello : I was wondering if you can hep me about an AR Invoices Report for Cloud. Please Advise Below is the SQL but it only works for EBS …gabriel kinovisques-163562 499 views 7 comments 0 points Most recent by gabriel kinovisques-163562 Reporting and Analytics for ERP