Reports
Discussion List
-
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 85 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 52 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 595 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 30 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 92 views 5 comments 0 points Most recent by Karishma Mungara-Oracle 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 -
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 27 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 47 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 31 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 111 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 58 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 63 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 115 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 111 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 60 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 15 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 49 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 141 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 59 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…