Category 129
Discussion List
-
ESS Job Report Output File NameSummary: Content (required): We used Bursting to set the file name of the report. It is displayed correctly on the ESS Job screen but when we click on the file to downlo…Vinay Gharge 536 views 1 comment 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
Calling BICC Rest API Service in ODISummary: Calling BICC Rest API Service in ODI 12c Content (required): Need help to know the step by step configuration for calling BICC Rest API services from ODI . How …Mandar -Oracle 574 views 0 comments 2 points Started by Mandar -Oracle Reporting and Analytics for ERP
-
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… -
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…
-
BI Template Sum Function Not Working ProperlySummary: The Sum function in the BI template not working as expected. Content (required): We have a custom report where we used the sum function on specific field but it…Ahmed Maher Kadeh 61 views 3 comments 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
Performance Issue caused after 22B upgrade for CF Activity ReportSummary: Hi Team, We have performance issue in our report after 22B update. Regards Nidhi... Content (required): Version (include the version you are using, if applicabl…Nidhi Chhajed 21 views 1 comment 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
Is there a REST API to get the submission and completion time details of an ESS Job ?Summary: Is there a REST API to get the submission and completion time details of an ESS Job ? Please provide pointers if available. DhruvDhruvjoshi23 342 views 2 comments 2 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
How to find the PTD, YTD and LTD for budget and actual for PPM BIP report?Summary: I want to fetch : 1) Period Name 2) From Project Number 3) To Project Number 4) FERC Code 5) Major Capital Category 6) Minor Capital Category 7) Project Owning …Anshul Varshney 383 views 0 comments 0 points Started by Anshul Varshney Reporting and Analytics for ERP
-
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 41 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 73 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 77 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 245 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 135 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 94 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 …