Reports
Discussion List
- 
             Schedule BIP in fusion in 1st 10 days of EVERY monthSummary: Content (required): Is there a way we can schedule a custom bi publisher report in fusion for the first 10 days of every month? Version (include the version you…Vinay Gharge 31 views 2 comments 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for ERP Schedule BIP in fusion in 1st 10 days of EVERY monthSummary: Content (required): Is there a way we can schedule a custom bi publisher report in fusion for the first 10 days of every month? Version (include the version you…Vinay Gharge 31 views 2 comments 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for ERP
- 
             Schedule BIP in fusion in 1st 10 days of EVERY monthSummary: Content (required): Is there a way we can schedule a custom bi publisher report in fusion for the first 10 days of every month? Version (include the version you…Vinay Gharge 11 views 2 comments 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for ERP Schedule BIP in fusion in 1st 10 days of EVERY monthSummary: Content (required): Is there a way we can schedule a custom bi publisher report in fusion for the first 10 days of every month? Version (include the version you…Vinay Gharge 11 views 2 comments 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for ERP
- 
             Table which holds notification modeSummary: We need table name which holds notification mode Content (required): table to print notification mode Version (include the version you are using, if applicable)…Nishanth B Jain 31 views 3 comments 0 points Most recent by Nishanth B Jain Reporting and Analytics for ERP Table which holds notification modeSummary: We need table name which holds notification mode Content (required): table to print notification mode Version (include the version you are using, if applicable)…Nishanth B Jain 31 views 3 comments 0 points Most recent by Nishanth B Jain Reporting and Analytics for ERP
- 
             No data in balances when using Natural Account SegmentSummary: When working with Subject Area General Ledger - Balances Real Time I cannot see any data in balances: Beginning Balance, Period Net Activity and Ending Balance …JJ_DTU 11 views 2 comments 0 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP No data in balances when using Natural Account SegmentSummary: When working with Subject Area General Ledger - Balances Real Time I cannot see any data in balances: Beginning Balance, Period Net Activity and Ending Balance …JJ_DTU 11 views 2 comments 0 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP
- 
            Manager Proficiency result for Competency Assessment ReportSummary i cant find the competency assessment column that shows assessment resultContent I wanted to compare target competency assessment and manager competency assessme…Michael Nega Gebrehawariyat 24 views 1 comment 0 points Most recent by User_2025-02-10-15-51-50-906 Reporting and Analytics for ERP
- 
             Newly created Financial Categories do not show in BI report list of valuesContent I'm looking to pull in 3 new Financial Categories into a BI report I created. I've created the lookup codes under GL and attached the categories to the account s…User_2025-02-05-22-11-22-331 139 views 16 comments 1 point Most recent by Sourabh Choudhury Reporting and Analytics for ERP Newly created Financial Categories do not show in BI report list of valuesContent I'm looking to pull in 3 new Financial Categories into a BI report I created. I've created the lookup codes under GL and attached the categories to the account s…User_2025-02-05-22-11-22-331 139 views 16 comments 1 point Most recent by Sourabh Choudhury Reporting and Analytics for ERP
- 
             OTBI Cost Centre lists all parent valuesSummary Cost Centre in OTBI returns all parent values as well as the lowest levelContent Hi all, Hoping someone could point me in the right direction. I am attempting to…StuartHibbert 220 views 2 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for ERP OTBI Cost Centre lists all parent valuesSummary Cost Centre in OTBI returns all parent values as well as the lowest levelContent Hi all, Hoping someone could point me in the right direction. I am attempting to…StuartHibbert 220 views 2 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for ERP
- 
             Analytic needs to work with Prompt in DashboardSummary Analytic needs to work with Prompt in DashboardContent Hi, I have a Dashboard include one analytic and one prompt. When i open the dashboard, analytic is searchi…User_2025-02-05-02-38-04-251 45 views 4 comments 2 points Most recent by A.JOSH Reporting and Analytics for ERP Analytic needs to work with Prompt in DashboardSummary Analytic needs to work with Prompt in DashboardContent Hi, I have a Dashboard include one analytic and one prompt. When i open the dashboard, analytic is searchi…User_2025-02-05-02-38-04-251 45 views 4 comments 2 points Most recent by A.JOSH Reporting and Analytics for ERP
- 
             SQL for Period Close Exceptions ReportSummary: SQL that generates reports Content (required): Hello, I am new as report guy at my company, and I would need to extract the SQL that generates this report 'Peri… SQL for Period Close Exceptions ReportSummary: SQL that generates reports Content (required): Hello, I am new as report guy at my company, and I would need to extract the SQL that generates this report 'Peri…
- 
             All assets that have been created in projects but have not been capitalized yetSummary All assets that have been created in projects but have not been capitalized yetContent I need to create a report in Project Costing - Assets Real Time subject ar…Andrew_Schmitz 24 views 3 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for ERP All assets that have been created in projects but have not been capitalized yetSummary All assets that have been created in projects but have not been capitalized yetContent I need to create a report in Project Costing - Assets Real Time subject ar…Andrew_Schmitz 24 views 3 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for ERP
- 
             Error Receive when View ReportSummary: Error Receive when View Report Content (required): User receive the error message below when generating dashboard Version (include the version you are using, if…CraigX 11 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP Error Receive when View ReportSummary: Error Receive when View Report Content (required): User receive the error message below when generating dashboard Version (include the version you are using, if…CraigX 11 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
- 
             How to check/download the BI report output submitted by usersSummary: Content (required): This is from Support User perspective. If a user opens a report from BI Catalog, runs it, and downloads the output, then how can we check/do…Vinay Gharge 23 views 2 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP How to check/download the BI report output submitted by usersSummary: Content (required): This is from Support User perspective. If a user opens a report from BI Catalog, runs it, and downloads the output, then how can we check/do…Vinay Gharge 23 views 2 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
- 
             Expense Report - all expenses by cost centerSummary: Content (required): We have an analysis created using Expense - Expense Transactions Real Time. When a user runs the report, they get their own expenses. When a… Expense Report - all expenses by cost centerSummary: Content (required): We have an analysis created using Expense - Expense Transactions Real Time. When a user runs the report, they get their own expenses. When a…
- 
             Can BI Deep Link use variable to represent the servername in the URLSummary: Deep Links present an issue during P2T environment copy downs because after each refresh all Deep Links embedded in BI report definitions have to be modified, i… Can BI Deep Link use variable to represent the servername in the URLSummary: Deep Links present an issue during P2T environment copy downs because after each refresh all Deep Links embedded in BI report definitions have to be modified, i…
- 
             Invoice Not reflecting in OTBISummary: Invoice Not reflecting in OTBI Content (required): Invoices created are not reflecting in OTBI Payables Transaction Real Time. Is there a time limit that the in…CraigX 132 views 1 comment 0 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP Invoice Not reflecting in OTBISummary: Invoice Not reflecting in OTBI Content (required): Invoices created are not reflecting in OTBI Payables Transaction Real Time. Is there a time limit that the in…CraigX 132 views 1 comment 0 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP
- 
             Unable to find PVOs in BICCContent Hello, We need PVOs of following tables in BICC but we couldn't find these in Lineage Sheet. If anyone has any idea on how to get those or any workaround would r… Unable to find PVOs in BICCContent Hello, We need PVOs of following tables in BICC but we couldn't find these in Lineage Sheet. If anyone has any idea on how to get those or any workaround would r…
- 
             Queries behind ADF pagesSummary: Is there a way to inspect queries behind the ADF pages in Fusion ? Content (required): Is it possible to get access to the queries/view objects behind a Fusion … Queries behind ADF pagesSummary: Is there a way to inspect queries behind the ADF pages in Fusion ? Content (required): Is it possible to get access to the queries/view objects behind a Fusion …
- 
             BI Publisher RTF Template AR Invoice : Grouping rowsContent I am required to create an AR Invoice report, where services are needed to be grouped based on what kind of service they are within a report. To be more clear, f… BI Publisher RTF Template AR Invoice : Grouping rowsContent I am required to create an AR Invoice report, where services are needed to be grouped based on what kind of service they are within a report. To be more clear, f…
- 
             Unable to open parameters page for any of the BI reportsSummary: Unable to open the parameters page for any of the BI report. When I click on any of the BI reports, I get a blank page that is visible. Not able to access any o…Divya K S-Oracle 11 views 11 comments 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP Unable to open parameters page for any of the BI reportsSummary: Unable to open the parameters page for any of the BI report. When I click on any of the BI reports, I get a blank page that is visible. Not able to access any o…Divya K S-Oracle 11 views 11 comments 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
- 
             How to add Project ID to OOB report?Summary: Add a column to OOB report "General Ledger and Subledger Accounting by Journal Lines" for Project ID Content (required): I really like the OOB report General Le… How to add Project ID to OOB report?Summary: Add a column to OOB report "General Ledger and Subledger Accounting by Journal Lines" for Project ID Content (required): I really like the OOB report General Le…
- 
             Dynamic Pivot column in BI PublisherSummary Need the column of a pivot table to be dynamic in BI PublisherContent We have a requirement to display GL balances by BU hierachy and period. As the users can ru…saravana maneeian subhramaniun 65 views 1 comment 2 points Most recent by User_7836 Reporting and Analytics for ERP Dynamic Pivot column in BI PublisherSummary Need the column of a pivot table to be dynamic in BI PublisherContent We have a requirement to display GL balances by BU hierachy and period. As the users can ru…saravana maneeian subhramaniun 65 views 1 comment 2 points Most recent by User_7836 Reporting and Analytics for ERP
- 
             Reporting on Transaction Incidents per User?Summary: We would need to be able to report on transactions done by certain users (aggregation of all incidents/controls where the selected user has done possibly fraudu…Ann Van Roosbroeck 21 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP Reporting on Transaction Incidents per User?Summary: We would need to be able to report on transactions done by certain users (aggregation of all incidents/controls where the selected user has done possibly fraudu…Ann Van Roosbroeck 21 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
- 
             Oracle Cloud Planning Dashboard 2.0 - Waterfall chart and loading timeContent Hi everyone I am trying to build a dashboard by using Dashboard 2.0 function and having an issue here, wondering whether you have had same issue and how to solve… Oracle Cloud Planning Dashboard 2.0 - Waterfall chart and loading timeContent Hi everyone I am trying to build a dashboard by using Dashboard 2.0 function and having an issue here, wondering whether you have had same issue and how to solve…
- 
             Best Practices to load high volume dataSummary Best Practices to load high volume dataContent Hello All,We are working on a project in which we may get high volume data to be loaded through FBDI. Based on you…Lucky Sharma 53 views 3 comments 3 points Most recent by Lucky Sharma Reporting and Analytics for ERP Best Practices to load high volume dataSummary Best Practices to load high volume dataContent Hello All,We are working on a project in which we may get high volume data to be loaded through FBDI. Based on you…Lucky Sharma 53 views 3 comments 3 points Most recent by Lucky Sharma Reporting and Analytics for ERP
- 
             Report Using Procure to Pay Subject AreaSummary A new subject area called “Procure to Pay Real Time” has been added to Procurement’s Oracle Transactional Business Intelligence or OTBI. You can use this subject…Manavalan Ethirajan 975 views 13 comments 14 points Most recent by Surajit Roy-Oracle Reporting and Analytics for ERP Report Using Procure to Pay Subject AreaSummary A new subject area called “Procure to Pay Real Time” has been added to Procurement’s Oracle Transactional Business Intelligence or OTBI. You can use this subject…Manavalan Ethirajan 975 views 13 comments 14 points Most recent by Surajit Roy-Oracle Reporting and Analytics for ERP
- 
             Procurement - Pending Change Orders Subject area does not correctly reportSummary The Change Order Creation Date is actually the PO Creation DateContent Has anyone else noticed that the "Change Order Creation Date" - a vital field in this subj… Procurement - Pending Change Orders Subject area does not correctly reportSummary The Change Order Creation Date is actually the PO Creation DateContent Has anyone else noticed that the "Change Order Creation Date" - a vital field in this subj…
- 
             Oracle Fusion Financials - custom version of standard BI Publisher reportSummary Oracle Fusion Financials - custom version of standard BI Publisher reportContent I am following this guide; - https://docs.oracle.com/en/cloud/saas/financials/21…User_2025-02-10-15-12-48-631 38 views 6 comments 2 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP Oracle Fusion Financials - custom version of standard BI Publisher reportSummary Oracle Fusion Financials - custom version of standard BI Publisher reportContent I am following this guide; - https://docs.oracle.com/en/cloud/saas/financials/21…User_2025-02-10-15-12-48-631 38 views 6 comments 2 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
- 
             'Create' Icon is missing from 'Manage Enterprise Scheduler Job Definitions and Job Sets for Human CaSummary 'Create' Icon is missing from 'Manage Enterprise Scheduler Job Definitions and Job Sets for Human Capital Management and Related Applications'taskContent Hi Team…Rohit Kumar Singh 31 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP 'Create' Icon is missing from 'Manage Enterprise Scheduler Job Definitions and Job Sets for Human CaSummary 'Create' Icon is missing from 'Manage Enterprise Scheduler Job Definitions and Job Sets for Human Capital Management and Related Applications'taskContent Hi Team…Rohit Kumar Singh 31 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
- 
             Unable to search Custom reports using Schedule New ProcessSummary Unable to search Custom reports using Schedule New Process. Reports are not coming in Search resultsContent Hi Team, Reports are not coming in Search results whe…Rohit Kumar Singh 46 views 3 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP Unable to search Custom reports using Schedule New ProcessSummary Unable to search Custom reports using Schedule New Process. Reports are not coming in Search resultsContent Hi Team, Reports are not coming in Search results whe…Rohit Kumar Singh 46 views 3 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
- 
             How to Handle Null or Not Present tags in xml file in BI Publisher?Content Hi all, I have an issue where I'm stuck at making an XML condition for a check print. I used this SQL query for the same condition, and now I want it to be imple…Sushan Peiris 1.1K views 4 comments 3 points Most recent by Sushan Peiris Reporting and Analytics for ERP How to Handle Null or Not Present tags in xml file in BI Publisher?Content Hi all, I have an issue where I'm stuck at making an XML condition for a check print. I used this SQL query for the same condition, and now I want it to be imple…Sushan Peiris 1.1K views 4 comments 3 points Most recent by Sushan Peiris Reporting and Analytics for ERP