Category 129
Discussion List
-
Display and ability to change parameter values in OTBI reportSummary: In BI Publisher report, report parameters are displayed and user can change the parameter values and run the report all on the same screen. Can the same be done…NMM 42 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for ERP -
Accounting year in parameter displaying decimal valuesSummary: One of the parameters in an OTBI report is Accounting year but when I want to select a year, it displays the years with decimals Content (required): Defined a O…
-
Is possible to create a report wit the purchase orders that no have any attachment?Summary: I want to know if is possible to create a report wit the purchase orders that no have any attachment. Content (required): I found that the documents of the purc…Jessica Yamilet Valdes Romero 42 views 2 comments 0 points Most recent by Jessica Yamilet Valdes Romero Reporting and Analytics for ERP
-
Pass Column as a Presentation VariableSummary: Using presentation variable, compare one column against another in Conditional Format Content (required): Hi All, Does anyone know how to go about creating a pr…
-
Backend Table for failed bursting casesSummary: Content (required): Is there a backend table or report we can use to show which all bursting emails were failed to sent to the supplier/customers? When we run "…Vinay Gharge 32 views 4 comments 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
File Error Data may have been lostin OTBI - BI Publisher report that has multiple tabs is showing this error on opening the excel file. File error : data may have been lost Users are able to provide a sp…Dhruvjoshi23 75 views 2 comments 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
Which PVO's have location level details (e.g., names, codes, address information)Summary: Which pvo should be used to join to in order to get the location information for the deliver_to_location_id for each purchase order distribution line? Content (…User_2025-03-07-18-57-57-349 78 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for ERP
-
What is the current(22B) licensing/role description for OTBI reporting? ERPSelf-service vs. ERP Fin?Summary: Use Case 1 Store managers want to drill down on a report to view additional details in the report. View/Read=ERP Self-Service Use Case 2 Store Manager wants to …Mechelle Stone-Oracle 22 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP -
What table stores the system transactions reference number for Bank Statement (CE) reconciled itemsSummary: We are attempting to replicate the Cash Management Bank Statements>Manual Reconciliation page>Reconciled tab in a custom OTBI Report. For system transactions li… -
schedule an analysis to run for sysdate and send email only if there is dataSummary: Content (required): Hi, I have created a very simple analysis - Project name, Project number, Project start date and project completion date and created by and …
-
Query or the table that contains financial catogory for manage value UISummary: Hello all, We have a report in which we need to pick the financial category code we put against an account in manage value UI.please advise! BR, Sushan Peiris C…Sushan Peiris 262 views 13 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
Unauthorized Access: Either you do not have the privilege, or you have not signed inAfter latest upgrade from Oracle fusion to version 22A and 22B - OTBI users are experiencing this error - intermittently. Everytime they refresh it connects back - but i…Dhruvjoshi23 139 views 5 comments 2 points Most recent by User_CUA6U Reporting and Analytics for ERP
-
EPM OOTB report listSummary: Report list Content (required): Hi, Is there a consolidated list available that provides EPM OOTB reports like other areas in a speadsheet? Thanks Version (incl…
-
Best practice to re-use same query in the same BIP data modelSummary: I have a common query say for selecting business unit based on certain user based login. Now I have a main data model query with multiple sub-queries in it. And…Ashu Raj-Oracle 31 views 1 comment 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
Strange SQL results, can't explain causeHi, I am comparing the use of SQL via Analytics between instances used by 2 different customers, both on version 22A. Example URL: example.fa.ocs.oraclecloud.com/analyti…
-
Audit trial for Financial Reports (FRC)Do we have audit trial for financial Reports ? lets say if we want to see that who run which FRC report and whenSandeep Nihalani 11 views 3 comments 1 point Most recent by Sandeep Nihalani Reporting and Analytics for ERP
-
Is there any way to get the sub category for module identify column in HRC_TXN_HEADER tableWe could see lot of transactions for Manage Employment (Under Module Identify field --> Table HRC_TXN_HEADER). We are trying to segregate the transactions. We are trying…Kiran Kollamsetti 12 views 0 comments 0 points Started by Kiran Kollamsetti Reporting and Analytics for ERP
-
How to download OTBI and BIP reports before the refresh of the instance ?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):DJ Kumar 41 views 4 comments 0 points Most recent by Deshin Pillay-Oracle Reporting and Analytics for ERP
-
Invoice Count by Supplier From Prior MonthSummary: COUNT function to display number of invoices by submitted from supplier in prior month using Dynamic Date scheduling Content (required): Hi All, Using the COUNT…Rory Mullin 95 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Where can I find prebuilt report and analysis list and pdf samples?Summary: Location of prebuilt report and analysis list and pdf samples on docs.oracle.com Content (required): The links do not work at https://docs.oracle.com/en/cloud/s…Rona Jeongco 76 views 2 comments 0 points Most recent by Rona Jeongco Reporting and Analytics for ERP
-
OTBI : Facing Java:Null issue in Dashboard PropertiesSummary: OTBI : Facing Java: Null issue in Dashboard Properties. As shown in the SS below. Is it because of 22A Upgrade? Content (required): Version (include the version…Shashank Verma-Oracle 31 views 4 comments 0 points Most recent by Shashank Verma-Oracle Reporting and Analytics for ERP -
Procurement Dashboard is not showing the correct informationSummary: My Procurement dashboard is not showing the correct information against the PR. The PR has been converted into the PO and system is showing it but Dashboard is …
-
BIP report Excel output is formatting large numbers as General/scientificSummary: We created a BIP report for Fixed Assets. Any numerical values in the tens of millions or higher export to Excel as scientific. For example, an asset Cost of 42…Brad Kirschner 692 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Manage Audit Policies enabled but output shows 'There are no records to display'Summary: We have enabled 'Manage Audit Policies' for Payables >Invoices (attributes also SELECTED and added) last week. 1) However when we run the "Generate Audit Report…Joel Dsilva 523 views 3 comments 1 point Most recent by Donna Curtis Reporting and Analytics for ERP
-
Read a file from UCM via Web Service as Private Data SourceSummary: Read File from UCM Web Service BI Publisher Content (required): We need to be able to read a file from UCM utilizing a data model in BI Publisher. We were able …
-
Cloud ERP Reporting: 10k / 10QSummary: Has anyone used any of the ERP Cloud Reporting tools to create their 10K /10Q's? Content (required): Version (include the version you are using, if applicable):…Susiemae Palmer-Oracle 32 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Can you change the font or color of a Dashboard tab?Summary: Can you change the font or color of a Dashboard tab? Content (required): Can you change the font or color of a Dashboard tab? Version (include the version you a… -
How can I create a BI Analysis that considers the credit limit of a customer at Party levelSummary: I need to create an analysis that considers the credit limit of a customer at Party level, all the subject areas that I found that have the credit limit are at …
-
Fixed Asset Balances - Real Time subject area is not updatingSummary: Content (required): We have developed a report using the Fixed Asset Extract Balances table and the recent transactions re not updated in the table. The "Extrac…Dian Minshan 148 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for ERP -
GL Trial Balance Report Custom TemplateSummary:We've created custom template for TrialBalalnce.xdo, But still ESS job is taking standard template.Is there are changes required in configuration to pick custom …