Sample Reports
Discussion List
-
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 628 views 5 comments 0 points Most recent by User_2025-02-08-08-48-00-058 Reporting and Analytics for ERP -
Table name and column for Cost ExpenditureTypeSummary Table name and column for Cost ExpenditureTypeContent Dear Champs, I am looking to find the amount of each expenditure type I wanted to check if ACCT_BURDENED_CO… -
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
-
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 42 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
-
20D release - SUBMITTED PROJECT BUDGET AND FORECAST VERSIONS IN OTBI.Summary 20D release for SUBMITTED PROJECT BUDGET AND FORECAST VERSIONS IN OTBI ReportContent HI Team, There is a new feature in 20D release for SUBMITTED PROJECT BUDGET …User_2025-02-05-00-13-31-186 38 views 5 comments 1 point Most recent by Andy May-Coates-Oracle Project Management
-
Human Resources Dasboard - HR SpecialistSummary Human Resources Dasboard - HR SpecialistContent Hi Team, Is there any dashboard for HR Specialist ? I couldn't find any as I found one for Line Manager ( /Shared…
-
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 -
How to fetch invoice_no and invoice_date from wsh_ tablesSummary Need to fetch invoice_no and invoice_date from wsh_ tablesContent Need to fetch invoice_no and invoice_date from wsh_ tables or from doo_ tablesNageshwaran1 24 views 3 comments 1 point Most recent by Nageshwaran1 Reporting and Analytics for ERP -
Risk Management Result Summary ExtractSummary For a specified control, list common result attributes you would find in both Advanced Access Controls and Advanced Financial Controls.Content * Download the zip…Stephanie Golly-Oracle 96 views 2 comments 3 points Most recent by Feras Ahmad Reporting and Analytics for ERP -
Risk Management Access Point ReportSummary A list of control violations by access point.Content * Download the zip file attached to this post * Unzip and you'll find a catalog file and pdf example of the …Stephanie Golly-Oracle 70 views 1 comment 1 point Most recent by Feras Ahmad Reporting and Analytics for ERP
-
Risk Management Global Conditions ReportSummary A listing of global conditions including the filter definitions.Content * Download the zip file attached to this post * Unzip and you'll find a catalog file and …Stephanie Golly-Oracle 57 views 1 comment 1 point Most recent by Feras Ahmad Reporting and Analytics for ERP
-
Risk Management Users with Access Violations by Control ReportSummary Lists users that have violated a specified control.Content * Download the zip file attached to this post * Unzip and you'll find a catalog file and pdf example o…Stephanie Golly-Oracle 122 views 1 comment 2 points Most recent by Feras Ahmad Reporting and Analytics for ERP
-
Cross posting this idea in ERP Reporting and Analytics forum - ability to Audit OTBI report configurSummary Cross posting this idea - ability to Audit OTBI report configurationsContent Here is an Idea posted in Financials - General that I thought would be of interest t…Jeff Hare CPA CISA CIA 31 views 0 comments 0 points Most recent by Jeff Hare CPA CISA CIA Reporting and Analytics for ERP -
Risk Management Intra-Role Violations by Control ReportSummary List of roles that contain violations within itself for a specified control.Content * Download the zip file attached to this post * Unzip and you'll find 2 catal…Stephanie Golly-Oracle 76 views 1 comment 1 point Most recent by Feras Ahmad Reporting and Analytics for ERP
-
Risk Management Access Violations within a Single Role (Intra-Role) ReportSummary List of roles, users and conflicting access points with conflicts by control. Only roles that contain violations within itself are listed.Content * Download the …Stephanie Golly-Oracle 129 views 1 comment 2 points Most recent by Feras Ahmad Reporting and Analytics for ERP
-
Cash bases accouting reportsSummary Cash bases accouting reportsContent Hi - Any one come across reports requirement on cases bases?if yes, how you Achieved? pls suggest..Sandeep Kumar-245021 26 views 1 comment 0 points Most recent by SandeepPaspunuri Reporting and Analytics for ERP
-
Basic General Ledger Transaction Report - Filtered By AccountSummary Does anyone have a robust Basic General Ledger Transaction Report - Filtered By Account that they could shareContent We are due to go live with Oracle Fusion (SA…User_2025-02-11-02-45-23-645 69 views 5 comments 0 points Most recent by User_2025-02-07-23-45-47-870 Reporting and Analytics for ERP
-
Join between wsh_deliveries and rcv_shipmentsSummary Join between wsh_deliveries and rcv_shipments to fetch shipment_num, invoice no & dateContent Join between wsh_deliveries and rcv_shipments tables to fetch shipm…Nageshwaran1 134 views 4 comments 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP
-
OTBI Learning Offering Deep Link ReportSummary This report lists all Learning Offerings and respective Deep LinksContent This is an alternative solution for MOS Doc ID 2535239.1 The Oracle Learning Cloud Offe… -
SQL Cash Advance Report from ExpensesSummary SQL Cash Advance Report from ExpensesContent Hello I was wondering if you can share with me any SQL regarding open Cash Advances from Expenses. Thanks for your h…gabriel kinovisques-163562 50 views 2 comments 1 point Most recent by Balachander G-Oracle Reporting and Analytics for ERP
-
Error tables in Oracle for Unit of Measure Intraclass Conversion FSM importSummary I am trying to fetch the errors that occured while importing Unit of Measure Intraclass Conversion using FSMContent Hi, I am searching for tables where I can fin…
-
Supplier Spend ReportSummary Supplier Spend ReportContent Hi, As stated, we would like to ask for your help if there is a standard supplier spend report in Oracle. What we need is the actual…Gene Garcia 660 views 2 comments 0 points Most recent by Kent Sarmiento Reporting and Analytics for ERP
-
List of all the recurring scheduled processes?Summary How to get a list of all the recurring scheduled processes?Content How to get a list of all the recurring scheduled processes?Yasmin Kennedy 60 views 3 comments 0 points Most recent by SankarBalu Reporting and Analytics for ERP -
Unable to open/view the xdmz format ( data model) and xdoz format ( report ) uploaded in Report CataSummary Unable to open/view the xdmz format ( data model) and xdoz format ( report ) uploaded in Report Catalog pageContent Hi Team, I'm new to reporting area and need s…User_2025-02-10-05-51-05-868 50 views 3 comments 1 point Most recent by User_2025-01-30-00-54-17-530 Reporting and Analytics for ERP
-
From which customer table can we find order_type fieldSummary From which customer table can we find order_type fieldContent Please suggest from which customer table can we find order_type fieldNageshwaran1 53 views 6 comments 0 points Most recent by Pradvin Prabhakar Reporting and Analytics for ERP
-
How to Print the attachment in PO ReportSummary We have a requirement to get the attachment from a PO should get displayed on the View PDF document. Kindly SuggestVersion 11.13.20.04.0Yogesh Kumar-234569 132 views 3 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for SCM
-
Report needed for default expense accountSummary Report needed for default expense accountContent Hi I am trying to get a report of all users on oracle and their default expense account on OTBI but cannot find …User_2025-01-29-02-09-34-137 163 views 9 comments 1 point Most recent by User_2025-02-05-23-22-15-856 Reporting and Analytics for ERP
-
Audit Report for modified Projects and Projects BudgetSummary Audit Report for modified Projects and Projects BudgetContent Currently, there is no available Audit Report for modified Projects and Projects Budget. Does anybo…Jas Aquino-Oracle 36 views 1 comment 0 points Most recent by Lalkrishna Rath-Oracle Project Management