Reports
Discussion List
-
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 -
Is it possible to Hide columns in List of Values used in a PVO ?Summary Is it possible to Hide columns in List of Values used in a PVO ?Content We have defined a number of custom Reports and ESS Definitions. We try to use the standar…Balachander G-Oracle 28 views 0 comments 0 points Most recent by Balachander G-Oracle Reporting and Analytics for ERP -
Probation Questionnaire ReportSummary I wanted to develop a probation questionnaire report using BIContent I couldn't find the table in which probation evaluation is found while developing a probatio…Michael Nega Gebrehawariyat 48 views 0 comments 0 points Most recent by Michael Nega Gebrehawariyat 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 32 views 0 comments 0 points Most recent by Jeff Hare CPA CISA CIA Reporting and Analytics for ERP -
Converting Parameter Timezone on Input - UTC Database vs BST Local IssueSummary Converting Parameter Timezone on InputContent Hi All, We have an issue relating to the database time being on UTC, where our current local time is BST, though I …
-
Search not working for LOV in BI Publisher ReportSummary Search not working for LOV in BI Publisher ReportContent Hi Team, I have created LOV through SQL in BI Publisher Report. If i am using value without transforming…Piyush Ojha 113 views 3 comments 0 points Most recent by Piyush Ojha 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
-
AR Account Profile ClassSummary Linking 2 AR Subject Areas.Content The AR Account Profile Class is not available in the 'Receivables - Payment Schedules Real Time' subject area (19C) and it is …
-
Dyanmic BI Publisher Page EntrySummary Page Entry for BI Publisher ReportsContent Hi, We need to have a dynamic page entry(one click navigation for report) to be created dynamically i.e it should not …Sahil Makhiza 59 views 3 comments 0 points Most recent by SantoshKumarBhairi 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 61 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 114 views 4 comments 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP
-
Syntax help for a BI ReportSummary Need field to display 'All' when nothing is selected, but also need to format this field as a date.Content Hello all. I'm looking for a bit of help with my synta… -
BIP Report to get the Payment pending for ApprovalSummary BIP Report to get the Payment pending for user ApprovalContent Hi All, We have enabled a Workflow approval for Payments in ERP Cloud. We have a created a Specifi…Uvaraja-Oracle 112 views 4 comments 2 points Most recent by User_2025-02-06-05-37-11-922 Reporting and Analytics for ERP
-
Unique Records via BIP for tables with Object Version NumberSummary I'm looking for a way to obtain the latest information for a given record via a BIP job, for tables with an Object_Version_Number columnContent Hi, As per the su…
-
Is it possible to add a calculated SQL-based column in an OTBI Analysis?Summary Need to return a segment value name in a column from an OTBI analysis using a SQL QueryContent Hello, Our Financial users have created several OTBI reports based… -
How to add OR condition in the input of the OTBI analysisSummary How to add OR condition in the input of the OTBI analysisContent There are suppliers whom we create only invoices and there are suppliers whom we create only PO …Manish Kumar Sinha 30 views 7 comments 2 points Most recent by Sahil Makhiza Reporting and Analytics for ERP -
Custom ESS Parameter with TextBox and SearchSummary How can we have a Custom ESS Job with parameter as Textfield with Search option.Content One of the standard ESS Job has a parmeter which is a TextBox with a Sear…Balachander G-Oracle 58 views 2 comments 1 point Most recent by EdWho Reporting and Analytics for ERP
-
AddIn is disable in VDI toolContent Hello, Can you help me out with this enable to AddIn in word in VDI tool. Thanks, Nupur Thakar Version VDI 5.4.3Nupur Thakar 17 views 0 comments 0 points Most recent by Nupur Thakar Reporting and Analytics for ERP
-
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 51 views 2 comments 1 point Most recent by Balachander G-Oracle Reporting and Analytics for ERP
-
Dynamic List of Values for ESS JobSummary Dynamic List of Values for ESS JobContent Hi, How to create a 'Dynamic List of Values for ESS Job' , I cant use the lookup and table type valueset is not working…Soumya Prakash Parhi 147 views 12 comments 3 points Most recent by RaviThejaDarbha Reporting and Analytics for ERP -
Generate SAFT Data Extract Norway is not populating with any dataSummary Generate SAFT Data Extract Norway is not populating with any dataContent The ESS job 'Generate SAFT Data Extract' is not populating with any data. Parameters scr…User_2025-02-05-22-11-22-331 58 views 2 comments 0 points Most recent by User_2025-02-05-22-11-22-331 Reporting and Analytics for ERP
-
Want to extract Data from Report & analytics by writing SQL QuerySummary Want to extract Data from Report & analytics by writing SQL QueryContent I Want to extract Data from Report & analytics by writing SQL Query. Previously i use ex… -
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 489 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 47 views 3 comments 1 point Most recent by User_2025-01-30-00-54-17-530 Reporting and Analytics for ERP
-
Report on selected bank accountSummary I need to report on the selected/default bank account where a colleague may have more than one in the systemContent Hello, I need to report on the selected/defau…User_2025-01-28-05-32-59-092 56 views 5 comments 1 point Most recent by Gopikrishna Nerella Reporting and Analytics for ERP
-
Table which captures the User-Defined Fiscal Classification CodesSummary I am looking for the back end table which captures the Manage Transaction-Based Fiscal Classifications Task DetailsContent Setup and Maintaince > Search Manage T…SandeepPaspunuri 195 views 1 comment 1 point Most recent by SandeepPaspunuri Reporting and Analytics for ERP -
Getting data from a Data Model to test it (Ad Hoc)Content After the direct SQL query was removed, I am now forced to create a report for my data model when I want to see the data in any other format than XML or more tha…MaartenDIF 61 views 6 comments 1 point Most recent by User_2025-02-06-06-17-13-684 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 55 views 6 comments 0 points Most recent by Pradvin Prabhakar Reporting and Analytics for ERP