Fusion Financial reporting
Discussion List
- 
             OTBI GL Subject Area : 'General Ledger - Journal Real Time'Summary OTBI GL Subject Area : 'General Ledger - Journal Real Time'Content We are developing Analysis reports relating to Cloud General Ledger in Oracle Transaction Busi…Swaroop Mitta 162 views 2 comments 1 point Most recent by Renuka Nuguru-Oracle Reporting and Analytics for ERP OTBI GL Subject Area : 'General Ledger - Journal Real Time'Summary OTBI GL Subject Area : 'General Ledger - Journal Real Time'Content We are developing Analysis reports relating to Cloud General Ledger in Oracle Transaction Busi…Swaroop Mitta 162 views 2 comments 1 point Most recent by Renuka Nuguru-Oracle Reporting and Analytics for ERP
- 
             How to restrict Data Model options to avoid users to access directly to the tables (SQL Query)?Summary Power users and contracts need to create data models based on BI Analysis, but this will also give them access to run SQL Queries. We want to restrict SQL Query … How to restrict Data Model options to avoid users to access directly to the tables (SQL Query)?Summary Power users and contracts need to create data models based on BI Analysis, but this will also give them access to run SQL Queries. We want to restrict SQL Query …
- 
             Segment Security in BI ReportSummary Restrict the BI report based on the user logged in and their Natural Account/Department.Content Folks, We have a requirement to restrict the BI report by Segment… Segment Security in BI ReportSummary Restrict the BI report based on the user logged in and their Natural Account/Department.Content Folks, We have a requirement to restrict the BI report by Segment…
- 
             Differences between running Reports Online vs Schedule/ESSSummary Can anyone list the differences in terms of restrictions of running Reports Online from BI Catalog vs Schedule / ESS DefinitionContent Hi Team, Our customer is a…Balachander G-Oracle 750 views 3 comments 0 points Most recent by User_2025-02-07-23-45-47-870 Reporting and Analytics for ERP Differences between running Reports Online vs Schedule/ESSSummary Can anyone list the differences in terms of restrictions of running Reports Online from BI Catalog vs Schedule / ESS DefinitionContent Hi Team, Our customer is a…Balachander G-Oracle 750 views 3 comments 0 points Most recent by User_2025-02-07-23-45-47-870 Reporting and Analytics for ERP
- 
             FRS General Ledger Financial ReportingSummary Combing Accounts and or Parents in FRS ReportContent Hello - does anyone know why we can't combine multiple accounts or multiple parents into one line on an FRS …User_2025-02-10-13-18-41-347 79 views 1 comment 0 points Most recent by CLAZAR-Oracle Reporting and Analytics for ERP FRS General Ledger Financial ReportingSummary Combing Accounts and or Parents in FRS ReportContent Hello - does anyone know why we can't combine multiple accounts or multiple parents into one line on an FRS …User_2025-02-10-13-18-41-347 79 views 1 comment 0 points Most recent by CLAZAR-Oracle Reporting and Analytics for ERP
- 
             GL reports on multiple ledgersContent Our client has close to 40 million journal lines across ledgers for a single period. They want a BIP report where they will only pass the ledger set and choose a…saravana maneeian subhramaniun 97 views 2 comments 0 points Most recent by CLAZAR-Oracle Reporting and Analytics for ERP GL reports on multiple ledgersContent Our client has close to 40 million journal lines across ledgers for a single period. They want a BIP report where they will only pass the ledger set and choose a…saravana maneeian subhramaniun 97 views 2 comments 0 points Most recent by CLAZAR-Oracle Reporting and Analytics for ERP
- 
             FRS Reporting Query - Current yearSummary FRS Reporting Query - Current YearContent Hi team, In FRS Report, If the current open period is Jun 20 and the report is run for year 2020, it does not give any …Vinod Kumar Mohanraj 61 views 1 comment 0 points Most recent by CLAZAR-Oracle Reporting and Analytics for ERP FRS Reporting Query - Current yearSummary FRS Reporting Query - Current YearContent Hi team, In FRS Report, If the current open period is Jun 20 and the report is run for year 2020, it does not give any …Vinod Kumar Mohanraj 61 views 1 comment 0 points Most recent by CLAZAR-Oracle Reporting and Analytics for ERP
- 
             FRS Report, calculation does not equal report TotalSummary A calculated value of four columns is off by less than $1 from the Report Total of those same four columnsContent Company 1 Company 2 Company 3 Company 4 Sum Rep…Dave Pucetas 29 views 1 comment 1 point Most recent by CLAZAR-Oracle Reporting and Analytics for ERP FRS Report, calculation does not equal report TotalSummary A calculated value of four columns is off by less than $1 from the Report Total of those same four columnsContent Company 1 Company 2 Company 3 Company 4 Sum Rep…Dave Pucetas 29 views 1 comment 1 point Most recent by CLAZAR-Oracle Reporting and Analytics for ERP
- 
             Smartview - reversing the signs so revenue presents as positiveSummary Wanting to pull in revenue as a positive valueContent We are new to Oracle and Smartview, and are learning how to use the tool. We have not determined how to bri…User_2025-02-11-03-09-13-126 62 views 1 comment 1 point Most recent by CLAZAR-Oracle Reporting and Analytics for ERP Smartview - reversing the signs so revenue presents as positiveSummary Wanting to pull in revenue as a positive valueContent We are new to Oracle and Smartview, and are learning how to use the tool. We have not determined how to bri…User_2025-02-11-03-09-13-126 62 views 1 comment 1 point Most recent by CLAZAR-Oracle Reporting and Analytics for ERP
- 
             R13 Risk Management OTBI subject area to database lineage mapping spreadsheetSummary This spreadsheet documents R13 Risk Management OTBI subject area to database lineage mapping and subject area security. Content This spreadsheet is published by …Noelle Bartlam-Oracle 688 views 8 comments 4 points Most recent by Feras Ahmad Reporting and Analytics for ERP R13 Risk Management OTBI subject area to database lineage mapping spreadsheetSummary This spreadsheet documents R13 Risk Management OTBI subject area to database lineage mapping and subject area security. Content This spreadsheet is published by …Noelle Bartlam-Oracle 688 views 8 comments 4 points Most recent by Feras Ahmad Reporting and Analytics for ERP
- 
             Custom OTBI content that we did not createSummary Why is there report objects under custom folder after install of OTBI that we did not createContent After our new POD was brought up I went into OTBI and I'm fin… Custom OTBI content that we did not createSummary Why is there report objects under custom folder after install of OTBI that we did not createContent After our new POD was brought up I went into OTBI and I'm fin…
- 
             Limit number of lines per pageSummary I have an invoice where I want to limit the number of lines that appears per pageContent Is there an IF statement that could limit the number of lines that appea…Mohammad Alhindawi 53 views 3 comments 0 points Most recent by RichardChan Reporting and Analytics for ERP Limit number of lines per pageSummary I have an invoice where I want to limit the number of lines that appears per pageContent Is there an IF statement that could limit the number of lines that appea…Mohammad Alhindawi 53 views 3 comments 0 points Most recent by RichardChan Reporting and Analytics for ERP
- 
             Analysis is missing the promptsSummary Missing prompt on Expense ReportContent We have a report called 'Expense Type Report' It was created with the 'Analysis' tool. This report has prompts when you g…Jennifer Wolfe 35 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP Analysis is missing the promptsSummary Missing prompt on Expense ReportContent We have a report called 'Expense Type Report' It was created with the 'Analysis' tool. This report has prompts when you g…Jennifer Wolfe 35 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
- 
             How to capture page overflow in rtf template - BI PublisherSummary I need to display the sum of a particular field for all the Invoices in the current page only even if the Invoices overflow to the next pageContent Hello, I have…Nalinee Uppiah 30 views 1 comment 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP How to capture page overflow in rtf template - BI PublisherSummary I need to display the sum of a particular field for all the Invoices in the current page only even if the Invoices overflow to the next pageContent Hello, I have…Nalinee Uppiah 30 views 1 comment 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP
- 
             How to fetch invoice_no and invoice_date from wsh_ tablesSummary Need to fetch invoice_no and invoice_date from wsh_ tablesContent Need to fetch invoice_no and invoice_date from wsh_ tables or from doo_ tablesNageshwaran1 24 views 3 comments 1 point Most recent by Nageshwaran1 Reporting and Analytics for ERP How to fetch invoice_no and invoice_date from wsh_ tablesSummary Need to fetch invoice_no and invoice_date from wsh_ tablesContent Need to fetch invoice_no and invoice_date from wsh_ tables or from doo_ tablesNageshwaran1 24 views 3 comments 1 point Most recent by Nageshwaran1 Reporting and Analytics for ERP
- 
             Is it possible to Hide columns in List of Values used in a PVO ?Summary Is it possible to Hide columns in List of Values used in a PVO ?Content We have defined a number of custom Reports and ESS Definitions. We try to use the standar…Balachander G-Oracle 27 views 0 comments 0 points Most recent by Balachander G-Oracle Reporting and Analytics for ERP Is it possible to Hide columns in List of Values used in a PVO ?Summary Is it possible to Hide columns in List of Values used in a PVO ?Content We have defined a number of custom Reports and ESS Definitions. We try to use the standar…Balachander G-Oracle 27 views 0 comments 0 points Most recent by Balachander G-Oracle Reporting and Analytics for ERP
- 
             Cross posting this idea in ERP Reporting and Analytics forum - ability to Audit OTBI report configurSummary Cross posting this idea - ability to Audit OTBI report configurationsContent Here is an Idea posted in Financials - General that I thought would be of interest t…Jeff Hare CPA CISA CIA 31 views 0 comments 0 points Most recent by Jeff Hare CPA CISA CIA Reporting and Analytics for ERP Cross posting this idea in ERP Reporting and Analytics forum - ability to Audit OTBI report configurSummary Cross posting this idea - ability to Audit OTBI report configurationsContent Here is an Idea posted in Financials - General that I thought would be of interest t…Jeff Hare CPA CISA CIA 31 views 0 comments 0 points Most recent by Jeff Hare CPA CISA CIA Reporting and Analytics for ERP
- 
             Cash bases accouting reportsSummary Cash bases accouting reportsContent Hi - Any one come across reports requirement on cases bases?if yes, how you Achieved? pls suggest..Sandeep Kumar-245021 26 views 1 comment 0 points Most recent by SandeepPaspunuri Reporting and Analytics for ERP Cash bases accouting reportsSummary Cash bases accouting reportsContent Hi - Any one come across reports requirement on cases bases?if yes, how you Achieved? pls suggest..Sandeep Kumar-245021 26 views 1 comment 0 points Most recent by SandeepPaspunuri Reporting and Analytics for ERP
- 
             AR Account Profile ClassSummary Linking 2 AR Subject Areas.Content The AR Account Profile Class is not available in the 'Receivables - Payment Schedules Real Time' subject area (19C) and it is … AR Account Profile ClassSummary Linking 2 AR Subject Areas.Content The AR Account Profile Class is not available in the 'Receivables - Payment Schedules Real Time' subject area (19C) and it is …
- 
             Basic General Ledger Transaction Report - Filtered By AccountSummary Does anyone have a robust Basic General Ledger Transaction Report - Filtered By Account that they could shareContent We are due to go live with Oracle Fusion (SA…User_2025-02-11-02-45-23-645 63 views 5 comments 0 points Most recent by User_2025-02-07-23-45-47-870 Reporting and Analytics for ERP Basic General Ledger Transaction Report - Filtered By AccountSummary Does anyone have a robust Basic General Ledger Transaction Report - Filtered By Account that they could shareContent We are due to go live with Oracle Fusion (SA…User_2025-02-11-02-45-23-645 63 views 5 comments 0 points Most recent by User_2025-02-07-23-45-47-870 Reporting and Analytics for ERP
- 
             Join between wsh_deliveries and rcv_shipmentsSummary Join between wsh_deliveries and rcv_shipments to fetch shipment_num, invoice no & dateContent Join between wsh_deliveries and rcv_shipments tables to fetch shipm…Nageshwaran1 115 views 4 comments 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP Join between wsh_deliveries and rcv_shipmentsSummary Join between wsh_deliveries and rcv_shipments to fetch shipment_num, invoice no & dateContent Join between wsh_deliveries and rcv_shipments tables to fetch shipm…Nageshwaran1 115 views 4 comments 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP
- 
             BIP Report to get the Payment pending for ApprovalSummary BIP Report to get the Payment pending for user ApprovalContent Hi All, We have enabled a Workflow approval for Payments in ERP Cloud. We have a created a Specifi…Uvaraja-Oracle 111 views 4 comments 2 points Most recent by User_2025-02-06-05-37-11-922 Reporting and Analytics for ERP BIP Report to get the Payment pending for ApprovalSummary BIP Report to get the Payment pending for user ApprovalContent Hi All, We have enabled a Workflow approval for Payments in ERP Cloud. We have a created a Specifi…Uvaraja-Oracle 111 views 4 comments 2 points Most recent by User_2025-02-06-05-37-11-922 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… 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…
- 
             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 62 views 2 comments 1 point Most recent by EdWho 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 62 views 2 comments 1 point Most recent by EdWho Reporting and Analytics for ERP
- 
             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… 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…
- 
             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…Amarnath 304 views 6 comments 0 points Most recent by User_2025-02-05-17-23-19-130 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…Amarnath 304 views 6 comments 0 points Most recent by User_2025-02-05-17-23-19-130 Reporting and Analytics for ERP
- 
             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 141 views 12 comments 3 points Most recent by RaviThejaDarbha Reporting and Analytics for ERP 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 141 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…User_2025-02-05-22-11-22-331 59 views 2 comments 0 points Most recent by User_2025-02-05-22-11-22-331 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…User_2025-02-05-22-11-22-331 59 views 2 comments 0 points Most recent by User_2025-02-05-22-11-22-331 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…User_2025-02-10-05-51-05-868 47 views 3 comments 1 point Most recent by User_2025-01-30-00-54-17-530 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…User_2025-02-10-05-51-05-868 47 views 3 comments 1 point Most recent by User_2025-01-30-00-54-17-530 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…User_2025-01-28-05-32-59-092 52 views 5 comments 1 point Most recent by Gopikrishna Nerella 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…User_2025-01-28-05-32-59-092 52 views 5 comments 1 point Most recent by Gopikrishna Nerella Reporting and Analytics for ERP