Reports
Discussion List
-
Transaction Query exampleSummary example of a GL Transaction query flexible to a range of parametersContent Seeking an Oracle Cloud example of a GL transaction query that returns line item detai…User_2025-02-11-03-09-13-126 330 views 6 comments 2 points Most recent by Sahil Makhiza Reporting and Analytics for ERP
-
OTBI Report that shows the element details field "Description"Summary OTBI Report that shows the element details field "Description"Content I am trying to build a report where I can pull in the field 'Description' on an element. Fo…
-
Project Invoice DistributionSummary Project Invoice DistributionContent Hello All, I want to know from which table we can get below information:-Lucky Sharma 61 views 3 comments 1 point Most recent by Nishanth B Jain Reporting and Analytics for ERP
-
OTBI usage tracking in 21ASummary OTBI usage tracking in 21AContent In this new subject area below, will that only track usage within the CRM subject areas or will that track report usage in the …Andrew_Schmitz 83 views 0 comments 3 points Most recent by Andrew_Schmitz Reporting and Analytics for ERP
-
Depreciation reserve of assetContent We're building a Fixed Asset Balances report out of Subject area Fixed Asset Balances - Real Time'. But we are not able to get the balances for Accumulated Depre…JL-JL 66 views 1 comment 0 points Most recent by Greg Jonovich-Oracle Reporting and Analytics for ERP
-
BIP Deeplink in report to view Purchase OrderContent Has anyone added a deeplink in a BIP report to view a PO? Please could you share.User_2025-02-05-23-02-10-916 63 views 3 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for ERP
-
Direct vs In-direct suppliersContent All - How to identify in Oracle Procurement cloud the direct vs in-direct suppliers? Also is there a field in OTBI that can tell direct vs Direct suppliers? I se…Hari Thyagaraj 33 views 6 comments 0 points Most recent by User_2025-02-06-05-37-11-922 Reporting and Analytics for ERP
-
Schedule Job Manager in OTBI to export the report output to Object Storage (OCI)Content Is there a way to export an OTBI BI publisher report to object storage (OCI) as part of a Job Manager scheduled job?
-
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 31 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 361 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 92 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 88 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 596 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 88 views 17 comments 0 points Most recent by amy hardtke Reporting and Analytics for ERP