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
-
Is it possible to have default prompt value specific for each user in an OTBI dashboardSummary: We have an OTBI dashboard for which each user is searching a specific account combinasion. Instead of always typing the account in the prompt of the dashboard, … -
Unable to open parameters page for any of the BI reportsSummary: Unable to open the parameters page for any of the BI report. When I click on any of the BI reports, I get a blank page that is visible. Not able to access any o…
-
Unable to extract large volume of dataSummary: We have prepared one BI publisher report which has different filter criteria in it. While we run the report & extract the data, it shows only 74701 records and …
-
Spend Analysis - How to load historical data to compare with current SpendSummary: I would like to know is there any method available to load historical spend data to compare with current spend? Content (required): I would like to know is ther…
-
SQL to query current BI Agents scheduled to e-mail / dashboard page etcSummary: I have written an sql query to extract all BIP reports currently scheduled, but want to do the equivalent with OTBI BI Agents - is it possible using sql and acc… -
What role is needed to run ESS job Vertex Payables Transaction Tax Action Report ?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Reporting on Transaction Incidents per User?Summary: We would need to be able to report on transactions done by certain users (aggregation of all incidents/controls where the selected user has done possibly fraudu… -
How to add Project ID to OOB report?Summary: Add a column to OOB report "General Ledger and Subledger Accounting by Journal Lines" for Project ID Content (required): I really like the OOB report General Le… -
ERP - OTBI Advanced Features event on Sep 22th 9am Pacific TimeSummary: After the record interest from this community on the previous OTBI event 'ERP - OTBI Made Easy' in May, and several requests for an advanced session, we decided…
-
How to Create Dependent LOV Parameters for custom ESS job using LOV's ?Summary: Hi we are trying to create Dependent LOV parameters for custom ESS job using LOV's ,Value set and lookup's . but we are unable to do that for custom report . af…User_2025-02-11-23-36-23-456 321 views 2 comments 0 points Most recent by Gergana Radoutcheva-Oracle
-
Report Error: ORA-01438: value larger than specified precision allowed for this columnSummary: Hey, I am running a custom report in BI Enterprise and keep getting the error below. The report is failing for only a few circumstances and am able to run it fo…
-
Need Information on Proxy Setup in Oracle Cloud - 21 BSummary: Need Information on Proxy Setup in Oracle Cloud - 21 B Content (required): Navigation: Settings and Actions > Set Preferences > Proxies Audit: Can we have a tra…
-
Print ZPL labelsSummary Print ZPL labelsContent Hi, We have a requirement to print ZPL labels on non-local Zebra printers. The availability and configuration of a Zebra printer (using a…
-
Refreshes P2T - Should BICC jobs be copied during a PROD to Test refresh?Summary Refreshes P2T - Should BICC jobs be copied during a PROD to Test refresh?Content Refreshes P2T - Should BICC jobs be copied during a PROD to Test refresh?
-
Issue running BI reportContent Some users are experiencing issues running report https://eeho.fa.us2.oraclecloud.com/analytics/saw.dll?bipublisherEntry&Action=open&itemType=.xdo&bipPath=%2FCus…
-
Extract Invoice attachment with Rest API Fusion ERP CloudSummary usingContent The following help page documents how to use the Get an attachment for an invoice Rest API. Running the codes gives me a similar response as per the…
-
Procurement - Pending Change Orders Subject area does not correctly reportSummary The Change Order Creation Date is actually the PO Creation DateContent Has anyone else noticed that the "Change Order Creation Date" - a vital field in this subj… -
'Create' Icon is missing from 'Manage Enterprise Scheduler Job Definitions and Job Sets for Human CaSummary 'Create' Icon is missing from 'Manage Enterprise Scheduler Job Definitions and Job Sets for Human Capital Management and Related Applications'taskContent Hi Team…
-
Unable to download Financial Reporting StudioSummary Unable to download Financial Reporting StudioContent Our customer has financial reporting report which needs to be opened through Financial Reporting Studio. I t…
-
Allow Scheduled Jobs to send to a distribution ListContent We would like to be able to send job failures to a group of people instead of individuals on Job notifications. This is needed for these reasons: 1. Oracle doesn…
-
I am looking for a way to get the value of a custom field (data type: NamedIDLabel) that I have creaSummary I am looking for a way to get the value of a custom field (data type: NamedIDLabel) that I have created in my contacts table.Content I am looking for a way to ge…User_2025-02-03-22-06-34-432 24 views 0 comments 0 points Most recent by User_2025-02-03-22-06-34-432
-
Looking for PO Receipt Number and related data in OTBISummary Cannot find PO Receipt Number, Receipt Date and related date in OTBI Subject Area: Procurement: Procure to Pay Real TimeContent Cannot find PO Receipt Number, Re…
-
Unable to search Custom reports using Schedule New ProcessSummary Unable to search Custom reports using Schedule New Process. Reports are not coming in Search resultsContent Hi Team, Reports are not coming in Search results whe…
-
query to get item cost for secondary uomContent how i get item cost for secondary uom ?
-
query to get ap accounted invoices.Content i need a query to get ap accounted invoices.
-
TIMEZONE Display on the report field - UTC Timezone to EST TimezoneSummary TIMEZONE Display on the report field - UTC Timezone to EST TimezoneContent Hi Experts, I am using the OTBI Analysis (Payables Transactions Real Time) to create a…
-
Oracle BI Report > Parameter based on LOV having string limitationsSummary Oracle BI Report Parameter dissappeared due to long string value on listContent Hello Community and experts, I am building a BI report based on a SQL query, and …
-
query to get item cost to secondary uomContent if i have an item has prinary uom and secondary uom. i need to get item cost for secondary uom.
-
query to get maturity date and cleared date for ar receiptContent in ar receipt i need a query to get maturity date and cleared date
-
Oracle ERP > Procurement> Self Service Receipts tables to query for a reportSummary Self Service Receipts tables to query for a reportContent Hello Community, I am new to the topic, and I am trying to generate a report on Oracle Fusion ERP based…