BI Publisher
Discussion List
-
How can we limit access to reports residing in delivered (out of the box) folders?Summary: How can we limit access to reports residing in delivered folders? Most of the users have access to BI roles (Consumer/Author/Admin) inherited through other role…Dibyanshu_Shekhar 42 views 2 comments 0 points Most recent by Dibyanshu_Shekhar Reporting and Analytics for ERP -
Is there a lag period before OTBI displays new invoices/data?Summary: Hi everyone, I am running the Payable Withholding Tax report from Reports and Analytics. Navigation: Shared Folders/Financials/Payables/Income Tax and Withholdi…
-
How to remove ability to Create Shortcut in Reports & Analytics pageSummary: Within the Reports & Analytics page, we do not want users to be able to create shortcuts. How can we remove this ability from users? Content (required): Is ther…Akbar Ahmed 91 views 2 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
Can custom PL SQL TABLE type in Fusion DB be createdSummary: Need custom PL SQL TABLE type in Fusion DB to use in BI report with Data Set Type as Procedural Call Content (required): In Fusion BI Report some complex valida…
-
How to modify a seeded dashboard?Summary: Hi. We need to modify some elements of a seeded dashboard according to client requirements. Grateful if someone could provide standard procedures for modifying …ShailenS 92 views 2 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
how to viewing oracle saas BIP report history based on job id parameterHi Team, When we select the Schedule and submit the BIP report (after entering the job name) from catalog section , Currently the History the Report has Job name , owner…User_2025-07-18-07-26-59-885 304 views 4 comments 0 points Most recent by User_2025-07-18-07-26-59-885 Reporting and Analytics for ERP
-
Is it possible to set up automated reports splitting data by cost centre or spare 1 field?Summary: Business has the requirement of splitting a report by cost centre or spare 1 field and sending to different receipts based on the cost centre. This is to send a…
-
AP_Invoices joins for Supplier Detail where vendor_id is negativeSummary: Sql question, I am looking for ap_invoices_all joins where vendor_id is negative, for the following scenarios; - expense (vendor id = -10016), one time supplier…Robert of STAU 791 views 8 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Identify customer from ar_statement_deliverySummary: How to identify the customer from the ar_statement_delivery table Content (required): I have written a sql in order to identify the customer_name, account_numbe…
-
Data Persistency in Oracle Cloud - how long will Request Ids, Output/log files be available?Summary: is there any time period for which the request ids, output/log files of Oracle ERP Cloud Process/Job/ESS requests are made available? Or Will these be available…
-
Can we get the dynamic url in BI Publisher email notifications?Summary: When we schedule a custom BIP report, and once it is completed then system is sending an email notification with the status. In the email notification there is …
-
Fetch large volume of data in BI publisher reportSummary Fetch large volume of data in BI publisher reportContent HI We have a requirement to extract data for GL code combinations using BI publisher and burst the outpu…ashishgupta0212 687 views 10 comments 2 points Most recent by Alok K Gupta Reporting and Analytics for ERP
-
List of All Tables for Oracle Fusion ERP in PDF FormSummary: We need to have a List of All Tables for Oracle Fusion ERP in PDF Form along with its corresponding descriptions Content (required): We need to have a List of A…Gene Garcia 1.7K views 13 comments 0 points Most recent by Agnes.Ramos Reporting and Analytics for ERP
-
Is there a size limit for email attachment for BI reports?Summary BIP - Report size is 15MB, job succeeds but never sends email.Content My report generates 15MB excel file but fails to email the report every time. I limited my …
-
Extend SQL Query Timeout Interval for BIP Data ModelsSummary: Extend SQL Query Timeout Interval for BIP Data Models Content (required): We would like to understand if the "Server Value" for "SQL Query Timeout" parameter ma…ks1075 838 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Different filename based on a parameter value of report using ESS jobHi All, How to achieve custom filename using report parameter value as part of filename Example: ABC_XYZ_Timestamp.xml or ABC_XYZ_Timestamp.csv ABC is part of the file, …Swapnil Kashid 252 views 7 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
How to move up one node in my xmlSummary: Getting data from one node up of xml Content (required): I have a template that gets the data from node . I need to also display columns from which is one leve…CKleu 11 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
Need help on calculating Hash Total for National Bank of Kuwait EFT templateSummary: is there any ready to use code to calculate hash total logic in oracle etext template to make a payment to National Bank of Kuwait Content (required): Hash tota…SireeshaJaladi 31 views 1 comment 0 points Most recent by SireeshaJaladi Reporting and Analytics for ERP
-
update on subtemplateSummary: 1- i update on Award Approval Notification Report. 2- has template AwardApprovalNotificationBodyReport.rtf. 3- in this template i have multiple subtemplate like…
-
How to download SSH Private Key uploaded in Upload Center?Summary: We need to download the SSH Private Key which was uploaded in the Upload Center of BI Administration. How to download it? Content (required): We need to downloa…Mohamed Iqbal Jahangeer 224 views 1 comment 2 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for ERP
-
How to send the BIP Report Output to Customer without Scheduling Cloud BIP ReportWe need to send BIP Report output to a mail id which is passed as parameter. We have enabled the Bursting it is working. But customer is not accepting to schedule the Re…Muthukrishnan-Oracle 82 views 4 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Having issues with BI Report. Wont pass multiple selections on ParametersSummary: I have the following attached report where when attempting to select multiple parameters such as Expense Status or departments I encounter the ORA-00909 error. …RRR RRR 81 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP -
OTBI login based data will display but user id not matchedSummary: OTBI dash board /analysis based on login user name data will display if user name/display name not matched still they want data using custom session variable to…SivaRamaKrishna-Oracle 31 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to fix envelope section in the first page when there are more than one page output in RTF?Summary: How to fix envelope section in the first page when there are more than one page output in RTF? Content (required): We have a requirement to fix the bottom secti…Abhilash K - Deloitte USI 31 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Calling runReport in xmlpserver/services/v2/ReportService Webservice with SSO enabled user(Azure AD)Summary: Hi All, I am working on calling a BI Publisher report from a custom application using xmlpserver/services/v2/ReportService webservice. The requirement is to use…Sarthak Mohanty 141 views 0 comments 0 points Started by Sarthak Mohanty Reporting and Analytics for ERP
-
Join Subledger Tables to AP_INVOICE_DISTRIBUTIONS_ALLSummary: I'm not sure if this belongs more in the Reporting forums, however I am looking to join any of the following Subledger accounting tables to the AP_INVOICE_DISTR…
-
Can working days be used instead of calendar days in a standard infolet?Summary: Calculate aging period using only working days instead of calendar days. Content: The aging requisition lines infolet in Purchase Orders area of Procurement mod…Ananda Bhargav Potluri 31 views 0 comments 0 points Started by Ananda Bhargav Potluri Reporting and Analytics for ERP
-
How do I get my .csv output columns in same order as ExcelHow do I get my .csv output columns in same order as Excel? Thank you. Esmeralda -
Editing a page using sandbox subjected to a user roleSummary: Content (required): Hi All, We have a requirement to publish the dash boards created using OTBI analysis in the 'My Dashboard' page. However, the published dash…Vipusha Chandrakumaran 31 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Connect Oracle Fusion BI Publisher and Oracle e-Commerce using Web Services Data SourceSummary: Is it feasible to connect Oracle Fusion BI Publisher and Oracle e-Commerce using Web Services Data Source ? If yes, can you provide us with any white paper docu…SUDHIRNARAHARISETTI 41 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP