BI Publisher
Discussion List
-
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 -
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 951 views 1 comment 1 point Most recent by Kumar -Oracle Reporting and Analytics for SCM
-
Reporting on Approval Transactions outside HCMSummary: Is there a subject area or report for Approval Transactions that are not HCM related. I know of the Human Capital Management - Approval Notification Archive Rea…
-
How do I keep a table with repeating elements from breaking across multiple pages?Summary: I am trying to develop a PO rtf template to upload in BI Publisher. When the file runs if the PO is too long, part of the items table that has a repeating eleme…
-
How to create ESS job to invoke multiple BIP Reports in oracle fusionHi All, We have a requirement to burst multiple-report output through the ESS job and this job will be invoked from OIC. Can you please help how we can achieve it. Thank…Arunkumar Ponnusamy 74 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Output BIP Report into JSON formatIs it possible through OTBI BIP report to output into JSON format? -
BI Publisher Notification - PO ApprovalSummary: I have amended the BI Publisher approval but only certain users see the body of the notifications, others just get an attachment and approval buttons Content (p…Robert of STAU 23 views 2 comments 1 point Most recent by Robert of STAU Reporting and Analytics for SCM
-
Manage Internal Supplier Profile Change ApprovalsCannot find Underlying Oracle Tables For The Setup And Maintenance Task - approval management Looking for the underlying Oracle tables for the Approval Management tasks,…NZ-user999 31 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Can we submit ESS job using BIP Report ??Summary: Can we submit ESS job using BIP Report ?? Content (required): Can we submit ESS job using BIP Report by setting data set as Procedural call ? Version (include t… -
Publisher report export to CSV with different columns order when running manually versus schedulingSummary: Publisher report export to CSV with different columns order when running manually versus scheduling. We have a report that runs in the last 4 months scheduled o…Boaz Nurieli 21 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Alex Glose 21 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle BI Publisher Learning Center -
Oracle HCM BIP Report - Employee Hierarchy queryI have a BIP requirement to display the employee details in the report where I need to show the employee details like tree structure. Eg: Manager A has 2 reportees calle…KishoreHari 143 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Human Capital Management
-
How to connect to GL Cubes as data source for MDX queriesSummary: Hello, I am trying to run a MDX query in Fusion ERP. But there are no data sources available. How can I create a data source to connect to the GL Cubes within E…rizk7 13 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Data Security in Custom BI Reports in Oracle Fusion Financials CloudSummary Data Security in Custom BI Reports in Oracle Fusion FinancialsContent Hi, We have lot of Custom BI Reports developed across financials Module ( AP , AR, FA , GL …Udit_Manchanda 493 views 9 comments 2 points Most recent by rahul.gupta.scm Reporting and Analytics for ERP
-
Need to control the access for users from copying/moving BI folders.Summary: Users with BI Author role are able to Move (Drag and drop) the BI folders to a different location. This is causing issues since the report/folder is not found i…Shashikanth Kumar P-Oracle 11 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle BI Publisher Learning Center
-
R12 ERP OTBI subject areas to database tables mapping spreadsheetsSummary R12 Financial and Supply Chain Management OTBI subject areas to database tables mapping spreadsheetsContent These spreadsheets are published by Oracle OTBI Devel…User720640-Oracle 2.1K views 14 comments 15 points Most recent by User_2025-10-31-00-30-05-350 Reporting and Analytics for ERP -
Print Receivable Transactions Report Custom templateSummary: Print Receivable Transactions Report Custom template Content (please ensure you mask any confidential information): Hi All, We customized the Print Receivable T…
-
How to add sequence number & date in BI excel templateHi, I have developed a Data model and attached an Excel template in BI. I am able to generate the data as expected. However; we have a requirement to add a sequence numb…Madhu A 451 views 2 comments 1 point Most recent by Manoj venishetti Reporting and Analytics for ERP
-
Recommendations to generate a delimited output over 5GB in FusionAre there any recommendations to generate a delimited output over 5GB without timeout and going into error using a report in Oracle fusion. Currently we are generating e…Abhilash K - Deloitte USI 11 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for ERP -
Query to fetch accounting period on project cost page in fusionSummary: Query to fetch accounting period on project cost page in fusion Content (please ensure you mask any confidential information): Hi Team, I am looking for query /…Nidhi Chhajed 638 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Excel output with Multiple sheets with hyperlink for cross-sheet reference BI Publisher ReportSummary: Hi , I have a specific query regarding the feasibility of a dynamic feature: Is it possible to enable a function in BIP's RTF/Excel template where, upon clickin…Sanmati Patil-Oracle 33 views 1 comment 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
Date format issue in RTF formatSummary: We're trying to pass the date period filter criteria to the RTF template as MMM-YYYY, but it keeps coming our as a five digit number. Documentation reflects tha…Jason Parker 13 views 1 comment 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
How to create a BIP Report in excel with a drill down option?Summary: I would like to create a BIP Report of the list of the BPAs. Click on BPA I would extract the list of the POs linked, click on PO I would extract the lines and …Giuseppe Galluzzo 11 views 2 comments 0 points Most recent by Giuseppe Galluzzo Reporting and Analytics for ERP
-
Client requesting data to be not split into multiple sheets in excel or rtf templateSummary: Our client is requesting that the output does not be split into different sheets if the count of records are more than 65K in Excel and 1M in RTF while generati…Abhilash K - Deloitte USI 1 view 0 comments 0 points Started by Abhilash K - Deloitte USI BI Publisher Learning Center
-
Is there an excel template based report delivered by Oracle in FusionHas Oracle created any report with excel template inside Fusion Applications?Abhilash K - Deloitte USI 2 views 0 comments 0 points Started by Abhilash K - Deloitte USI BI Publisher Learning Center
-
Custom report using BIPSummary: Can BIP be still used for custom report creation in ERP cloud. Should BICC be leveraged for custom reports? Content (please ensure you mask any confidential inf…Sajeena 81 views 8 comments 0 points Most recent by Hitesh Jasuja-Oracle Reporting and Analytics for ERP
-
Scheduled process listWe would like to know the list of ESS jobs are scheduled with start date, end date and email address of users. Oracle suggested to get the time using Oracle customer con…
-
Table name for auto provisioning data access setsWe have configured data provisioning rules for data access sets. While trying to download all the auto configured data sets rules, its downloads only 10% of the rules an…Vijay Ramani VJ 61 views 3 comments 0 points Most recent by lsriramakumar Reporting and Analytics for ERP -
Need to find Parameter details which is used while running report in Audit TablesHi Team, I am trying to build an audit report for BI Reports but I am unable to get the column for parameters in the audit tables. Can you please confirm if this is stor…Shubham Khandelwal - Accenture 43 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
How to generate XML Positive Pay File in COS payments formatSummary HSBC bank needs XML Positive Pay File in COS payments formatContent ERP Cloud customer is engaging with HSBC for payment processing. Customer will continue to pr…Sujay Kamath 272 views 8 comments 2 points Most recent by User_BGHTM Reporting and Analytics for ERP