-
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…
-
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…
-
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…
-
Tables to find 'Impersonator' and 'Impersonator ID' values in the Oracle fusion
What is Impersonator and Impersonator ID in the standard Audit Report in Oracle fusion. In which table we can find these values for building the custom audit report. We have a field called 'AUDIT IMPERSONATOR' in the audit table IBY_EXT_BANK_ACCOUNTS_ but we don't have any data here. Could you please advise, Thankyou!
-
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…
-
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…
-
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…
-
Unfortunately we deleted the catalog files. IS there any option to recover
-
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>…
-
Report Ends with "dummy file is deleted" error
Hi all, getting above error when tried to execute the ess job for bursting query. Kindly suggest what to do???? I tried below solution also but not working Report Ends with "dummy file is deleted" error when I scheduled the report it is getting failed in BI also and in ESS job also. why I am getting this failed status Here…
-
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…
-
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…
-
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,…
-
BIP Report loading taking too long once we click report open link from catalog in 12c
Summary BIP Report loading taking too long once we click report open link from catalog in 12c Content Hi, When I am clicking open bi publisher report from catalog, the report loading taking too much time from analytics link 12c. Almost 4minutes to load or view, then once click apply button report data is displaying. Tried…
-
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:…
-
Customization of Oracle Standard Check Printing: Issue with printing check info at fixed position:
Summary Customization of Oracle Standard Check Printing: Issue with printing check info at fixed position: Content Dear Experts, I am working on new check printing format ( Used the oracle standard check template and customizing it) which is to print invoice data on first half of the page and the second half is to print…
-
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…
-
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.
-
BI Publisher Bursting - BCC email delivery not working
We've configured bursting and the delivery channel is email. Mails are getting delivered successfully to Business Users which are marked in TO (PARAMETER1) & CC (PARAMETER2) columns but not to the Users who are marked in BCC (PARAMETER8), parameters are configured as per below link -…
-
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?
-
Installation of BI Analytics 7.0.0
EBS: 12.2.10 Database: 19c (19.18.0.0.0) OS: IBM AIX OnPower 7.2 64 bit I want to use BI analytics on my local desktop. What are pre-requisites for this installation? Will it be installed like BI publisher or it requires different environment or OS? Purpose of this installation is to develop rtf templates for excel reports…
-
Query to get Change Order Tasks
Hi. I am looking for Query to get Change Order Tasks from SCM Oracle fusion tables. Attaching Screenshot
-
Need to send BIP bursting excel output as a url in email instead of attachment
Hi I have created a report where I can mail the excel output as an attachment. I need to mail that same excel as a url and not as an attachment. I have set "send email as url " option in admintration-> delivery configuration. I can send pdf output as a url but not the excel one. PFB my bursting query: SELECT DISTINCT 1…
-
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…
-
Working with Main and Subtemplate in OTAP
Within our organization we use for 2 reports a main template with subtemplates. We develop in the acceptance environment and then the report goes to the production environment. At the moment both environments have the same URL for the location of the subtemplates. In November the database will go to the cloud and also the…
