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
-
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… -
last item costContent i need a query , to get last item cost. -
in otbi create analysis from 2 subject areaContent can i create analysis from 2 subject area ? if yes i need an example
-
Publish reference document within Oracle FusionSummary Is there a way to publish reference document or link to a reference document within Oracle FusionContent Our Finance department is currently engaged in a project…User_2025-02-03-23-21-35-207 39 views 3 comments 0 points Most recent by User_2025-02-03-23-21-35-207 -
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…
-
Oracle Fusion-Manage Allocation Formulas- Complex formulas to allocate fees calculated based on reveSummary I want to know what the most effective approach would be for automating fee/royalty calculations for different contract agreements.Content I am trying to help st…
-
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 -
How to migrate the Common lookup from one instance to another instanceSummary We have created a Comoon lookup and need to migrate into another environment. Can you please help me by providing steps for migration
-
Standard test scripts for Financials for regression testing for qtrly patchesSummary Standard test scripts for Financials for regression testing for qtrly patchesContent Hi All, Are there any standard test scripts for financials available from or…
-
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 …
-
Period 13 and Financial Reporting Prior PeriodSummary How do I bring in December as Prior Period when a report period selection is January of a given yearContent Report works correctly as long as the user is looking…
-
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..