BI Publisher
Discussion List
-
How does user level data security work in Fusion Financials BI PublisherSummary: Trying to confirm if I understand the correct way data security works for BIP reports in Fusion as its not working as expected Content (please ensure you mask a… -
Schedule BIP report only when it has DataSummary Schedule BIP report only when it has DataContent We have one requirement for BIP report where we have schedule BIP report daily. so we need that if report data i…User_2025-02-07-23-45-47-870 501 views 7 comments 1 point Most recent by User_A19YQ Reporting and Analytics for ERP -
Slowness of report after upgrade to 23DSummary: A report which ran in less than a minute in 23c is taking 12 mins to complete for the same data post upgrade to 23D. We had 23D upgrade in all non-prod PODs and…Abhilash K - Deloitte USI 41 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP -
segregation of access within BI Reporting (Reports and Analytics)Summary: Requirement to segregate the access in Reports and Analytics such that user who can deploy the reports to PROD, user who can manage the reports (edit/delete) an…
-
How to merge customer names with transactions in a grouped SQL query?Hello, I have this customer ABC having multiple transaction i want to merge the cells that have the same customer name and make it appear one time, i am using select fro…Omran Zeaiter 31 views 1 comment 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Burst to multiple destinationsSummary: Burst to multiple destinations Content (please ensure you mask any confidential information): Hello - We use Fusion BIP application for ERP. I wanted to know if…
-
Budgetary Control Analysis ReportSummary: Control Budget parameter search does not return all project numbers in the Oracle seeded BI Publisher report Content (required): We have a user that runs the se…
-
Custom report for Invoice approval workflow detailsSummary: Custom report for Invoice approval workflow details Content (required): Hi All, We got a requirement to develop BI report to show AP Invoice approval details li…
-
Budgetary Control Purchase Order Life Cycle Custom ReportSummary Use this report to analyze a purchase order life cycle and its impact on budgetary control balances.Content The Budgetary Control Transaction Life Cycle report i…Anne Wong -Oracle 195 views 1 comment 5 points Most recent by Mr.Bilal Reporting and Analytics for ERP -
Sales Order Lifecycle ReportI am looking for end to end O2C lifecycle details in report. Do we have any sample report report with this requirement ? Below are the columns I am looking into it. Sale…Oracletechnofunctional 71 views 3 comments 1 point Most recent by Renganathan V Reporting and Analytics for ERP
-
Not able to execute report from "Financial Reporting Center"Hi, I have developed a custom report and able to generate the data without any issue if i run from "Report And Analytics" but report execution is failed from "Financial …Madhu A 1 view 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
What are the Table names for fields "Other Communication Accounts" and "Order of Preference"Content (please ensure you mask any confidential information): What are the Table names for fields "Other Communication Accounts" and "Order of Preference". Need to fetc… -
Rest API to GET reports from BIP in Fusion Financials SAASSummary Is there a Rest API to get BI Publisher reportsContent Hi All Is there a Rest API to call BI Publisher reports from Fusion Cloud Financials within SAAS financial…
-
Republish option not enabled in scheduled BIP reportsIn some of the scheduled BIP reports with excel template, the 'Republish' option is not enabled. Even after checking Save Data for Republishing, clicking on 'Republish' …Sharmava 61 views 2 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
How to get list of custom BI and OTBI Reports in FusionSummary How to get list of custom BI and OTBI Reports in FusionContent Hi, Do we have any standard ESS job or tables which can give us below details of custom report: Na…Nidhi Chhajed 1.3K views 8 comments 0 points Most recent by Arun Raj Reporting and Analytics for ERP
-
Sample query for Project BudgetsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to add Hyperlink in Footer of RTFSummary: Hi team, We have defined a lookup where we are storing links, from the data model we are fetching xml tags and using it in rtf to dynamically change link. when … -
How to remove Contract Template PDF Cover Page?Summary: How are we able to completely remove/delete the cover page on the contract template PDF page? We were able to remove the signature lines on the last page but ha… -
Create Rules XML File for BI Extender Automation - NO LOVwhen i run Create Rules XML File for BI Extender Automation program, its not showing in any LOV in parameter, role is already assigned to user What could be reason ?Sandeep Nihalani 113 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Inventory valuation Report (As of Date) - DepericatedWe had Oracle delivered Inventory valuation Report which used to run by parameter as of date. We were using it extensively. Unfortunately Oracle has depreciated this rep…Oracletechnofunctional 191 views 4 comments 0 points Most recent by Adarsh.Kumar Reporting and Analytics for ERP
-
Custom FolderSummary: We have created a folder named "Reports " - it is not in the custom folder - will this folder be preserved when doing an upgrade or do we need to put all custom…Vinayak Walse-Oracle 61 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
formatting currency through DM or RTF?Summary: when customizing a DM and RTF, I need to format the currency into $****,****.XX format. Content (please ensure you mask any confidential information): Should I … -
Image in BI Publisher template spills into attachment when sent to e-mail outputSummary: Image in BI Publisher template spills into attachment when sent to e-mail output Content (please ensure you mask any confidential information): In BI Publisher …Robert of STAU 41 views 7 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Need to convert string into hash valueHi, I need to convert 'AKEBSTEST-700(2.1)' string into hash value i.e '561956564' using sql or Plsql. Is any function we can use to convert this value.vikram khengare 31 views 3 comments 1 point Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Need Custom Advance Shipment Report fileSummary Need Custom Advance Shipment Report Sample fileContent Need Custom Advance Shipment Report fileNageshwaran1 28 views 1 comment 0 points Most recent by Mahmoud Abdulghany Reporting and Analytics for ERP -
SQL query to get transaction date on statement lin, joining CE_BAT_TRANSFERS with CE_STATEMENT_LINESI'm trying to create a query where I want to find the transaction date of an Internal Bank Transfer. The goal is to create a report which is used for reconciliation of b… -
Can I change bip:AUTHOR on a saved BI report?Summary: Is it possible to change the bip:AUTHOR value on a saved BI report? Content (required): I want to make some reports public that I've exported to a .CATALOG file…JimCC 82 views 5 comments 0 points Most recent by Shanmugaraja_Karunamoorthy Reporting and Analytics for ERP
-
Is there a size limit to extract data from Fusion ERP?Summary: We will extract data out from Fusion ERP using BIP, BICC to Data warehouse. Is there a data limit? Will Oracle charge for outbound (egress) traffic? Content (pl…Jie Shen 142 views 3 comments 0 points Most recent by Madhavi Godbole Reporting and Analytics for ERP
-
Generate file name at runtime with respect to parametersSummary: I want to get Report's output where i want to generate name of output report with respect to User Input Parameters against the same Bi Publisher rtf Report. Con…
-
Custom BIP Report Dynamic Column IssuesSummary: The requirement is to print the output in below format: For each period, there should be a row and corresponding value in dynamically generated column. Ex.- For…