Reports
Discussion List
-
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 43 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 599 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 61 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 156 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 91 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 733 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 55 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 28 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
-
FRS General Ledger Financial ReportingSummary Combing Accounts and or Parents in FRS ReportContent Hello - does anyone know why we can't combine multiple accounts or multiple parents into one line on an FRS …User_2025-02-10-13-18-41-347 80 views 1 comment 0 points Most recent by CLAZAR-Oracle Reporting and Analytics for ERP
-
GL reports on multiple ledgersContent Our client has close to 40 million journal lines across ledgers for a single period. They want a BIP report where they will only pass the ledger set and choose a…saravana maneeian subhramaniun 96 views 2 comments 0 points Most recent by CLAZAR-Oracle Reporting and Analytics for ERP
-
FRS Report, calculation does not equal report TotalSummary A calculated value of four columns is off by less than $1 from the Report Total of those same four columnsContent Company 1 Company 2 Company 3 Company 4 Sum Rep…Dave Pucetas 30 views 1 comment 1 point Most recent by CLAZAR-Oracle Reporting and Analytics for ERP
-
R13 Risk Management OTBI subject area to database lineage mapping spreadsheetSummary This spreadsheet documents R13 Risk Management OTBI subject area to database lineage mapping and subject area security. Content This spreadsheet is published by …Noelle Bartlam-Oracle 681 views 8 comments 4 points Most recent by Feras Ahmad Reporting and Analytics for ERP
-
Custom OTBI content that we did not createSummary Why is there report objects under custom folder after install of OTBI that we did not createContent After our new POD was brought up I went into OTBI and I'm fin…
-
Competency ReportSummary developing a competency report using otbiContent Dear All, Which work area is suitable to create a report to check the competency name, the target competency, th…Michael Nega Gebrehawariyat 41 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Limit number of lines per pageSummary I have an invoice where I want to limit the number of lines that appears per pageContent Is there an IF statement that could limit the number of lines that appea…Mohammad Alhindawi 53 views 3 comments 0 points Most recent by RichardChan Reporting and Analytics for ERP
-
Pivot self-assessed tax amount from a column to a row in an OTBI ReportSummary Pivot self-assessed tax amount from a column to a row in an OTBI ReportContent Currently, we have an OTBI report using the subject area “Payables Invoices – Tran…James Cusson 37 views 0 comments 0 points Most recent by James Cusson Reporting and Analytics for ERP
-
How can i find BI Tables easily?Summary How can i find BI Tables easily?Content How can I find BI tables where specific data is stored, I spend so many times trying to map and also get a table I want f…Michael Nega Gebrehawariyat 86 views 2 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP
-
ce_available_transactions_vSummary Recreate ce_available_transactions_v in OACContent Hello all I'm trying to recreate 'ce_available_transactions_v ' in Oracle Analytics Cloud (either via replicat…Elisa Fernandez 53 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to get Request Id at runtime for the BI-Publisher ReportSummary How to get Request Id at runtime for the BI-Publisher ReportContent In the custom reports, the business users are expecting to capture the Request-Id/Report-Job-…
-
Analysis is missing the promptsSummary Missing prompt on Expense ReportContent We have a report called 'Expense Type Report' It was created with the 'Analysis' tool. This report has prompts when you g…Jennifer Wolfe 35 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Query to retreive Custom BI Report details in CloudSummary Query to retreive Custom BI Report details in CloudContent Hi Team, Which table will give the information of the custom BI Reports created in Oracle ERP Cloud? T…Abhilash K - Deloitte USI 560 views 7 comments 0 points Most recent by Dharmendra Shukla Reporting and Analytics for ERP -
How to capture page overflow in rtf template - BI PublisherSummary I need to display the sum of a particular field for all the Invoices in the current page only even if the Invoices overflow to the next pageContent Hello, I have…Nalinee Uppiah 31 views 1 comment 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP
-
Replace Dynamic SQL with Explicit SQL notificationSummary Notification received from OracleContent Hi There, Since yesterday we have received many notifications stating "Replace BI Publisher Dynamic SQL with Explicit SQ…
-
Exclude a column in XML Report output formatSummary My select query has two columns. I want to have only one column in my report output which is in XML format. Is there wa we can achieve this.Content My select que…Karishma Mungara-Oracle 101 views 5 comments 0 points Most recent by Karishma Mungara-Oracle Reporting and Analytics for ERP