Category 129
Discussion List
-
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 24 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 276 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 11 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 550 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 25 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 105 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 21 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 21 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 41 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 5 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 31 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 24 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.4K views 3 comments 0 points Most recent by ROBERTO J CAMACHO Reporting and Analytics for ERP
-
I was creating multi partitioned external table received errorHello Tom i was creating multi partitioned external table from parquet file but end up having these error did so much research but not able find cause of this error plea…ankeshphapale1234 32 views 1 comment 1 point Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Can we access dashboard prompts value in URL as Dynamically in BIP Report?Summary: Hi Experts, We are having a requirement, whenever user clicks on count then it should redirect to the detail report for those specific values selected in Dashbo…
-
Sql query for Canceled Payment Report.I wanted to fetch the Canceled Payment details from the person results through SQL query.Chetana Pawar 23 views 2 comments 0 points Most recent by Chetana Pawar Reporting and Analytics for ERP
-
How to add background color BIP excel template row wise in HCMHi Folks, May I know how to set the row background colour in the Excel template? Thanks Prakash JayavelPrakash Jayavel 32 views 1 comment 1 point Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
In Payment Approval Notification, Can we add one more pdf attachment?Summary: We want Output of Payables Selected Installments Selection Report along with Disbursement Payment Process Request Status Report in the Payment Approval Notifica…Deepa Kumari 21 views 2 comments 1 point Most recent by Mohammed Qurram Reporting and Analytics for ERP
-
bi publisher to oci object storageSummary: How can bi publisher report burst the out to an Oracle Cloud Insfrastructure Object Storage Content (please ensure you mask any confidential information): BI pu…Maria Inocentes 21 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
How to populate tax rate name under Receivables-Transactions Real time subject area in an OTBIWe built an OTBI report with the subject area - Receivables-Transactions Real time. We do not see an option to select the tax rate name/code such as GST, HST etc. Only t…Lakshmi Kanchi 15 views 2 comments 1 point Most recent by Lakshmi Kanchi Reporting and Analytics for ERP
-
Scheduled BI Publisher reportSummary: Does a scheduled report need re-scheduling if its underlying BI Publisher template or data model is changed after the scheduling starts? Content (please ensure …Robert of STAU 11 views 2 comments 1 point Most recent by Robert of STAU Reporting and Analytics for ERP
-
Need help for getting Average cost of an item column in OTBI Subject areaHello experts, I need some quick help in for my OTBI Analysis which is for supply chain module. I want to calculate the Sum of Debits and Credits in Inventory. For that …NIKHIL M Y 57 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
display column based on promptSummary: I want to add a prompt (Yes/No) to display a column. I'd settle for a prompt that forks to two different results tables as well. Content (please ensure you mask… -
How to run US 1099 Electronic Media Report for a specific vendorHi All, We need to submit an electronic file for one vendor we missed. Is there an option to run the US 1099 Electronic Media Report for a specific vendor. There seems t…Lakshmi Kanchi 13 views 2 comments 0 points Most recent by Lakshmi Kanchi Reporting and Analytics for ERP
-
SQL query to get the Item Category HierarchySummary: SQL query to get the Item Category Hierarchy Content (please ensure you mask any confidential information): Version (include the version you are using, if appli…Lakshmi Bandlamudi 958 views 1 comment 1 point Most recent by Kumar -Oracle Reporting and Analytics for SCM
-
Does an expense listing report exist?Users are wanting to run an expense listing report - does anything exist similar to what existed in EBS r12? Or alternatively is there a form where this can be extracted…
-
Data Model Default parameter to current periodOn a Data Model for a report I have a parameter for the period that I would like to default to the current period. The parameter is a Data Type of Date and a Parameter T…