Fusion Financial reporting
Discussion List
-
OTBI Reporting for Financials Cloud - Tips and TechniquesSummary Aimed at report builders, the white paper addresses frequently asked questions in OTBI reporting for the Financials Cloud. It also includes tips to enhance repor…Anand DN-Oracle 1.7K views 21 comments 13 points Most recent by Kathleen - MNG Reporting and Analytics for ERP -
Budgetary Control Carry Forward Sample BIP ReportsSummary Sample reports to identify transactions that impact budget account balances, and also facilitate the identification of transactions and balances that need to be …Anne Wong -Oracle 457 views 6 comments 7 points Most recent by Sarah Munro 12024679 Reporting and Analytics for ERP -
Is it possible to add a calculated SQL-based column in an OTBI Analysis?Summary Need to return a segment value name in a column from an OTBI analysis using a SQL QueryContent Hello, Our Financial users have created several OTBI reports based…Federico Samyn Dowie 63 views 8 comments 1 point Most recent by Federico Samyn Dowie Reporting and Analytics for ERP -
Custom ESS Parameter with TextBox and SearchSummary How can we have a Custom ESS Job with parameter as Textfield with Search option.Content One of the standard ESS Job has a parmeter which is a TextBox with a Sear…Balachander G-Oracle 18 views 2 comments 1 point Most recent by User_WZSBF Reporting and Analytics for ERP
-
FRS - Does RelativeMember Function work on Prompted AccountingPeriod?Summary FRS - Issue with period-to-period comparison on prompted valuesContent I am creating a Period-to-Period Financial comparison report, where Accounting Period need…
-
Is it possible to create a data source for ERP Cloud from Oracle Analytics Cloud (OAC)?Summary My company is moving to Oracle ERP Cloud, but end users want to still use OAC as the primary source for Reporting and AnalyticsContent My company is moving to Or…Federico Samyn Dowie 37 views 3 comments 1 point Most recent by Federico Samyn Dowie Reporting and Analytics for ERP
-
20c- BI Publisher Data Models No Longer Support Passing Dynamic SQL Parameters in Reference CursorsSummary 20c- BI Publisher Data Models No Longer Support Passing Dynamic SQL Parameters in Reference CursorsContent All, 20c- BI Publisher Data Models No Longer Support P…
-
Dynamic List of Values for ESS JobSummary Dynamic List of Values for ESS JobContent Hi, How to create a 'Dynamic List of Values for ESS Job' , I cant use the lookup and table type valueset is not working…Soumya Prakash Parhi 110 views 12 comments 3 points Most recent by RaviThejaDarbha Reporting and Analytics for ERP -
Generate SAFT Data Extract Norway is not populating with any dataSummary Generate SAFT Data Extract Norway is not populating with any dataContent The ESS job 'Generate SAFT Data Extract' is not populating with any data. Parameters scr…Matthew Pitkin 8 views 2 comments 0 points Most recent by Matthew Pitkin Reporting and Analytics for ERP -
Unable to open/view the xdmz format ( data model) and xdoz format ( report ) uploaded in Report CataSummary Unable to open/view the xdmz format ( data model) and xdoz format ( report ) uploaded in Report Catalog pageContent Hi Team, I'm new to reporting area and need s…RAJESH M-226898 17 views 3 comments 1 point Most recent by Abhishek Gupta1 Reporting and Analytics for ERP
-
Suggest Some Price List table in oracle fusionSummary Please suggest some price list table in oracle fusion and where can we find themContent Please suggest some price list table in oracle fusion and where can we fi…user12240811 10 views 2 comments 0 points Most recent by user12240811 Reporting and Analytics for ERP -
Report on selected bank accountSummary I need to report on the selected/default bank account where a colleague may have more than one in the systemContent Hello, I need to report on the selected/defau…Lauren Emberton 42 views 5 comments 1 point Most recent by Gopikrishna Nerella Reporting and Analytics for ERP
-
BIP Report to list all Custom ReportsSummary BIP Report to list all Custom Reports.Content Ho to fetch list of all custom reports from cloud instance (Oracle Cloud SaaS). I know how to fetch them from BIP A…
-
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… -
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… -
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 field
-
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 …Doron de Jong-57089 133 views 9 comments 1 point Most recent by Ed Higgins 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 24 views 1 comment 0 points Most recent by Vikas Tiwari Reporting and Analytics for ERP -
How to add account flex field as parameter for custom BIP reportSummary How to add account flex field as parameter for custom BIP reportContent Hi All - I have requirement to create custom BIP report which has to developed around GL …user12232237 45 views 6 comments 0 points Most recent by Sharad Jadhav 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 tableuser12240811 24 views 5 comments 0 points Most recent by user12240811 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 17 views 0 comments 0 points Started 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 39 views 9 comments 0 points Most recent by Senthilrajan V Reporting and Analytics for ERP -
Oracle Fusion BI Publisher Custom Physical SQL SecuritySummary Oracle Fusion BI Publisher Custom SQL - Security ConsiderationsContent Hi, When you create a Business Intelligence Publisher data model with physical SQL, you ha…Praveen Kumar-156819 48 views 4 comments 2 points Most recent by Matt Van Asten 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 clouduser12240811 10 views 1 comment 0 points Most recent by user12240811 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 37 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…
-
Missing Republish Button @ ESS Jobs to open outputSummary Missing Republish Button @ ESS Jobs to open outputContent * Should be able to view the output of Jobs run from SOA user as jobs are scheduled from SOA User.For a…Senthilrajan V 35 views 7 comments 1 point Most recent by Adam Gardner Reporting and Analytics for ERP
-
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 20 views 1 comment 0 points Most recent by Gergana Radoutcheva-Oracle Reporting and Analytics for ERP