Reporting and Analytics for ERP
Discussion List
-
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 … -
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…
-
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…
-
Custom Expenses Subtemplate Not Reflecting in NotificationsI have customized the Expense Approval Data Model to add one field not in seeded DM. The field needs to go in to Expenses section which is part of the Expense Notificati…
-
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 21 views 2 comments 0 points Most recent by Jessica Yamilet Valdes Romero
-
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 "…
-
Can multiple trees/hierarchies for the same segment be use in a single report?Summary: We are currently converting from PeopleSoft to Oracle ERP/EPM and are trying to understand the reporting and any potential limitations. We have multiple hierarc…
-
Group Filter not working in Custom ReportContent We have developed a custom Report. The Data Model is a master detail query includes a main query and three child queries Q_1 - Main Q_2, Q_3, Q_4 are child queri…
-
Smartview HelpSummary Large Report book for SmartviewContent We just implemented Oracle ERP cloud. We have certain reports in a package totaling 208. We are currently utilizing about …
-
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… -
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 (…
-
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 … -
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… -
How to find latest record in table PJO_PLAN_VERSIONS_B for projectSummary: Hi Team, I want to know how to find the most recent record in PJO_PLAN_VERSIONS_VL as version_number is same for all 3 rows. Regards Nidhi... Content (required)…
-
How to Translate the BI Publisher Catalog Report Name and parameter to multiple languages.Summary How to Translate the BI Publisher Catalog Report Name and parameter to multiple languages.Content How to Translate the BI Publisher Catalog Report Name and param…
-
General Ledger Transaction Listing ReportSummary Lists down all Journal Entries along with corresponding subledger detailsContent This is one single consolidated view of all the transactions in ERP. This report… -
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…
-
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… -
Query or the table that contains columns of the Account Analysis ReportSummary: Content (required): Hello everyone, I have a requirement to make a custom report for the Account Analysis Report. I need to pick some of the columns in the seed…
-
-
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… -
Open Purchase Orders & Goods Received Not Invoiced reportsSummary Various OTBI reports showing Open Purchase Orders & Goods Received Not InvoicedContent Import the attached catalog files into your environment using the "Unarchi… -
R13: Project Portfolio Management Cloud OTBI: Subject Areas to Database Tables Mapping SpreadsheetSummary The spreadsheet provides a mapping of the BI Subject Area columns to source database tables and columns. It also has the View Object (VO) names for each column.&…
-
Bank Statement Analysis Report > Bank Statement TransactionsWe are trying to validate the transactions being reflected on this report. Here's the full path of the seeded report: Shared Folders > Financials > Cash Management >Bank…
-
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 when
-
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…