-
Create Data Set for HTTP XML Feed type with parameters.
I'm creating a Data Model with HTTP XML Feed type. But not able to define URL Suffix with parameter. Without parameter its working fine but its giving error when define parameter. Rest Endpoint URL {BASE_URL}ESSRESTJOB/1.0/pushBIP?VPARAM1=&VPARAM2=&VPARAM3= Anyone can suggest a solution how to use parameter in URL Suffix.…
-
ORA-00907: missing right parenthesis https://docs.oracle.com/error-help/db/ora-00907/
Hi Folks, One of our client requirement is to develop an "An audit report for Requisition", we develop the report but facing issue while adding parameters in the query , the objective is to allow "Multiple Requisition Number and Last Update Date" parameter in the report, but we get this following error while adding the…
-
How to convert blob data available in oracle workflow attachment table to pdf, xlsx, png etc file
How to convert blob data available in oracle workflow attachment table to pdf, xlsx, png etc file formats
-
REST API for Oracle analytics publisher to Run a report
I am looking for REST API for Oracle analytics publisher to Run a report using parameters. Kindly share me the Request and response xml in details if anyone has available.
-
Page number issue using nested for-each@section in BI Publisher
Hi Everyone, we have a report, for each member, it has two parts with different headers,each part may be across multiple pages, now the report only has one problem, page number are reset for the two parts what we expect is each member has its own page number system, but within the member we require it has a continuous page…
-
How can we join the custom subject area with another table ?
Hi, We would like to import a batch of data from a third party system. So, we plan to store these data in a custom object, and extract the data for FBDI by BI publisher. However, I could not JOIN the custom subject area to the SaaS table in the data model. It appeared that it was not possible because the data sources were…
-
error using data mode property: Optimize Query Execution
Hello everyone, a few days ago I experienced a new situation. I have a report that extracts a large amount of data (over 100,000). I tried to optimize the execution time using a property of the data model. The execution time is faster, the number of records is the same, but for some reason the information varies in some…
-
End User Licensing Agreement for Oracle Desktop Publisher
Hi, Do we have a readily available EULA (End User Licensing Agreement) for Oracle Desktop Publisher downloads?
-
How to get Column headings to repeat across multiple pages
Hello all - I am struggling to setup my RTF template to display a column heading table at the top of each page when there is more then 1 page. I have set the Word Table/Row properties "Repeat as header row at the top of each page" to be selected, and also used the <?for-each@section:to be used just before and after the…
-
Hyperlink URL not opening in new tab.
In the Workflow Termination Report, there is a 'View Attachments' hyperlink. When a manager receives a bell notification via the BPM Worklist and clicks the link, it opens in the same tab instead of a new one. This behavior is specific to bell notifications. Is this a standard limitation in Fusion, or is there a way to…
-
Which table stores the Expense Class in Oracle Fusion
As given in this screenshot, not able to find the table behind for column 'Expense Class'. Could you please suggest in which table we can find this column?
-
for-each@section:DATA_SET do not generates PDF report if no data are found
i am working on a report that has lots of parameters, it could happen that for some parameters inserted the reprot will not extract data to display. i am using @section because i need data to be splitted by CUST_NUMBER. so the report is working fine if soome data are extracted, but if no data are found, report is throwing…
-
While Running Ess Job the report output is not generating
-
Not able to change the Date Format
I am not able to change the date format to YYYY-MM-DD in BI Publisher Web Layout Editor( Currently it is showing YYYY-MM-DDTimestamp). I am getting proper backend output using the Datamodel sql query (in Format YYYY-MM-DD), but the same query in frontend report showing with timestamp.
-
Oracle Analytics Publisher Upgrade to 7.6 (2024) facing Socket read timed out issue.
We recently upgraded several servers running Oracle Analytics Server from version 5.5 to version 7.6 and applied the latest patch. However, after the upgrade, we began experiencing some unusual issues. Prior to the upgrade, certain reports—even those that took up to 3 hours to complete—were executing successfully. After…
-
Adobe acrobat pdf output issue after downloading pdf from report history
I am able to see the pdf outputs in Adobe Acrobat when I executed the report from report analytics screen by using view report option after exporting into pdf output. However the same report I have executed with Schedule option and then downloaded the report pdf output from Report history, when I opened pdf output in adobe…
-
How do I check on my bursting report after I schedule it to run?
Hi everyone, I was practicing with BI Publisher, I created a bursting query to deliver a report to multiple emails. Then I scheduled it to run as a test and it was announced as "success" in Report Job History, but I could not find the report that was supposed to be sent. Since I use LAN network and will send the mails…
-
Error: "Failed to load XML" when extracting from TransactionDocumentExtractDm for Payment Disburseme
I'm trying to extract XML data using the data model TransactionDocumentExtractDm for a Payment Disbursement Report. However, I'm encountering the following error: Failed to load XML. Can anyone advise why this error might occur or how to troubleshoot it? Could it be due to data volume, invalid characters in the CLOB, or an…
-
Oracle Analytics Desktop Publisher and/or BIP Desktop Publisher Installation issue
I am receiving an error message when trying to install Oracle Analytics Publisher Desktop: "Error applying transforms. Verify that the specified transform paths are valid." Any insights are appreciated. Running MS Office 2016 , 64 bit Word. Enterprise license by my enterprise email id. I remote into a stand alone desktop…
-
BIP Report Out of Memory (Can LIMIT display, without affecting Export?)
So I have a large BIP report. I do display paramters, row counts and time all at the top of the report. I want the user to be able to see the report before they export it so they can understand what's on the report and have a sample of information that will be exported. I was wondering if there's a way to display the first…
-
BIP Report works some times but errors out other times
Created a BIP analysis that has both a table and a graph. I have been unable to figure out what causes the error but at random times the table errors out. Below are two pictures. One is what the report should look like, the other is the error with no details. Any help would be greatly appreciated.
-
Get Permissions for All Objects in the Catalog
I'm trying to get for all objects in the catalog. So I can confirm that permissions look appropriate for audit. I've look through this forum and see various responses, but nothing concrete. I've tried to use the API to use the API to do this:…
-
Performance Issue After Joining EGO_ITEM_EFF_B on the basis of CHANGE_LINE_ID. Any solutions?
Hi, I’m working on a query that previously ran within seconds, but after adding the lastLEFT JOIN, the execution time has increased significantly—even for a single change order, it now takes around 2 minutes. The purpose of the join is to retrieve the redlined value for a specific attribute tied to a particular change…
-
How do I preserve parameter visibility settings when migrating BI Publisher reports to a new server?
I was working with Oracle BI Publisher and I came upon this problem: In the Report Editor page, there's a Parameters dialog where you can choose to show or hide specific parameters in a report by checking or unchecking a boxes in the 'Show' column. Let's say I check the first 2 parameters and uncheck the third, I call it…
-
Group Filter set to parameters with default values but no data returns, even though it's there.
I created a Data Model with an Excel spreadsheet. I added a group filter setting the parameter to a value and I even converted it all to strings in the group filter. However, I'm still not getting any results back. What could be the issue here?
-
dynamic footer in RTF template
Hi, i have a requirement to change the footer based on a value found for each customer account, in particular i have to change the language of footer based on language of account. in my template i call the footer with <?call@inlines:footer_content?> and in the footer i have <?template: footer_content?> <?xdofx:if…
-
Unable to compute difference between 2 columns of different data sets in RTF
Hello All, I have 2 fields in my RTF which are the difference values from XML: ORIGINAL_QTY(G_1)-SUM_SHIP_LBS(G_2) ORDER_AMOUNT(G_2)-SUM_SHIP_AMT(G_2) The section of XML looks like this: RTF section: The formulae used for difference is <?xdofx:ORDER_AMT - SUM_SHIP_AMT?> <?xdofx:ORIGINAL_QTY - SUM_SHIP_LBS?> Difference is…
-
Oracle Fusion financials - Unearned amount aging
In Oracle Fusion BIP, for each contract line need to implement event level bifurcation of unearned amount (Revenue amount < invoiced amount) aging calculation in FIFO sequence (here event completion date is considered) based on knock off logic. We would need event by event comparison between fully invoiced and fully…
-
Calendar Templates in BI Publisher?
Hello, Are there any rtf templates available for creating a Calendar in BI Publisher? What about in the BI Publisher plugin for Microsoft Word?
-
BIP Report to Extract Resource Actuals and Budget and expense
Experts, I have requirement to develop a BIP report to extract resource actuals, Budgets and expense. I was able to develop another report to extract this info based on tasks but I am not able to for the resources. Any starters or similar reports would help.