-
Need help in including the FLOW_ID in my BI Publisher report
In my BI Publisher data model I’m using a custom SQL query that returns payroll balances driven from the standard payroll action tables: PAY_PAYROLL_ACTIONS, PAY_PAYROLL_REL_ACTIONS, and PAY_PAY_RELATIONSHIPS_DN (filtered by payroll action type). This part of the query is working as expected. Now I need to bring in the…
-
Oracle Kubernetes - PDF printing on a Kubernetes Weblogic BI server
I install and maintain an Oracle Analytics Publisher that runs on Weblogic for the purposes of printing PDFs from APEX. It is nothing more than the PDF printer. The current effort is to move as much infrastructure to a RKE2 Kubernetes cluster. Are there Helm charts available for this type of install? Does anyone have…
-
Customization of PO Output for Communication
Summary Customization of PO Output for Communication Content Hi, Not able to attach a Customized Template in standard oracle Po Steps. 1. created New template code 2. Created New Data Template 3. Attached as setup in purchasing in Standard PO template 4. Change document style sheet to our new customized template 5. Create…
-
How to send multiple files from "split by" in one email by "deliver by" ?
Bursting a report we want to send every invoice, dunning, etc as a separate PDF/Excel, but in one email per customer . I thought this could be done by configuring the "Split by Invoice#" and the "deliver by Customer#" - but there are always sent separate mails for every Invoice-PDF, so if there are 5 Invoice# the customer…
-
Trying to add a telephone number hyperlink like "tel:###" to an RTF template for BI email bursting
I'm trying to add a clickable telephone number hyperlink like "tel:###" to an RTF template used for BI-Publisher email bursting. According to this, it should be possible: https://answers.microsoft.com/en-us/msoffice/forum/all/clickable-phone-numbers-in-word-documents/3ed057a0-789a-47c3-bdbc-f6592e848c4e But when I try…
-
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…
-
Why does the Publisher Word Add-in not appear ?
After successfully executing the newest Analytics Publisher Add-In Installation-File (OracleAnalyticsPublisherDesktop-8.2.0-win64.exe) the BI-Publisher-Word-Add-In isn't visible, even though it is listed as enabled under Options/Add-Ins. Setup is executed with administrator rights on an Windows 11-Computer. Word-Version:…
-
OAS 2025 Upgrade Problem. BIP reports are missing Parameters when added to a dashboard page
When we open a BIP report from the catalog, we are able to see the parameters that are built into the report. But when we add it to a dashboard page the parameter is hidden. How can we fix this issue? an Example is shown below The first picture is the dashboard page and the second is when I open it from the catalog.
-
Check Printing : Is there a way to access the signature from a secure web location like SFTP?
Hi All , Is there a way to secure the check signature image on the RTF in Oracle cloud? Like for example access the signature from a secure web location like SFTP.
-
How do I view the HTML output of a Oracle BI Publisher report with 700 thousand rows?
Hi everyone, I'm currently using BI Publisher embedded in Oracle Analytics Server 2024. I have a report that uses 2 parameters: P_BRANCHES and P_DATE For P_BRANCHES = 'ALL' (all the branches), the report will return all the values for the column BRANCH_NAME and the remaining columns, which is 700 thousand rows plus in…
-
BI Publisher - Suppress Repeating Values in RTF template?
In BI Publisher, I have a table inserted and would like to suppress repeating value for a column. How would I go about doing this?
-
Using BIPublisher RTF template how to create protected word outputs ?
I am using BI Publisher RTF templates to generate WORD output reports. The requirement is to have the Word output report "protected" so that Users cannot change the values, but alongside also have a few fields which will be editable. How to achieve this?
-
BI Publisher - English Text Alignment Issue in Arabic Session
Hello, I am working on a BI Publisher report that contains both English and Arabic text. The issue I am facing is that English text appears misaligned when the session language is set to Arabic (AR). EN Version : AR Version: In the Arabic session, the English text is incorrectly right-aligned instead of being left-aligned,…
-
Arabic diacritic is being dropped during PDF generation
Dear supprot font / Arabic diacritics rendering issue when exporting report RTF → PDF in Oracle Analytics 6.4. دً (Dal + tanween) in RTF working fine, becoming just د in the PDF That means the tanween diacritic is being dropped during PDF generation same fonts are mapping in RTF and PDF.
-
How to convert number to text for non-English language
We have a requirement to show the Total Amount of Purchase Order into words in rtf. We were able to display it in English, but the requirement is to display in a non-English language (in this case it's Vietnamese). How do we achieve that?
-
Dunning Letter File naming within the zip file.
Currently, using Bursting, I am able to place the “Dunning Letter” output zipped PDF files with naming convention ("Dunning_'Dunning_id'.zip") directly into the SFTP location. However, as per the requirement, the output name for the individual pdf inside the zip file should have naming convention as "combination of the…
-
Custom Purchase Order PDF errors out when document amount exceeds '999' $/Rupees/Euros etc
We have created a custom PO PDF template for the customer The user is able to download any PO PDF when the document amount < = 999 $/Rs/Euro(Any currency) But for amounts 1000 or greater we are getting an error "The file was not downloaded or was not downloaded correctly." Any advice on this would be appreciated.
-
How to display an image in attachment in a BIP report against a record
We are working on Custom BIP Report wherein we need to display signature image from the attachments, but we are not able to display it. Please share some document or reference guide for same?
-
BIP report's header to be that column's Property > Label when output format is .csv
Hi Experts, I would like to reach out to you for my question below: The BIP report is having Subject Area (Supplier - Supplier Real Time) as the data source. And I am simply using a Data Table to extract the supplier data. When the output is Excel file, the columns' header are presenting correctly, aligned with what I see…
-
In Cash Management, we have manual reconciliation. In the Reconciled tab, there isaTransactionSource
In Cash Management, we have manual reconciliation. In the Reconciled tab, there is a Transaction Source column. From which table can we get this data?
-
Is there a way to allow SCM user to have access of creating data model using SCM tables?
Is there a way to allow SCM user to have access of creating data model using SCM tables but restricts access of HCM tables?
-
Who Columns not getting updated with the timestamp for table IBY_EXT_PARTY_PMT_MTHDS
For some of the records who columns are not getting updated with the timestamp in the table IBY_EXT_PARTY_PMT_MTHDS. We are relying on these Who columns to verify the incremental data. Can you please let us know the reason for these WHO columns not getting updated with the timestamp
-
How to create RFQ from approved PR
I’m a beginner in fusion and a I want to know how to create RFQ from approved PR, please I need the steps in order also to create PO if you available pdf documents or links it would greatly appreciated
-
Extract scheduled Report
Hi Experts , Can someone help me with scheduled extract report? Looking for actual start date and end date of the scheduled job. Referred the below link which has next scheduled start date. https://community.oracle.com/customerconnect/discussion/669431/is-there-a-way-to-report-on-what-jobs-are-scheduled-for-extracts…
-
Is it possible to customize a seeded ESSJOB?
Hi. Does anyone have any idea if it is possible to customize the Create Customer Statement ESSJOB to include three more parameters? Client wanted to include a parameter for Customer Class, Collector, and Generate Balance in Zero which would allow them to run the essjob for customers that has zero balance for statements. Is…
-
Customizing the Bursting Query for a Seeded Report
Hello, is it possible to customize the bursting query for a seeded report? Instead of the original key used in the bursting, I want to use the Customer Account as the key. Would it be possible even if the report relies on the parameters entered on the ESSJOB? The seeded report I am talking about it Generate Statement…
-
How to Add PO Number column in Oracle fusion Account analysis report -Standard
Hi, We have business requirments to add the Po number and its related information in the account analysis report so please guide how to achieve this to add this information in the account analysis data model. Regards
-
How to connect BI Publisher using REST services
Hello everyone, I'm developing a project where I need to consume a couple of reports from BI Publisher using OIC. The idea was to consume them via URL. I see there are certain connection services for this, but I'm getting a 500 error. The report URL is: https://domain/xmlpserver/Custom/PruebaBI.xdo. I'm trying to consume…
-
How to run bip report from oracle analytics cloud ?
How to run bip report from oracle analytics cloud ?
-
Barcode not working
Hi all, I am currently working on a BIP template for a client where a barcode is needed, the oracle seeded template has the barcode works perfectly fine but the client wants their own version with their logo. When i download the oracle seeded template, the barcode appears as symbols and the font is code 128, when i change…
