-
BI Publisher Sync vs Asynch
We have recently upgraded from BIP V11 to V12 and all our reports appears to be running in Async mode instead of the previous Synchronous mode when we post the URL to run the report into a browser, Is it possible to run in Synchronous mode? Is this a setting somewhere that has been perhaps lost in the upgrade?
-
Issue with Bursting Query in Oracle Report: "There is no data to process" Error
I have created a report in Oracle that outputs data correctly when run on its own. However, when I attach a bursting query and run it through an ESS job, I receive the error: "There is no data to process", even though there is data available. Here is the bursting query I am using: SELECT '1' AS KEY, 'Department Delete…
-
How to layout tables in custom order by RTF
Hi, All I am looking to layout 8 tables per page in RTF, 2x4. The tables should be generated based on the values contained in a single row of the data model, I would like the output in the following order one table on the upper left one table to the right of 1. 3. one table to the left of the next line one table to the…
-
GettingError "ORA-00904:"CPI"CLEARING_CCID":invalid identifier" while running US 1099 Paymentsreport
GettingError "ORA-00904:"CPI"CLEARING_CCID":invalid identifier" while running US 1099 Payments seeded report Need some guidance on troubleshooting this error, Would like to understand the root cause for this
-
How to recover / find who has deleted the data model.
Unfortunately, the data model got deleted. So we need to know who has deleted the data model. Could you please share the steps to check the history of data model.
-
What would cause the same data to be bursted across multiple days?
Summary: We have quite a few Bursting notifications but one of them bursts the same data across two different days. This Notification is a generic email and an excel attachment. The content of the excel is what should be different each day, and has worked without issue previously. We only have one job scheduled and the job…
-
Not able to Print Enterprise Contract Terms in Custom Report as ARTICLE_TEXT is HTML embedded
select ch.contract_number, cab.label||''||caa.article_title article,fl.meaning,cab.document_id,cv.ARTICLE_TEXT from okc_k_headers_vl ch,okc_k_articles_b cab, okc_articles_all caa, okc_article_versions cv, FND_LOOKUPS fl where ch.id = cab.document_id and cab.article_version_id = cv.article_version_id and cv.article_id =…
-
'Print Receivables Transactions' Data Model does not return any Sample Data.
The underlying data model for 'Print Receivables Transactions', ' Transactions Print Data Model', does not return any sample data. I would need this to get a sample XML to create a custom template and for its testing. I tried it for a single Transaction as well and it keeps Processing and eventually gets timed-out
-
Create a conditional area in a pivot table in publisher rtf
Hello Team, I created a pivot table in an rtf. I would like to show the cell of the total by row only if the attribute row is similar (includes or not) to some text. I thought about using the like condition in an if statement, but it doesn't seem to work. This is the if statement that works: <?if@cell:.//H = '01 -…
-
Query for Workflow Details of NIR
Hi Everyone, I am looking for the query to get workflow task details of an NIR. Please refer to highlighted part screenshot for details. I am creating a custom BIP Report for this requirement.
-
BIP Data Source: Secure HTTP Connection
While setting up an HTTP connection in the Data Sources section, I noticed that the only authentication method available is basic authentication. I’m reaching out to see if there are any other options, such as OAuth, that would allow us to create HTTP connections without needing a password.
-
Fusion: Is there a SOAP Web Service to find Job IDs based on a report's Absolute Path
Hi I need to download the output PDF of a report that's scheduled daily, but all I have to start with is the name of the report (or the Absolute Path of the XDO file). Is there an API in the Fusion version of Analytics Publisher that I can use to get the Job ID's of runs of this report? I can't seem to find a link between…
-
Create a donut chart with conditional formatting in publisher RTF
Hello Team, I would like to create donut charts in my RTF report where the measurement is formatted in red or green for measurement below or above a certain fixed value. However, I don't see the possibility, like for classic oracle analytics, to format within the graph. The only solution found consists in creating two…
-
Oracle Language Pack does not working in custom RTF templates even it is installed?
Hello, Good Day! We are customizing the the template of a seeded template but when we re-upload the language pack doesn't work as it expected. Can anyone help me understand why this is happening in the custom templates. Thanks,
-
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…
-
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
