-
How to Encode/Encrypt BLOB Column to Base64 Format for BIP Job
Product: Oracle BI Publisher / Oracle Database Description: We have a BIP job that retrieves data from an Oracle Database table containing a BLOB column (e.g., storing PDF or image files). For downstream processing and integration, we need to encode (or encrypt, if possible) the BLOB data into Base64 format within the SQL…
-
Number fields losing format in BI Publisher
Hi, I have a BI Publisher report using an analysis as source in Data Model. However, when I run the analysis, the number fields have been shown with their correct formatting (Ex.: 999.999,99). However, when I open the BI Publisher report the format changes to 999,999.99 and I am unable to change the data format on Data…
-
is there any way to export deployed custom report list and report location from fusion cloud
is there any way to export deployed custom report list and report location from fusion cloud
-
BI Publisher Report Leaving out Duplicates
When I run my query I get the full report but when I created a BIP excel report, I find that rows with a duplicate person id are missing. This is a first time issue, is there a way around this? Thanks.
-
BI Publisher Table Grouping Help
So, in BI Publisher, in my data model I have a subgrouping for one part of my data set but in the template, I have a for each on the subgrouping but they're not appearing correctly. Basically, for The parent group, I would have a header, but there would be a table which would have each element in the child group based for…
-
Invoke fusion webservice as BI Publisher Web Service Source
Hi Team, can you confirm Invoke fusion webservice as BI Publisher Web Service data Source? We try to invoke esswebservice from BI Publisher Web Service Source it is not working. We added SSL Certificate also. Please help on this.
-
Need guidance on how we can enable Account - scm/PlanningDataLoader/import for out BI Report output
We have developed a new BI Report; while trying to schedule the report, in the Output tab, we are not seeing the expected account - scm/PlanningDataLoader/import, once we select Security Group - FAFusionExportImport. We need guidance on how we can enable it for out BI Report user.
-
How Can I Generate QR Codes and Barcodes from XML Fields Using Oracle BI Publisher Desktop?
Issue: QR Code Generation Error in BI Publisher Desktop I’m trying to generate a QR code using the syntax <?qrcode:QR_STRING;60?> in my Oracle BI Publisher Desktop template. However, when I run the template, I get the following error: javascriptCopyoracle.xdo.XDOException: oracle.xdo11g.xpath.XPathException: Extension…
-
Any webservice available to unarchive catalog file in fusion?
-
Is there any rest api to run BIP report from fusion
-
How to uninstall BIP Desktop?
Hi, In my laptop the old office had BIP Desktop 32bit. Then with an update, the Add-on seemed to be disabled. I decided to remove and reinstall. I noticed the new office 365 had 64 bit. But now when it starts to install I get the message :"Please uninstall the current version using Add or Remove Programs from the Control…
-
ESS Job Output Not Printing to Printer
Hi All, I’m submitting an ESS job using the advanced option to print the output to a specific printer. I’ve provided the printer name in the destination field. However, the BIP data model used in the report also includes a bursting query to FTP. When I submit the ESS job, it only triggers the bursting logic defined in the…
-
BIP Report Skipped some data while bursting or Scheduling
Dear Expers, I have a complex BIP report. It is having 12 different datasets and one RTF. It is basically a pdf ouput file. If I am running the report from the folders, then it is working very good as expected. But if I am running the report through the flow pattern or scheduling the report, Output is not as expected. It…
-
How to Insert a Blank Page After an Odd Numbered Account Statement in BI Publisher
Hello Oracle Community, I am working on a project where I need to generate PDF statements for account records using Oracle BI Publisher. The data is provided in XML format, and the templates are in RTF. The issue I'm facing is related to duplex printing for account statements. Specifically, I need to ensure that if an…
-
Need to do a Gantt chart in Oracle Analytics using P6 EPPM Data
I believe that Gantt charts are not currently supported in Oracle Analytics, but I'm wondering if anyone has found a workaround to generate a Gantt-like chart using Oracle Analytics (Web)? Any assistance would be greatly appreciated!
-
Is it possible to configure SFTP command when triggering extract run?
Hi experts, We have a payroll extract that is sent daily to our customer's SFTP server. Sometimes the file doesn't reach the configured destination. To improve connectivity, the customer suggests to configure some parameters in the SFTP command as follows: -oConnectTimeout=120 -oServerAliveInterval=15…
-
How to Force Latin (Western) Numbers in Arabic Locale in BI Publisher?
We're facing a localization issue in Oracle BI Publisher 12.1 (on-premises) where numbers automatically convert to Arabic-Indic digits (٠١٢٣٤٥٦٧٨٩) when using Arabic locale, but we need them to display as Western numbers (0-9) while keeping other Arabic text elements. Problem Details: Using BI Publisher 12.1 with Online…
-
Unfortunately we deleted the catalog files. IS there any option to recover
-
Storing OAP reports in OCI Object Storage - Configuration Issue
Hi Forum, Could someone guide me in terms of configuration as I do not manage to connect to the OCI object Storage adding a delivery server. The doubt i have is related to the private key file location and the way to set it correctly. In the past we could upload it from BIP administration UI directly. What is the proper…
-
Ajay Hinduja Geneva, Switzerland (Swiss) - Prolonged BI Publisher System Downtime: Login Issue
Hello Oracle Community, I'm Ajay Hinduja from Geneva, Switzerland (Swiss) and I am currently facing a prolonged issue with Oracle BI Publisher that is severely affecting our operations. Issue: Users are unable to log in despite entering correct credentials. Each login attempt results in the following error message:…
-
How to execute a BI Publiser job on demand from an external process
Hi all, I have several BI Publisher reports configured to export their output as .csv files directly to OCI Object Storage buckets. However, I now have a requirement where these jobs must be triggered on demand, rather than on a scheduled basis. Is there a supported or recommended way to execute these BI Publisher jobs via…
-
Couldn't do a supperscript in RTF file
Hi all, I'm currently working on a BI Publisher RTF template for a job offer letter in Oracle Fusion HCM. In the template, I manually formatted text (e.g., the "th" in "13th") using superscript formatting via Microsoft Word. However, when I preview the output in PDF or generate the final document from Fusion, the…
-
SOAP request response param backend table in fusion
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> unsafe:soapenv:Body <scheduleReportResponse xmlns="http://xmlns.oracle.com/oxp/service/v2"> <scheduleReportReturn>43596</scheduleReportReturn> </scheduleReportResponse> </soapenv:Body>…
-
Execution Plan is deferent in pre prod and prod for Custom BIP Report in Oracle ERP/CRM
We have a Custom BIP Report (involving large data in Incentive Compensation) is running longer in Prod than pre Prod. I see more full table scan in Prod than in pre prod which is recently cloned from Prod. When I compare the Execution Plans they are deferent in pre prod and prod for Custom BIP Report in Oracle ERP/CRM. I…
-
Error: Set Word2007 flg failed
I'm trying to install the BI Publisher on my laptop. I have MS Word version 2504 and I tried to install the current version of BI Publisher and I'm getting the error of 'Set Word2007 flg failed'. Also, I tried to install different version of BI Publisher but then I still get that kind of error. What should I do?
-
Query to get Change Order Tasks
Hi. I am looking for Query to get Change Order Tasks from SCM Oracle fusion tables. Attaching Screenshot
-
How to ungroup data or unmerge data rows when pivot table is used in interactive template in BIP Rep
Issue description clarification. Rows are getting merged for repeating labels after pivot table has been applied in the Interactive template. We want to unmerge those rows.
-
Connecting a custom data set to a standard data model
We report on a database that is maintained by the supplier. The supplier provides standard data models and standard reports. In our organization, we have in the past turned standard data models into custom data models with a custom reports. Due to a personnel change and a lot of maintenance time on the custom data models,…
-
Cost Accounting View – Rolled Up Cost Not Found in Any Table
Hi Everyone, In the Cost Accounting view, the rolled-up cost for a specific scenario and item is visible in the UI, but I’m unable to find the corresponding cost distribution in any of the underlying tables. CST_STD_COSTS css, CST_STD_COST_DETAILS cssd, cst_cost_elements_vl csse In the screenshot the values are showing 0's…
-
Editing a BI Job which is scheduled to run daily(destination is email) but unable to find the job
Hello, In our production instance, we have scheduled a BI Publisher report that runs daily and sends out email to a bunch of users. Earlier i used to see the job information which is running daily. Now, we want to add a new user to this list, to I go into the "Report Jobs" screen, try to find my job but does not show up…