Reports
Discussion List
-
Best strategy for weighed FIFO item cost.Content Hi. In Oracle EBS we had FIFO layers that each one was being consumed. The item cost at a time was the weighted average of the value of the unit value of the lay…User_2025-02-07-06-48-26-537 44 views 0 comments 0 points Most recent by User_2025-02-07-06-48-26-537 Reporting and Analytics for ERP -
Emailing report based on field on data model?Summary Send report to destination based on field on DM?Content Hi. I'm working on a simple report to show the quantity on hand of items based on subinventory. Each subi…User_2025-02-07-06-48-26-537 35 views 3 comments 0 points Most recent by User_2025-02-07-06-48-26-537 Reporting and Analytics for ERP
-
GL Journal Workflow notification template customizationSummary GL Journal Workflow notification template customizationContent In latest release oracle allows editing the workflow notification template. We are trying to custo…saravana maneeian subhramaniun 43 views 1 comment 0 points Most recent by Gergana Radoutcheva-Oracle Reporting and Analytics for ERP -
Monthly Scheduled report did not runSummary Monthly Scheduled report did not runContent Hi Experts We have a monthly scheduled report scheduled in March and has run fine for first 3 months. The report has …Murthy Kodavati 34 views 3 comments 0 points Most recent by Sahil_Makhiza Reporting and Analytics for ERP -
Goals Report - Quarterly reviewSummary Unable to find columnsContent Hi, I've been asked to build a Goals report that contain the following fields that I cannot seem to find in any of the Goals Subjec…User_2025-02-05-22-44-35-842 39 views 0 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for ERP
-
Logo in OTBI AnalysisSummary Getting error when uploading images into OTBI analysis from local driveContent Hi All, I am getting below error when uploading logo image into an OTBI analysis u…Vinod Kumar Mohanraj 298 views 7 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for ERP
-
Best practice to control the folder permissions in Reports and AnalyticsContent We have the same requirement, or at least the same issue as described in this topic (https://cloudcustomerconnect.oracle.com/posts/b07532cb8d) , but prefer to ma…MaartenDIF 54 views 3 comments 3 points Most recent by SantoshKumarBhairi Reporting and Analytics for ERP -
Subject Area - Payables Invoices - Transactions Real TimeSummary Not able to find taxes - Transaction Tax section under Subject Area - Payables Invoices - Transactions Real TimeContent Hi All i was building OTBI report for bus…User_2025-02-07-08-55-07-914 83 views 4 comments 0 points Most recent by User_2025-02-07-08-55-07-914 Reporting and Analytics for ERP
-
Can a BI report be scheduled to email an excel attachement using Schedule Report JobSummary Email an excel attachement of BI report OutputContent Can a BI report be scheduled to email an excel attachment using Schedule Report Job? When scheduling via th…User_2025-02-06-00-15-19-515 69 views 6 comments 1 point Most recent by User_2025-02-06-00-15-19-515 Reporting and Analytics for ERP
-
Column returning no value when combining Payables Invoices and Payment History subject areasContent Hi all, I have created a summary analysis for AP with a pivot table view that users can drill through to a detailed analysis and then drill down into the manage …
-
Page Entry For OTBI DashboardsSummary How to Create page Entry for OTBI DashboardsContent Hi There, We have a requirement where in we want to have the page entry created for our dashboards. We dont w…Sahil_Makhiza 61 views 2 comments 1 point Most recent by Sahil_Makhiza Reporting and Analytics for ERP
-
Procurement - Pending Change Order - Pending ApproverSummary Procurement - Pending Change Order - Pending ApproverContent Hello All, I am trying to get the the "Pending Approver" of a pending Change Order. Let me know if a… -
Need ERP R12 tables in FusionSummary Just want to know the ERP r12 tables in fusionContent Hi, Can any one help below listed ERP R12 tables in Oracle Fusion. jai_om_wsh_lines_all jai_om_wsh_line_tax…Nageshwaran1 107 views 4 comments 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP -
How can I either hide or remove columns easily in a data model?Summary data model bi publisher reportContent I have a data model that I have copied this over. I am trying to remove and/or hide some of the columns, and then move some…User_2025-02-08-08-55-02-564 171 views 8 comments 0 points Most recent by User_2025-02-08-08-55-02-564 Reporting and Analytics for ERP
-
How to control the folder permissions in Reports and Analytics to user levelSummary Need to control users to access the folders within the permissions provided and controlled at the user level, Please provide the details how to control this fold…
-
Exit the Foreach Loop after fetching once value in XSL TemplateSummary We have an requirement where if there are multiple Invoice lines with PO numbers,but we have to fetch any one of the PO number from lines in XSL template from Pa…User_9SGJ3 57 views 4 comments 0 points Most recent by Sahil_Makhiza Reporting and Analytics for ERP
-
Need Help with E-textSummary Arabic data getting Jumbled in Etext tempalteContent Hi There, We are having a requirement wherein the data in the database is in Arabic. We are preparing the e-…Sahil_Makhiza 38 views 24 comments 1 point Most recent by Sudha KOVURU Reporting and Analytics for ERP
-
Show Declaration while running BI ReportSummary Show Declaration while running BI ReportContent Hello Experts Is there a place where we can show declaration before running/scheduling a report ?A checkbox will …Murthy Kodavati 39 views 4 comments 0 points Most recent by Murthy Kodavati Reporting and Analytics for ERP
-
Need SQL join to show bank assignment to supplier siteSummary We assign bank accounts to supplier sites, I need the table joins to allow me to create a data model to show which bank account is assigned to each supplier site…User_2025-02-04-14-03-09-386 313 views 2 comments 0 points Most recent by User_2025-02-04-14-03-09-386 Reporting and Analytics for ERP
-
RTF Template Table Overflow - SolvedSummary RTF Template Table Overflow to a different table in the same RTFContent Hi, I am trying to create a report where the data overflows from one table in an rtf to a…
-
OTBI Reporting reporting Invoice Summary + checking hold statusSummary Wanting to report on Invoice summary (outstanding, in progress etc) but need to be not on holdContent Hi I am using the Payables Invoices Transactions Real Time …RichardChan 74 views 2 comments 0 points Most recent by SandeepPaspunuri Reporting and Analytics for ERP -
what is the role of ar_receivable_applications_all.display columnContent ar_receivable_applications_all.Display = 'Y' or 'N' what will happen in each case. Can anyone explain? BR LuckyLucky Sharma 74 views 6 comments 1 point Most recent by Nishanth B Jain Reporting and Analytics for ERP -
Tables in which Printer name and details are savedSummary Tables in which Printer name and details are savedContent Whenever any Customer facing document/report is sent through a BIP report to the printers, is there any…
-
How to pass field value(s) from Page to OTBI (for report or dashboard generation) ?Summary An iFrame is created in an existing Page layout in order to accommodate a OTBI report. How to pass field value(s) from Page to OTBI (for report or dashboard gene…
-
OTBI performance recommendations V2 paper (2679006.1) is available on MOS PortalSummary OTBI performance recommendations V2 doc is intended for OTBI system integrators, BI report developers and admins. It covers advanced performance tuning technique…Pavel Buynitsky-Oracle 88 views 2 comments 5 points Most recent by Pavel Buynitsky-Oracle Reporting and Analytics for ERP
-
OTBI Dashboard to Monitor AssessmentsSummary Includes deep drills to control and assessment records in Risk Cloud pagesContent This dashboard is useful for monitoring and acting on open assessments as well …Stephanie Golly-Oracle 78 views 0 comments 3 points Most recent by Stephanie Golly-Oracle Reporting and Analytics for ERP -
Need help getting drill to detailed analysis from pivot table to workContent I'm trying to create a dashboard which contains some prompts and a pivot table. When a value in the pivot table is clicked, I want the detailed report to open. T…
-
Security Role for Access to Payable Invoice Register ReportSummary I'm looking to setup a custom role that gives access to the Payables Invoice Register ReportContent It seems like I've given permissions that should be sufficien…David Rabalais 41 views 2 comments 0 points Most recent by Nishanth B Jain Reporting and Analytics for ERP -
How to create custom XML output formatSummary How to create custom XML output formatContent Hi All, We have to generate a custom .xml output file from ERP cloud . How can we generate XML output file from BIP…Najeeb_ACN 306 views 5 comments 0 points Most recent by Sahil_Makhiza Reporting and Analytics for ERP
-
Spend calculations - Procure-To-Pay Subject AreasSummary How is Spend value calculated in Procure-To-Pay Subject AreasContent Gurus, Looking at seeded 'Top 10 Spend by Category' OTBI report and see Spend column. Wonder…Manoj Acc 55 views 1 comment 0 points Most recent by Nishanth B Jain Reporting and Analytics for ERP