-
Merged Cell in Excel Template of BIP Report
Hi All, How do I generate the report shown below? I wish to merge common text in "Organization" and generate report like below. Please provide pointers to any link for reference. Thank U.
-
Urgent please..migration from bi publisher 12c to oracle analytics publisher
Hi, Need your inputs urgently, could you please help me here. we have bi publisher reports currently in obiee 12c. we are planning to migrate our BI Publisher report to the newer version i guess it's in OAS? (Oracle analytics publisher), our bip reports are generated using xml data source. we use REST Api/SOAP to generate…
-
What is the model of QR code in BIP?
https://docs.oracle.com/middleware/bi12214/bip/BIPRD/GUID-A229808F-D2F6-458E-8E52-9E7FA156FF0E.htm#BIPRD3336 We developed the report and generate QR code using the syntax above, we got the inquiry from client that is it model 1 QR code or a model 2 QR code? Anyone who can confirm it? Thanks.
-
Want to customise Standard Oracle SalesOrder Report by adding new columns
I want to add few new columns in salesorder standard Oracle Report ,but unfortunately standard XML attached in the datamodel does not have the tags that I require , Is there any way I can add the the required fields as tags in the xml ?
-
BIP report bursting is giving output failed issue
Hi, Have created BIP report which is generated output in excel using RTF template, while trying to schedule the report Adding Destination as Email type, it's sending email with report. However when using bursting option, it's giving following error: Waiting Time: 0.9 seconds Data Fetch Time: 0.5 seconds Total Execution…
-
Repeating headers within a loop
Hello All, I am currently facing an issue with repeating headers within a loop using the <?start:body?> and <?end body?> tags. Despite implementing these tags, the headers are not repeating as required. Could someone please provide guidance or suggestions on how to achieve this? Your prompt assistance would be greatly…
-
How to pass multiple values to parameter
I am passing multiple values to parameter by using IN sql query it giving error of ORA-00909: invalid number of arguments whats the slution how to pass the values multple with parameter
-
Grouping in rtf template for employee organization
Hello All, I developed a report with rtf template and data as xml. The columns of employee earnings/deductions , we made it as dynamic and column as horizontal-break-table. All is working fine, except the group by employee organization. Please find attached xml , rtf file. Thanks, Afzal.
-
How to get BIP Output suffixed with datetimesamp
Dear all, Does anyone know how to generate a BIP output file with a datetimestamp like Outputfile_202306171124.csv ? 202306171124 = 2023 / 06 / 17 plus time 11:24 Many thanks. Brgds, Fernando
-
The Oracle Analytics XMLPServer search bar
The Oracle Analytics XMLPServer search bar typically displays a limited number of results (often two pages). are there ways to potentially increase the number of returned results?
-
BI Publisher Report not returning SOME values for a column - data exists in the sample data.
We have a BI Pub report that is showing data not populating on some of the rows. The values exist in the code result, sample data, XML. However when added to the internal template builder, these certain rows do not return. I built a Word rtf template and the data returns without issue. Has anyone else encountered this with…
-
BI Publisher Template Builder not visible in Word
I am attempting to install the the BI Publisher Template Builder Add-in. And, as usual, having no luck making the Publisher option appear on the Word menu. Software versions on my PC: MS Office 64-bit Version 2209 Build 16.0.15629.20256. Java SE Development Kit version 8 update 311 (64 bit) 8.0.3110.11. Microsoft .NET…
-
Archiving Data Model
I am trying to archive a data model but when it is downloaded into my system, it tries to open with Adobe. Is there a way to rectify this? Thanks
-
Could please let me know I have only one group how to split into multiple sheets in oracle EBSR12
We are developed new xml report in EBS R12(12.2.9) with xls template ,issue with report is after reaching 65k records xls template not supporting and we did the setup in data template for more than 65k records but still issue not fixed. Could you please any one help on report when data is getting more than 65k need to…
-
Bulk Download of files in Report jobs
Can we bulk download all the files which are in a scheduled job? It makes life worse while we try to download 1000+ odd files
-
In Oracle Fusion- BIP Report Job succeeds but Files not found on FTP Server
We have scheduled a BI publisher report by using the schedule option on the BIP report to place file on the FTP server. When we run the job it is getting ran successfully without any error, but the file is not placed on the FTP server. We have done this for few list of reports. Few of the reports output is placed on the…
-
BI Publisher Microsoft Office AddIn Proxy Configuration
Hi team, I can't log on to the Oracle BI Publisher using the Word/Excel Office Add In. The reason is that there are 2 proxies and the one route works but the other does not work. Is there any way to configure the Office Addin to use a specific proxy ? I tried to update the Java Option using the -Dhttp.proxyHost and…
-
REST API or function to get if the employee Eligible or not.
Hi All, I'm integrating with another system and facing a challenge when an employee submits a leave request. The issue arises because the employee is in their probation period, and the ERP system can't process the leave request due to eligibility constraints. However, in the other system, there are no eligibility…
-
How to Display Total at the Top of Stacked horizontal bar graph in BI Publisher
-
Image Alignment issue in BIP Report
Hi We are working one customer requirement where we need send corporates card expense details in email body along with below image. When validate the report output in web browser its working fine and aligned with text but when open same notification in outlook the image not aligned with the text and showing like this…
-
Is there a way to build a BI Publisher report for COA, Location and Project?
Files are being exported by going to setup and maintenance and then manage values and export data, is there an available query or perhaps the reference table I could use? same with the asset location and asset location aliases?
-
Is there an audit report to identify who ran a BIP report and when?
-
How to use subtemplates with Excel templates?
I have found several documentation and examples of using rtf subtemplates but have not found any for Excel subtemplates. Can you please help me?
-
I need to join ZX_REPORT_CODES_ASSOC and zx_rates_b.
I thought the join was with entity_id and tax_rate_id. It works for some invoices, but the it is giving blank for other invoices.
-
Is there a customizable data model for Supplier Contract Preview PDF?
/Shared Folders/Enterprise Contracts/Contract Printing/Contract Preview.xdo Requirement for new fields, new SQL mapping, derivation logic, etc. So we have to update not just the RTF template but the data model too. Please advise, thank you.
-
Why Bursting Delivery email's are receiving only few user's why not for Others?
Hi , We are seeing some strange issue w.r.t to BIP email Bursting where some users are receiving the emails and few users are not receiving the emails but delivery job history showing successful for all the users. What could be the issue? Split by/Delivery by is Person ID - Key
-
How to Modify the Asset State Parameter in Property Tax Report
Hi , PFB details - 1) We want to pass 'All' Values in Asset State Parameter of Property Tax Report. However, by default there is no option to select 'All values' in the parameter in ESS Job of standard report. (PFA Screenshot of ESS Job) 2) When we try to customize the report and modify the ESS Job, We have to make changes…
-
Is there function available for getting day of the week from any date field in RTF template
Hello , I am creating a logic where i need to fetch previous Sunday and Saturday dates from a date column Payment date coming from XML field below. I have a <PAYMENT_DATE>2024-02-26</PAYMENT_DATE> column in XML file and I am using this value I need to bring back previous sunday and Saturday dates in RTF templates
-
How can I use session variables with a report BIP?
I built a Report (BIPublisher) using a subject area table, which is created in the physical layer with a sql query with session variables in the where clause. Is it possible to change the values of these variables on the Report? Thanks
-
Double strikethrough in rtf template not showing in report output, however single strike is showing.
Any idea if it is feasible to show double strikethrough in report output with rtf template. Below change in rtf not showing any strike in output.
