-
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,
-
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…
-
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.
-
'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
-
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 =…
-
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.
-
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 -…
-
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…
-
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.
-
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…
-
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 force URL defined in BIP Layout editor to open in a new window
We need to open a standard application redwood page using the URL functionality in the layout editor. Example target page is: <POD Name>/fscmUI/redwood/procurement/workconfirmation?PONumber=PCOR100010 The above URL is generated fine but always opens in the same window as the report which is not acceptable. If the target…
-
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?
-
Empty columns missing from BI Publisher output in oracle fusion report and analytics
I have developed BIP report with around 60 columns in my query and generated pipe (|) delimited output. However, my output shows only columns which has data and missing all other columns which does not have any data. My requirement is to include each and every column in the output whether the data exists or not. Really…
-
Customization of item structure report
Hello Everyone, Actually ,We are trying to do customize the standard report of item structure report, where we have followed the oracle document to Configure the Template for the Item Structure Report with Additional…
-
Can we write a report to query the "Directory" and "File Name" from report history?
We are checking to see if it's possible to write a query in BIP to query BIP report history and capture the Directory and File Names. Use case is that we need to provide these details to another team so they can validate they picked up and processed each of the files we FTP'd to them.
-
BI publisher Header record displays in Uppercase.
I am generating CSV file with PIPE(|) delimiter and output looks good. However, my header record always display in Uppercase even though I defined as mixed case in the data model query. my requirement is whatever format I gave and should come same format in my CSV file. select FIRST_NAME 'FirstName', LAST_NAME 'LastName'…
-
Possible to display the current and future value of a specific payroll element for an employee?
Hi there, Our business requirement is to produce a BI report that shows the current and future values of a known and finite set of payroll elements for an employee. For example, suppose Employee A currently has a Base Salary and Involuntary Deduction. Following a promotion - effective 30 days from now - the Employee's Base…
-
Calling another template in RTF left-justifies the alignment instead of justify
Summary: Content (please ensure you mask any confidential information): Hi all, I am calling another template within my rtf template and it's working great, but the issue I am getting is that when I run the sub template on it's own, the page is just the way I want it (justify alignment), but when I run the report within…
-
Is it possible to create a data set using REST API as a data source in oracle fusion cloud?
Please suggest solutions to set up an REST API as a data source for a data model in Oracle Fusion. instead of sql query as a data set we need to pull data from rest api data.
-
What is the difference between Uploading a BIP report vs. Archiving a BIP Report
Summary: There are two options to take a copy or get a copy of Data Model and Reports. * XMLPServer and click on Upload/Download * Catalog folder and Archive/Unarchive Content (please ensure you mask any confidential information): What is the difference between these two options? When should we choose one over the other?…
-
There is a way to limit access to specify tables trought customize DM in OTBI?
Hi everyone! We have a requeriment, and we need to know if there is a way to restrict the access an specifics tables in oracle fusion trought customize DMs in OTBI? I mean, create a custom role with access to OTBI and just can query the following tables and not others. FND_FLEX_VALUES FND_FLEX_VALUES_TL…
-
Format table cells in RTF Template like Excel's "accounting" number-format?
If you're like me, you've got a RTF template that contains a table of numeric values, and you've been asked to format them "like the 'accounting' number-format from Excel" — with one difference. I'd appreciate some advise on how to make this happen? From what I can tell, this means: a dollar sign aligned to the left margin…
-
Programming of a Bi PUblisher
Hi, I have problems when programming BI Publisher. I can't get it to add 1 day to the parameter. What I want is that it takes each day, the day of execution as input parameter but it always executes the same day. The day I programmed it. It always executes it with the 30/10/2024. Regards, Iker
-
Adding conditional formating to BI Publisher Pivot table on Excel
Hello Team, I am trying to add conditional formatting to a pivot table I have created on Excel BI Publisher : For this table for example I have added two conditions on the data cell : But when I published this template I can see that only the first condition is applied and so with excel conditional formatting we can only…
-
How do I change de date formats for a non-ISO field in a RTF template?
Hi, I'm kind of new in Oracle-land, and the many fora and places to ask questions are still sometimes confusing, so first of all I hope I'm in the right place at the moment. The issue at hand is: I live in 'nl-NL' and I'm building a template for a confirmationletter for Opera Cloud. In this letter I have several date…
-
Is there a log that contains error details for Oracle Analytics Publisher REST API
I am trying to use the RunReport request but am getting "Request Failed" returned. For testing purposes at this point, the report only returns current time and does not take parameters. Using the same report path, I am able to retrieve the report definition using the Get Report Definition request, so the API is…
-
how to get the underline details of job history in bursiting
Using bursting if we are sending any letter i need to know the details of the against each employee the delivery status Sucess/Failed/Error and the email to which it is delivered.
