Reports
Discussion List
-
Substring Function in FRSContent Is it possible to use a Substring function in FRS reports? We have a requirement to Substring the Cost Centre values on one of our reports so I was just wonderin…User_2025-02-05-23-02-10-916 22 views 1 comment 0 points Most recent by Naveen Gowda Reporting and Analytics for ERP -
Rx-Only: Other Receipt Applications ReportSummary Rx-Only: Other Receipt Applications ReportContent Hi All, Do we have the same/similar "Rx-Only: Other Receipt Applications Report" from fusion cloud.?Amarnath 26 views 1 comment 0 points Most recent by Nadia Khan-73252 Reporting and Analytics for ERP -
Receipts Awaiting Bank Clearance Report in EBS R12Summary Receipts Awaiting Bank Clearance ReportContent HI All, Do we have the same/similar functionality report as "Receipts Awaiting Bank Clearance Report" from EBS in … -
Physical or Soft Deletes handled in PVO DataSummary How are Physical or Soft Deletes handled in PVO Data ? Does it comes as a flag/identified along with incremental extract so that it can be deleted in the target …Upendra Nayak 32 views 0 comments 0 points Most recent by Upendra Nayak Reporting and Analytics for ERP -
Stop Email Bursting on Lower EnvironmentsSummary Prevent Seeded Process to Send EmailsContent Hi Experts, Need Help!! Recently we had got Production environment cloned to Test, so the data was also occupied, Th…Sahil Makhiza 362 views 9 comments 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
R13.18A OTBI BI Catalog LockdownSummary With 13.18A release customers will no longer be able to modify the shipped BI catalog content.Content R13.18A OTBI Product Alert This product alert is published …User720640-Oracle 383 views 8 comments 14 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
Payables invoices consolidated to 1 currency in OTBISummary Write report for AP Invoices from different BUContent We have many business units in our system and each of them are having different ledger currency. We would l…User_2025-02-04-22-27-16-622 31 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Do we have the same/similar reports from fusion cloudSummary Do we have the same/similar reports from fusion cloudContent All, Do we have the same/similar reports from fusion cloud Miscellaneous Receipts Register EBS R12 R… -
Date format issue with Excel template in BIPSummary Date format issue with Excel template in BIPContent Hi Friends, We have date format issues while using Excel template in BIP so could you please suggest if anyon…Sudha KOVURU 93 views 9 comments 0 points Most recent by Hariharan Sekaran Reporting and Analytics for ERP
-
Raw data extraction from Oracle Fusion to Datalake/SFTP serverSummary Exporting data from Oracle Fusion to SFTP Server - Unable to handle systematic deletesContent Hi All, We have a requirement where we need to push raw data into a…Kalyan Reddy 49 views 1 comment 0 points Most recent by User_2025-01-28-08-43-27-760 Reporting and Analytics for ERP -
Custom Job running concurrently & seeded program running sequentiallySummary Custom Job running concurrently & seeded program running sequentiallyContent We have developed the custom program basing on seeded program. Where we noticed cust… -
Reporting from both Oracle ERP Cloud and PaaSSummary How to build report using data from both Oracle ERP Cloud and PaaSContent How to build a report using data from both Oracle ERP Cloud and PaaS? What are the vari…Vamshi Mohan 69 views 2 comments 0 points Most recent by Sudha KOVURU Reporting and Analytics for ERP -
OTBI Procurement Subject Area shows Communication Date same for Original and Change Order PO DocumenSummary OTBI Procurement Subject Area shows Communication Date same for Original and Change Order PO DocumentContent Hi, We got to see that PO Communication date to supp…User_2025-02-10-05-51-05-868 18 views 1 comment 2 points Most recent by Anca A-Oracle Reporting and Analytics for ERP -
How to restrict Audit Reports on basis of AORSummary How to restrict Audit Reports on basis of AORContent Hi All, I have a requirement to restrict data access on the output of Audit reports via Navigator - Tools - …User_2025-02-06-08-26-40-838 93 views 1 comment 2 points Most recent by Anca A-Oracle Reporting and Analytics for ERP -
Using Task Number instead of Task IDSummary I want to use Task Number as a Prompt but when i am searching with task number. system search with task IDContent Hi, I am using Task Number value in a Prompt. M…User_2025-02-05-02-38-04-251 25 views 1 comment 0 points Most recent by Rich Merkel Reporting and Analytics for ERP -
BIP report needs to pick transactoions from the last successful runSummary BIP report needs to pick transactoions from the last successful runContent All, How to incorporate logic for a BIP report which needs to pick transactions from t…Amarnath 32 views 3 comments 2 points Most recent by Murthy Kodavati Reporting and Analytics for ERP -
Creating new Employee report with Expense Account InformationSummary What is the field and record to pull in the Employee Expense Account InformationContent We are building a new employee report and have a requirement to add the '…Jennifer Wolfe 41 views 4 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP -
Limitations of OTBI reportsContent Can someone please share the limitations on OTBI reporting compared to BI reporting. I'll inputs regarding the performance, number of records/columns that can be…User_2025-02-08-08-48-00-058 607 views 5 comments 0 points Most recent by User_2025-02-08-08-48-00-058 Reporting and Analytics for ERP -
RTF Template : Hide Row based on SUM() after complex RegroupingSummary Has anyone tried to Hide a row after regrouping the data and the conditions should be based on the SUM() of a column obtained after groupingContent The XML data …Balachander G-Oracle 57 views 1 comment 0 points Most recent by Amrit Reporting and Analytics for ERP -
Not-for-Profit Statement of ActivitiesSummary Seeking sample Statement of ActivitiesContent Statement of Activities quantifying revenue and expenses of our not-for-profit entity for a reporting period. The n…User_2025-02-11-03-09-13-126 19 views 0 comments 1 point Most recent by User_2025-02-11-03-09-13-126 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 -
OTBI Reports MigrationSummary OTBI Reports Migration StrategyContent Hi, Do we have any DevOps approach in migrating OTBI Reports like catalog,datamodel and template from one environment to t…Sujan Gutha 90 views 17 comments 0 points Most recent by amy hardtke 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 … -
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 760 views 3 comments 0 points Most recent by User_2025-02-07-23-45-47-870 Reporting and Analytics for ERP -
How to fix table position at the bottom of my pageSummary Need to fix table position at the bottom of my last pageContent Hello, I have a requirement to fix a table at the bottom of my last page. I have managed to get t…Nalinee Uppiah 54 views 7 comments 0 points Most recent by Nishanth B Jain Reporting and Analytics for ERP -
Capacity of Smartview report breaching 250k lines in ExcelSummary When running a Smartview TB Report, if it is filtered by more than 1 segment Eg, Account then fund, it will not run the query as it brings back > 250k linesConte…User_2025-02-11-02-45-23-645 24 views 1 comment 1 point Most recent by Anca A-Oracle Reporting and Analytics for ERP -
Which roles to use to secure custom OTBI ObjectsSummary In Otbi I see job roles, Duty Roles and Privileges what should I use to secure custom content in OTBI catalogContent All, When setting up custom folders in OTBI … -
Project Number is still seeing wrongSummary I changed project number in the system. I am seeing old number for the project in analyticsContent Hi Dear All, We are using an Analytics using Procurement - Pur…User_2025-02-05-02-38-04-251 46 views 1 comment 0 points Most recent by User_2025-02-05-02-38-04-251 Reporting and Analytics for ERP -
Different PR - PO Matched in AnalyticsSummary for one pr has multiple po one of them cancelled the other one closed but i saw cancelled one. I cannot reach the closed oneContent Hi Dear All, We had a PR and …User_2025-02-05-02-38-04-251 13 views 0 comments 0 points Most recent by User_2025-02-05-02-38-04-251 Reporting and Analytics for ERP