-
BI report email delivery is appending domain name to invalid emails
We have a custom BI report that we are using for sending emails by bursting. We are facing the below issue after 24C upgrade. provided email is xyz@abc This is an invalid email address. So, the delivery should fail and delivery status should be warning or error. (this was the behaviour before 24C upgrade) But email getting…
-
Scheduling a BIP Report failed but ESS job with same BIP report is going to success
Hi Team, Is anybody faced issue in scheduling BIP report which leads to failure with below error. Job processor caused exception [INSTANCE_ID=bip.bi_server1] [INSTANCE_JOB_ID=79688] Error getting report data [INSTANCE_ID=bip.bi_server1] oracle.xdo.servlet.scheduler.ProcessingException: Error getting report data…
-
Run report using Rest API - /services/rest/v1/reports/{reportPath}/run
We are trying to run report using Rest API - /services/rest/v1/reports/{reportPath}/run. But we are facing an error - 404 Not found. URL used: https://host.com:port/xmlpserver/services/rest/v1/reports/Custom%252FServices%252FInterface%252FReports%252FFXX_TECHNICIAN_PROFILE_RPT/run Headers: Content-Type:multipart/form-data;…
-
After Create trigger is not working in the custom object triggers in Fusion
The script works correctly in the Before Insert and Before Update triggers within the custom object, but it is not functioning as expected in the After Create trigger within the Application Composer. Could you please help correct this issue?
-
what are the values passed to dataset in parameter multiple selection in BIP report
-
How to edit the sales order Report data model
I want to add new columns in the sales order print dala model. But I found out that the data model is not in sql but in XML format. When I downloaded the file it is in .xmdz file extension, which not opening in readable or editiable mode. Please help me in finding a way to add new columns in the data model of sales order…
-
BI Publisher Reports Roadmap
Summary: Is there a roadmap published by Oracle on the BI Publisher Report roadmap. Content (please ensure you mask any confidential information): I have seen documents where it is recommended that BI Publisher is used as a reporting tool only and not for data extracts. But I am sure there are many customers who use BI…
-
OBIEE 12c in RHEL 8 Text Messages not visible in dashboard
I have used conditional report to display some text messages in the dashboard. Conditional report is working fine and returns results as expected when directly placed in the dashboard. But when conditional report is used in the condition, and I am trying to display some text message using Text option in one of the…
-
How to call BIP report using REST API?
Hi all, we want to call BIP report using rest api service, we were able to call it using soap using the Basic Auth however when using the rest api it's saying 404 not found. This is the URL we are using <base URL>xmlpserver/services/rest/v1/reports/Custom%252fIntegration%252fITEM_DETAILS_REPORT/run Content-Type as…
-
Field is in DM but not showing on BI Publisher to add to template
I'm trying to add a field to a BIP report and the field is included in the DM. When I open the template and access BIP and select field to add it to the template the field isn't available as an option. Does anyone have any troubleshooting tips on how to get this field to display?
-
How does the last update date of seeded reports and dashboard of change
Hello, During our audit review of BI reports, we came across seeded reports which show a different last modified date than our system upgrade date i.e., from 23A to 23B, etc. I checked on Oracle support, but not able to find anything that says the reports were last modified as part of certain patch. Is there any way I can…
-
csv export in BIPublisher without Column Headers
Hi Experts, by default, csv export in BIP gives all data inclusive of all columns and their respective headers. However, is there a way that csv export generates file only with data without any column headers? I understand we can achieve the same using eText templates. However, I want to have the output in csv format only.…
-
Report Ends with "dummy file is deleted" error
Hi all, getting above error when tried to execute the ess job for bursting query. Kindly suggest what to do???? I tried below solution also but not working Report Ends with "dummy file is deleted" error when I scheduled the report it is getting failed in BI also and in ESS job also. why I am getting this failed status Here…
-
How to print salary amount in Latvian and Estonian in BI Report?
We have a requirement to generate Employment Contracts for Latvian and Estonian employees. We got everything to print in the letter except the salary amount. As per requirement, we need to print Salary Amount in words (in Latvian and Estonian). We are using this word function to translate and it is working for other…
-
Oracle BIP Report Not Summing
I need your help in my RTF template that has a sum for every each segments. * I added the field in the cell, set the Calculation to Sum and checked the Grouping. * Generated the report and it's giving "0.00" in value instead of 5,149.999.96 (DEBITS Column) Here's the report layout: I would appreciate any help. I'm not sure…
-
Oracle BI Publisher Notification for Job History email content is having incorrect URL
We moved the platform on-prem from 12.2.1.4 to OAS 2023 and performed the xmlp migration script "/bip_12c_scheduler_migration.sql" . The small problem is that the content of the job execution result email , the url is of the old 12.2.1.4 and not of the OAS. Job Name : Population Job Job Executed Date : August 7, 2024…
-
Is it possible to fetch dynamic columns based on lookups in BIP report for aging purpose
I had a requirement to have a different set of buckets for inventory aging reports, is this achievable?
-
Can we get ZPL output for Zebra Printer from Oracle BI Publisher
Summary: We need to get ZPL output for Zebra Printer from Oracle BI Publisher. Is it possible to get that. Please advise. Content (please ensure you mask any confidential information): We need to get ZPL output for Zebra Printer from BI Publisher. Is it possible to get that. Please advise. Version (include the version you…
-
How are BIP emails for scheduled jobs being marked as Important?
I do not see a setting in the scheduler to mark a report job via email delivery as 'Important' but some of my scheduled reports are showing high importance in outlook while others do not. Is there a way to change this? I'm not sure how some are marked important while others are not?
-
Impact of enabling Audit for BI Publisher
I would like to understand the potential system and performance impact of enabling audit logging for BI Publisher in our Oracle Fusion environment. Specifically, I am interested in knowing if enabling audit logging for BI Publisher affects report performance and if there are any other impacts on the system, such as…
-
Is is possible to invoke OIC (APP driven orchestration) from BIP report?
Hi, We have a requirement to invoke an OIC (APP driven orchestration) from an ESS job via BIP. Please let me know if this is possible and anyone has achieved it. Doc ID 2642375.1 says that Oracle doesn't support RESTful data sources. I have tried this by following steps mentioned in this blog…
-
Cloud Fusion BI Publisher - Ways to confirm if the email from bursting was actually sent out or not.
1. Is it possible to retrieve BIP jobs ( bursting execution log ) backend if the Job is no longer available from the BIP Job History page ? 2. Is there a way to enable ( some kind of tracing ) for report bursting/delivery to be able to gather additional information ?
-
How to pass parameters in RunReport on OBIP using REST API or SOAP
I am able to get a valid output on both rest and soap when I dont add the parameters to the request On the SOAP, I get the On the REST API, I get error code 400 when I try to add the parameters to the curl Can anyone assist with how the sample payload with parameters
-
BI SFTP connection no longer working due to Key Exchange Algorithm Deprecation
One of our SFTP delivery configuration in Oracle BI Publisher has stopped working due to deprecation of diffie-hellman-group14-sha1 SSH Kexs on the target server. Error message: Could not establish connection. oracle.xdo.delivery.ssh2.SshException: Timeout waiting for response from server As per Oracle docs,…
-
Using SSO connection with On Prem Essbase connection
We created a connection to our Essbase source using the BI Admin tool (rpd) and were able to successfully create a subject area and build visualizations within OAC. To create the Essbase connection we used our ADMIN credentials that has access to all data. Our security requirement is that we need to use Essbase user data…
-
executeUpdateTemplateForReport Failure: user has no access to report
My use case is that I'm creating a way to download a template (which I can do), but then user can make changes to the RTF and update the template. The download is fine. I'm trying to use ExternalReportWSSService to update a template The response, below is "user has no access to report". <env:Envelope…
-
How to use if statement for comparing dates in BIP template
Summary: How to use if statement for comparing dates in BIP template Content (please ensure you mask any confidential information): I have customised the Customer Statement Data Model to show me the apply_date of the payment. Now I wish to show payments only where the apply_date is before the statement_date. I have put in…
-
Inquiry Regarding Dynamic User Inclusion in Report Emails via Bursting
Summary: Hi Oracle Experts, We have received a request from our users to include the username of the individual executing a report in the email body after the "Thanks" section within the bursting logic. This inclusion should occur dynamically whenever a report is executed, whether through a scheduling job or an ESS job.…
-
How to override existing the BIP report using Webservices
I'm attempting to use CatalogService's updateObject() Method to override the current bip. As a result, when the report is opened, it displays the error message "Failed to load <Absolute path>/<object name>". Could you please help on resolving the issue. Thanks in Advance!!
-
Creating a pivot table on RTF Template with dynamic sheets
Hello Team, I am trying to create a pivot table with the following fields: Source, Year, Month, Measure. I would like to generate the output in an excel format to visualize the year as separate sheets, maintaining the pivot format with source on the rows and the year in months on the columns. However, once the pivot table…
