To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
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… -
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…
-
on otbi create conditional format for rows not columnContent can i create conditional format to become a row is green ? not for column
-
BI Publisher Report Outputs to OCI - Cloud StorageSummary is it possible to send the BI Publisher Report Outputs to OCI - Cloud StorageContent We are working on a customer proposal and need to validate the feasibility o…
-
How to Change view PO PDF standard report to customizedContent Dear , We need to change PDF view standard report to our customized report in which i read the Oracle Doc ID 2302842.1. But issue is when wo go to oracle standar… -
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…
-
generating more than 75k record in OTBISummary generating more than 75k record in OTBIContent Is it possible to exceed the limit of 75k records in OTBI by importing an OTBI report as a data model in BI? Versi… -
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_ tables -
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… -
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 …
-
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 …
-
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…
-
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…
-
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…
-
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… -
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…
-
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 …
-
Increment Date Parameter on scheduled jobs - workaround neededSummary Increment Date Parameter on scheduled jobs - workaround neededContent When scheduling jobs like: Create Accounting, or Payables Cash Requirement Report, these re…
-
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 …
-
Payments Subject AreaContent Hi, As attached in the screenshot please advise which subject area need to be used for Payments Thanks -
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…
-
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..
-
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 …
-
Need Logic/Query to create below KPI's for Purchase Requisitions/OrdersSummary Need Logic/Query to create below KPI's for Purchase Requisitions/OrdersContent Need Logic to create below KPI's for Purchase RequisitionsWe have been trying to c…
-
on bi convert number to character but on Arabic formatContent i user but character is english , i need a character with arabic .
-
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… -
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…
-
BI Publisher Procedure call that populate temp tableSummary BI Publisher Procedure call that populate temp tableContent Is it possible to create BI Publisher Procedure call that run one of the customeraging Requests that … -
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…