BI Publisher
Discussion List
-
How to increase the query time out in Oracle fusion BIPContent Hi Team, One of report is getting error due to query time out. We want to increase the query time out for this report. Could you please do the needful. Version 2…Jayaprakash Mathakamalli 211 views 6 comments 0 points Most recent by Jayaprakash Mathakamalli Reporting and Analytics for ERP -
Performance of BI GL balances querySummary Performance of BI GL balances queryContent The Attached BI query timesout when executed with just the tree values. I have passed nulls for the remaining levels c…saravana maneeian subhramaniun 63 views 3 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
How to fetch -4 days from to_date without weekend and holidaysSummary Hi, i need to fetch -4 working date from to_date. so here i am using gl_periods table to get start_date and end_date. end date -4 should be my to_date.Content Hi…
-
OTBI dashboard operators link to BI publisherSummary Can we use OTBI dashboard operators in BI Publisher sqlContent We are embedding SQL query based BI publisher report in OTBI dashboard. The OTBI dashboard has an …saravana maneeian subhramaniun 89 views 6 comments 0 points Most recent by Karina Ogata Reporting and Analytics for ERP
-
ESS Job Dependant Parameter LOVsSummary ESS Job Dependant Parameter LOVsContent Hi , I need to create two LOVs for Supplier Name and Its dependent Supplier Site for the ESS Job. Is this feasible ? I ca…Soumya Prakash Parhi 62 views 4 comments 0 points Most recent by Sujan Gutha Reporting and Analytics for ERP -
URL to download expense report attachments from UCMSummary URL to download expense report attachments from UCMContent Hi, I am trying to download the attachments in my expense report from UCM. I was able to fetch the DM_…Shifa Nazumudeen 192 views 8 comments 1 point Most recent by Shifa Nazumudeen Reporting and Analytics for ERP -
Attach Custom List of Value to ESS JobSummary Custom List of Value to ESS JobContent Hi Experts, I have two questions pertaining to ESS jobs and are as follows:- 1) How can I attach a custom list of value to…Sahil_Makhiza 63 views 3 comments 0 points Most recent by Sahil_Makhiza Reporting and Analytics for ERP
-
Anyone has query to link PPM projects with GL in fusion?Summary Anyone has query to link PPM projects with GL in fusion?Content Anyone has query to link PPM projects with GL in fusion?Pradvin Heggar Prabhakar-147626 104 views 0 comments 0 points Most recent by Pradvin Heggar Prabhakar-147626 Reporting and Analytics for ERP
-
Creating Custom Account Analysis ReportSummary Create Account Parameter(Similar to Oracle seeded Account Analysis Report) in Custom BI report(ESS Job)Content Hello, I am creating a custom bI report similar to…User_2025-01-28-02-08-49-904 139 views 1 comment 0 points Most recent by User_QEU3G Reporting and Analytics for ERP -
ExternalReportWSSService -> runReport failing with error 415 Unsupported Media TypeContent I am trying to run a simple report from pl/sql using ExternalReportWSSService -> runReport and it is failing with error 415 Unsupported Media Type. The same payl…Murthy Kodavati 141 views 1 comment 0 points Most recent by Murthy Kodavati Reporting and Analytics for ERP -
Remove zero lines from customer statementSummary Remove zero lines from customer statementContent Hi, I am trying to modify the attached customer statement template to exclude lines where F_amount = 0 Any idea ?Shlomo Elnekave 65 views 3 comments 0 points Most recent by Shlomo Elnekave Reporting and Analytics for ERP -
How to register ESS Jobs in R13 20B?Summary How to register ESS Jobs in R13 20B?Content Hi Everyone, Can you please share your thoughts on How to register ESS Jobs in R13 20B? Thanks, -
Distribution Email List for ESS JobsSummary Distribution Email List for ESS JobsContent Hi Everyone, Can you please share your thought on , how to setup distribution Email List for ESS Jobs? Thanks,
-
oracle.xdo.servlet.data.DataException: ORA-01722: invalid numberSummary oracle.xdo.servlet.data.DataException: ORA-01722: invalid numberContent Hi i have below error in Data model Parameter name: p_JV_NUM oracle.xdo.servlet.data.Data…Mahgoub S.Mohamed 407 views 3 comments 0 points Most recent by Ahmed Mousa Reporting and Analytics for ERP -
Is it possible to link a BIP or OTBI report to an FR report using related contentSummary Recently found that we can drill to a second FR report using related content and the parameters get passed on from the first report cell from which we drill. Exp…Shweta Prithviraj-163613 39 views 0 comments 0 points Most recent by Shweta Prithviraj-163613 Reporting and Analytics for ERP
-
Tracking non-financial information related to a chart of account segment for reporting with GL BalanSummary Does anyone have recommendations for storing non-financial information related to a chart of account segment and related GL Balance?Content We have some non-fina…User_2025-02-04-18-03-15-131 31 views 1 comment 0 points Most recent by ndryden Reporting and Analytics for ERP
-
BI Content MetricsSummary Is Usage Tracking Available for Cloud-Hosted Installs?Content We are looking to track and report on the usage of various BI content we have developed, including …
-
Drill Down in OTBI for code combination balance to journal linesSummary Drill Down in OTBI for code combination balance to journal linesContent Use case: We need to build a report listing all the account code combination balances and…Sumanth Kunimakki-21932 69 views 3 comments 1 point Most recent by Arun Raj Reporting and Analytics for ERP
-
Sourcing data for BI Publisher Reports from External Data sources including Oracle DBCS/DBAASSummary Building a BI Publisher report in Oracle Fusion Cloud ERP that shall source data from Fusion cloud database and some external data.Content We need to build a BI …Senthilrajan V 169 views 12 comments 0 points Most recent by Manjunathan S-Oracle Reporting and Analytics for ERP -
BI Publisher- Watermark with rtf template (should be visible with table) and excel templateContent Hi All, I need your help. I am trying to implement watermark with rtf and excel template. With rtf, I am able to see watermark only on the last page, where data …
-
OTBI Analysis to FTP/MS SharePointSummary Publishing OTBI report to MS SharePointContent All - Do you know if there is a way to send an OTBI analysis to external location like FTP or MS SharePoint server…Hari Thyagaraj 121 views 0 comments 1 point Most recent by Hari Thyagaraj Reporting and Analytics for ERP
-
Parameter not printing in XPT templateSummary Parameter Value not printing on XPT template LayoutContent Hi All, I have created XPT template layout for my data model. I have created text element to show para…Piyush Ojha 123 views 2 comments 0 points Most recent by Karina Ogata Reporting and Analytics for ERP
-
Report to find which users of Expense module have a banking addressSummary Report to find which users of Expense module have a banking addressContent Hello, I need to write a BI Publisher report that lists all users that have access to …
-
Is there any way to run a BIP Data model / Report thru a web service and get the output as a responsSummary Is there any way to run a BIP Data model / Report thru a web service and get the output as a responseContent Hi Friends, Is there any way to run a BIP Data model…Umamaheswara Reddy Karri 75 views 9 comments 0 points Most recent by Murthy Kodavati Reporting and Analytics for ERP -
Budget is not appear in my Analytic reportSummary Budget is not appear in my Analytic reportContent Hello i upload budget by using create budget in spreadsheet from Planning and Budgeting in General Ledger i nee…Mahgoub S.Mohamed 36 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to use electronic signature with the BI Publisher forms ?Summary How to use electronic signature with the BI Publisher forms ?Content Hi, How to use electronic signature with the BI Publisher forms ? what are the basic objects…Shlomo Elnekave 36 views 5 comments 0 points Most recent by Shlomo Elnekave Reporting and Analytics for ERP
-
BI Query to get Difference between Dates in numeric formatSummary We have requirement to get the Average time required to complete particular ESS Job in Minutes or Seconds.Content Here are more details - We need to calculate th…
-
Disable Delete Option in Report FolderSummary Disable Delete Option in Report FolderContent Hello please help me for how to Disable Delete Option in Report Folder . Thanks MahgoubMahgoub S.Mohamed 82 views 2 comments 0 points Most recent by Karina Ogata Reporting and Analytics for ERP
-
"Insert text item" field is extending up to end of frameSummary "Insert text item" field is extending up to end of frameContent Hi I created a BI Report in Cloud. In the heading section of the report, need to display the para…Rama Pedamallu-193980 31 views 1 comment 0 points Most recent by Murthy Kodavati Reporting and Analytics for ERP
-
BIP Report: How can I make default output to open in ExcelSummary BIP Report: How can I make default output to open in ExcelContent Hi Gurus, I am new to reporting.. I have just created a BIP report and I want the default outpu…