Category 129
Discussion List
-
Unusual behavior of OTBI report -Not displaying 'invoice amount' and 'discountable amount'Hi Team, We have OTBI report which displays invoice discount information. After 24A we are observing it is not displaying 'invoice amount' and 'discountable amount' for …Kalpesh Salunke-Oracle 22 views 6 comments 0 points Most recent by Kalpesh Salunke-Oracle Reporting and Analytics for ERP -
What Information is stored in faw_db_sql_pjclabordisttxndetails FAW Table?Summary: What Information is stored in faw_db_sql_pjclabordisttxndetails FAW Table? What is the use of this table in FAW? Content (required): MAYO Clinic Version (includ… -
Does anyone have a Procurement Purchase Order dashboard they could share?Summary: Wondering if anyone has a (more recent) Procurement / Purchase Orders OTBI Dashboard they could share. Content (please ensure you mask any confidential informat…Greg Aulson 11 views 1 comment 0 points Most recent by Bharat Agrawal Reporting and Analytics for ERP
-
Unable to access attachments uploaded in workflow notification via hyperlinkAttachements uploaded in "Account Coding Workflow Notification" are getting saved as a content in BLOB column of a table rather than storing it as file in UCM. Hence it …
-
How do I see all scheduled recurring jobs & detailsI have come into a situation where folks have been allowed to schedule recurring jobs under their own IDs. This creates a handful of issues (in my mind at least): No one…Matt Mossman 176 views 12 comments 1 point Most recent by Bharat Agrawal Reporting and Analytics for ERP
-
Analysis to retrieve total element amount per month and yearly trendSummary: Good afternoon, I'm trying to build an analysis to get the total amount of elements (e.g., variable pay) + salary that is valid in a specific month in some coun…ammiano 22 views 2 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
how to store the manual input parameter values for multiple session in BIP report.Summary: User wants to run the BIP report with same input parameter values again and again and our report has around 20 manual input parameters. So is there any workarou…Gaurav Paliwal 15 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
can we audit Allowed Email Recipient DomainsSummary: Auditing Allowed Email Recipient Domains Content (please ensure you mask any confidential information): A change has been made in one of our test systems to the…
-
SQL Query to get Transaction column from Review Completed Transactions Page for intransit shipmentSummary: I want SQL query to transaction, serial number from get reviewed completed transaction data for Intransit shipment transaction type. Content (please ensure you …Latha00 698 views 5 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for ERP
-
How to link Account Receivables (AR) module with Costing to get item cost for an invoice lineSummary: Hello Which table should I use/link with 'RA_CUSTOMER_TRX_LINES_ALL' to get the cost price of an invoice line in AR? Content (please ensure you mask any confide…Varun Dhondea 97 views 3 comments 0 points Most recent by Syed_Ibrahim Reporting and Analytics for ERP -
BI publisher nested group issueI have an rtf template in BI Publisher where I want to show all rows of data within a repeating group. My problem is, I need to do this outside of the end of the group, …
-
Regarding connectivity between BI Reports and OIC (PaaS)Hi team, Currently we are having few BI reports which call OIC services as data sources. All these connections are secured via basic auth. Since we are currently using O…
-
Is intercompany invoice eligible for Mass Addition process?Summary: Hello, I created an Intercompany invoice with asset clearing account and want to transfer it through mass addition. I'm not able to do so. Please note that I've…
-
Open-source fonts to replace licensed Monotype fonts in BIP and OTBI in 24AIn 24A, open-source fonts will replace the Monotype fonts currently available in Oracle Transactional Business Intelligence. You can use the open-source fonts available …Noelle Bartlam-Oracle 125 views 6 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
what is the link between main negotion number with negotion number whic has multiple rounds 2 or 3oracle fusion 11.13.23.10.0 for e.g in my system i have negotition number with this RFX-CSC-230022 this is main one RFX-CSC-230022-2 this is 2nd round RFX-CSC-230022-3 t…Abdur Rehman 22 views 2 comments 0 points Most recent by Abdur Rehman Reporting and Analytics for SCM -
unable to get BIP Excel output and ends with error file format and extension dont matchSummary: when BIP Excel output is generated, the xls output ends with an error as "the file format and extension 'filename.xls' dont match. when the dialogue button is a…Prassanna_Srinivasan 261 views 7 comments 0 points Most recent by Prassanna_Srinivasan Reporting and Analytics for ERP
-
Subject Area to get real time ESS Job details for OTBI Analysis dashoboardHi, We have a requirement to create an ESS Job monitoring dashboard to show summary of ESS Jobs by status and few detail drill down reports. Is there any subject area wh…Ankit_Bhadja 19 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for ERP -
Pre-defined variable to get instance URL for analytics server similar to CURRENT_SERVER_URLHi, We need to include links to drill-down BIP reports in the output of a master report using an RTF template. When creating these links, the instance hostname should be…Ankit_Bhadja 32 views 3 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for ERP
-
Hide column in a data modelSummary: Hi Team, We have requirement to generate an XML output with parent and child relationships for AR invoice data. We have created a parent dataset with customer_t…
-
How to work with Multiple selection and NVL function In ParameterSummary: How to work with Multiple selection and NVL function Content (required): Hi All, Hope everyone is doing well. I have a below requirement for which i need you he…Pritam Das 522 views 3 comments 0 points Most recent by Humberto Martín-Oracle Reporting and Analytics for ERP
-
We want to provide a deep link in email to supplier for purchase order acknowledgementSummary: We want to provide a deep link in email to suppliers for purchase order acknowledgement so that supplier can click on the URL and PO acknowledgement page opens …Amit Sutar 42 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Need a query to get accounting period of a POWe are unable to find a way to get an accounting period for a purchase order. Could you help with a query? I need the PO# and the accounting period as a column. Also, le…Abhilash K - Deloitte USI 24 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
How to create AOR based transaction console BI report in oracle fusion hcmHow we can create AOR based transaction console BI report in oracle fusion hcmAnup Karmankar 104 views 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Reporting and Analytics for HCM
-
Numbers Format Issue Standard Purchase Order ReportDear All, The format of numbers in the purchase order BI standard report are not displayed correctly, because the NLS_NUMERIC_CHARACTERS setting is not configured at the…George Mattar 22 views 3 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for ERP
-
How can we determine if the BIP report has reached/hit a certain number of billion logical I/O?Summary: We received a notification from Oracle that the one of our report is running for more than 5 hours or exceeding 4 billion Logical I/O. Hence, the report needs t…Sonam Anekar 22 views 1 comment 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
What Table(s) should I use to report on segment details?Summary: I am trying to build a BI Publisher report in SQL that exports details on individual segments in our chart of accounts. Content (please ensure you mask any conf…Henry Imgrund 46 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Generate an audit report for the role modification.Summary: Hi Team, We are seeking clarity on the individuals responsible for creating roles within our system. Upon investigation, we came across Document ID 2175861.1. H…joelroshan92 4 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Is there an advanced official source about the map view feature in OTBI?I would like to try using the map view in OTBI and followed the guide below for configuration, but only the background map is displaying. I would like to know if there i…Andy K W, SO 33 views 2 comments 1 point Most recent by Andy K W, SO Reporting and Analytics for ERP
-
Missing Data in Custom Report for Scheduled ProcessesSummary: We have created a custom report to meet the requirement of viewing all scheduled processes created by all users. In this report, we aim to display columns such …Srikanth Dodla 21 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
I need a query to obtain Chart of accounts Values on ERPSummary: We are trying to create a report using BI Publisher and We require a SQL query to obtain the chart of account value set values (Value and Description shown on s…Robinson Antunez 2.3K views 3 comments 0 points Most recent by ROBERTO J CAMACHO Reporting and Analytics for ERP