-
How to config auto run when user click apply button in OAS-Publisher
I’m having an issue: when I open a report on OAS that’s built with an Excel template, it auto-runs right away and downloads the Excel file. I want to configure it so that when I first open it, it won’t run until I choose the parameters, and only when I click apply it should run and download the file.
-
Request for Resource Principal Authentication Support in OAC BI Publisher Object Storage Delivery Pr
Currently, Oracle Analytics Cloud (OAC) BI Publisher (BIP) delivery profiles require static OCI user credentials (user OCID and private key) to connect to OCI Object Storage. This approach poses significant security and operational concerns, especially as our OAC footprint grows. Challenges with Current Approach: Security…
-
customizing Compensation workbench report Subject line
Hi, We need to customize Compensation workbench report subject line. We found the report template which contains the content of email but unable to find subject line configuration. Please help on this. Below is the path of seeded report for the notification. /Human Capital Management/Workflow…
-
Help with Extracting L1/L2/L3 Managers in Reports
Hi, We’re working on extracting L1/L2/L3 manager hierarchy using the standard logic (e.g., PER_MANAGER_HRCHY_DN). In most cases, the extraction works fine — but in specific scenarios, some employees don’t appear at all, likely due to how the query is structured. If you’ve solved something similar, I’d really appreciate it…
-
Bi publisher Expand pivot table columns by default
Hi, We are creating a new bi publisher reports and we have set a pivot table with several columns. We have seen that by default the tool display the columns collapsed: Is is possible to change some property to display the columns expanded by default? Thanks and regards. Pablo.
-
Queries on Timezone related outputs in ERP Cloud
Our users are in PST Timezone and has raised concerns about report outputs being in UTC Timezone. We are trying to update report code and wanted to clarify few queries before we proceed to update all the report code. Parameters have an option whether to be input in UTC using the ignore timezone flag. So if the “ignore time…
-
RTF Template: Background Image Only Appears in PDF Output, Missing in Other Formats
Hi everyone, I'm creating an RTF template in Oracle BI Publisher to generate a certificate-style report. The goal is to display a background image (a certificate design) with dynamic field values printed on top — for example, the recipient's name, date, etc. What I Did: Inserted the certificate design image into the RTF…
-
RTF Template: Background Image Only Appears in PDF Output, Missing in Other Formats
Hi everyone, I'm creating an RTF template in Oracle BI Publisher to generate a certificate-style report. The goal is to display a background image (a certificate design) with dynamic field values printed on top — for example, the recipient's name, date, etc. What I Did: Inserted the certificate design image into the RTF…
-
Assistance with Moving Image Behind Text in RTF Template Rendered as HTML in Oracle BI Publisher
I am working on a customized notification in Oracle BI Publisher and need assistance with rendering an RTF template as HTML. Specifically, I want to position an image as a background behind the text. Here’s a summary of the issue: -I attempted to insert the image as a watermark in the RTF template, but it didn't achieve…
-
Segment Value Security in Oracle Analytics Publisher
I understand segment value security by business function enforcement works when the predefined Oracle Analytics Publisher Trial Balance Report using the Scheduled Processes page is submitted. https://docs.oracle.com/en/cloud/saas/financials/24d/faigl/enforcement-of-segment-value-security-by-business-function.html#u30251554…
-
Clarification on AR Invoice Print Seeded Data Model – GL Segment Addition & Data Visibility Issue
Hi Team, We have two queries regarding the AR Invoice Print seeded data model in Oracle Fusion: Is it possible to include the GL Segment in the AR Invoice Print seeded data model? If yes, could you please guide us on the recommended approach for customizing the data model to include this segment? We are currently unable to…
-
BI Admin Delivery setting for object Storage
Hi, everyone. Is there a way to make the BIP output file go directly to Object Storage? I couldn’t see Object Storage listed under Delivery. However, in the video below, I noticed that one of the options available is Object Storage. https://www.youtube.com/watch?v=-nKs5-mPYiQ
-
Toggle Maintenance Mode Audit Trail
Hi Team, Is there a way to check if a user has modified the flag for 'Toggle Maintenance Mode' in BI Publisher Administration? I am looking for a table or an audit report which potentially captures when/who modified this flag in order to avoid any future issues. Thanks, Thiru.
-
If/Else Conditional Region based on Purchasing Category for PO PDF Output
We are trying to update the PO PDF template so that if 3 specific purchasing categories are used on the Purchase Order it renders some different text on the template. If any other Purchasing Category is used then some other text should be rendered instead. We want to explore the following options: Check all Purchase Orders…
-
Initial synchronization for large tables using BICC
Our implementation involves several large tables containing millions of transactional rows that need to be synchronized between SaaS and PaaS using BICC. While incremental sync is planned to run on a daily schedule, the challenge experienced is in performing the initial full data sync between the SaaS and PaaS systems. In…
-
OAS Configuration stuck at Configure button on UI
Hi ,I was trying to configure OAS but it is stuck at configure button .Button is greyed out.Please help on this
-
Is there an API to fetch BIP printer details in OAC?
I want to fetch printer details added in OAC under xmlpserver -> Administration -> Printer. Is there an API to get the printer info. If yes, can you please share the documentation.
-
Repeating a Header When Lines Overflow to the Next Page in an RTF Template
Dear All, I have multiple groups in my RTF template, and when the content of the second group overflows to a new page, I need the header from the first group to repeat at the top of the new page. I have already tried enabling the "Repeat as header row at the top of each page" option at the row level, but it is not…
-
how to get report output as PDF by QR Code on BIP report (oracle fusion) ?
Hi, i want to ask about QR code on report output, the user will generate a document using self service , this document which is a report output contains QR code at the beginning of the report, once the user scan the QR code by phone he will see the report output on his phone please advice how to do that if its doable on…
-
Clarification on Remittance Feasibility in Check Template
Hello Everyone, The requirement is to print Check Remittance details in a new column once a certain overflow count is reached, instead of continuing on a new line. Based on my understanding, using the standard feature of VOID by overflow we can print max of 32 invoices in one page, As per the requirement the print need to…
-
Confirmation needed on BI Publisher REST API for Catalog Management & SOAP API Support Lifecycle
We are implementing a CI/CD pipeline to manage our BI Publisher assets. A core requirement for this automation is a script that can upload BI Publisher catalog objects, particularly data model files (.xdm), from our version-controlled repository to BI publisher. Our development and research led us to the BI Publisher SOAP…
-
Maximum characters allowed in parameter text of a BIP report
Summary Maximum characters allowed in parameter text of a BIP report Content Hi Team, I want to understand what is the maximum limit of characters to pass as a text parameter of a BIP report? Scenario: Based on output from another report we have to run another BIP report having input parameter from one of the column of the…
-
What parameters to put in "Transactions Print Data Model"
Hi Team, Hope you all are doing great! I want to know what all parameter data would be required to put in the "Transactions Print Data Model" to generate the XML data directly. I have tried to pass in the arguments by checking the submitted process but it is not giving any data. I would really appreciate help/input…
-
What Descriptive Flexfields (DFFs) are supported in Oracle Fusion Payroll?
Hello Experts, I am currently working on Oracle Fusion Payroll and would like to understand the scope of Descriptive Flexfields (DFFs) available in Payroll. Specifically, I want to know: Which DFFs are delivered out of the box in Fusion Payroll? Are there specific DFFs tied to Payroll elements, balances, or costing? Can…
-
What Descriptive Flexfields (DFFs) are supported in Oracle Fusion Payroll?
Hello Experts, I am currently working on Oracle Fusion Payroll and would like to understand the scope of Descriptive Flexfields (DFFs) available in Payroll. Specifically, I want to know: Which DFFs are delivered out of the box in Fusion Payroll? Are there specific DFFs tied to Payroll elements, balances, or costing? Can…
-
BI Publisher Desktop add-in "Error while trying to access Report Server Location"
Hi all, I have the BI publisher desktop add-in for Word/Excel etc to build RTF templates, but I can not log on, I get the error msg "Error while trying to access Report Server Location: The remote server returned an error : (400) Bad Request. Report Server Location is: our URL" URL, username/password are all fine ( port is…
-
What is the difference between Archiving and Downloading BI objects?
What is the difference between .catalog and .xdmz/.xdoz BI objects, the archive and download options thru OTBI (/analytics) and Oracle Analytics Publisher (/xmlpserver)? I understand the .xdmz/.xdoz objects can be unzipped and read thru xml format, what about the .catalog format? Both are recommended alternatives for…
-
Selecting and formatting CLOB column in data model SQL
I need to pull in a CLOB column into a BIP Data Model and in the end format it as a Rich Text. Is there a reference document or any suggestions on how to accomplish this?
-
Unable fetch the value of a Variable in RTF Header Section
Hello Community, I am doing a set variable in rtf body <?xdoxslt:set_variable($_XDOCTX, 'vlang',0)?> and trying to get the value of same variable in Header of the body using <?xdoxslt:get_variable($_XDOCTX, 'vlang')?> what i noticed is the value set in the body is not getting printed in the header of the Report. Any…
-
No output generated in bursting but status is Success in BI Publisher
Hello I created a report with bursting and it turns out that when creating a report, I don't always have data, and logically an empty report is created, but BI bursting does not create an empty file and simply says "No output avaible". How can this problem be solved, I need even if there is no data, then an empty letter or…
