-
How to create a hyperlink to another sheet within same excel -BIP report Excel template
Summary: I am trying to create an Excel template in which there are 2 tabs. One will have budget control balance details and other sheet will have PO details. Expected functionality is 'If we click on resource name in sheet1, it should navigate to first instance of same resource name in sheet 2. Content (please ensure you…
-
RTF Template Requirements for PDF Generation
Dear All, I have two requirements concerning the RTF template for a PDF-generated file: 1- A table should appear in the header of each page in the PDF, where the data in this table is related to a "group by" block. 2- Pages should be numbered based on the "group by" block. For example, if a segment has 8 pages, the pages…
-
Migrating from BIP 12c to OAP 7.0
Hi there, I'm reaching out to the community to see if anyone has encountered this scenario and to learn the best way to handle it. Your suggestions are greatly appreciated. Currently we are using BIP 12c which is integrated with Siebel for Reporting. We are migrating from one OS to another (from Windows Server 2016 to…
-
BI Publisher RTF Template, the Tag:"if then else" create return carriage in Word, I do not want them
BI Publisher RFT Template, I am using in a table some images, for one row of this table I have one image after the previous one, 17 consecutive images. The visualization of this image are conditioned by the use of if TAG: <?if:number(B1_SDG_1)=1?> image<?end if?> <?if:number(B1_SDG_2)=1?> image2<?end if?> etc etc for 17…
-
Migrating from BIP 12c to OAS/OAP 7.0
Hi there, I'm reaching out to the community to see if anyone has encountered this scenario and to learn the best way to handle it. Your suggestions are greatly appreciated. Currently we are using BIP 12c which is integrated with Siebel for Reporting. We are migrating from one OS to another (from Windows Server 2016 to…
-
SQL code runs fine in SplashBI SQL Connect tool but times out in Oracle BIP Data Model
Hi all - I have a SQL query that runs within a few seconds in my Splash BI (SQL Connect) query tool, however when I use this same code in the Oracle Data Model in BIP it runs for a long time and then eventually times out. I am honestly stumped by this and would appreciate any insight as to why this is happening. I have…
-
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…
-
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
-
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…
-
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…