BI Publisher
Discussion List
-
BI Admin role revokation not workingSummary: Hello Everyone, We have assigned a BI admin role to user and it worked fine. It has all the admin privileges. So far so good. We have realized that the user sho…Oracletechnofunctional 32 views 2 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting and Analytics for ERP -
Check BI role as part of standard user rolesSummary: Hello Everyone, Is there a way or query to check which user roles have enherited the BI Admin/BI auther role ? Please help. Thanks in advance. Content (required…Oracletechnofunctional 42 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Account Analysis report returns no data - 2nd year in a row this report has become broken in March.Summary: In march, this report starts returning no data. Runs fine in Jan & Feb. Last year, the SR reported back that the data model had been updated for performance rea…Miriam Rowan 63 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP -
Employee Vacation and Delegation Rules Report is not being translatedSummary: Unable to translate the seeded Oracle report to FRC Content (required): We are trying to translate the Oracle seeded "Employee Vacation and Delegation Rules Rep…Eva Mirzoyan 41 views 1 comment 1 point Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP -
How to create dependent parameter using table valueset for ESS Job?Summary: How to create dependent parameters using a table value set for ESS Job? Content (required): Hi All, How to create dependent parameters using a table value set f…Venkatesan 151 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Table to get user password expiration dateSummary: Table to get user password expiration date Content (required): Hi All, Which table stores the user password expiration date? The user wants to create a report. …Venkatesan 807 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
How to create ESS for custom report in multiple languages?Summary: Suppose a custom report whose layout is already available in multiple languages (multiple xlf files). First I logged in EN language, went to the Manage Enterpri…User_2025-02-11-06-12-35-024 41 views 3 comments 0 points Most recent by Shravan S Kumar-Oracle Reporting and Analytics for ERP -
Is it somehow possible to work dynamically with BIP reports directly in Excel?Content (required): Hi all, Is it somehow possible to work dynamically with BIP reports directly in Excel? Hence, have the layout of the BIP reports with the same parame…Daniel Lundsteen Minke 42 views 1 comment 0 points Most recent by Cezar - Fusion Oracle Support-Oracle Reporting and Analytics for ERP -
OTBI Access and SQL Query ViewHi For OTBI Report Creation - the access is incomplete. Please observe the Create --> Published Reporting and Actionable Intelligence - only two options What all are the…SaurabhSinghal26 41 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Is it possible to generate csv file with column labels of child records even when they don't exist?Summary: Standard BI Publisher behavior is that column labels are not generated for columns of child records when they don't exist. Example: Data Model queries: Data Set…User_2025-02-11-06-12-35-024 31 views 4 comments 0 points Most recent by User_2025-02-11-06-12-35-024 Reporting and Analytics for ERP
-
Customise standard report - new layoutSummary: Standard report which only runs inside Fusion ERP. How to use sample data xml export in Fusion BI Publisher? Content (required): So I have a standard report whi…Robert of STAU 58 views 4 comments 0 points Most recent by Robert of STAU Reporting and Analytics for ERP
-
Customisation of Expense Approval Workflow Notification using BIPSummary Issues persist even while following expense config document step by stepContent Hi,We are trying to implement customized expense approval workflow notifications …
-
How to create a Cross-Tab reporting using BIP Excel TemplateSummary: How to create a Cross-Tab reporting using BIP Excel Template Content (required): Hi, We have a complex report layout and we have to develop it using BIP Excel T…
-
How to restrict custom folder created in dashboardSummary: How to restrict custom folder created in dashboard Content (required): Hi Experts, We have created one custom folder and included all the custom reports in the …
-
Manage Project Sets - Table/Subject AreaSummary: Content (required): Hi I would like to know which tables stores the information in regards to Project Sets that is created in Fusion. I find the manage project …Nicolas Vahman 11 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Report definition not found:/Custom/Financials/Payables/Invoices/****.xdoSummary: I keep getting the Report definition not found:/Custom/Financials/Payables/Invoices/****.xdo error Content (required): I keep getting the Report definition not …
-
Borders are not displaying in Word(.docx) outputSummary: Borders are not displaying in Word(.docx) output Content (required): Hi Experts, We develop RTF with borders, but when we run the output as .docx borders not di…Venkatesan 42 views 3 comments 0 points Most recent by Skolli-Oracle Reporting and Analytics for ERP
-
Digitally Sign BIP report sent to SFTP server using BurstingSummary: Hi Team, Once we set up the SFTP server in fusion as a delivery option, there is a checkbox to sign output. So does it digitally sign the file and it will use w…
-
API to manage BIP Catalog ObjectsSummary: Content (required): We have a CatalogService WSDL to download and upload catalog objects, however, that API asks for passing the username and password in the Bo…Vinay Gharge 31 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
REST API to schedule and run report in Oracle Fusion BIP reportsSummary: REST API to schedule and run report in Oracle Fusion BIP reports Content (required): Version (include the version you are using, if applicable): 22D Code Snippe…
-
Need help in understanding the BIP SQL query (new to SQL and BIP)Summary: Hi Experts I'm new to SQL and BIP reporting. I'm working on one BIP report and I have added parameter to an existing BIP query to filter based on item number, a…Sharmava 51 views 2 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
Invoice History Report for a given supplierHi All Is there any standard report which allows to drill down open closed invoices per supplier and also drilldown to the individual invoices via deeplinks ? Thanks Mur…Murthy Kodavati 12 views 2 comments 0 points Most recent by Murthy Kodavati Reporting and Analytics for ERP -
Customizing Print Receivable Transactions: Invoices ReportSummary: We have this seeded report "Print Invoice Template" (Defaultinvoice.xdo) which has a corresponding ESS job "Print Receivable Transactions: Invoices" which is a …Ashu Raj-Oracle 554 views 8 comments 0 points Most recent by Sahil Makhiza Reporting and Analytics for ERP -
Schedule BI Report > Schedule tab > UTC Time ZoneSummary: Schedule BI Report > Schedule tab > UTC Time Zone Content (required): Hello All, When we schedule a BI Report from the Schedule tab: it seems the Time Zone of t…Bernard T 22 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Need a query to get negotiation approver list in oracle fusionSummary: Content (required): Hello everyone, I need a query to get negotiation approver list in oracle fusion.Please advise! BR, Sushan Peiris Version (include the versi…Sushan Peiris 261 views 1 comment 0 points Most recent by Sushan Peiris Reporting and Analytics for ERP -
Getting warning while creating Content Data setSummary: Getting warning while creating Content Data set Content (required): Hi All, Got a requirement to show attachments in the PO PDF report. So we try to customize t…
-
Where is WF_ROUTING_RULES located? Vacation Rules table?Content Hi, I'm trying to do reports for vacation rules and I have read I can use WF_ROUTING_RULES but or the life of me I can't find where these reside Any clues? Do I …King Jack 269 views 9 comments 2 points Most recent by Divya Mangtani Reporting and Analytics for ERP
-
Period name taken as a parameter tag display in a wrong format in excel outputSummary: Content (required): Hello Everyone, I recently created a BIP report using excel with the "xls" format and using the xml exported, I ,created the report in an ex…Sushan Peiris 146 views 3 comments 0 points Most recent by Sushan Peiris Reporting and Analytics for ERP
-
How to customize Goal workflow notificationSummary: Content (required): Hi All, We have a requirement to customize the Goal workflow notification. we need to replace the word Goal with Objective. Is it possible ?…Venkatesan 22 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
Can we define custom report view in custom reportDear , We have one custom report (SQL query), now our requirement we have to show data as per user login For example if User ABC login report shows only custom Data whic…