-
BIP Report in Oracle fusion not generating output when XML bursting is used in excel template
Hi All, I've designed a BIP report using excel template as layout. I wrote XML bursting query to send the output to an email address. Observed that when I use excel template as layout, bursting query is not generating any output file. I can just see the XML tags in XML diagnostics being generated with data. But no excel…
-
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:…
-
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…
-
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…
-
Got the message about tbaddin64 add-in.
Hi, Last week I got the message while opening Word. Word is running into problems with the tbaddin64 add-in. If this keeps happening, disable this add-in and check for updates later. After disabeling it, I am not finding BI Publisher icon in the ribbon.
-
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…
-
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…
-
Issue with a BIP report output, where column headers & column values are mismatching
Hi All, I am facing an issue with BIP report output where The column header and column values are mismatching. Example : A column Posting_Date the expected value is a date but i am getting a text. Further I noticed that when we remove the Description column from report logic the data mismatch issue is not there, but we…
-
Dynamic image in RTF template in BI report Oracle fusion
Summary BI Report should grab the signature in run time Content how to call image from content server in rtf template? is there any way we can create RTF template without any image stored and also in run time it should pick the image ?
-
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…
-
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…
-
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?
-
can we able to create, update, delete data from oracle BI publisher 12c
Hi All, is there any way where we can create, update, delete data from oracle BI publisher 12c tool? something like write back data to table option in Oracle BI publisher 12c. Thank you, Joe
-
How to set parameter default value to null in BIP 12c
Summary How to set parameter default value to null in BIP 12c Content Hi I am using Oracle BI Publisher 12.2.1.2.0 (build:20160906.0632) . I have a parameter named ‘Spec’. Its Data Type is String. I want to set its Default Value to null. When I input null to the Default Value field, the value actually is ‘null’. Would you…
-
Change excel sheetname ( BI Publisher - Excel template 12.2.1.3)
Hi, We have a multi-sheet excel template report which is working fine. There is a requirement to change the sheet name at run time. Sheet name is based on department name. However business wants to change one department name sheet to a specific name. Tried using replace command it's not working. Error:…
-
Page Break function not working for excel(MHTML) output format
Hi Team, The customer wants to redevelop the Excel template report (with multiple tabs) into an RTF template, as the Excel template only displays 65K records per tab. We have developed the multi-tab report using the RTF template. In the RTF template, we used the page break option to split the data into multiple tabs (data…
-
How to join price list tables with price strategy and customer site details
i have below tables from price list and price strategy qp_price_list_items_int ,qp_price_list_charges ,qp_tier_lines ,qp_pricing_strategies_tl I want above tables to be joined with below customer site and account tables hz_cust_acct_sites_all ,hz_cust_site_uses_all Let me know if there is any joining condition between…
-
A BI Report data model have two data sets with one data sets not returning data
I have a client requirement, a BI report having two data seta when one data set does not return data. The report should not generate output for one data set and send email with one data set output to the. Please help I need it urgent I am in middle of UAT.
-
OAP 7.6 with Ukrainian localization is inoperable
In the process of evaluating OAS 2024 with Stack Patch Bundle 7.6.0.0.241009 we noticed that Analytic Publisher is inoperable with Ukrainian localization. Browser's console for the xmlpserver/servlet/home page shows this errors: Uncaught SyntaxError: Unexpected identifier 'язкових' (at jstrans.jsp:229:58) Uncaught…
-
OAP 7.6 Execel output with several tabs
Hi Community, I need to generate an excel output from my application database with several tabs, each tab containing a different kind of report. Is that doable with OAP 7.6 version and how. If there is a link on the documentation, this would be definitely useful, cannot find it easily. Thanks for support and guidelines. Jf
-
OBIEE 11g- BI Publisher running the scheduled reports even Scheduler service is stopped
We have OBIEE 11g installed and we have a lot of reports in BI Publisher which are also scheduled via Scheduler. Recently we have cloned our Production Environment to a Test Environment for some upgrade activity. However, all the scheduled jobs in BIP in Production started to run from Test Env as well. We have stopped the…
-
Oracle Analytical Publisher desktop installation fails with 'Install DIR get failed'
We are trying to uninstall a previous version of Oracle Analytical Publisher Desktop and install a new version for 64bit. The installation is failing with 'Install DIR get failed'. We do not have Admin rights on our computer. So our desktop support group logs into our laptop with Admin role and is trying to install this.
-
Date Display as "Date Format" but not "Text Format" in Excel output
Hello there, The report has assigned the "requested date" as "DD/MM/YY" format while it is showing as "Text" in excel output. Is there a way to change it as Date format in Excel ? Thanks, Jason
-
Oracle Fusion BIP SQL using BIPUBLISHER_V to pull data from Audit Tables via BIP for custom reports
Hi Guys wp-fusionbipaudit-5459609.pdf I saw a very old post relating to using BIPUBLISHER_V, quoting the PDF attached, but would like to know if this is still relevant for the latest versions of Oracle Fusion BIP SQL and the use case we have? Basically we would like to build a custom report for our users showing changes…
-
Export BI Publisher Report in CSV Automatically
Summary Export BI Publisher Report in CSV Automatically Content Hi Gurus, I noticed in my BI Publisher (12.2.1.2), if I tried to open the report in PDF it will download automatically. But when I opened the report in CSV, it will display the output in the browser instead of downloading the report. So I need to do Export >…
-
Pivot functionality in excel template does not work when the number of data rows exceed 65K
We are using excel template pivot functionality to develop a costing report. Oracle supports only xls excel template and this is causing issue when the number of data rows exceed 65k limit. Is there a workaround to achieve pivot functionality with filters and drill down option without using excel template.
-
Add a signature stored as an image to a report
Hello, The user wants to store an Image in a DFF, then call the image in the report. The image is the signature of different employees. Based on the employee different signatures will be called. Is there a specific way to do this in BI Publisher?
-
How to add Hyperlink in SQL for Bursting in BI Publisher
Hello, I would like to ask if someone from you encounter of adding a hyperlink in the message body for bursting in BI Publisher. Delivery Channel is Email with the following Parameter values: PARAMETER1: Email Address PARAMETER2: cc PARAMATER3: From PARAMETER4: Subject PARAMETER5: Message body - this contains the text with…
-
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
