-
Unable to install BI publisher plug in in my windows
Receiving errors Word 2007 flg get failed and 64 bit failed while i am trying to install BI publisher 64 bit in my windows system. Any help would be appreciated.
-
How to Restrict Infolets for Business Unit(BU) created under Analytics in Oracle Fusion.
How to restrict the Infolet for Business Units is there any EL expression for this? I trued to restrict it's Visibility for Role using EL Expression and it's working i.e #{securityContext.userInRole['ROLE_CODE1,ROLE_CODE2']} Same way how we can restrict it for particular Business Unit? Here is the image of infolet: Please…
-
Error while trying to login to report server using BI publisher tool
I am trying to login into test instance
-
SSH key format - do we need to update?
Hi - we needed to convert our SSH private key to the new format in order to load into one of our dev environments. Do we need to update our production key (it's still aes256-cbc format - we uploaded it in 2019) it still works in prod. thank you.
-
Hi, how can I ensure the space infront of the word " certificate" remains when the pdf is rendered?
<?FOR-EACH@inlines:row_RU_FOUNDATN_WRK?><?IF@inlines:fld_DESCR254A!=''?>and <?fld_DESCR254A?> certificate<?END IF?><?END FOR-EACH?>
-
RTF file Configuration for Eliminating Null Value Column
I am creating an RTF file using Word table with 3 fixed columns and another 4 columns that I do want to show the non null columns If a column is totally null values i don't want to show, is that feasible ?
-
Aloha Analytics Community
My apologies as I come here to ask you this. Perhaps it will she some light to some of our company experience with Oracle. We are a WACS customer and so far no Oracle person I spoke to has been able to tell me where in the Cloud (Identity - Domains) I can find the User permissions for BI PUBLISHER. Do any of you know this?
-
How can we add the filter parameters 'from and to date' in etext formate
Hello, We are attempting to add filter parameters, specifically for the "from" and "to" dates, to a BIP report created using an eText template. However, we are currently unable to incorporate these filter parameters into the eText layout. Could you kindly assist us with this? Thank you.
-
Cannot handle Null cells in calculated columns from layout editor in BIP
We are creating a report using two data set - one is SQL based and another is loaded from excel. Using layout editor we are trying to create a calculated column subtracting where col2 is from excel data set and col1 from sql data set, where in a cell in col2 the value is null and there is corresponding value in col1 but in…
-
BI Publisher management of multiple simultaneous exports
I have to send several times a day about 50 exports at the same time. I have a question and a problem. Is it possible to program schedules by script? It's hard to do them manually and especially the changes. Each time, the 50 exports open and close an SFTP connection to send the report. Sometimes, a few exports get wrong…
-
Bi Publisher - add x days to a date element in rtf template -FA24D
What is the function to add one day to an RTF Template? Below function is not working for me in FA 24D <?xdoxslt:ora_format_date_offset(YOUR_DATE_FIELD, 1, '+')?>
-
Ship-to ID's Not Populating In RA_CUSTOMER_TRX_ALL Table
Hi All, I can see RA_CUSTOMER_TRX_ALL table has all SHIP_TO Columns populated with NULL values. Have used SHIP_TO_PARTY_ID's to get SHIP TO information as per the oracle document (Doc ID 2377015.1), but the issue is that one party is having multiple customer accounts. unable to identify the exact ship to customer. Please…
-
How to edit the sales order Report data model
I want to add new columns in the sales order print dala model. But I found out that the data model is not in sql but in XML format. When I downloaded the file it is in .xmdz file extension, which not opening in readable or editiable mode. Please help me in finding a way to add new columns in the data model of sales order…
-
Query to find the tax Reporting code using the tax rate from zx_lines?
The tax Reporting Code is in the table - ZX_REPORTING_CODES_B I need help on how to join this table with zx_lines, or join tax rate with tax reporting code?
-
Encoding type of BI Publisher
Hi, My report has been encoded in UTF-8 BOM, and the customer wants UTF-8 not BOM. Is there option to change the encoding method? how can I do it? Thanks all!
-
BI Publisher 12 > update an XLS template, only the RTF format is offered
Hello, I have been working with BIP12 recently, I want to update an Excel model, but only the RTF format is offered. When I create a new model, the Excel format is suggested. Do you know where the problem could come from ? Thank's
-
Need details or white paper for the function per_availability_details.get_schedule_duration
We need details on the parameters used in the function per_availability_details.get_schedule_duration. Any document or white paper or any clue regarding the details of the parameters is appreciated.
-
How to use if statement for comparing dates in BIP template
Summary: How to use if statement for comparing dates in BIP template Content (please ensure you mask any confidential information): I have customised the Customer Statement Data Model to show me the apply_date of the payment. Now I wish to show payments only where the apply_date is before the statement_date. I have put in…
-
RTF XDO_METADATA setup not working despite mirroring other setup that is working
Summary: We have customized an RTF to where the results are broken out into different tabs. We used the same for each loop as the other tabs, but the new tab is putting all results in a single row instead of one row per record. Content (please ensure you mask any confidential information): Why is this happening? How do we…
-
OAC BI publisher security setup
Hi All, We have a Oracle DB schema with sensitive data, we are planning to create BIP reports and publish them on classic dashboard, for this schema we are not creating any SA in RPD or semantic model, we are planning to create couple of data models and create reports on top of them. we need to setup Data level security…
-
Use parameters to make the file path dynamic
we have requirement in BI Publisher template to call template from External file in the folder mounted in BIP Server. <?import:file:/istinc/OBIE/board/commentary/commentary_qfr_000022_202412.rtf?> <?call-template: QFR_PR_TITLE?> I have two parameter which would be passed to the Main BIP template…
-
BIP API ScheduleService states ftpOptions element ftpUserName is unexpected but matches WSDL
This ca be ignored, I would delete it if I could. I kept overlooking some typos. Trying to use BI Publihser API ScheduleService, but response staes the ftpOptions item element contains an unexpected element ftpUserName, even though it matches WSDL. I am doing this from Postman, and there may be a error in my XML that I am…
-
Create Datamodel using oracle web services
Hi All , I am currently working in a requirement to create a datamodel and report using oracle web services, The service that I am currently using is 'Catalog Service.' Through this, I was able to create data models from the SOAP UI. The problem I am facing here is the datamodel is getting created while it is not creating…
-
How to schedule Seeded Trial Balance report to SFTP using Bursting Query?
I have a requirement to schedule the seeded Trial Balance report to sftp server . I tried writing the bursting query but as the seeded data model doesnt contain the standard tables the bursting is not working which results in sending blank file to the sftp server folder. I tried writing dual in the from statement bursting…
-
We created the Fusion BI Reports and data stored in English. but need to report display in Arabic.
We created the Fusion BI Reports and data stored in English. but we need to report display in Arabic. How to create the multilanguage setup in Fusion BI Reports.
-
Documents uploaded in DOR who can we download using query (bursting or extracts)
Documents uploaded in DOR who can we download using query (bursting or extracts) Like you resume/photo/passport can you help with solution.
-
Is BI Publisher Replaced with Oracle Analytics
Is the below note accurate and valid " BI Publisher is effectively replaced by Oracle Analytics Publisher, which is essentially the same functionality but now part of the larger Oracle Analytics suite. Users should migrate to Oracle Analytics Publisher for any new report development and functionality. " Can anybody provide…
-
RTF export to PDF > Line shape not rendered properly
Hello All, I have added horizontal lines above the text in the RTF template; however, it is not rendered properly when exporting to PDF: The first line intersects with the text and does not reach the end of it. Even the start and the end of the rectangle are not as per the RTF Template. Any hints/tips on this? Screenshots…
-
able that shows me the creation or modification of a data model
Hello everyone, is there a table that shows me the creation or modification of a data model (the one that is displayed within the “properties” session of the folder/data model/report under analytics)
-
If condition in BI publisher RTF
Hello Team, I would like to create a pivot table in bi publisher rtf, where the column of totals per row is displayed only if the field in the row is different from a list of terms. The following construction works correctly:<?if:.//H='11 - MAGAZZINO INIZIALE'?> total <?end if?>. But I want something like the following:…
