-
BI Publisher interactive report row limit
Hello, I have a question about the row limit of an Interactive BI Publisher report. Currently, I get as an output 200 rows, which matches the limit of the Data Model and I would like to know if there is an official limit for this type of output. By checking the community, I came across the thread…
-
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!!
-
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 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
-
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…
-
Need timestamp along with date as input parameter in Oracle BIP report
Hi All, We have a requirement in BIP report where user need to enter the date along with time (hours, minutes and seconds). Does anyone come across similar requirement or any thoughts please let us know. Thanks in Advance Satya.M
-
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…
-
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,…
-
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?
-
How to burst BIP Report output based on a web service based data model
-
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?
-
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…
-
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 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…
-
what are the values passed to dataset in parameter multiple selection in BIP report
-
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?
-
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…
-
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.…
-
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…
-
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…
-
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…
-
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…
-
Repeating a Header When Lines Overflow to the Next Page in an RTF Template
Dear All, I have multiple groups in my RTF template, and when the content of the second group overflows to a new page, I need the header from the first group to repeat at the top of the new page. I have already tried enabling the "Repeat as header row at the top of each page" option at the row level, but it is not…
-
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…
-
Big problem to integrate dinamic images in RTF template
I have a very strange and in the same time big problem when I tried to integrate images (link of images) in my RTF template in BI Publisher. So this is the started situation, I have one Dataset with a field with the link of the image in internet, something like that: "https://link/pippo.png" in the field named FLAG_URL. To…
-
Question On Datasets In BIP
I have created two Data sets as per requirement in BIP but in the child data set I need to give parameter for child data field how before that I have created but it does not filter.
-
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?
-
Using BI Publisher I would like to export a "protected" word document
I have created one rtf file as template for Oracle BI Publisher. This rtf file has been protected in some sections of the document. I would like to have as result of the execution of this report, one word document that is protected in the same sections than the template. I have had as result one word document no protected…